View Incident Report

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

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

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

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap