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 /mysql-test/t/func_group.test | |
| 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.
Diffstat (limited to 'mysql-test/t/func_group.test')
| -rw-r--r-- | mysql-test/t/func_group.test | 15 |
1 files changed, 15 insertions, 0 deletions
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 # |