Fix jsonpath existense checking of missing variables
authorAlexander Korotkov <akorotkov@postgresql.org>
Thu, 12 Jan 2023 15:16:34 +0000 (18:16 +0300)
committerAlexander Korotkov <akorotkov@postgresql.org>
Thu, 12 Jan 2023 15:17:43 +0000 (18:17 +0300)
commit4dc3f94fae3de3f19b5c7dd507beac0216b0cde9
tree8722a2aba4f16dfee6c3cdbea3cc3f556ead1330
parent6f25e48774fe9302ca08dae07420df95998d792a
Fix jsonpath existense checking of missing variables

The current jsonpath code assumes that the referenced variable always exists.
It could only throw an error at the value valuation time.  At the same time
existence checking assumes variable is present without valuation, and error
suppression doesn't work for missing variables.

This commit makes existense checking trigger an error for missing variables.
This makes the overall behavior consistent.

Backpatch to 12 where jsonpath was introduced.

Reported-by: David G. Johnston
Discussion: https://postgr.es/m/CAKFQuwbeytffJkVnEqDyLZ%3DrQsznoTh1OgDoOF3VmOMkxcTMjA%40mail.gmail.com
Author: Alexander Korotkov, David G. Johnston
Backpatch-through: 12
src/backend/utils/adt/jsonpath_exec.c
src/test/regress/expected/jsonb_jsonpath.out
src/test/regress/sql/jsonb_jsonpath.sql