SQL query is using CAPITALIZED table names causes query failure

Document ID : KB000093293
Last Modified Date : 27/04/2018
Show Technical Document Details
Issue:
SQL query is using CAPITALIZED table nams causes query failure 2018-04-27 15:34:17,704Z (11:34) [qtp996963339-20] WARN groovy.sql.Sql - Failed to execute: SELECT ca.*, c.host_name FROM COMPONENT c, COMP_ATTR ca WHERE c.comp_uuid = ca.comp_uuid AND ca.attr_key = 'VSE Performance' AND ( ( ca.end_tm IS NULL AND ca.start_tm < '2018-04-27 11:00:00.0' ) OR NOT ( ca.end_tm < '2018-04-26 11:00:00.0' OR ca.start_tm > '2018-04-27 11:00:00.0' ) ) ORDER BY ca.start_tm because: Table 'evaldt1e00.COMPONENT' doesn't exist
Environment:
All supported releases of DevTest with MySQL.
Cause:
This is a known issue with DevTest and was reported in 10.2.4 for MySQL. This is supposed to be fixed in 10.3.0.

Not recognizing upper case table names.
Resolution:
The workaround:

In the /etc/my.cnf file can you add the below lines and restart MySQL.

lower_case_table_names = 1

This will supposed to make the table names case-insensitive.