SQLite Forum

problem report: incorrect join behavior
Login
Another simplification:

> ~~~
CREATE TABLE t1(a INT);
INSERT INTO t1(a) VALUES(1);
CREATE TABLE t2(b INT);
SELECT * FROM (SELECT 3 AS c FROM t1) AS t3 LEFT JOIN t2 ON c IS NULL;
~~~

Should give one row of output, but it fact gives zero rows.