I presume the queries don't backtick the column names.
For example:
Code: Select all
Cannot compare jira_default.AO_102D86_SUBCOMPONENT with jira_default.AO_102D86_SUBCOMPONENT on INFORMATION_SCHEMA.127.0.0.1.
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'VIRTUAL, VIRTUAL_CMP
FROM jira_default.AO_102D86_SUBCOMPONENT ORDER BY ID' at line 1