From 16ad1fc54027c4607f9edd14b02f776b41393f16 Mon Sep 17 00:00:00 2001 From: Alexander Barkov Date: Thu, 8 Oct 2015 20:48:46 +0400 Subject: MDEV-8921 Wrong result for CAST(AVG(double_column) AS SIGNED) --- mysql-test/t/func_group.test | 12 ++++++++++++ 1 file changed, 12 insertions(+) (limited to 'mysql-test/t/func_group.test') diff --git a/mysql-test/t/func_group.test b/mysql-test/t/func_group.test index 2497e4850b7..9fedfa8bc72 100644 --- a/mysql-test/t/func_group.test +++ b/mysql-test/t/func_group.test @@ -1581,6 +1581,18 @@ SELECT id, AVG(a) AS avg, CAST(MIN(a) AS SIGNED) AS cast_min FROM t1 GROUP BY id SELECT id, AVG(a) AS avg, CAST(AVG(a) AS SIGNED) AS cast_avg FROM t1 GROUP BY id HAVING avg!=123 ORDER BY id; DROP TABLE t1; +--echo # +--echo # MDEV-8921 Wrong result for CAST(AVG(double_column) AS SIGNED) +--echo # +CREATE TABLE t1 (id INT, a DOUBLE); +INSERT INTO t1 VALUES (1,0x7FFFFFFFFFFFFFFF),(2,0x7FFFFFFFFFFFFFFF); +SELECT id, AVG(a) AS avg, CAST(MIN(a) AS SIGNED) AS cast_min,CAST(AVG(a) AS SIGNED) AS cast_avg FROM t1 GROUP BY id HAVING avg!=123 ORDER BY id; +DROP TABLE t1; +CREATE TABLE t1 (a DOUBLE); +INSERT INTO t1 VALUES (0x7FFFFFFFFFFFFFFF); +SELECT MIN(a), SUM(a), CAST(SUM(a) AS SIGNED), CAST(AVG(a) AS SIGNED) FROM t1; +DROP TABLE t1; + --echo # --echo # End of 10.1 tests --echo # -- cgit v1.2.1