ast-project/part1/results/3/bug_6fca0ccb-e03c-4307-9ffe-870801e951f5_logic.md

Summary

**No review yet**

Minimized query

PRAGMA secure_delete = NO;
PRAGMA checkpoint_fullsync;
PRAGMA case_sensitive_like = 2.718281828459045;
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 /* NTH_VALUE({c}, 1) */ 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;
PRAGMA table_list("users");
PRAGMA count_changes = NO;
INSERT INTO t52 DEFAULT VALUES;

Actual output

0
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
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