summaryrefslogtreecommitdiff
path: root/src/test
diff options
context:
space:
mode:
authorBruce Momjian2014-02-01 15:49:17 +0000
committerBruce Momjian2014-02-01 15:49:17 +0000
commitd0ee93797d9c06e619b3f382705d99ee195bb573 (patch)
treec4a0c4f43381a2d946fabf43c4f56e7915e77fbc /src/test
parent858ec11858a914d4c380971985709b6d6b7dd6fc (diff)
arrays: tighten checks for multi-dimensional input
Previously an input array string that started with a single-element array dimension would then later accept a multi-dimensional segment. BACKWARD INCOMPATIBILITY
Diffstat (limited to 'src/test')
-rw-r--r--src/test/regress/expected/arrays.out2
-rw-r--r--src/test/regress/sql/arrays.sql2
2 files changed, 2 insertions, 2 deletions
diff --git a/src/test/regress/expected/arrays.out b/src/test/regress/expected/arrays.out
index e1b9d7f0a84..6dce5c9301b 100644
--- a/src/test/regress/expected/arrays.out
+++ b/src/test/regress/expected/arrays.out
@@ -1491,7 +1491,7 @@ select cardinality('{{1,2},{3,4},{5,6}}'::int[]);
6
(1 row)
-select cardinality('{{{1}},{{2,3},{3,4}}}'::int[]);
+select cardinality('{{{1,9},{5,6}},{{2,3},{3,4}}}'::int[]);
cardinality
-------------
8
diff --git a/src/test/regress/sql/arrays.sql b/src/test/regress/sql/arrays.sql
index 64630d9ab78..92af172dfc4 100644
--- a/src/test/regress/sql/arrays.sql
+++ b/src/test/regress/sql/arrays.sql
@@ -425,7 +425,7 @@ select cardinality(array[1,2,3]);
select cardinality('[2:4]={5,6,7}'::int[]);
select cardinality('{{1,2}}'::int[]);
select cardinality('{{1,2},{3,4},{5,6}}'::int[]);
-select cardinality('{{{1}},{{2,3},{3,4}}}'::int[]);
+select cardinality('{{{1,9},{5,6}},{{2,3},{3,4}}}'::int[]);
select array_agg(unique1) from (select unique1 from tenk1 where unique1 < 15 order by unique1) ss;
select array_agg(ten) from (select ten from tenk1 where unique1 < 15 order by unique1) ss;