Icon View Incident Report

Serious 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 Comments
Copy of incident report #4659 for DBISAM.

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

Products Affected Products Affected
Elevate Web Builder
Elevate Web Builder Modules
Elevate Web Builder Trial