aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorPeter Eisentraut <peter@eisentraut.org>2019-03-25 08:15:38 +0100
committerPeter Eisentraut <peter@eisentraut.org>2019-03-25 08:15:38 +0100
commitc77e12208cd8540a209cc698373a3cfba8802639 (patch)
tree4a35135f8a4567c9ab3997f6e2d4be7b167657f8
parent919e48b943014b1d4ab5d83e48dbc9f8e87e7be4 (diff)
downloadpostgresql-c77e12208cd8540a209cc698373a3cfba8802639.tar.gz
postgresql-c77e12208cd8540a209cc698373a3cfba8802639.zip
Add ORDER BY to regression test case
Apparently, the output order is different on different endianness, per build farm member snapper.
-rw-r--r--src/test/regress/expected/collate.icu.utf8.out8
-rw-r--r--src/test/regress/sql/collate.icu.utf8.sql4
2 files changed, 6 insertions, 6 deletions
diff --git a/src/test/regress/expected/collate.icu.utf8.out b/src/test/regress/expected/collate.icu.utf8.out
index 4b67922f86c..d5132a28c33 100644
--- a/src/test/regress/expected/collate.icu.utf8.out
+++ b/src/test/regress/expected/collate.icu.utf8.out
@@ -1372,18 +1372,18 @@ SELECT x FROM test2ci UNION SELECT x FROM test1ci ORDER BY x;
ghi
(3 rows)
-SELECT x FROM test1ci INTERSECT SELECT x FROM test2ci;
+SELECT x FROM test1ci INTERSECT SELECT x FROM test2ci ORDER BY x;
x
-----
- ghi
abc
+ ghi
(2 rows)
-SELECT x FROM test2ci INTERSECT SELECT x FROM test1ci;
+SELECT x FROM test2ci INTERSECT SELECT x FROM test1ci ORDER BY x;
x
-----
- ghi
ABC
+ ghi
(2 rows)
SELECT x FROM test1ci EXCEPT SELECT x FROM test2ci;
diff --git a/src/test/regress/sql/collate.icu.utf8.sql b/src/test/regress/sql/collate.icu.utf8.sql
index d8c65f48c1d..e611bdb567f 100644
--- a/src/test/regress/sql/collate.icu.utf8.sql
+++ b/src/test/regress/sql/collate.icu.utf8.sql
@@ -517,8 +517,8 @@ SELECT x FROM test3ci WHERE x SIMILAR TO 'a%';
SELECT x FROM test3ci WHERE x ~ 'a';
SELECT x FROM test1ci UNION SELECT x FROM test2ci ORDER BY x;
SELECT x FROM test2ci UNION SELECT x FROM test1ci ORDER BY x;
-SELECT x FROM test1ci INTERSECT SELECT x FROM test2ci;
-SELECT x FROM test2ci INTERSECT SELECT x FROM test1ci;
+SELECT x FROM test1ci INTERSECT SELECT x FROM test2ci ORDER BY x;
+SELECT x FROM test2ci INTERSECT SELECT x FROM test1ci ORDER BY x;
SELECT x FROM test1ci EXCEPT SELECT x FROM test2ci;
SELECT x FROM test2ci EXCEPT SELECT x FROM test1ci;
SELECT DISTINCT x FROM test3ci ORDER BY x;