From dfaf9fbcb4e09f674301edea8ddce438643c48af Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Sun, 6 Jun 1999 17:41:01 +0000 Subject: Add a regression test case to catch breakage of GROUP BY and aggregate functions in queries that use inheritance. --- src/test/regress/input/misc.source | 7 +++++++ 1 file changed, 7 insertions(+) (limited to 'src/test/regress/input') diff --git a/src/test/regress/input/misc.source b/src/test/regress/input/misc.source index 5de5381cff..f582381299 100644 --- a/src/test/regress/input/misc.source +++ b/src/test/regress/input/misc.source @@ -100,6 +100,13 @@ SELECT class, c FROM e_star* x WHERE x.c NOTNULL; SELECT * FROM f_star* x WHERE x.c ISNULL; +-- grouping and aggregation on inherited sets have been busted in the past... + +SELECT sum(a) FROM a_star*; + +SELECT class, sum(a) FROM a_star* GROUP BY class; + + ALTER TABLE f_star RENAME COLUMN f TO ff; ALTER TABLE e_star* RENAME COLUMN e TO ee; -- cgit v1.2.1