On Thu, Jun 6, 2024 at 6:20 PM Amit Langote <amitlangot...@gmail.com> wrote: > > Hi, > > Alvaro reported off-list that the following should really fail, > because the jsonpath expression refers to a PASSING variable that > doesn't exist: > > select json_query('"1"', jsonpath '$xy' passing 2 AS xyz); > json_query > ------------ > 2 > (1 row) > > This works because of a bug in GetJsonPathVar() whereby it allows a > jsonpath expression to reference any prefix of the PASSING variable > names. > > Attached is a patch to fix that.
Here's an updated version that I'll push tomorrow. -- Thanks, Amit Langote
v2-0001-SQL-JSON-Correct-jsonpath-variable-name-matching.patch
Description: Binary data