ast-project/part1/results/1/bug_20ec678e-ff15-4102-aef5-1d9a47c1aeeb_logic.md

Summary

**No review yet**

Minimized query

PRAGMA recursive_triggers = TRUE;
CREATE TABLE T /* PRAGMA vdbe_addoptrace = NO; */ (
  a CHARINT,
  b REAL,
  c REAL
);
INSERT INTO T VALUES (sqlite_compileoption_get(-1),1.5,10.0), (2,-2.5,20.0), (3,-9e999,30.0);
SELECT * FROM T WHERE NOT b < 2.0 ORDER BY b;

SELECT COUNT(*) FROM T;
WITH cte AS (SELECT a, SUM(a) AS total FROM T GROUP BY a) SELECT * FROM cte ORDER BY total DESC;
DROP TRIGGER IF EXISTS T;
SELECT * FROM T;
INSERT OR ABORT INTO T VALUES ('', -4, '');
VACUUM main;
PRAGMA module_list;

Actual output

3
3|3
2|2
|
|1.5|10.0
2|-2.5|20.0
3|-Inf|30.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

Expectation

3
3|3
2|2
|
|1.5|10.0
2|-2.5|20.0
3|-Inf|30.0
fsdir
generate_series
bytecode
dbstat
tables_used
sqlite_stmt
sqlite_dbpage
rtree_i32
fts4aux
fts3
zipfile
fts4
completion
rtree
fts3tokenize

Flag

-nofollow