Hello all,
when using MySQL 5.7 (because we do not have experience with downgrades on U*nx), reading in this wiki and stackoverflow, to make it run, we did some things; maybe you know about the consequence (security, compatibility with … whatever) with what we did:
a/ setting in the advance set-up the URL connection string to: default_storage_engine instead of storage_engine
b/ changing the sql-mode values: // display them: SELECT @@sql_mode
// change: for liquibase execution in general SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,‘ONLY_FULL_GROUP_BY’,’’));
c/ change: for the IDGen module, because the datetime default caused an error
// date_created
datetime NOT NULL default ‘0000-00-00 00:00:00’,
//change: SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,‘STRICT_TRANS_TABLES’,’’)); SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,‘NO_ZERO_DATE’,’’));
May we ask, if you knew, does this have an impact? Thank you