diff options
| author | Peter Eisentraut <peter@eisentraut.org> | 2020-09-09 09:58:12 +0200 |
|---|---|---|
| committer | Peter Eisentraut <peter@eisentraut.org> | 2020-09-09 09:58:12 +0200 |
| commit | fe2bf8f81096ea1b7b2fc58501309fc5e41ccd47 (patch) | |
| tree | f0e50a5456999f27d98fd77aae8f2020b99436b6 /src | |
| parent | f481d2823297e692e9d44c9edfd18e626e768b0c (diff) | |
Add some more numeric test coverage
max(numeric) wasn't tested at all, min(numeric) was only used by some
unrelated tests. Add explicit tests with the other numeric aggregate
functions.
Diffstat (limited to 'src')
| -rw-r--r-- | src/test/regress/expected/numeric.out | 12 | ||||
| -rw-r--r-- | src/test/regress/sql/numeric.sql | 2 |
2 files changed, 14 insertions, 0 deletions
diff --git a/src/test/regress/expected/numeric.out b/src/test/regress/expected/numeric.out index 8546ce901fa..86940ec6838 100644 --- a/src/test/regress/expected/numeric.out +++ b/src/test/regress/expected/numeric.out @@ -1096,6 +1096,18 @@ SELECT AVG(val) FROM num_data; -13430913.592242320700 (1 row) +SELECT MAX(val) FROM num_data; + max +-------------------- + 7799461.4119000000 +(1 row) + +SELECT MIN(val) FROM num_data; + min +---------------------- + -83028485.0000000000 +(1 row) + SELECT STDDEV(val) FROM num_data; stddev ------------------------------- diff --git a/src/test/regress/sql/numeric.sql b/src/test/regress/sql/numeric.sql index 416c16722a9..febb096af23 100644 --- a/src/test/regress/sql/numeric.sql +++ b/src/test/regress/sql/numeric.sql @@ -752,6 +752,8 @@ SELECT power('-inf'::numeric, '-inf'); -- ****************************** -- numeric AVG used to fail on some platforms SELECT AVG(val) FROM num_data; +SELECT MAX(val) FROM num_data; +SELECT MIN(val) FROM num_data; SELECT STDDEV(val) FROM num_data; SELECT VARIANCE(val) FROM num_data; |