## Summary **No review yet** ## Minimized query ```sql 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]}') + 1.7976931348623157e+308))),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; ``` ## Actual output ```sql 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 NULL|NULL|| 1.79769313486231562234e+308|NULL|| 'a'|NULL|| |3 4 a| | 1.79769313486232e+308| | a| | 1.79769313486232e+308| | a| | 1.79769313486232e+308| | ``` ## Expectation ```sql fsdir generate_series bytecode dbstat tables_used sqlite_stmt sqlite_dbpage rtree_i32 fts4aux fts3 zipfile fts4 completion rtree fts3tokenize NULL|NULL|| 1.797693134862315692e+308|NULL|| 'a'|NULL|| |3 4 a| | 1.79769313486232e+308| | a| | 1.79769313486232e+308| | a| | 1.79769313486232e+308| | ``` ## Flag ``` ```