View Incident Report

Serious

Reported By: Frederick Chin
Reported On: 7/3/2018
For: Version 2.06 Build 15

# 4663 DBISAM DataSet SQL that Contains LIKE Wilcard Conditions with ANDs Can Cause Incorrect Results

I have a DBISAM table with 54 records, and using the following query results in zero rows when the number of source records exceeds 53 records.

select a.*, if(a.payee<>'',a.payee,a.desc) as payeedesc
from gltran54 a
where (a.tranno like '%' or upper(a.payee) like '%' or upper(a.desc) 
like '%') and a.trandate >= '2014-01-01'
order by a.trandate, a.tranno

Comments

Copy of incident report #4659 for DBISAM.

Resolution

Fixed Problem on 6/23/2018 in version 2.06 build 16

Products Affected

Elevate Web Builder
Elevate Web Builder Modules
Elevate Web Builder Trial

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap