Icon View Incident Report

Serious 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 Resolution
Fixed Problem on 9/15/2001 in version 3.02 build 1