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

Commit29f710c

Browse files
author
Nikita Glukhov
committed
Fix jsonpath timestamptz encoding in jsonb tests
1 parent779f6bd commit29f710c

File tree

2 files changed

+62
-0
lines changed

2 files changed

+62
-0
lines changed

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

Lines changed: 50 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -436,6 +436,37 @@ SELECT JSON_VALUE(jsonb 'null', '$a' PASSING point ' (1, 2 )' AS a RETURNING poi
436436
(1,2)
437437
(1 row)
438438

439+
-- Test timestamptz passing and output
440+
SELECT JSON_VALUE(jsonb 'null', '$ts' PASSING timestamptz '2018-02-21 12:34:56 +10' AS ts);
441+
json_value
442+
------------------------------
443+
Tue Feb 20 18:34:56 2018 PST
444+
(1 row)
445+
446+
SELECT JSON_VALUE(jsonb 'null', '$ts' PASSING timestamptz '2018-02-21 12:34:56 +10' AS ts RETURNING timestamptz);
447+
json_value
448+
------------------------------
449+
Tue Feb 20 18:34:56 2018 PST
450+
(1 row)
451+
452+
SELECT JSON_VALUE(jsonb 'null', '$ts' PASSING timestamptz '2018-02-21 12:34:56 +10' AS ts RETURNING timestamp);
453+
json_value
454+
--------------------------
455+
Tue Feb 20 18:34:56 2018
456+
(1 row)
457+
458+
SELECT JSON_VALUE(jsonb 'null', '$ts' PASSING timestamptz '2018-02-21 12:34:56 +10' AS ts RETURNING json);
459+
json_value
460+
-----------------------------
461+
"2018-02-21T02:34:56+00:00"
462+
(1 row)
463+
464+
SELECT JSON_VALUE(jsonb 'null', '$ts' PASSING timestamptz '2018-02-21 12:34:56 +10' AS ts RETURNING jsonb);
465+
json_value
466+
-----------------------------
467+
"2018-02-21T02:34:56+00:00"
468+
(1 row)
469+
439470
-- JSON_QUERY
440471
SELECT
441472
JSON_QUERY(js, '$'),
@@ -805,6 +836,25 @@ SELECT JSON_QUERY(jsonb '{"a": 1}', '$.a' RETURNING sqljsonb_int_not_null);
805836

806837
SELECT JSON_QUERY(jsonb '{"a": 1}', '$.b' RETURNING sqljsonb_int_not_null);
807838
ERROR: domain sqljsonb_int_not_null does not allow null values
839+
-- Test timestamptz passing and output
840+
SELECT JSON_QUERY(jsonb 'null', '$ts' PASSING timestamptz '2018-02-21 12:34:56 +10' AS ts);
841+
json_query
842+
-----------------------------
843+
"2018-02-21T02:34:56+00:00"
844+
(1 row)
845+
846+
SELECT JSON_QUERY(jsonb 'null', '$ts' PASSING timestamptz '2018-02-21 12:34:56 +10' AS ts RETURNING json);
847+
json_query
848+
-----------------------------
849+
"2018-02-21T02:34:56+00:00"
850+
(1 row)
851+
852+
SELECT JSON_QUERY(jsonb 'null', '$ts' PASSING timestamptz '2018-02-21 12:34:56 +10' AS ts RETURNING jsonb);
853+
json_query
854+
-----------------------------
855+
"2018-02-21T02:34:56+00:00"
856+
(1 row)
857+
808858
-- Test constraints
809859
CREATE TABLE test_jsonb_constraints (
810860
js text,

‎src/test/regress/sql/jsonb_sqljson.sql

Lines changed: 12 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -114,6 +114,13 @@ FROM
114114
SELECT JSON_VALUE(jsonb'null','$a' PASSINGpoint' (1, 2 )'AS a);
115115
SELECT JSON_VALUE(jsonb'null','$a' PASSINGpoint' (1, 2 )'AS a RETURNINGpoint);
116116

117+
-- Test timestamptz passing and output
118+
SELECT JSON_VALUE(jsonb'null','$ts' PASSINGtimestamptz'2018-02-21 12:34:56 +10'AS ts);
119+
SELECT JSON_VALUE(jsonb'null','$ts' PASSINGtimestamptz'2018-02-21 12:34:56 +10'AS ts RETURNINGtimestamptz);
120+
SELECT JSON_VALUE(jsonb'null','$ts' PASSINGtimestamptz'2018-02-21 12:34:56 +10'AS ts RETURNINGtimestamp);
121+
SELECT JSON_VALUE(jsonb'null','$ts' PASSINGtimestamptz'2018-02-21 12:34:56 +10'AS ts RETURNING json);
122+
SELECT JSON_VALUE(jsonb'null','$ts' PASSINGtimestamptz'2018-02-21 12:34:56 +10'AS ts RETURNING jsonb);
123+
117124
-- JSON_QUERY
118125

119126
SELECT
@@ -230,6 +237,11 @@ SELECT * FROM unnest(JSON_QUERY(jsonb '[{"a": 1, "t": ["foo", []]}, {"a": 2, "jb
230237
SELECT JSON_QUERY(jsonb'{"a": 1}','$.a' RETURNING sqljsonb_int_not_null);
231238
SELECT JSON_QUERY(jsonb'{"a": 1}','$.b' RETURNING sqljsonb_int_not_null);
232239

240+
-- Test timestamptz passing and output
241+
SELECT JSON_QUERY(jsonb'null','$ts' PASSINGtimestamptz'2018-02-21 12:34:56 +10'AS ts);
242+
SELECT JSON_QUERY(jsonb'null','$ts' PASSINGtimestamptz'2018-02-21 12:34:56 +10'AS ts RETURNING json);
243+
SELECT JSON_QUERY(jsonb'null','$ts' PASSINGtimestamptz'2018-02-21 12:34:56 +10'AS ts RETURNING jsonb);
244+
233245
-- Test constraints
234246

235247
CREATETABLEtest_jsonb_constraints (

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp