summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--src/test/regress/expected/collate.out2
-rw-r--r--src/test/regress/sql/collate.sql2
2 files changed, 2 insertions, 2 deletions
diff --git a/src/test/regress/expected/collate.out b/src/test/regress/expected/collate.out
index 13c252494e..2c037682f3 100644
--- a/src/test/regress/expected/collate.out
+++ b/src/test/regress/expected/collate.out
@@ -489,7 +489,7 @@ LINE 2: (SELECT x FROM (VALUES('a' COLLATE "C"),('b')) t(x)
^
HINT: Use the COLLATE clause to set the collation of the non-recursive term.
SELECT a, b, a < b as lt FROM
- (VALUES ('a', 'B'), ('A', 'b' COLLATE "C")) v(a,b) ORDER BY a;
+ (VALUES ('a', 'B'), ('A', 'b' COLLATE "C")) v(a,b);
a | b | lt
---+---+----
a | B | f
diff --git a/src/test/regress/sql/collate.sql b/src/test/regress/sql/collate.sql
index a281921fe2..d663593111 100644
--- a/src/test/regress/sql/collate.sql
+++ b/src/test/regress/sql/collate.sql
@@ -161,7 +161,7 @@ WITH RECURSIVE foo(x) AS
SELECT * FROM foo;
SELECT a, b, a < b as lt FROM
- (VALUES ('a', 'B'), ('A', 'b' COLLATE "C")) v(a,b) ORDER BY a;
+ (VALUES ('a', 'B'), ('A', 'b' COLLATE "C")) v(a,b);
-- casting