ast-project/part1/results/3/bug_63861303-8a2c-41db-8b5c-72d2a5a808e3_logic.md

Summary

**No review yet**

Minimized query

PRAGMA query_only;
PRAGMA module_list;
CREATE TABLE T (
  a INTEGER,
  b TEXT,
  c REAL,
  d REAL
);
INSERT INTO T VALUES (abs(-(-((0 + 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

0

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

0

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

-newline "

"