Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

Commit11c9650

Browse files
author
Nikita Glukhov
committed
Fix json tests
1 parent74f1abf commit11c9650

File tree

3 files changed

+7
-7
lines changed

3 files changed

+7
-7
lines changed

‎src/test/regress/expected/json.out

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -3970,7 +3970,7 @@ select pg_column_size('{}'::json || '{}'::json) = pg_column_size('{}'::json);
39703970
t
39713971
(1 row)
39723972

3973-
select pg_column_size('{"aa":1}'::json || '{"b":2}'::json) = pg_column_size('{"aa":1, "b":2}'::json);
3973+
select pg_column_size('{"aa":1}'::json || '{"b":2}'::json) = pg_column_size('{"aa":1, "b":2}'::json);
39743974
?column?
39753975
----------
39763976
t
@@ -4048,7 +4048,7 @@ select '{"a":1 , "b":2, "c":3}'::json - 'd';
40484048
{"a": 1, "b": 2, "c": 3}
40494049
(1 row)
40504050

4051-
select pg_column_size('{"a":1 , "b":2, "c":3}'::json - 'b') = pg_column_size('{"a":1, "b":2}'::json);
4051+
select pg_column_size('{"a":1 , "b":2, "c":3}'::json - 'b') = pg_column_size('{"a":1, "b":2}'::json);
40524052
?column?
40534053
----------
40544054
t

‎src/test/regress/expected/json_encoding.out

Lines changed: 3 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -48,9 +48,9 @@ SELECT '"\uaBcD"'::json;-- OK, uppercase and lower case both OK
4848

4949
-- handling of unicode surrogate pairs
5050
select json '{ "a": "\ud83d\ude04\ud83d\udc36" }' -> 'a' as correct_in_utf8;
51-
correct_in_utf8
52-
----------------------------
53-
"\ud83d\ude04\ud83d\udc36"
51+
correct_in_utf8
52+
-----------------
53+
"😄🐶"
5454
(1 row)
5555

5656
select json '{ "a": "\ud83d\ud83d" }' -> 'a'; -- 2 high surrogates in a row

‎src/test/regress/sql/json.sql

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -1150,7 +1150,7 @@ select '{"c": 1}'::json || '["a", "b"]';
11501150
select'{}'::json||'{"cq":"l", "b":"g", "fg":false}';
11511151

11521152
select pg_column_size('{}'::json||'{}'::json)= pg_column_size('{}'::json);
1153-
select pg_column_size('{"aa":1}'::json||'{"b":2}'::json)= pg_column_size('{"aa":1, "b":2}'::json);
1153+
select pg_column_size('{"aa":1}'::json||'{"b":2}'::json)= pg_column_size('{"aa":1, "b":2}'::json);
11541154
select pg_column_size('{"aa":1, "b":2}'::json||'{}'::json)= pg_column_size('{"aa":1, "b":2}'::json);
11551155
select pg_column_size('{}'::json||'{"aa":1, "b":2}'::json)= pg_column_size('{"aa":1, "b":2}'::json);
11561156

@@ -1164,7 +1164,7 @@ select '{"a":null , "b":2, "c":3}'::json - 'a';
11641164
select'{"a":1 , "b":2, "c":3}'::json-'b';
11651165
select'{"a":1 , "b":2, "c":3}'::json-'c';
11661166
select'{"a":1 , "b":2, "c":3}'::json-'d';
1167-
select pg_column_size('{"a":1 , "b":2, "c":3}'::json-'b')= pg_column_size('{"a":1, "b":2}'::json);
1167+
select pg_column_size('{"a":1 , "b":2, "c":3}'::json-'b')= pg_column_size('{"a":1, "b":2}'::json);
11681168

11691169
select'["a","b","c"]'::json-3;
11701170
select'["a","b","c"]'::json-2;

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp