ast-project/part1/results/1/bug_44606ca8-55ca-411a-a08e-f7945de26756_unexpected_error.md

Summary

**No review yet**

Minimized query

ATTACH DATABASE ':memory:' AS aux82;
.vfsinfo
CREATE TABLE T1 (
  a INTEGER,
  b REAL
);
CREATE TABLE T2 (
  a INTEGER,
  b REAL
);
INSERT INTO T1 VALUES (if(format('%s', log2(CAST(1 AS MEDIUMINT))), 1, 1),1.0);
INSERT INTO T2 VALUES (1,-1.0),(2,9e999);
INSERT OR REPLACE INTO T1
SELECT * FROM T2;
SELECT * FROM T1;
PRAGMA defer_foreign_keys = FALSE;
ALTER TABLE T1 ADD COLUMN extra_5658 DOUBLE DEFAULT NULL;
VACUUM main;
CREATE TABLE T (
  a INTEGER,
  b TEXT,
  c REAL
);
INSERT INTO T VALUES (1,'a',1.25), (2,'b',-3.5), (3,'c',9e999);
WITH d AS (SELECT * FROM T) SELECT * FROM d WHERE c > 0;
SELECT * FROM T1 NATURAL JOIN T2;
SELECT * FROM T1 t1 JOIN T1 t2 ON t1.b = (SELECT b FROM T1 LIMIT 1);
DELETE FROM T2 WHERE 0;
INSERT INTO T2 VALUES (NULL, NULL);
INSERT INTO T2 DEFAULT VALUES;
PRAGMA journal_mode = 'PERSIST';
PRAGMA index_list(users);
DETACH DATABASE aux82;

Actual output

vfs.zName      = "unix"
vfs.iVersion   = 3
vfs.szOsFile   = 120
vfs.mxPathname = 512
1|-1.0
2|Inf
1|a|1.25
3|c|Inf
1|-1.0|
2|Inf|
1|-1.0||1|-1.0|
1|-1.0||2|Inf|
memory

Expectation

Flag