regression.diffs

application/octet-stream

Filename: regression.diffs
Type: application/octet-stream
Part: 0
Message: Re: Bug in jsonb_path_exists (maybe _match) one-element scalar/variable jsonpath handling
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 
 ------------------