From a04bb0e2cafec4d6cd254ff9d745795a438d811c Mon Sep 17 00:00:00 2001 From: Kyotaro Horiguchi Date: Fri, 28 May 2021 15:21:45 +0900 Subject: [PATCH v2 2/2] Add test cases for trailing garbage of (multi)range types. --- src/test/regress/expected/multirangetypes.out | 5 +++++ src/test/regress/expected/rangetypes.out | 5 +++++ src/test/regress/sql/multirangetypes.sql | 1 + src/test/regress/sql/rangetypes.sql | 1 + 4 files changed, 12 insertions(+) diff --git a/src/test/regress/expected/multirangetypes.out b/src/test/regress/expected/multirangetypes.out index 50f7c37b88..98ac592127 100644 --- a/src/test/regress/expected/multirangetypes.out +++ b/src/test/regress/expected/multirangetypes.out @@ -13,6 +13,11 @@ ERROR: malformed multirange literal: "{,}" LINE 1: select '{,}'::textmultirange; ^ DETAIL: Expected range start. +select '{(,)}.'::textmultirange; +ERROR: malformed multirange literal: "{(,)}." +LINE 1: select '{(,)}.'::textmultirange; + ^ +DETAIL: Junk after right brace. select '{[a,c),}'::textmultirange; ERROR: malformed multirange literal: "{[a,c),}" LINE 1: select '{[a,c),}'::textmultirange; diff --git a/src/test/regress/expected/rangetypes.out b/src/test/regress/expected/rangetypes.out index e6ca99d43d..f6170db53a 100644 --- a/src/test/regress/expected/rangetypes.out +++ b/src/test/regress/expected/rangetypes.out @@ -9,6 +9,11 @@ ERROR: malformed range literal: "" LINE 1: select ''::textrange; ^ DETAIL: Missing left parenthesis or bracket. +select '(,).'::textrange; +ERROR: malformed range literal: "(,)." +LINE 1: select '(,).'::textrange; + ^ +DETAIL: Junk after right parenthesis or bracket. select '-[a,z)'::textrange; ERROR: malformed range literal: "-[a,z)" LINE 1: select '-[a,z)'::textrange; diff --git a/src/test/regress/sql/multirangetypes.sql b/src/test/regress/sql/multirangetypes.sql index 692f2416d9..3cbebedcd4 100644 --- a/src/test/regress/sql/multirangetypes.sql +++ b/src/test/regress/sql/multirangetypes.sql @@ -7,6 +7,7 @@ -- negative tests; should fail select ''::textmultirange; select '{,}'::textmultirange; +select '{(,)}.'::textmultirange; select '{[a,c),}'::textmultirange; select '{,[a,c)}'::textmultirange; select '{-[a,z)}'::textmultirange; diff --git a/src/test/regress/sql/rangetypes.sql b/src/test/regress/sql/rangetypes.sql index cb5353de6f..3a3e1029e0 100644 --- a/src/test/regress/sql/rangetypes.sql +++ b/src/test/regress/sql/rangetypes.sql @@ -8,6 +8,7 @@ create type textrange as range (subtype=text, collation="C"); -- negative tests; should fail select ''::textrange; +select '(,).'::textrange; select '-[a,z)'::textrange; select '[a,z) - '::textrange; select '(",a)'::textrange; -- 2.27.0