ast-project/part1/results/3/bug_ee834e2c-d6f3-44b9-8ae4-7884e7efcf10_unexpected_error.md

Summary

**No review yet**

Minimized query

CREATE TABLE T (
  a INTEGER,
  b TEXT,
  c INTEGER
);
INSERT INTO T VALUES (json_group_array(1),'a',NULL), (2,'b',1), (3,'c',2);
WITH RECURSIVE d(a,b,c,e) AS (
  SELECT *,1 FROM T WHERE c IS NULL
  UNION ALL
  SELECT T.a,T.b,T.c,d.e+1
  FROM T JOIN d ON T.c=d.a
)
SELECT * FROM d;

SELECT COUNT(*) FROM T;
UPDATE T SET c = 'x' WHERE c IS NOT NULL RETURNING *;

Actual output

Parse error near line 6: misuse of aggregate: json_group_array()
  INSERT INTO T VALUES (json_group_array(1),'a',NULL), (2,'b',1), (3,'c',2);
                        ^--- error here

Expectation

Flag

-bail