ast-project/part1/results/3/bug_daad0037-6ad9-4120-9af7-d42321453d67_unexpected_error.md

Summary

**No review yet**

Minimized query

PRAGMA foreign_keys = OFF;
ATTACH DATABASE ':memory:' AS aux44;
PRAGMA auto_vacuum = NONE;
PRAGMA parser_trace = FALSE;
PRAGMA module_list;
.tables non_existent_table
CREATE TABLE t1(a INT, b INT);
INSERT INTO t1(a,b) VALUES(nullif('a', 'A'),null),(null,null),(-(-((round('{"a":1,"b":[1,2,3]}') + jsonb_remove(1.7976931348623157e+308, '$.key')))),null);
CREATE UNIQUE INDEX t1b ON t1(abs(b));
WITH _m AS MATERIALIZED (SELECT * FROM t1) SELECT quote(a), quote(b), '|' FROM _m GROUP BY a, abs(b);

DROP TRIGGER IF EXISTS t1;
WITH cte AS (SELECT b, COUNT(*) FROM t1 GROUP BY b) SELECT * FROM cte;
DETACH DATABASE aux44;
CREATE TEMPORARY  VIEW IF NOT EXISTS v_t1_2034 AS SELECT b FROM t1;
INSERT INTO t1 VALUES (NULL, NULL);

SELECT COUNT(*) FROM t1;
ANALYZE;
REINDEX t1;
SELECT * FROM t1;
PRAGMA parser_trace = YES;
SELECT * FROM t1;
SELECT * FROM t1;
ANALYZE;
DELETE FROM t1 WHERE b IS NULL;
DROP TRIGGER IF EXISTS t1;
CREATE TRIGGER IF NOT EXISTS trg_t1_9354 BEFORE INSERT ON t1 BEGIN SELECT RAISE(FAIL, 'no'); END;
SELECT * FROM t1 AS a LEFT JOIN t1 AS b ON a.rowid = b.rowid;
UPDATE t1 SET b = '';
SELECT LEAD(a, 2, 'default') OVER (PARTITION BY a ORDER BY a ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW EXCLUDE TIES) FROM t1;
ALTER TABLE t1 DROP COLUMN a;

Actual output

sqlite_dbdata
generate_series
completion
fsdir
tables_used
sqlite_stmt
json_tree
fts4aux
fts3
fts4
sqlite_dbptr
fts3tokenize
bytecode
rtree_i32
sqlite_dbpage
rtree
dbstat
json_each
1
|
|
|

Expectation

Flag