Switching the database source to Mysql throws an error

  • The CODE parameter in the SEC_RESOURCE_ROLE table throws an exception when creating an index
    • Specified key was too long; max key length is 767 bytes
    • Maximum length is 767 bytes for InnoDB and 1000 for MyISAM.
    • Encoding method is utf8, utf8mb4
  • After manually modifying CODE varchar(255) to CODE varchar(190)
    • Duplicate column name ‘DELETE_TS_NN’ was thrown
    • liqiubase executed the sql to create DELETE_TS_NN again


Switching db encoding to UTF8mb3 is a solution.

And we have Chinese forum : forum.cuba-platform.cn ,you can also post there.