diff options
| author | Alexander Barkov <bar@mariadb.org> | 2015-10-22 08:11:31 +0400 |
|---|---|---|
| committer | Alexander Barkov <bar@mariadb.org> | 2015-10-22 08:11:31 +0400 |
| commit | bdc03e0579cc5b7fbf07928eeace72a4715cdf52 (patch) | |
| tree | e1c6232a6eb38a7f7c983b012fbeacc170c4cf37 | |
| parent | 7e29f2d64fb463559a7c9c178ffe899b9bcab113 (diff) | |
| download | mariadb-git-bdc03e0579cc5b7fbf07928eeace72a4715cdf52.tar.gz | |
MDEV-7195 AVG() loses precision in INT context
The fix for MDEV-8918 previously fixed the problem reported in MDEV-7195.
Adding a test case from MDEV-7195 only.
| -rw-r--r-- | mysql-test/r/func_group.result | 17 | ||||
| -rw-r--r-- | mysql-test/t/func_group.test | 15 |
2 files changed, 32 insertions, 0 deletions
diff --git a/mysql-test/r/func_group.result b/mysql-test/r/func_group.result index 023b0091357..659580059b5 100644 --- a/mysql-test/r/func_group.result +++ b/mysql-test/r/func_group.result @@ -2314,5 +2314,22 @@ MIN(a) SUM(a) CAST(SUM(a) AS SIGNED) CAST(AVG(a) AS SIGNED) 9.223372036854776e18 9.223372036854776e18 9223372036854775807 9223372036854775807 DROP TABLE t1; # +# MDEV-7195 AVG() loses precision in INT context +# +CREATE TABLE t1 ( +auto SERIAL, +fld1 bigint unsigned NOT NULL, +companynr tinyint(2) unsigned zerofill DEFAULT '00' NOT NULL, +UNIQUE fld1 (fld1) +); +INSERT INTO t1 VALUES (1,0x7FFFFFFFFFFFFFFF,00); +INSERT INTO t1 VALUES (2,0x7FFFFFFFFFFFFFFE,37); +INSERT INTO t1 VALUES (3,0x7FFFFFFFFFFFFFFC,37); +SELECT companynr, AVG(fld1), AVG(fld1)<<0 AS avg1, CAST(AVG(fld1) AS UNSIGNED)<<0 AS avg2 FROM t1 GROUP BY companynr; +companynr AVG(fld1) avg1 avg2 +00 9223372036854775807.0000 9223372036854775807 9223372036854775807 +37 9223372036854775805.0000 9223372036854775805 9223372036854775805 +DROP TABLE t1; +# # End of 10.1 tests # diff --git a/mysql-test/t/func_group.test b/mysql-test/t/func_group.test index 9fedfa8bc72..b5270743465 100644 --- a/mysql-test/t/func_group.test +++ b/mysql-test/t/func_group.test @@ -1594,5 +1594,20 @@ SELECT MIN(a), SUM(a), CAST(SUM(a) AS SIGNED), CAST(AVG(a) AS SIGNED) FROM t1; DROP TABLE t1; --echo # +--echo # MDEV-7195 AVG() loses precision in INT context +--echo # +CREATE TABLE t1 ( + auto SERIAL, + fld1 bigint unsigned NOT NULL, + companynr tinyint(2) unsigned zerofill DEFAULT '00' NOT NULL, + UNIQUE fld1 (fld1) +); +INSERT INTO t1 VALUES (1,0x7FFFFFFFFFFFFFFF,00); +INSERT INTO t1 VALUES (2,0x7FFFFFFFFFFFFFFE,37); +INSERT INTO t1 VALUES (3,0x7FFFFFFFFFFFFFFC,37); +SELECT companynr, AVG(fld1), AVG(fld1)<<0 AS avg1, CAST(AVG(fld1) AS UNSIGNED)<<0 AS avg2 FROM t1 GROUP BY companynr; +DROP TABLE t1; + +--echo # --echo # End of 10.1 tests --echo # |