Reported By: Phillip Percival Reported On: 6/17/2004 For: Version 4.08 Build 1
# 1770SQL EXCEPT Clause Not Working Properly When Source Tables Contain Deleted Records Consider the following SQL query. It appears to return the wrong result. CHANGES has only 1 row in it and SOURCES has 40, the result is 39 rows *including* the row that matches both statements.
SELECT DOMAINID, HOSTID, SRCIDX, REF FROM SOURCES
INTERSECT
SELECT DOMAIN AS "DOMAINID", HOST AS "HOSTID", SOURCE AS "SRCIDX", REF
FROM CHANGES
CommentsThe SQL engine was including deleted records in the results, hence the results were incorrect.
ResolutionFixed Problem on 6/17/2004 in version 4.09 build 1