ast-project/part1/results/3/bug_9283c117-e770-44aa-b5d6-2e2d38d4edef_logic.md

Summary

**No review yet**

Minimized query

PRAGMA module_list;
CREATE TABLE T (
  a INTEGER,
  b TEXT,
  c REAL,
  d REAL
);
INSERT INTO T VALUES (abs(-(-(1))),'a',40.5,-70.0), (2,'b',-10.25,20.5), (3,'c',9e999,-9e999);
SELECT b FROM T WHERE NOT ABS(c) > /**/ 5 AND ABS(d) > 5;
PRAGMA case_sensitive_like = NO;
PRAGMA vdbe_trace = 0;
CREATE TABLE A(Name text);
CREATE TABLE Items(ItemName text , Name text);
INSERT INTO Items VALUES('Item1','Parent');
INSERT INTO Items VALUES('Item2','Parent');
CREATE TABLE B(Name text);
SELECT Items.ItemName FROM Items LEFT JOIN A ON (A.Name = Items.ItemName and Items.ItemName = 'dummy') LEFT JOIN B ON (B.Name = Items.ItemName) WHERE Items.Name = 'Parent' ORDER BY Items.ItemName;

PRAGMA cache_spill = FALSE;
CREATE UNIQUE  INDEX IF NOT EXISTS idx_B_4843 ON B(Name) WHERE Name > 0;
VACUUM main;
INSERT OR ABORT INTO A VALUES ('x');
INSERT INTO B DEFAULT VALUES;
ALTER TABLE B ADD COLUMN extra_827 DOUBLE PRECISION DEFAULT '';
CREATE  VIEW IF NOT EXISTS v_T_4771 AS SELECT d FROM T;
SELECT * FROM T;
PRAGMA legacy_alter_table = 0;
REINDEX Items;

SELECT COUNT(*) 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
Item1
Item2
1|a|40.5|-70.0
2|b|-10.25|20.5
3|c|Inf|-Inf
3

Expectation

fsdir
generate_series
bytecode
dbstat
tables_used
sqlite_stmt
sqlite_dbpage
rtree_i32
fts4aux
fts3
zipfile
fts4
completion
rtree
fts3tokenize
Item1
Item2
1|a|40.5|-70.0
2|b|-10.25|20.5
3|c|Inf|-Inf
3

Flag