SQL query is using CAPITALIZED table names causes query failure
search cancel

SQL query is using CAPITALIZED table names causes query failure

book

Article ID: 93293

calendar_today

Updated On:

Products

CA Application Test CA Continuous Application Insight (PathFinder) Service Virtualization

Issue/Introduction

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 add the below lines and restart MySQL.

lower_case_table_names = 1

This will make the table names case-insensitive.