View Incident Report

Serious

Reported By: James Shedden
Reported On: 5/30/2011
For: Version 4.30 Build 5

# 3457 Using the EXCEPT Operator After the INTERSECT Operator Can Cause Incorrect Query Results

When I run the same set query ((A+B) not C) with two different data sets, one small and one large, I get different results.

select patnum from chemLarge 
where ...
intersect 
select patnum from chemLarge
where...
except 
select patnum from chemLarge
where ...

Resolution

Fixed Problem on 6/2/2011 in version 4.30 build 6

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