Icon View Incident Report

Serious Serious
Reported By: Samuel
Reported On: 8/12/2008
For: Version 2.01 Build 4
# 2750 Using a CONTAINS Wildcard Search in an Un-Optimized WHERE Condition Causes Incorrect Results

The following query does not return any results, while the query after it does.

SELECT * FROM Product
WHERE (uid > 7694) OR (TRUE AND (Name CONTAINS 'anti*'))

SELECT * FROM Product
WHERE (uid > 7694) OR ((Name CONTAINS 'anti*'))



Comments Comments and Workarounds
The issue is with the wilcard search and the OR combined. In such a case, EDB is performing a row scan and the row-by-row evaluation of wildcard searches for CONTAINS isn't working correctly.


Resolution Resolution
Fixed Problem on 8/12/2008 in version 2.01 build 5


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 VCL Client-Server
ElevateDB VCL Client-Server with Source
ElevateDB VCL Standard
ElevateDB VCL Standard with Source
ElevateDB VCL Trial

Image