ast-project/part1/results/1/bug_767ab5c0-6ea7-458f-9b20-102fc5550735_logic.md

Summary

**No review yet**

Minimized query

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;

Actual output

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

Expectation

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

Flag