When retrieving data using ODBC, there is slow performance when the where clause contains uppercase letters. For example, results are returned promptly if the SQL statement contains all lowercase letters such as:
select number, short_description from incident where number='INC0001059';
Slow performance occurs if the where clause contains uppercase letters such as:
select number, short_description FROM incident WHERE NUMBER='INC0001059';
Steps to Reproduce
- Install ServiceNow ODBC driver (any version up to 1.09).
- Create a system DSN to connect to ServiceNow instance.
- Open Interative SQL (ISQL) and connect to the database.
- Issue a query using at least one uppercase letter for column name in where clause, for example:
select sys_id, short_description from incident where Number='<use-valid-number-here';
Use all lowercase letters in column and table names in your query.
Related Problem: PRB644132