ast-project/part1/results/1/bug_d65631a1-e76e-44dc-9b3e-5effb32d5eb0_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;

Actual output

1|-1.0
2|Inf

Expectation

Flag