On 12/18/2013 10:10 PM, Harmen de Jong - CoachR Group B.V. wrote:
We have found a query that does not give a result, while it should.
The query is:
select id
from productionentry
where id NOT IN (select productionentryid from zentry)
AND examid=12581;
There are rows in the table productionentry for which the id does not exist in
the column productionentryid in the table zentry.
However, when we execute the following query (which should be practically the
same), we do get results:
select id
from productionentry
where id NOT IN (select id
from productionentry
where id IN (select productionentryid from zentry)
AND examid=12581)
AND examid=12581;
So for some reason the NOT IN keyword does not work correctly. We created a
test database that can be downloaded here:
http://www.coachrdevelopment.com/share/querybug.zip .
Are we missing something, or is this a bug?
Are there any NULL values in the productionentryid column of
table zentry?
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
