Icon View Incident Report

Serious Serious
Reported By: Terry Swiers
Reported On: 4/27/2010
For: Version 2.03 Build 12
# 3196 CONTAINS/NOT CONTAINS with Wildcards Not Respecting Case-Sensitivity of Indexed Column Collation

In the attached database, the collation on the code.descr field text index is case insensitive. Both of the following queries return the same results if I'm using the full word to search on which indicates that the case insensitive flag is being honored for full word searches. But if I'm using a wildcard, the contains is being processed as case sensitive. The first returns the
correct result set because it matches the case of the values in the field while the second returns no rows at all.

Okay:

select * from code where descr contains 'Series'
select * from code where descr contains 'SERIES'

Not okay:

select * from code where descr contains 'Seri*'
select * from code where descr contains 'SERI*'



Resolution Resolution
Fixed Problem on 4/28/2010 in version 2.03 build 13


Products Affected Products Affected
ElevateDB Additional Software and Utilities
ElevateDB DAC Client-Server
ElevateDB DAC Client-Server with Source
ElevateDB DAC Standard
ElevateDB DAC Standard with Source
ElevateDB DAC Trial
ElevateDB LCL Standard with Source
ElevateDB VCL Client-Server
ElevateDB VCL Client-Server with Source
ElevateDB VCL Standard
ElevateDB VCL Standard with Source
ElevateDB VCL Trial

Image