It contains changes to the upgrade script so it can be only tested by running the upgrade script.
Neal Caidin June 22, 2016 at 12:28 PM
Test plan for this one? Thanks!
Sam Ottenhoff June 20, 2016 at 8:59 AM
Oh yes......... we are seeing mixed-case indexes all over the place, in databases with lower_case_table_names on and off .... and there is zero consistent way to delete them without following this path.
Matthew Buckett June 20, 2016 at 4:11 AM
Nice fix of re-creating the tables.
Have you seen instances of mixed case indexes too?
Conversion scripts fail because of case-sensitivity with FK. This is the line that fails:
ALTER TABLE QRTZ_BLOB_TRIGGERS DROP FOREIGN KEY QRTZ_BLOB_TRIGGERS_IBFK_1;
Tested with Mysql 5.1, 5.5 with lower_case_table_names on and off