View Incident Report

Serious

Reported By: Phillip Percival
Reported On: 6/17/2004
For: Version 4.08 Build 1

# 1770 SQL 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

Comments

The SQL engine was including deleted records in the results, hence the results were incorrect.

Resolution

Fixed Problem on 6/17/2004 in version 4.09 build 1

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap