ast-project/part1/results/3/bug_d6f4dc04-5a1d-4cb1-901c-7273d1e1e065_unexpected_error.md

Summary

**No review yet**

Minimized query

CREATE TABLE t1(a INT, b INT);
INSERT INTO t1(a,b) VALUES(json_set(-power(if(0.0, 9223372036854775809, 9223372036854775809), 9223372036854775809), '$.new_key', 1),null),(null,null),(1,null);
CREATE UNIQUE INDEX t1b ON t1(abs(b));
SELECT quote(a), quote(b), '|' FROM t1 GROUP BY a, abs(b);

INSERT INTO t1 DEFAULT VALUES;
CREATE TEMPORARY  VIEW IF NOT EXISTS v_t1_5266 AS SELECT b FROM t1;
SELECT * FROM t1 WHERE a IN (SELECT a FROM t1 LIMIT 0);
WITH cte AS (SELECT * FROM t1) SELECT * FROM cte c1 JOIN cte c2 ON c1.b = c2.b;
INSERT INTO t1 VALUES (NULL, NULL);
CREATE TRIGGER IF NOT EXISTS trg_t1_2501 BEFORE UPDATE OF a ON t1 FOR EACH ROW BEGIN INSERT INTO t1(a) VALUES (NULL); END;
ANALYZE t1;

Actual output

Parse error near line 2: no such function: if
  INSERT INTO t1(a,b) VALUES(json_set(-power(if(0.0, 9223372036854775809, 922337
                               error here ---^

Expectation

Flag