Icon View Incident Report

Serious Serious
Reported By: Roy Lambert
Reported On: 5/27/2007
For: Version 1.03 Build 1
# 2357 LIKE with Wildcards that Uses the ANSI or Unicode Collation Not Returning Correct Rows

The following query results in the following small selection from the 201 results, only 3 of which contain the string delphi3

[tmail2000] delphi component Mail2000 v1.10.3
[tmail2000] Re: delphi component Mail2000 v1.10.3
Re: [delphi-en] Detect Delphi IDE
[delphi-en] Re: SenkKey for Delphi 7
WebDB - delphi source code

select _subject from mandn
where _subject collate ansi_ci like '%delphi3%'

Comments Comments
The issue was related to the trimmed comparison changes in 1.03 to comply with the SQL 2003 standard for only comparing strings without any trailing spaces combined with the default ANSI or Unicode collations. The comparison routines for these built-in collations were not handling the comparison of an empty string against a non-empty string properly.

Resolution Resolution
Fixed Problem on 6/5/2007 in version 1.04 build 1

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