From 4da845ec489edb5156be248b117c0dfdfd48f058 Mon Sep 17 00:00:00 2001
From: Tor Didriksen <tor.didriksen@oracle.com>
Date: Fri, 19 Aug 2011 09:06:50 +0200
Subject: Backport from trunk of: Bug#12532830 - SIGFPE OR ASSERTION (PRECISION
 <= ((9 * 9) - 8*2)) && (DEC <= 30)

---
 mysql-test/t/func_if.test | 12 ++++++++++++
 1 file changed, 12 insertions(+)

(limited to 'mysql-test/t/func_if.test')

diff --git a/mysql-test/t/func_if.test b/mysql-test/t/func_if.test
index 91f70bb98d7..41115a2da30 100644
--- a/mysql-test/t/func_if.test
+++ b/mysql-test/t/func_if.test
@@ -177,3 +177,15 @@ INSERT INTO t1 VALUES (NULL, 0), (NULL, 1);
 SELECT IF(b, (SELECT a FROM t1 LIMIT 1), b) c FROM t1 GROUP BY c;
 
 DROP TABLE t1;
+
+--echo #
+--echo # Bug#12532830 
+--echo # SIGFPE OR ASSERTION (PRECISION <= ((9 * 9) - 8*2)) && (DEC <= 30)
+--echo #
+
+let $nines= 9999999999999999999999999999999999999;
+eval select
+sum(distinct(if('a',
+                (select adddate(elt(convert($nines,decimal(64,0)),count(*)),
+                                interval 1 day))
+                , .1))) as foo;
-- 
cgit v1.2.1