Due to a MySQL bug regarding auto increment columns, I am investigating upgrading from MySQL 5.7 to 8.0 where the bug has been fixed. I have successfully upgraded the database but as I have table names and columns that are now reserved words I have to – according to the upgrade check report – enclose them in quotes (or back ticks) when referring to them. I can’t get this to work. I have tried enclosing the names in double quotes, single quotes and back ticks but still get the error (for table groups) Incorrect table name ‘ groups ‘. Also in the database painter, I cannot open these tables due to a syntax error.
Is there known issues with PB2019 Build 2082 and MySQL 8?