ast-project/part1/results/1/bug_ece42722-b71e-4350-9d8f-4e4c9d5d0b31_logic.md

Summary

**No review yet**

Minimized query

PRAGMA vdbe_debug = YES;
PRAGMA index_xinfo(idx1);
PRAGMA index_list(users);
PRAGMA max_page_count = '&';
PRAGMA user_version = 999;
.progress
CREATE TABLE T (
  a INTEGER,
  b REAL
);
INSERT INTO T VALUES (1,1.5), (2,-2.5), (3,0.0);
CREATE INDEX c
ON T(b);
SELECT * FROM T WHERE b >= -2.5 AND b < 2.0;
SELECT * FROM (SELECT * FROM (SELECT * FROM T) AS inner1) AS inner2;
SELECT * FROM (SELECT * FROM T) AS t1 JOIN (SELECT * FROM T) AS t2 ON t1.a = t2.a;
SELECT * FROM T AS a RIGHT OUTER JOIN T AS b ON a.rowid = b.rowid;

Actual output

1073741823
2|-2.5
3|0.0
1|1.5
1|1.5
2|-2.5
3|0.0
1|1.5|1|1.5
2|-2.5|2|-2.5
3|0.0|3|0.0
1|1.5|1|1.5
2|-2.5|2|-2.5
3|0.0|3|0.0

Expectation

4294967294
2|-2.5
3|0.0
1|1.5
1|1.5
2|-2.5
3|0.0
1|1.5|1|1.5
2|-2.5|2|-2.5
3|0.0|3|0.0
1|1.5|1|1.5
2|-2.5|2|-2.5
3|0.0|3|0.0

Flag