Hi,
CREATE TABLE t0 (c0);
CREATE TABLE t1 (c1);
INSERT INTO t0 VALUES (1);
SELECT c0
FROM t0 LEFT JOIN t1 ON c1=c0
WHERE NOT (c1 IS NOT NULL AND c1=2);
Expected result: (1)
Actual result: no rows returned
This appears to be a regression in 3.30; 3.29 and earlier give the
expected result.
Reproduced on Windows builds sqlite-dll-win32-x86-3300100,
sqlite-dll-win64-x64-3300100 and sqlite-dll-win64-x64-3300000 (via
Python sqlite3).
cheers,
--
And Clover
mailto:a...@doxdesk.com
https://www.doxdesk.com/
gtalk:chat?jid=bobi...@gmail.com
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users