ast-project/part1/results/3/bug_24d8b458-c37c-4d40-9fa4-7140c6023e54_logic.md

Summary

**No review yet**

Minimized query

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

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

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