Hi, SQLite developers,

Please see the below test cases. After I add where t1.c0, which will be evaluated as true, on the first join query, the second query wrongly produces the value of t0.c0. The version I use is SQLite version 3.49.1 2025-02-18 13:38:58.

CREATE TABLE t0 (c0 INT);
CREATE TABLE t1 (c0 INT);
INSERT INTO t1 VALUES (1);
INSERT INTO t0 VALUES (0);

SELECT (t0.c0 is null), t1.c0
FROM (SELECT TOTAL(0) OVER () AS col_0 FROM t0) as subQuery
         LEFT JOIN t0 ON ((CASE 1
                                     WHEN 1 THEN subQuery.col_0
                                      END) LIKE (((((subQuery.col_0))))))
         LEFT JOIN t1 ON ((subQuery.col_0) == (false));
-- 0, 1
SELECT (t0.c0 is null), t1.c0
FROM (SELECT TOTAL(0) OVER () AS col_0 FROM t0) as subQuery
         LEFT JOIN t0 ON ((CASE 1
                                     WHEN 1 THEN subQuery.col_0
                                      END) LIKE (((((subQuery.col_0))))))
         LEFT JOIN t1 ON ((subQuery.col_0) == (false)) where t1.c0;
-- 1, 1   Wrong result, expected result: 0, 1