diff options
Diffstat (limited to 'src/test')
| -rw-r--r-- | src/test/regress/expected/collate.linux.utf8.out | 16 | ||||
| -rw-r--r-- | src/test/regress/expected/jsonb_jsonpath.out | 6 | ||||
| -rw-r--r-- | src/test/regress/sql/collate.linux.utf8.sql | 6 | ||||
| -rw-r--r-- | src/test/regress/sql/jsonb_jsonpath.sql | 2 |
4 files changed, 26 insertions, 4 deletions
diff --git a/src/test/regress/expected/collate.linux.utf8.out b/src/test/regress/expected/collate.linux.utf8.out index 37c6add5b51..f06ae543e49 100644 --- a/src/test/regress/expected/collate.linux.utf8.out +++ b/src/test/regress/expected/collate.linux.utf8.out @@ -461,6 +461,22 @@ SELECT to_char(date '2010-04-01', 'DD TMMON YYYY' COLLATE "tr_TR"); 01 NİS 2010 (1 row) +-- to_date +SELECT to_date('01 ŞUB 2010', 'DD TMMON YYYY'); + to_date +------------ + 02-01-2010 +(1 row) + +SELECT to_date('01 Şub 2010', 'DD TMMON YYYY'); + to_date +------------ + 02-01-2010 +(1 row) + +SELECT to_date('1234567890ab 2010', 'TMMONTH YYYY'); -- fail +ERROR: invalid value "1234567890ab" for "MONTH" +DETAIL: The given value did not match any of the allowed values for this field. -- backwards parsing CREATE VIEW collview1 AS SELECT * FROM collate_test1 WHERE b COLLATE "C" >= 'bbc'; CREATE VIEW collview2 AS SELECT a, b FROM collate_test1 ORDER BY b COLLATE "C"; diff --git a/src/test/regress/expected/jsonb_jsonpath.out b/src/test/regress/expected/jsonb_jsonpath.out index ef8db2d060a..83a050d3e29 100644 --- a/src/test/regress/expected/jsonb_jsonpath.out +++ b/src/test/regress/expected/jsonb_jsonpath.out @@ -1674,9 +1674,9 @@ select jsonb_path_query('[]', 'strict $.datetime()'); ERROR: jsonpath item method .datetime() can only be applied to a string select jsonb_path_query('{}', '$.datetime()'); ERROR: jsonpath item method .datetime() can only be applied to a string -select jsonb_path_query('""', '$.datetime()'); -ERROR: datetime format is not unrecognized -HINT: use datetime template argument for explicit format specification +select jsonb_path_query('"bogus"', '$.datetime()'); +ERROR: datetime format is not recognized: "bogus" +HINT: Use a datetime template argument to specify the input data format. select jsonb_path_query('"12:34"', '$.datetime("aaa")'); ERROR: invalid datetime format separator: "a" select jsonb_path_query('"aaaa"', '$.datetime("HH24")'); diff --git a/src/test/regress/sql/collate.linux.utf8.sql b/src/test/regress/sql/collate.linux.utf8.sql index 8c26f16f5d5..cbbd2203e41 100644 --- a/src/test/regress/sql/collate.linux.utf8.sql +++ b/src/test/regress/sql/collate.linux.utf8.sql @@ -182,6 +182,12 @@ SELECT to_char(date '2010-02-01', 'DD TMMON YYYY' COLLATE "tr_TR"); SELECT to_char(date '2010-04-01', 'DD TMMON YYYY'); SELECT to_char(date '2010-04-01', 'DD TMMON YYYY' COLLATE "tr_TR"); +-- to_date + +SELECT to_date('01 ŞUB 2010', 'DD TMMON YYYY'); +SELECT to_date('01 Şub 2010', 'DD TMMON YYYY'); +SELECT to_date('1234567890ab 2010', 'TMMONTH YYYY'); -- fail + -- backwards parsing diff --git a/src/test/regress/sql/jsonb_jsonpath.sql b/src/test/regress/sql/jsonb_jsonpath.sql index 591be00278f..731b4d444cc 100644 --- a/src/test/regress/sql/jsonb_jsonpath.sql +++ b/src/test/regress/sql/jsonb_jsonpath.sql @@ -352,7 +352,7 @@ select jsonb_path_query('1', '$.datetime()'); select jsonb_path_query('[]', '$.datetime()'); select jsonb_path_query('[]', 'strict $.datetime()'); select jsonb_path_query('{}', '$.datetime()'); -select jsonb_path_query('""', '$.datetime()'); +select jsonb_path_query('"bogus"', '$.datetime()'); select jsonb_path_query('"12:34"', '$.datetime("aaa")'); select jsonb_path_query('"aaaa"', '$.datetime("HH24")'); |