This patch resolves some regression test failures caused by platform

dependencies.

David Hartwig

1 files changed, 36 insertions, 11 deletions

diff --git a/src/test/regress/expected/select_having.out b/src/test/regress/expected/select_having.out
index 95dd274c51..f9188a08fb 100644
--- a/src/test/regress/expected/select_having.out
+++ b/src/test/regress/expected/select_having.out
@@ -1,12 +1,37 @@
-QUERY: SELECT d1, count(*) FROM DATETIME_TBL
-  GROUP BY d1 HAVING count(*) > 1;
-d1                          |count
-----------------------------+-----
-Thu Jun 13 00:00:00 1957 PDT|    2
-Mon Feb 10 09:32:01 1997 PST|    3
-Mon Feb 10 17:32:01 1997 PST|   13
-Sun Feb 16 17:32:01 1997 PST|    2
-Sat Mar 01 17:32:01 1997 PST|    2
-invalid                     |    2
-(6 rows)
+QUERY: CREATE TABLE test_having (a int, b int, c char(8), d char);
+QUERY: INSERT INTO test_having VALUES (0, 1, 'XXXX', 'A');
+QUERY: INSERT INTO test_having VALUES (1, 2, 'AAAA', 'b');
+QUERY: INSERT INTO test_having VALUES (2, 2, 'AAAA', 'c');
+QUERY: INSERT INTO test_having VALUES (3, 3, 'BBBB', 'D');
+QUERY: INSERT INTO test_having VALUES (4, 3, 'BBBB', 'e');
+QUERY: INSERT INTO test_having VALUES (5, 3, 'bbbb', 'F');
+QUERY: INSERT INTO test_having VALUES (6, 4, 'cccc', 'g');
+QUERY: INSERT INTO test_having VALUES (7, 4, 'cccc', 'h');
+QUERY: INSERT INTO test_having VALUES (8, 4, 'CCCC', 'I');
+QUERY: INSERT INTO test_having VALUES (9, 4, 'CCCC', 'j');
+QUERY: SELECT max(a) FROM test_having
+	GROUP BY lower(c) HAVING count(*) > 2 OR min(b) = 3;
+max
+---
+  5
+  9
+(2 rows)
 
+QUERY: SELECT lower(c), count(c) FROM test_having
+	GROUP BY lower(c) HAVING count(*) > 2 OR min(a) = max(a);
+lower   |count
+--------+-----
+bbbb    |    3
+cccc    |    4
+xxxx    |    1
+(3 rows)
+
+QUERY: SELECT c, max(a) FROM test_having
+	GROUP BY c HAVING count(*) > 2 OR min(a) = max(a);
+c       |max
+--------+---
+XXXX    |  0
+bbbb    |  5
+(2 rows)
+
+QUERY: DROP TABLE test_having;