150 views

Description

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

 

  1. Install ServiceNow ODBC driver (any version up to 1.09).
  2. Create a system DSN to connect to ServiceNow instance.
  3. Open Interative SQL (ISQL) and connect to the database.
  4. 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';

Workaround

Use all lowercase letters in column and table names in your query.

 


Related Problem: PRB644132

Seen In

Eureka Patch 9 Hot Fix 4

Fixed In

Istanbul

Associated Community Threads

There is no data to report.

Article Information

Last Updated:2018-03-15 23:40:13
Published:2018-03-16