Kbase P167935: Sql Server DataServer Generates UPPER in Sql Statements Causing Performance problems
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
14/06/2010 |
|
Status: Unverified
SYMPTOM(s):
SQL server generates UPPER in SQL statements causing performance problems
Almost all queries to any tables have UPPER function in SQL statements
FACT(s) (Environment):
Windows
OpenEdge 10.2x
CAUSE:
The .r code was compiled against a schema holder that has following attributes in the header
DRIVER-CHARS "11,13,14,20,23,33,35,36,"
while default schema holder should have
DRIVER-CHARS "11,13,14,17,20,23,33,35,36,"
Number 17 is in the default schema holder which determines whether a the driver has case insensitivity support. When this switch is removed, data server assumes there is no case insensitivity, therefore uses UPPER to support case insensitivity.
FIX:
Use the schema holder that has switch 17 turned on at compile and at runtime.