Hello,
I have come across a strange behaviour of SQLite 3.7.5.
The following query:
SELECT DISTINCT COALESCE(a.xxx, b.yyy) value
FROM tbl1 a
LEFT OUTER JOIN tbl2 b
ON a.zzz = b.ttt
EXCEPT
SELECT DISTINCT ggg value
FROM tbl3;
will not return any results (which seems to be correct).
However, when I write it this way:
SELECT DISTINCT COALESCE(a.xxx, b.yyy) value
FROM tbl1 a
LEFT OUTER JOIN tbl2 b
ON a.zzz = b.ttt
WHERE value NOT IN (
SELECT DISTINCT ggg
FROM tbl3
);
I get results (which are wrong).
I could send a samble database with full query to a developer if
needed in order to reproduce that.
Is this known bug?
Thank you,
Benoit
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
