## Summary **No review yet** ## Minimized query ```sql 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),(1,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; ``` ## 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|NULL|| 'a'|NULL|| |3 4 a| | 1| | ``` ## 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|NULL|| 'a'|NULL|| |3 4 a| | 1| | ``` ## Flag ``` ```