ast-project/part1/results/3/bug_3bf84a3b-3b1d-4c74-9eb9-6eddee920e73_logic.md

Summary

**No review yet**

Minimized query

SAVEPOINT sp1382;
PRAGMA defer_foreign_keys = NO;
PRAGMA query_only = FALSE;
PRAGMA cell_size_check = NO;
.log OFF
DROP TABLE IF EXISTS t1;
DROP TABLE IF EXISTS t2;
CREATE TABLE t1(x);
INSERT INTO t1 VALUES(char(1, 2, 3, 4, 5));
CREATE TABLE t2(y,z);
INSERT INTO t2 VALUES(2,3);
CREATE INDEX t2y ON t2(y);
SELECT * FROM t1,(SELECT * FROM t2 WHERE y=2 ORDER BY y,z);

INSERT INTO t1 DEFAULT VALUES;
WITH RECURSIVE cnt(x) AS (VALUES(0) UNION ALL SELECT x-1 FROM cnt WHERE x>-10) SELECT * FROM cnt;
SELECT * FROM t2;
SELECT * FROM t2 WHERE y IN (SELECT y FROM t2 LIMIT 1);
ANALYZE t1;
WITH cte AS (SELECT 1 AS x) SELECT x + 0.5 FROM cte;
SELECT FIRST_VALUE(z) OVER (ORDER BY z RANGE BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING EXCLUDE NO OTHERS) FROM t2;
PRAGMA fullsync = 1;
ROLLBACK TO sp1382;
RELEASE sp1382;

Actual output

|2|3
0
-1
-2
-3
-4
-5
-6
-7
-8
-9
-10
2|3
2|3
1.5
3

Expectation

^A^B^C^D^E|2|3
0
-1
-2
-3
-4
-5
-6
-7
-8
-9
-10
2|3
2|3
1.5
3

Flag