diff -U3 /home/vagrant/postgres/src/test/regress/expected/jsonb_jsonpath.out /home/vagrant/postgres/src/test/regress/results/jsonb_jsonpath.out --- /home/vagrant/postgres/src/test/regress/expected/jsonb_jsonpath.out 2022-12-07 22:32:22.239087891 +0000 +++ /home/vagrant/postgres/src/test/regress/results/jsonb_jsonpath.out 2022-12-07 22:33:27.539969274 +0000 @@ -486,7 +486,10 @@ (1 row) select * from jsonb_path_query('{"a": 10}', '$ ? (@.a < $value)'); -ERROR: could not find jsonpath variable "value" + jsonb_path_query +------------------ +(0 rows) + select * from jsonb_path_query('{"a": 10}', '$ ? (@.a < $value)', '1'); ERROR: "vars" argument is not an object DETAIL: Jsonpath parameters should be encoded as key-value pairs of "vars" object. @@ -2213,7 +2216,10 @@ (0 rows) SELECT jsonb_path_query('[{"a": 1}]', '$undefined_var'); -ERROR: could not find jsonpath variable "undefined_var" + jsonb_path_query +------------------ +(0 rows) + SELECT jsonb_path_query('[{"a": 1}]', 'false'); jsonb_path_query ------------------ @@ -2291,7 +2297,11 @@ (1 row) SELECT jsonb_path_query_first('[{"a": 1}]', '$undefined_var'); -ERROR: could not find jsonpath variable "undefined_var" + jsonb_path_query_first +------------------------ + +(1 row) + SELECT jsonb_path_query_first('[{"a": 1}]', 'false'); jsonb_path_query_first ------------------------ @@ -2331,7 +2341,7 @@ SELECT jsonb_path_exists('[{"a": 1}]', '$undefined_var'); jsonb_path_exists ------------------- - t + f (1 row) SELECT jsonb_path_exists('[{"a": 1}]', 'false'); @@ -2403,7 +2413,7 @@ (1 row) SELECT jsonb_path_match('[{"a": 1}]', '$undefined_var'); -ERROR: could not find jsonpath variable "undefined_var" +ERROR: single boolean result is expected SELECT jsonb_path_match('[{"a": 1}]', 'false'); jsonb_path_match ------------------