← Back to branch summary

~ubuntu-branches/ubuntu/precise/mysql-5.5/precise-201203300109

« back to all changes in this revision

Viewing changes to mysql-test/t/func_if.test

  • Committer: Clint Byrum
  • Date: 2012-02-15 01:24:19 UTC
  • mto: This revision was merged to the branch mainline in revision 10.
  • Revision ID: clint@ubuntu.com-20120215012419-upaezkp5ynk787ki
Import upstream version 5.5.20

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/t/func_if.test
177
177
SELECT IF(b, (SELECT a FROM t1 LIMIT 1), b) c FROM t1 GROUP BY c;
178
178
 
179
179
DROP TABLE t1;
 
180
 
 
181
--echo #
 
182
--echo # Bug#12532830 
 
183
--echo # SIGFPE OR ASSERTION (PRECISION <= ((9 * 9) - 8*2)) && (DEC <= 30)
 
184
--echo #
 
185
 
 
186
let $nines= 9999999999999999999999999999999999999;
 
187
eval select
 
188
sum(distinct(if('a',
 
189
                (select adddate(elt(convert($nines,decimal(64,0)),count(*)),
 
190
                                interval 1 day))
 
191
                , .1))) as foo;