View Incident Report

Serious

Reported By: Clive Bennett
Reported On: 10/31/2004
For: Version 4.14 Build 1

# 1885 IN Sub-SELECTs That Reference the Same Table as the Main SQL Query Not Working Properly

This query incorrectly returns all the rows from the periods table where project_code = 1 , It should in fact return zero rows.

select * from periods where project_code =  1 and period not in 
(select 
period from periods where project_code = 1)

Resolution

Fixed Problem on 11/2/2004 in version 4.15 build 1

More Support Options