On Friday, 1 November, 2019 09:12, And Clover <and-...@doxdesk.com> wrote:
> 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. SQLite version 3.31.0 2019-11-01 16:38:18 Enter ".help" for usage hints. Connected to a transient in-memory database. Use ".open FILENAME" to reopen on a persistent database. sqlite> CREATE TABLE t0 (c0); sqlite> CREATE TABLE t1 (c1); sqlite> INSERT INTO t0 VALUES (1); sqlite> SELECT c0 ...> FROM t0 LEFT JOIN t1 ON c1=c0 ...> WHERE NOT (c1 IS NOT NULL AND c1=2); 1 Appears to be fixed in the current tip ... -- The fact that there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
