diff options
| author | Tor Didriksen <tor.didriksen@oracle.com> | 2011-08-19 09:06:50 +0200 |
|---|---|---|
| committer | Tor Didriksen <tor.didriksen@oracle.com> | 2011-08-19 09:06:50 +0200 |
| commit | 4da845ec489edb5156be248b117c0dfdfd48f058 (patch) | |
| tree | 73cea93f02979761076fafb51153522053e8bf3a /mysql-test/t/func_if.test | |
| parent | 9e2109c88e0685e60db96423be25f10f326cecb2 (diff) | |
| download | mariadb-git-4da845ec489edb5156be248b117c0dfdfd48f058.tar.gz | |
Backport from trunk of:
Bug#12532830 - SIGFPE OR ASSERTION (PRECISION <= ((9 * 9) - 8*2)) && (DEC <= 30)
Diffstat (limited to 'mysql-test/t/func_if.test')
| -rw-r--r-- | mysql-test/t/func_if.test | 12 |
1 files changed, 12 insertions, 0 deletions
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; |