1 files changed, 12 insertions, 0 deletions
diff --git a/src/test/regress/sql/json.sql b/src/test/regress/sql/json.sql
index 4db55474011..c9801321e09 100644
--- a/src/test/regress/sql/json.sql
+++ b/src/test/regress/sql/json.sql
@@ -248,6 +248,7 @@ select '{"a": [{"b": "c"}, {"b": "cc"}]}'::json -> '';
 select '[{"b": "c"}, {"b": "cc"}]'::json -> 1;
 select '[{"b": "c"}, {"b": "cc"}]'::json -> 3;
 select '[{"b": "c"}, {"b": "cc"}]'::json -> 'z';
+select '{"a": "c", "b": null}'::json -> 'b';
 select '"foo"'::json -> 1;
 select '"foo"'::json -> 'z';
 
@@ -259,6 +260,7 @@ select '{"a": [{"b": "c"}, {"b": "cc"}]}'::json ->> '';
 select '[{"b": "c"}, {"b": "cc"}]'::json ->> 1;
 select '[{"b": "c"}, {"b": "cc"}]'::json ->> 3;
 select '[{"b": "c"}, {"b": "cc"}]'::json ->> 'z';
+select '{"a": "c", "b": null}'::json ->> 'b';
 select '"foo"'::json ->> 1;
 select '"foo"'::json ->> 'z';
 
@@ -312,6 +314,10 @@ select '{"f2":["f3",1],"f4":{"f5":99,"f6":"stringy"}}'::json#>>array['f2','1'];
 
 -- corner cases for same
 select '{"a": {"b":{"c": "foo"}}}'::json #> '{}';
+select '[1,2,3]'::json #> '{}';
+select '"foo"'::json #> '{}';
+select '42'::json #> '{}';
+select 'null'::json #> '{}';
 select '{"a": {"b":{"c": "foo"}}}'::json #> array['a'];
 select '{"a": {"b":{"c": "foo"}}}'::json #> array['a', null];
 select '{"a": {"b":{"c": "foo"}}}'::json #> array['a', ''];
@@ -323,11 +329,16 @@ select '{"a": [{"b": "c"}, {"b": "cc"}]}'::json #> array['a','1','b'];
 select '{"a": [{"b": "c"}, {"b": "cc"}]}'::json #> array['a','z','b'];
 select '[{"b": "c"}, {"b": "cc"}]'::json #> array['1','b'];
 select '[{"b": "c"}, {"b": "cc"}]'::json #> array['z','b'];
+select '[{"b": "c"}, {"b": null}]'::json #> array['1','b'];
 select '"foo"'::json #> array['z'];
 select '42'::json #> array['f2'];
 select '42'::json #> array['0'];
 
 select '{"a": {"b":{"c": "foo"}}}'::json #>> '{}';
+select '[1,2,3]'::json #>> '{}';
+select '"foo"'::json #>> '{}';
+select '42'::json #>> '{}';
+select 'null'::json #>> '{}';
 select '{"a": {"b":{"c": "foo"}}}'::json #>> array['a'];
 select '{"a": {"b":{"c": "foo"}}}'::json #>> array['a', null];
 select '{"a": {"b":{"c": "foo"}}}'::json #>> array['a', ''];
@@ -339,6 +350,7 @@ select '{"a": [{"b": "c"}, {"b": "cc"}]}'::json #>> array['a','1','b'];
 select '{"a": [{"b": "c"}, {"b": "cc"}]}'::json #>> array['a','z','b'];
 select '[{"b": "c"}, {"b": "cc"}]'::json #>> array['1','b'];
 select '[{"b": "c"}, {"b": "cc"}]'::json #>> array['z','b'];
+select '[{"b": "c"}, {"b": null}]'::json #>> array['1','b'];
 select '"foo"'::json #>> array['z'];
 select '42'::json #>> array['f2'];
 select '42'::json #>> array['0'];