Commitdfaf9fb

committed

Add a regression test case to catch breakage of GROUP BY

and aggregate functions in queries that use inheritance.

1 parentb4210ae commitdfaf9fbCopy full SHA for dfaf9fb

File tree

+24

-0

lines changed

+24

-0

lines changed

Lines changed: 7 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -100,6 +100,13 @@ SELECT class, c FROM e_star* x WHERE x.c NOTNULL;`
`100`	`100`
`101`	`101`	`SELECT * FROM f_star* x WHERE x.c ISNULL;`
`102`	`102`
	`103`	`+-- grouping and aggregation on inherited sets have been busted in the past...`
	`104`	`+`
	`105`	`+SELECT sum(a) FROM a_star*;`
	`106`	`+`
	`107`	`+SELECT class, sum(a) FROM a_star* GROUP BY class;`
	`108`	`+`
	`109`	`+`
`103`	`110`	`ALTER TABLE f_star RENAME COLUMN f TO ff;`
`104`	`111`
`105`	`112`	`ALTER TABLE e_star* RENAME COLUMN e TO ee;`

Lines changed: 17 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -178,6 +178,23 @@ f \| \| \| \|((11111111,33333333),(22222222,44444444))`
`178`	`178`	`f \| \| \| \|`
`179`	`179`	`(8 rows)`
`180`	`180`
	`181`	`+QUERY: SELECT sum(a) FROM a_star*;`
	`182`	`+sum`
	`183`	`+---`
	`184`	`+355`
	`185`	`+(1 row)`
	`186`	`+`
	`187`	`+QUERY: SELECT class, sum(a) FROM a_star* GROUP BY class;`
	`188`	`+class\|sum`
	`189`	`+-----+---`
	`190`	`+a \| 3`
	`191`	`+b \| 7`
	`192`	`+c \| 11`
	`193`	`+d \| 84`
	`194`	`+e \| 66`
	`195`	`+f \|184`
	`196`	`+(6 rows)`
	`197`	`+`
`181`	`198`	`QUERY: ALTER TABLE f_star RENAME COLUMN f TO ff;`
`182`	`199`	`QUERY: ALTER TABLE e_star* RENAME COLUMN e TO ee;`
`183`	`200`	`QUERY: ALTER TABLE d_star* RENAME COLUMN d TO dd;`

Comments

(0)