ast-project/part1/results/1/bug_40d33f4f-3d58-4415-84e2-3de123418153_unexpected_error.md

Summary

**No review yet**

Minimized query

BEGIN;
CREATE TABLE T1 (
  a INTEGER,
  b TEXT
);
CREATE TABLE T2 (
  a INTEGER,
  b TEXT
);
INSERT INTO T1 VALUES (if('', 1, 1),'a'),(2,'b');
INSERT INTO T2 VALUES (1,'c'),(1,'d');
SELECT T1.b,
(
  SELECT GROUP_CONCAT(b,',')
  FROM T2
  WHERE T2.a=T1.a
) AS c
FROM T1;
END;
CREATE TRIGGER IF NOT EXISTS trg_T1_2488 AFTER UPDATE OF a ON T1 BEGIN SELECT RAISE(ABORT, 'abort'); END;
DELETE FROM T1 WHERE 1;
INSERT INTO T1 SELECT * FROM T1;
VACUUM;

Actual output

Parse error near line 10: no such function: if
  INSERT INTO T1 VALUES (if('', 1, 1),'a'),(2,'b');
                         ^--- error here

Expectation

Flag