Horton

SQL/JSON: Prevent ON EMPTY for EXISTS columns in JSON_TABLE()

Amit Langote <amitlan@postgresql.org>

View on postgr.es
Commit: e3c1393efc31ac70de7b68e9a283ec3f2d7f9bd2
Author: Amit Langote <amitlan@postgresql.org>
Date: 2024-06-28T05:01:43Z
Releases: 17.0 
SQL/JSON: Prevent ON EMPTY for EXISTS columns in JSON_TABLE()

Due to an oversight in de3600452b61, the ON EMPTY clause was
incorrectly allowed in the EXISTS column. Fix the grammar to prevent
this.

Discussion: https://postgr.es/m/CA%2BHiwqHh3YDXTpccgAo4CdfV9Mhy%2Bmg%3Doh6t8rfM5uLW1BJN4g%40mail.gmail.com

Files

PathChange+/−
src/backend/parser/gram.y modified +3 −3
src/test/regress/expected/sqljson_jsontable.out modified +5 −0
src/test/regress/sql/sqljson_jsontable.sql modified +3 −0

Discussion