View Incident Report

Serious

Reported By: Robert Gesswein
Reported On: 7/18/2018
For: Version 4.45 Build 4

# 4681 Query/Filter Bitmap Set Processing Incorrect for NOT Operator and ANDed Conditions

I'm getting unexpected SQL behavior between ver. 4.22b3 and 4.45b4. The following is my problematic SQL.

SELECT Show.ID_SHOW, Show.IS_LOCKED
FROM Show
--WHERE (not Show.IS_LOCKED)  -- this works with both versions
--WHERE (Show.ID_SHOW<>1055)  -- this works with both versions
WHERE ((not Show.IS_LOCKED) and (Show.ID_SHOW<>1055))  -- this DOESN'T work (returns zero rows) with 4.45b4
--WHERE ((Show.IS_LOCKED=False) and (Show.ID_SHOW<>1055))  -- this works with both versions

Resolution

Fixed Problem on 7/20/2018 in version 4.45 build 5

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

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap