diff options
Diffstat (limited to 'src/test/regress/input/misc.source')
| -rw-r--r-- | src/test/regress/input/misc.source | 7 |
1 files changed, 7 insertions, 0 deletions
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; |