ast-project/part1/results/1/bug_73b05429-e52e-4314-b585-34eaaf11e67c_logic.md

Summary

**No review yet**

Minimized query

PRAGMA module_list;
CREATE TABLE T (
  A VARCHAR(20),
  B VARCHAR(10),
  C INTEGER,
  PRIMARY KEY (A, B)
);
INSERT INTO T VALUES (('a' || ''), 'p', -2147483648);
INSERT INTO T VALUES ('b', 'q', 100);
INSERT INTO T VALUES ('b', 'r', 200);
INSERT INTO T VALUES ('c', 's', 300);
INSERT INTO T VALUES ('d', 't', 2147483647);
INSERT INTO T VALUES ('b', 't', 50);
SELECT /* PRAGMA case_sensitive_like = NO; */ A, COUNT(*) AS D, SUM(C) AS E FROM T GROUP BY A HAVING COUNT(*) > 1;
CREATE TEMPORARY  VIEW IF NOT EXISTS v_T_6362 AS SELECT A FROM T;
SELECT AVG(C) FROM T;

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
b|3|350
108.166666666667

Expectation

fsdir
generate_series
bytecode
dbstat
tables_used
sqlite_stmt
sqlite_dbpage
rtree_i32
fts4aux
fts3
zipfile
fts4
completion
rtree
fts3tokenize
b|3|350
108.166666666667

Flag