regression.diffs
application/octet-stream
Filename: regression.diffs
Type: application/octet-stream
Part: 0
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
------------------