ast-project/part1/results/2/bug_a497a9a4-639f-46e1-bc46-5be9beca3df9_logic.md

Summary

**No review yet**

Minimized query

CREATE TABLE t1(a, b, c);
INSERT INTO t1 VALUES(1,'aaa','bbb');
INSERT INTO t1 SELECT * FROM t1;
INSERT INTO t1 VALUES(2,'ccc','ddd');
SELECT DISTINCT a AS x, b||c AS y FROM t1 WHERE y IN ('aaabbb','xxx');
SELECT DISTINCT a AS x, b||c AS y FROM t1 WHERE +y='aaabbb';

CREATE  INDEX IF NOT EXISTS idx_t1_6751 ON t1(b);
SELECT * FROM t1 AS a INNER JOIN t1 AS b ON a.rowid = b.rowid;
WITH a AS (SELECT * FROM t1), b AS (SELECT * FROM a), c AS (SELECT * FROM b), d AS (SELECT * FROM c) SELECT * FROM d;

Actual output

SQLite version 3.39.0 2022-05-10 23:28:12
Enter ".help" for usage hints.
sqlite> sqlite> sqlite> sqlite> sqlite> 1|aaabbb
sqlite> 1|aaabbb
sqlite> sqlite> sqlite> 1|aaa|bbb|1|aaa|bbb
1|aaa|bbb|1|aaa|bbb
2|ccc|ddd|2|ccc|ddd
sqlite> 1|aaa|bbb
1|aaa|bbb
2|ccc|ddd
sqlite>

Expectation

SQLite version 3.51.1 2025-11-28 17:28:25
Enter ".help" for usage hints.
sqlite> sqlite> sqlite> sqlite> sqlite> 1|aaabbb
sqlite> 1|aaabbb
sqlite> sqlite> sqlite> 1|aaa|bbb|1|aaa|bbb
1|aaa|bbb|1|aaa|bbb
2|ccc|ddd|2|ccc|ddd
sqlite> 1|aaa|bbb
1|aaa|bbb
2|ccc|ddd
sqlite>

Flag

-interactive