ast-project/part1/results/1/bug_c73cb6e7-8169-4a3a-90e2-ea30345bd2aa_unexpected_error.md

Summary

**No review yet**

Minimized query

CREATE TABLE T1 (
  a INTEGER,
  b REAL
);
CREATE TABLE T2 (
  a INTEGER,
  b REAL
);
INSERT INTO T1 VALUES (if(1, 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;
SELECT * FROM T1 NATURAL JOIN T2;
REINDEX;
CREATE TEMP  VIEW IF NOT EXISTS v_T2_1378 AS SELECT b FROM T2;

Actual output

1|-1.0
2|Inf
1|-1.0|
2|Inf|

Expectation

Flag