ast-project/part1/results/3/bug_a50f919a-f893-4f87-8130-5acdd83d2b41_unexpected_error.md

Summary

**No review yet**

Minimized query

CREATE TABLE t1(a INTEGER, b TEXT, c BLOB, CHECK( coalesce(b,c) ));
INSERT INTO t1 VALUES(if(0, 1, 1), 2, 3);
ALTER TABLE t1 RENAME COLUMN b TO d;
CREATE TABLE t3(a, b, c, d, e, f, g, h, i, j, k, l, m, FOREIGN KEY (b, c, d, e, f, g, h, i, j, k, l, m) REFERENCES t4);
CREATE TABLE t4(x, y, z);
INSERT INTO t4 VALUES(3, 2, 1);

WITH cte AS (SELECT a, COUNT(*) AS cnt FROM t1 GROUP BY a) SELECT * FROM cte WHERE cnt > 1;

Actual output

Parse error near line 2: no such function: if
  INSERT INTO t1 VALUES(if(0, 1, 1), 2, 3);
                        ^--- error here

Expectation

Flag