From a437551a228a5099c305d1376188d6926c043724 Mon Sep 17 00:00:00 2001 From: Andrew Dunstan Date: Wed, 28 Mar 2018 17:06:45 +1030 Subject: [PATCH] Make fast_default regression tests locale independent --- src/test/regress/expected/fast_default.out | 2 +- src/test/regress/sql/fast_default.sql | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) diff --git a/src/test/regress/expected/fast_default.out b/src/test/regress/expected/fast_default.out index 9e74068a0a..3568fa7b8a 100644 --- a/src/test/regress/expected/fast_default.out +++ b/src/test/regress/expected/fast_default.out @@ -339,7 +339,7 @@ ORDER BY pk LIMIT 10; (10 rows) -- Aggregate function -SELECT SUM(c_bigint), MAX(c_text), MIN(c_text) FROM T; +SELECT SUM(c_bigint), MAX(c_text COLLATE "C" ), MIN(c_text COLLATE "C") FROM T; sum | max | min -----+-------+----- 200 | hello | 31 diff --git a/src/test/regress/sql/fast_default.sql b/src/test/regress/sql/fast_default.sql index 6a3f9b367e..ea707d402a 100644 --- a/src/test/regress/sql/fast_default.sql +++ b/src/test/regress/sql/fast_default.sql @@ -290,7 +290,7 @@ FROM T ORDER BY pk LIMIT 10; -- Aggregate function -SELECT SUM(c_bigint), MAX(c_text), MIN(c_text) FROM T; +SELECT SUM(c_bigint), MAX(c_text COLLATE "C" ), MIN(c_text COLLATE "C") FROM T; -- ORDER BY SELECT * FROM T ORDER BY c_bigint, c_text, pk LIMIT 10; -- 2.40.0