ast-project/part1/results/3/bug_66819bda-b50d-4d8e-b8f9-1e8ac1738f1a_unexpected_error.md

Summary

**No review yet**

Minimized query

PRAGMA temp_store = '0';
-- .log ON

.explain auto
PRAGMA query_only = OFF;
ATTACH DATABASE ':memory:' AS aux18;
.log ON
PRAGMA /**/ legacy_alter_table = ON;
CREATE TABLE [T] (
  a TEXT,
  b INTEGER,
  c REAL
);
INSERT INTO T VALUES ('a',NULL,jsonb_group_array(hex('hello'))), ('a',substr(julianday(CAST(-x'' AS BLOB)), -(-(1))),-3.0), ('b',1,4.5);
SELECT a,b,c,
SUM(c) OVER (
  PARTITION BY a
  ORDER BY b
) AS d
FROM T;
SELECT * FROM T AS a RIGHT OUTER JOIN T AS b ON a.rowid = b.rowid;
SELECT b, (SELECT AVG(b) FROM T) AS avg_val FROM T;
SELECT CUME_DIST() OVER (PARTITION BY a ORDER BY a RANGE BETWEEN 1 PRECEDING AND 1 FOLLOWING) FROM T;
DETACH DATABASE aux18;

Actual output

Parse error near line 14: no such function: jsonb_group_array
  INSERT INTO T VALUES ('a',NULL,jsonb_group_array(hex('hello'))), ('a',substr(j
                   error here ---^

Expectation

Flag