Hi, SQLite developers,

Please see the below test cases, I meet an unexpected multiple join result.(Here I just refine and reformat my bug report for some proposes.) 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))))))
         INNER JOIN t1 ON ((subQuery.col_0) == (false));
-- 1, 1   Wrong result
-- Expected result: 0, 1