View Incident Report

Serious

Reported By: Ulrich Becker
Reported On: 9/4/2013
For: Version 2.13 Build 3

# 3895 Combining Optimized and Un-Optimized Conditions with OR Operator Can Cause Incorrect Results

I am looking for all records which contain both "steuer" and "ident" in one of the fields "Caption", "Search" or "Text".

Only the field "Text" has a TextIndex.

I expect 2 records in the result:
1st record contains "steuer" and "ident" both in "Caption"
2nd record contains "steuer" and "ident" both in "Text"

The statement using the TextIndex returns only 1 record ("steuer" and "ident" both in "Text"), while the LIKE statement returns 2 records correctly.

Incorrect - returns 1 record:

SELECT* from Folders where (BenutzerID = 1)
 AND (Caption like '%steuer%' OR Search like '%steuer%' OR text 
contains '*steuer*')
 AND (Caption like '%ident%' OR Search like '%ident%' OR text contains 
'*ident*')

Correct, returns 2 records:

SELECT * from Folders WHERE (BenutzerID = 1)
 AND (Caption like '%steuer%' OR Search like '%steuer%' OR text like 
'%steuer%')
 AND (Caption like '%ident%' OR Search like '%ident%' OR text like 
'%ident%')

Resolution

Fixed Problem on 9/6/2013 in version 2.14 build 1

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 PHP Standard
ElevateDB PHP Standard with Source
ElevateDB PHP Trial
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