Add a regression test case to catch breakage of GROUP BY

and aggregate functions in queries that use inheritance.

1 files changed, 17 insertions, 0 deletions

diff --git a/src/test/regress/output/misc.source b/src/test/regress/output/misc.source
index 419f63b2a0..b4ba19a186 100644
--- a/src/test/regress/output/misc.source
+++ b/src/test/regress/output/misc.source
@@ -178,6 +178,23 @@ f    |  | |   |((11111111,33333333),(22222222,44444444))
 f    |  | |   |                                         
 (8 rows)
 
+QUERY: SELECT sum(a) FROM a_star*;
+sum
+---
+355
+(1 row)
+
+QUERY: SELECT class, sum(a) FROM a_star* GROUP BY class;
+class|sum
+-----+---
+a    |  3
+b    |  7
+c    | 11
+d    | 84
+e    | 66
+f    |184
+(6 rows)
+
 QUERY: ALTER TABLE f_star RENAME COLUMN f TO ff;
 QUERY: ALTER TABLE e_star* RENAME COLUMN e TO ee;
 QUERY: ALTER TABLE d_star* RENAME COLUMN d TO dd;