ast-project/part1/results/3/bug_ea98531f-b95f-4bae-afcd-3dff18b255d1_logic.md

Summary

**No review yet**

Minimized query

PRAGMA checkpoint_fullsync;
PRAGMA case_sensitive_like = 1;
PRAGMA collation_list;
.scanstats est
CREATE TABLE t51(x, y);
CREATE TABLE t52(x, y);
CREATE VIEW v5 as SELECT x, y FROM t51 UNION ALL SELECT x, y FROM t52;
CREATE INDEX t51x ON t51(x);
CREATE INDEX t52x ON t52(x);
SELECT * FROM v5 WHERE x='12345' ORDER BY y;
SELECT x, y FROM v5 WHERE x='12345' ORDER BY y;
SELECT x, y FROM v5 WHERE +x='12345' ORDER BY y;

CREATE  VIEW IF NOT EXISTS v_t51_8940 AS SELECT x FROM t51;
SELECT FIRST_VALUE(y) OVER (PARTITION BY y ORDER BY y GROUPS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) FROM t51;
WITH RECURSIVE fib(a,b) AS (VALUES(1,1) UNION ALL SELECT b, a+b FROM fib WHERE b<1000) SELECT a FROM fib;
DELETE FROM t51 WHERE 0;
INSERT INTO t51 DEFAULT VALUES;
UPDATE t52 SET y = 'x' WHERE y IS NOT NULL;
SELECT * FROM t52 AS a RIGHT JOIN t52 AS b ON a.rowid = b.rowid;

Actual output

0|decimal
1|uint
2|RTRIM
3|NOCASE
4|BINARY
1
1
2
3
5
8
13
21
34
55
89
144
233
377
610
987

Expectation

0|decimal
1|BINARY
2|NOCASE
3|RTRIM
4|uint
1
1
2
3
5
8
13
21
34
55
89
144
233
377
610
987

Flag