ast-project/part1/results/2/bug_789ffe58-11a9-494b-a5b7-07f5c44383e4_logic.md

Summary

**No review yet**

Minimized query

BEGIN;
SAVEPOINT sp8941;
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(-CAST(atan(-(-(7932293039094677366))) AS BOOLEAN)),'a',1.25), (2,'b',-3.5), (3,'c',9e999);
WITH d AS (SELECT * FROM T) SELECT * FROM d WHERE NOT NOT (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);
ROLLBACK TO sp8941;
RELEASE sp8941;
REINDEX;
CREATE TABLE T (
  A VARCHAR(15) PRIMARY KEY,
  B VARCHAR(30) NOT NULL,
  C BIGINT UNIQUE
);
INSERT INTO T VALUES ('a', 'x', -9223372036854775808);
INSERT INTO T VALUES ('b', 'y', -1000000);
INSERT INTO T VALUES ('c', 'y', 0);
INSERT INTO T VALUES ('d', 'y', 42);
INSERT INTO T VALUES ('e', 'x', 9223372036854775807);
INSERT INTO T VALUES ('f', 'z', 2147483648);
SELECT * FROM T WHERE C > 0 ORDER BY C DESC;
END TRANSACTION;
ALTER TABLE T RENAME TO T_r3599;

Actual output

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

10000000
e|x|9223372036854775807
f|z|2147483648
d|y|42

Expectation

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

10000000
e|x|9223372036854775807
f|z|2147483648
d|y|42

Flag