ast-project/part1/results/3/bug_31b267bf-8e89-4620-b9f7-d9ef45e0663c_unexpected_error.md

Summary

**No review yet**

Minimized query

PRAGMA defer_foreign_keys = OFF;
ATTACH DATABASE ':memory:' AS aux46;
CREATE TABLE t1(a);
INSERT INTO t1 VALUES(-(-(concat(sqrt(1), 1, 1))));
ALTER TABLE t1 ADD COLUMN b TEXT DEFAULT -123.0;
SELECT b, typeof(b) FROM t1;
ALTER TABLE t1 ADD COLUMN c TEXT DEFAULT -123.5;
ALTER TABLE t1 ADD COLUMN d TEXT DEFAULT 'hello';
SELECT c, typeof(c) FROM t1;

SELECT PERCENT_RANK() OVER (ORDER BY a ROWS BETWEEN UNBOUNDED PRECEDING ANd CURRENT ROW EXCLUDE TIES) FROM t1;
DETACH DATABASE aux46;
SELECT * FROM t1 AS a RIGHT JOIN t1 AS b ON a.rowid = b.rowid;
PRAGMA vdbe_listing = 0;
INSERT INTO t1 SELECT * FROM t1;

Actual output

Parse error near line 4: no such function: concat
  INSERT INTO t1 VALUES(-(-(concat(sqrt(1), 1, 1))));
              error here ---^

Expectation

Flag