diff options
Diffstat (limited to 'src/test/regress/sql/copyselect.sql')
| -rw-r--r-- | src/test/regress/sql/copyselect.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/src/test/regress/sql/copyselect.sql b/src/test/regress/sql/copyselect.sql index c2526487c8..beca507ae7 100644 --- a/src/test/regress/sql/copyselect.sql +++ b/src/test/regress/sql/copyselect.sql @@ -53,11 +53,11 @@ copy (select * from test1 join test2 using (id)) to stdout; -- -- Test UNION SELECT -- -copy (select t from test1 where id = 1 UNION select * from v_test1) to stdout; +copy (select t from test1 where id = 1 UNION select * from v_test1 ORDER BY 1) to stdout; -- -- Test subselect -- -copy (select * from (select t from test1 where id = 1 UNION select * from v_test1) t1) to stdout; +copy (select * from (select t from test1 where id = 1 UNION select * from v_test1 ORDER BY 1) t1) to stdout; -- -- Test headers, CSV and quotes -- |