ast-project/part1/results/1/bug_fdc515bd-2b20-44a3-a1e4-a09046d0ae57_unexpected_error.md

Summary

**No review yet**

Minimized query

ATTACH DATABASE '' || (':memory:') AS aux69;
CREATE TABLE T (
  a INT2,
  b TEXT,
  c REAL
);
INSERT INTO T VALUES ('a','b',-concat_ws('|', 'a', 'b', 'c')), ('a','c',5.0), ('b','d',-8.25);
SELECT a,b,c,
RANK() OVER (PARTITION BY a ORDER BY c DESC) AS d FROM T;
ATTACH DATABASE ':memory:' AS aux60;
BEGIN EXCLUSIVE;
ATTACH DATABASE ':memory:' AS aux0;
-- PRAGMA automatic_index = 1;

.quit
PRAGMA short_column_names > unistr('Hello\u0041');
PRAGMA empty_result_callbacks = OFF;
PRAGMA journal_mode = 'MEMORY';
.expert
CREATE TABLE "t3893"("x");
INSERT INTO t3893 VALUES(format('%.*s', x'295e035cb918ad9d9555' ->> '$', jsonb_object('k', (max(json_array_length(1, '$.nonexistent'), 2, 3, 4, 5) + 0).7976931348623157e+308)));
SELECT "y"."x" FROM (SELECT "x" FROM "t3893") AS "y";


SELECT COUNT(*) FROM t3893;
CREATE TRIGGER IF NOT EXISTS trg_t3893_1953 BEFORE UPDATE ON t3893 BEGIN SELECT RAISE(FAIL, 'no'); END;
SELECT LEAD(x, 1, NULL) OVER (PARTITION BY x ORDER BY x RANGE BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING EXCLUDE NO OTHERS) FROM t3893;
DETACH DATABASE aux0;
WITH cte(x) AS (VALUES(1),(2),(3)) SELECT * FROM t3893 WHERE NOT x IN (SELECT x FROM cte);
SELECT COUNT(*) FILTER (WHERE x IS NOT NULL), SUM(rowid) FILTER (WHERE +x > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(x) FILTER (WHERE x > 0 AND x < 100), COUNT(*) FILTER (WHERE typeof(x) = "text") FROM t3893;
SELECT LAST_VALUE(x) OVER (PARTITION BY x ORDER BY x ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW EXCLUDE TIES) FROM t3893;
INSERT INTO t3893 SELECT * FROM t3893;
ROLLBACK;
INSERT INTO t3893 VALUES (1) ON CONFLICT(x) DO UPDATE SET x = excluded.x;
CREATE  INDEX IF NOT EXISTS idx_t3893_4855 ON t3893(lower(x));
DROP INDEX IF EXISTS t3893;
SELECT * FROM t3893 t1 JOIN (SELECT * FROM t3893) AS sub ON t1.x = sub.x;
SELECT SUM(x) FILTER (WHERE x > 0) OVER (ORDER BY x RANGE BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING EXCLUDE NO OTHERS) FROM t3893;
DELETE FROM t3893 WHERE x > (SELECT AVG(x) FROM t3893);
WITH cte(x) AS (VALUES(1),(2),(3)) SELECT * FROM t3893 WHERE x IN (SELECT x FROM cte);
WITH RECURSIVE r AS (SELECT x FROM t3893 WHERE x IS NOT NULL UNION ALL SELECT x FROM r WHERE x > 0 LIMIT 10) SELECT * FROM r;
SELECT * FROM t3893;
DETACH DATABASE aux60;
ANALYZE;

VACUUM;
INSERT INTO T VALUES (NULL, NULL, NULL);
INSERT OR FAIL INTO T VALUES (6, '', '');
ALTER TABLE t3893 RENAME TO t3893_r9196;
INSERT INTO t3893 VALUES (1) ON CONFLICT(x) DO UPDATE SET x = excluded.x;
VACUUM;
SELECT * FROM t3893 AS a LEFT JOIN T AS b ON a.rowid = b.rowid;
REINDEX;
INSERT INTO t3893 SELECT * FROM t3893;
DROP VIEW IF EXISTS t3893;
DELETE FROM t3893 WHERE rowid = 32 RETURNING *;
CREATE  INDEX IF NOT EXISTS idx_t3893_5088 ON t3893((x + 1)) WHERE x > 0;
DETACH DATABASE aux69;
DELETE FROM T WHERE rowid = 59;
SELECT * FROM t3893;
CREATE TEMPORARY  VIEW IF NOT EXISTS v_T_3907 AS SELECT b FROM T;

Actual output

Parse error near line 7: no such function: concat_ws
  INSERT INTO T VALUES ('a','b',-concat_ws('|', 'a', 'b', 'c')), ('a','c',5.0), 
                   error here ---^

Expectation

Flag