← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/func_math.test

  • Committer: lbieber
  • Date: 2010-10-08 01:11:05 UTC
  • mfrom: (1821.1.4 build)
  • Revision ID: lbieber@orisndriz08-20101008011105-1tbwbvz9me9fy7ua
Merge Monty - Fixed the last of the ICC warnings. Turned on warnings=errors
Merge Brian - fixu bug #655558: SELECT 102/(1-1) should error on divide by zero          
Merge Brian - fix bug #654219: information_schema.key_column_usage does not contain information about FKs

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
20
21
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);
21
22
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
22
24
select ln(exp(10)),exp(ln(sqrt(10))*2),ln(-1),ln(0),ln(NULL);
23
25
explain extended select ln(exp(10)),exp(ln(sqrt(10))*2),ln(-1),ln(0),ln(NULL);
 
26
--error ER_DIVISION_BY_ZERO
24
27
select log2(8),log2(15),log2(-2),log2(0),log2(NULL);
25
28
explain extended select log2(8),log2(15),log2(-2),log2(0),log2(NULL);
 
29
--error ER_DIVISION_BY_ZERO
26
30
select log10(100),log10(18),log10(-4),log10(0),log10(NULL);
27
31
explain extended select log10(100),log10(18),log10(-4),log10(0),log10(NULL);
28
32
select pow(10,log10(10)),power(2,4);