![Change to sp_iqlocks output [CR 472791]](arrow-left.gif){kind=icon}
![Clarify NULL in STDDEV and VARIANCE functions [CR 470567]](arrow-right.gif){kind=icon}
In some cases, an optimization in Sybase IQ 12.7 causes the results of a comparison returned in a case insensitive database to be different from the results returned in previous releases of IQ. You cannot expect case sensitive results in a database that is case insensitive (CASE IGNORE). This has always been true for Sybase IQ.
To clarify the results expected from a case insensitive database, the information in the section “Results returned in a case insensitive database [CR 472049]” will be added to the description of the CASE clause in the “Usage” section of the “CREATE DATABASE statement” section in Chapter 6, “SQL Statements.”
