ast-project/part1/results/1/bug_1e7b20ae-cb90-4cb9-b12b-6f459c5aa3dd_unexpected_error.md

Summary

**No review yet**

Minimized query

CREATE TABLE T (
  a TEXT,
  b REAL
);
INSERT INTO T VALUES ('a',jsonb_array()), ('b',-nullif(NULL, NULL)), ('c',9e999);
SELECT a,b,
LEAD(b,1) OVER (ORDER BY b DESC) AS c,
NTILE(2) OVER (ORDER BY b DESC) AS d FROM T;
INSERT OR ROLLBACK INTO T VALUES (NULL, '');
SELECT AVG(a) FROM T;
CREATE UNIQUE  INDEX IF NOT EXISTS idx_T_1267 ON T(b) WHERE b > 0;
CREATE  INDEX IF NOT EXISTS idx_T_1060 ON T(a) WHERE a IS NOT NULL;

Actual output

Parse error near line 5: no such function: jsonb_array
  INSERT INTO T VALUES ('a',jsonb_array()), ('b',-nullif(NULL, NULL)), ('c',9e99
              error here ---^

Expectation

Flag