summaryrefslogtreecommitdiff
path: root/src/test
diff options
context:
space:
mode:
Diffstat (limited to 'src/test')
-rw-r--r--src/test/regress/expected/xc_distkey.out12
-rw-r--r--src/test/regress/sql/xc_distkey.sql7
2 files changed, 18 insertions, 1 deletions
diff --git a/src/test/regress/expected/xc_distkey.out b/src/test/regress/expected/xc_distkey.out
index e05fe7eb89..461f779e2b 100644
--- a/src/test/regress/expected/xc_distkey.out
+++ b/src/test/regress/expected/xc_distkey.out
@@ -103,8 +103,8 @@ insert into vc_tab values(NULL);
select * from vc_tab order by a;
a
----------------------------
- A quick brown fox
abcdefghijklmnopqrstuvwxyz
+ A quick brown fox
(3 rows)
@@ -616,3 +616,13 @@ select * from tstz_tab_h where a = 'Jun 23, 2001 23:59:59.99 PST';
Sun Jun 24 00:59:59.99 2001 PDT
(1 row)
+create table my_rr_tab(a integer, b varchar(100)) distribute by round robin;
+insert into my_rr_tab values(1 , 'One');
+insert into my_rr_tab values(2, 'Two');
+select * from my_rr_tab order by a;
+ a | b
+---+-----
+ 1 | One
+ 2 | Two
+(2 rows)
+
diff --git a/src/test/regress/sql/xc_distkey.sql b/src/test/regress/sql/xc_distkey.sql
index 8650718d32..b57502d26f 100644
--- a/src/test/regress/sql/xc_distkey.sql
+++ b/src/test/regress/sql/xc_distkey.sql
@@ -243,3 +243,10 @@ select * from tstz_tab_h order by a;
select * from tstz_tab_h where a = 'May 10, 2011 00:01:02.03 PST';
select * from tstz_tab_h where a = 'Jun 23, 2001 23:59:59.99 PST';
+
+create table my_rr_tab(a integer, b varchar(100)) distribute by round robin;
+insert into my_rr_tab values(1 , 'One');
+insert into my_rr_tab values(2, 'Two');
+
+select * from my_rr_tab order by a;
+