From c77e12208cd8540a209cc698373a3cfba8802639 Mon Sep 17 00:00:00 2001 From: Peter Eisentraut Date: Mon, 25 Mar 2019 08:15:38 +0100 Subject: [PATCH] Add ORDER BY to regression test case Apparently, the output order is different on different endianness, per build farm member snapper. --- src/test/regress/expected/collate.icu.utf8.out | 8 ++++---- src/test/regress/sql/collate.icu.utf8.sql | 4 ++-- 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 4b67922f86..d5132a28c3 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 d8c65f48c1..e611bdb567 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; -- 2.40.0