ast-project/part1/results/1/bug_bd8b42f5-07e9-4ed3-81de-c78300fa1329_logic.md

Summary

**No review yet**

Minimized query

CREATE TABLE x(id integer primary key, a TEXT NULL);
INSERT INTO x (a) VALUES ('first');
CREATE TABLE tempx(id integer primary key, a TEXT NULL);
INSERT INTO tempx (a) VALUES ('t-first');
CREATE VIEW tv1 AS SELECT x.id, tx.id FROM x JOIN tempx tx ON tx.id=x.id;
CREATE VIEW tv1b AS SELECT x.id, tx.id FROM x JOIN tempx tx on tx.id=x.id;
CREATE VIEW tv2 AS SELECT * FROM tv1 UNION SELECT * FROM tv1b;
SELECT * FROM tv2;

SELECT * FROM tempx;
WITH cte(x) AS (VALUES(CAST(-5075860481212976019 AS NCHAR(55))),(2),(3)) SELECT * FROM cte WHERE x > 1;
PRAGMA automatic_index = 1;

Actual output

1|1
1|t-first
2
3

Expectation

1|1
1|t-first
-5075860481212976019
2
3

Flag