ast-project/part1/results/2/bug_095dc3fe-e9d7-4c62-8e2d-b7c4245b3937_logic.md

Summary

**No review yet**

Minimized query

PRAGMA short_column_names;
ATTACH DATABASE ':memory:' AS aux31;
ATTACH DATABASE ':memory:' AS aux55;
-- json_set({v}, '$.new_key', {v})

ATTACH DATABASE ':memory:' AS aux6;
CREATE TABLE T (
  a INTEGER,
  b TEXT,
  c REAL
);
INSERT INTO T VALUES (asinh(-7932293039094677366),'a',1.25), (2,'b',-3.5), (3,'c',9e999);
WITH d AS (SELECT * FROM T) SELECT * FROM d WHERE c > 0;
PRAGMA module_list;
PRAGMA journal_mode;
PRAGMA user_version;
.prompt 'IPA eli isopropanoli on loistava puhdistusaine joka irrataa'
CREATE TABLE t1(a,b,x);
CREATE TABLE t2(c,d,y);
CREATE INDEX t1b ON t1(b);
CREATE INDEX t2d ON t2(d);
ANALYZE sqlite_master;
INSERT INTO sqlite_stat1 VALUES('t1','t1b','10000 500');
INSERT INTO sqlite_stat1 VALUES('t2','t2d','10000 500');
ANALYZE sqlite_master;
SELECT * FROM t1, t2 WHERE d=b;
SELECT * FROM t1, t2 WHERE d>b AND x=y;
DETACH DATABASE aux6;
SELECT * FROM T WHERE a IN (SELECT a FROM T);
SELECT MAX(x) FROM t1;
PRAGMA soft_heap_limit = 10000000;
CREATE TEMP  VIEW IF NOT EXISTS v_T_6525 AS SELECT a FROM T;
SELECT * FROM t2 AS a JOIN t1 AS b ON a.rowid = b.rowid;
REINDEX;
SELECT SUM(c) OVER (ORDER BY c RANGE BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING EXCLUDE NO OTHERS) FROM t2;
DETACH DATABASE aux55;
DETACH DATABASE aux31;
UPDATE t1 SET b = CURRENT_TIMESTAMP;
CREATE TEMPORARY  VIEW IF NOT EXISTS v_t1_6727 AS SELECT a FROM t1;
INSERT INTO t1 VALUES (NULL, NULL, NULL);

Actual output

1
-44.210621008338|a|1.25
3|c|Inf
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
memory
0
-44.210621008338|a|1.25
2|b|-3.5
3|c|Inf

10000000

Expectation

1
-44.210621008338|a|1.25
3|c|Inf
fsdir
generate_series
bytecode
dbstat
tables_used
sqlite_stmt
sqlite_dbpage
rtree_i32
fts4aux
fts3
zipfile
fts4
completion
rtree
fts3tokenize
memory
0
-44.210621008338|a|1.25
2|b|-3.5
3|c|Inf

10000000

Flag