Icon View Incident Report

Serious Serious
Reported By: Jose Eduardo Helminsky
Reported On: 6/26/2018
For: Version 4.45 Build 3
# 4660 Combining Ranges with Filters that Use Constant Expressions without Columns Causes Incorrect Results

I think I have found a bug because in DBISAM last version because in earlier version it works as expected.

Table: HCLI
Index: SRAZ

Situation 1:
Apply range using "Ativo"
OK

Situation 2:
Apply filter '1=1 and textsearch(''PIRACICABA'' in CID)'
OK

Situation 3:
Apply range using "Ativo"
Apply filter '1=1 and textsearch(''PIRACICABA'' in CID)'
NOT OK

Applying RANGE + FILTER is the problem, when I use just one of them it works as expected.


Comments Comments
This bug was very similar to incident #4659, where constant expressions were tripping up the query optimizer changes for 4.45.


Resolution Resolution
Fixed Problem on 6/26/2018 in version 4.45 build 4


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

Image