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 | |
| parent | f481d2823297e692e9d44c9edfd18e626e768b0c (diff) | |
| download | postgresql-fe2bf8f81096ea1b7b2fc58501309fc5e41ccd47.tar.gz postgresql-fe2bf8f81096ea1b7b2fc58501309fc5e41ccd47.zip | |
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.
| -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; |