Commitfe2bf8f

committed

Add some more numeric test coverage

max(numeric) wasn't tested at all, min(numeric) was only used by someunrelated tests. Add explicit tests with the other numeric aggregatefunctions.

1 parentf481d28 commitfe2bf8fCopy full SHA for fe2bf8f

File tree

+14

-0

lines changed

+14

-0

lines changed

Lines changed: 12 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -1096,6 +1096,18 @@ SELECT AVG(val) FROM num_data;`
`1096`	`1096`	`-13430913.592242320700`
`1097`	`1097`	`(1 row)`
`1098`	`1098`
	`1099`	`+SELECT MAX(val) FROM num_data;`
	`1100`	`+ max`
	`1101`	`+--------------------`
	`1102`	`+ 7799461.4119000000`
	`1103`	`+(1 row)`
	`1104`	`+`
	`1105`	`+SELECT MIN(val) FROM num_data;`
	`1106`	`+ min`
	`1107`	`+----------------------`
	`1108`	`+ -83028485.0000000000`
	`1109`	`+(1 row)`
	`1110`	`+`
`1099`	`1111`	`SELECT STDDEV(val) FROM num_data;`
`1100`	`1112`	`stddev`
`1101`	`1113`	`-------------------------------`

Lines changed: 2 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -752,6 +752,8 @@ SELECT power('-inf'::numeric, '-inf');`
`752`	`752`	`-- ******************************`
`753`	`753`	`-- numeric AVG used to fail on some platforms`
`754`	`754`	`SELECTAVG(val)FROM num_data;`
	`755`	`+SELECTMAX(val)FROM num_data;`
	`756`	`+SELECTMIN(val)FROM num_data;`
`755`	`757`	`SELECT STDDEV(val)FROM num_data;`
`756`	`758`	`SELECT VARIANCE(val)FROM num_data;`
`757`	`759`

Comments

(0)