diff options
Diffstat (limited to 'src/test/regress/sql')
-rw-r--r-- | src/test/regress/sql/jsonpath.sql | 3 | ||||
-rw-r--r-- | src/test/regress/sql/jsonpath_encoding.sql | 23 |
2 files changed, 1 insertions, 25 deletions
diff --git a/src/test/regress/sql/jsonpath.sql b/src/test/regress/sql/jsonpath.sql index 29ea77a4858..7afe2528c3b 100644 --- a/src/test/regress/sql/jsonpath.sql +++ b/src/test/regress/sql/jsonpath.sql @@ -30,10 +30,9 @@ select '$.a/+-1'::jsonpath; select '1 * 2 + 4 % -3 != false'::jsonpath; select '"\b\f\r\n\t\v\"\''\\"'::jsonpath; -select '''\b\f\r\n\t\v\"\''\\'''::jsonpath; select '"\x50\u0067\u{53}\u{051}\u{00004C}"'::jsonpath; -select '''\x50\u0067\u{53}\u{051}\u{00004C}'''::jsonpath; select '$.foo\x50\u0067\u{53}\u{051}\u{00004C}\t\"bar'::jsonpath; +select '"\z"'::jsonpath; -- unrecognized escape is just the literal char select '$.g ? ($.a == 1)'::jsonpath; select '$.g ? (@ == 1)'::jsonpath; diff --git a/src/test/regress/sql/jsonpath_encoding.sql b/src/test/regress/sql/jsonpath_encoding.sql index a3b5bc39a1c..3a23b728182 100644 --- a/src/test/regress/sql/jsonpath_encoding.sql +++ b/src/test/regress/sql/jsonpath_encoding.sql @@ -24,29 +24,6 @@ select '"dollar \\u0024 character"'::jsonpath as not_an_escape; select '"null \u0000 escape"'::jsonpath as not_unescaped; select '"null \\u0000 escape"'::jsonpath as not_an_escape; --- checks for single-quoted values - --- basic unicode input -SELECT E'\'\u\''::jsonpath; -- ERROR, incomplete escape -SELECT E'\'\u00\''::jsonpath; -- ERROR, incomplete escape -SELECT E'\'\u000g\''::jsonpath; -- ERROR, g is not a hex digit -SELECT E'\'\u0000\''::jsonpath; -- OK, legal escape -SELECT E'\'\uaBcD\''::jsonpath; -- OK, uppercase and lower case both OK - --- handling of unicode surrogate pairs -select E'\'\ud83d\ude04\ud83d\udc36\''::jsonpath as correct_in_utf8; -select E'\'\ud83d\ud83d\''::jsonpath; -- 2 high surrogates in a row -select E'\'\ude04\ud83d\''::jsonpath; -- surrogates in wrong order -select E'\'\ud83dX\''::jsonpath; -- orphan high surrogate -select E'\'\ude04X\''::jsonpath; -- orphan low surrogate - ---handling of simple unicode escapes -select E'\'the Copyright \u00a9 sign\''::jsonpath as correct_in_utf8; -select E'\'dollar \u0024 character\''::jsonpath as correct_everywhere; -select E'\'dollar \\u0024 character\''::jsonpath as not_an_escape; -select E'\'null \u0000 escape\''::jsonpath as not_unescaped; -select E'\'null \\u0000 escape\''::jsonpath as not_an_escape; - -- checks for quoted key names -- basic unicode input |