Icon View Incident Report

Serious 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 Resolution
Fixed Problem on 6/2/2011 in version 4.30 build 6


Products Affected Products Affected
DBISAM Additional Software and Utilities
DBISAM CLX Client-Server
DBISAM CLX Client-Server with Source
DBISAM CLX Standard
DBISAM CLX Standard with Source
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