ast-project/part1/results/3/bug_c4650700-bfbe-44c9-b08e-20f1c300a7ad_unexpected_error.md

Summary

**No review yet**

Minimized query

PRAGMA writable_schema = YES;
CREATE TABLE main.T (
  a TEXT,
  b TEXT,
  c REAL
);
INSERT INTO T VALUES ('a','b',-(-('[1,2,3]'))), ('a','c',-datetime(x'3ea400a5e66ccb', '+1 day')), ('b','d',jsonb_array(0.0));
SELECT
COALESCE(a,'e') AS d,
COALESCE(b,'f') AS e,
SUM(c) AS f
FROM T
GROUP BY a,b;
WITH cte AS (SELECT * FROM T), cte2 AS (SELECT * FROM cte) SELECT * FROM cte2;
CREATE UNIQUE  INDEX IF NOT EXISTS idx_T_7700 ON T(b COLLATE NOCASE) WHERE NOT NOT (b IS NOT NULL) ;
REINDEX T;
INSERT INTO T VALUES (NULL, NULL, NULL);
CREATE TRIGGER IF NOT EXISTS trg_T_5109 AFTER INSERT ON T FOR EACH ROW BEGIN SELECT RAISE(IGNORE); END;
WITH cte AS (SELECT a, SUM(a) AS total FROM T GROUP BY a) SELECT * FROM cte ORDER BY total DESC;
PRAGMA vdbe_debug = NO;
VACUUM;
WITH RECURSIVE cnt(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM cnt WHERE x<98) SELECT * FROM cnt;

SELECT MIN(c) OVER (PARTITION BY c ORDER BY c RANGE BETWEEN 1 PRECEDING AND 1 FOLLOWING) FROM T;
SELECT * FROM T;
CREATE UNIQUE  INDEX IF NOT EXISTS idx_T_7241 ON T(b COLLATE NOCASE);

Actual output

|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98

||

Expectation

Flag