← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/func_math.test

[patch 112/129] Merge patch for revision 1925 from InnoDB SVN:
revno: 1925
revision-id: svn-v4:16c675df-0fcb-4bc9-8058-dcc011a37293:branches/zip:6169
parent: svn-v4:16c675df-0fcb-4bc9-8058-dcc011a37293:branches/zip:6163
committer: calvin
timestamp: Thu 2009-11-12 12:40:43 +0000
message:
  branches/zip: add test case for bug#46676
  
  This crash is reproducible with InnoDB plugin 1.0.4 + MySQL 5.1.37.
  But no longer reproducible after MySQL 5.1.38 (with plugin 1.0.5).
  Add test case to catch future regression.
added:
  mysql-test/innodb_bug46676.result 6169@16c675df-0fcb-4bc9-8058-dcc011a37293:branches%2Fzip%2Fmysql-test%2Finnodb_bug46676.result
  mysql-test/innodb_bug46676.test 6169@16c675df-0fcb-4bc9-8058-dcc011a37293:branches%2Fzip%2Fmysql-test%2Finnodb_bug46676.test
diff:
=== added file 'mysql-test/innodb_bug46676.result'

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/t/func_math.test
17
17
select round(5.64,1),round(5.64,2),round(5.64,-1),round(5.64,-2);
18
18
select abs(-10), sign(-5), sign(5), sign(0);
19
19
explain extended select abs(-10), sign(-5), sign(5), sign(0);
20
 
--error ER_DIVISION_BY_ZERO
21
20
select log(exp(10)),exp(log(sqrt(10))*2),log(-1),log(NULL),log(1,1),log(3,9),log(-1,2),log(NULL,2);
22
21
explain extended select log(exp(10)),exp(log(sqrt(10))*2),log(-1),log(NULL),log(1,1),log(3,9),log(-1,2),log(NULL,2);
23
 
--error ER_DIVISION_BY_ZERO
24
22
select ln(exp(10)),exp(ln(sqrt(10))*2),ln(-1),ln(0),ln(NULL);
25
23
explain extended select ln(exp(10)),exp(ln(sqrt(10))*2),ln(-1),ln(0),ln(NULL);
26
 
--error ER_DIVISION_BY_ZERO
27
24
select log2(8),log2(15),log2(-2),log2(0),log2(NULL);
28
25
explain extended select log2(8),log2(15),log2(-2),log2(0),log2(NULL);
29
 
--error ER_DIVISION_BY_ZERO
30
26
select log10(100),log10(18),log10(-4),log10(0),log10(NULL);
31
27
explain extended select log10(100),log10(18),log10(-4),log10(0),log10(NULL);
32
28
select pow(10,log10(10)),power(2,4);