ast-project/part1/results/1/bug_386f998f-fe62-4fa4-85b6-939387961e17_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;

Actual output

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

Expectation

Flag