Dear SQLite Developers,

I meet a wrong left join result. Please see the below cases. I can reproduce it on the version SQLite version 3.51.0 2025-07-11 14:18:19 and the latest Check-in [a5369e67f7]. I would like to express my gratitude to your efforts in bug fixing and detailed analysis!

CREATE VIRTUAL TABLE t0 USING fts5(c0, c1);

INSERT INTO t0(c0,c1) VALUES (1,0);


SELECT * FROM  t0 LEFT JOIN ( SELECT 0 AS col_0 ) ON ((((t0.c1 MATCH '1')AND(CASE WHEN t0.c0 THEN CAST(t0.c1 AS INTEGER) ELSE 1 END))));
-- Wrong Execution Result: 
-- Expected Result: 1,0,NULL