View Incident Report

Serious

Reported By: Giovanni Premuda
Reported On: 9/10/2001
For: Version 3.00 Build 1

# 858 SQL LEFT OUTER JOINs on AutoInc Fields not Handling NULLs Properly

If you run a query like the following the result will show all table2.ID as 0 for all the records in table1. If you remove the WHERE clause the result is correct. The same happens with UPDATE statements.

select table1.ID, table1.linkID, table2.ID
from table1 left join table2 on table1.linkID=table2.ID
where table2.ID is null

Resolution

Fixed Problem on 9/15/2001 in version 3.02 build 1

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap