ast-project/part1/results/1/bug_f8d4c07f-f290-4458-b272-ee72452cdcbd_unexpected_error.md

Summary

**No review yet**

Minimized query

CREATE TABLE T (
  a TEXT,
  b TEXT,
  c REAL
);
INSERT INTO T VALUES ('a','b',jsonb_object('k', ln(1.5))), ('a','c',-2.25), ('b','b',4.75);
SELECT a,
SUM(CASE WHEN b='b' THEN c ELSE 0 END) AS d,
SUM(CASE WHEN b='c' THEN c ELSE 0 END) AS e
FROM T
GROUP BY a;

Actual output

Parse error near line 6: no such function: jsonb_object
  INSERT INTO T VALUES ('a','b',jsonb_object('k', ln(1.5))), ('a','c',-2.25), ('
                  error here ---^

Expectation

Flag

-vfs memdb