44
44
Note 1003 select abs(-(10)) AS `abs(-10)`,sign(-(5)) AS `sign(-5)`,sign(5) AS `sign(5)`,sign(0) AS `sign(0)`
45
45
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);
46
log(exp(10)) exp(log(sqrt(10))*2) log(-1) log(NULL) log(1,1) log(3,9) log(-1,2) log(NULL,2)
47
10 10 NULL NULL NULL 2 NULL NULL
49
Error 1365 Division by 0
50
Error 1365 Division by 0
51
Error 1365 Division by 0
46
ERROR 22012: Division by 0
52
47
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);
53
48
id select_type table type possible_keys key key_len ref rows filtered Extra
54
49
1 SIMPLE NULL NULL NULL NULL NULL NULL NULL NULL No tables used
56
51
Note 1003 select log(exp(10)) AS `log(exp(10))`,exp((log(sqrt(10)) * 2)) AS `exp(log(sqrt(10))*2)`,log(-(1)) AS `log(-1)`,log(NULL) AS `log(NULL)`,log(1,1) AS `log(1,1)`,log(3,9) AS `log(3,9)`,log(-(1),2) AS `log(-1,2)`,log(NULL,2) AS `log(NULL,2)`
57
52
select ln(exp(10)),exp(ln(sqrt(10))*2),ln(-1),ln(0),ln(NULL);
58
ln(exp(10)) exp(ln(sqrt(10))*2) ln(-1) ln(0) ln(NULL)
61
Error 1365 Division by 0
62
Error 1365 Division by 0
53
ERROR 22012: Division by 0
63
54
explain extended select ln(exp(10)),exp(ln(sqrt(10))*2),ln(-1),ln(0),ln(NULL);
64
55
id select_type table type possible_keys key key_len ref rows filtered Extra
65
56
1 SIMPLE NULL NULL NULL NULL NULL NULL NULL NULL No tables used
67
58
Note 1003 select ln(exp(10)) AS `ln(exp(10))`,exp((ln(sqrt(10)) * 2)) AS `exp(ln(sqrt(10))*2)`,ln(-(1)) AS `ln(-1)`,ln(0) AS `ln(0)`,ln(NULL) AS `ln(NULL)`
68
59
select log2(8),log2(15),log2(-2),log2(0),log2(NULL);
69
log2(8) log2(15) log2(-2) log2(0) log2(NULL)
70
3 3.90689059560852 NULL NULL NULL
72
Error 1365 Division by 0
73
Error 1365 Division by 0
60
ERROR 22012: Division by 0
74
61
explain extended select log2(8),log2(15),log2(-2),log2(0),log2(NULL);
75
62
id select_type table type possible_keys key key_len ref rows filtered Extra
76
63
1 SIMPLE NULL NULL NULL NULL NULL NULL NULL NULL No tables used
78
65
Note 1003 select log2(8) AS `log2(8)`,log2(15) AS `log2(15)`,log2(-(2)) AS `log2(-2)`,log2(0) AS `log2(0)`,log2(NULL) AS `log2(NULL)`
79
66
select log10(100),log10(18),log10(-4),log10(0),log10(NULL);
80
log10(100) log10(18) log10(-4) log10(0) log10(NULL)
81
2 1.25527250510331 NULL NULL NULL
83
Error 1365 Division by 0
84
Error 1365 Division by 0
67
ERROR 22012: Division by 0
85
68
explain extended select log10(100),log10(18),log10(-4),log10(0),log10(NULL);
86
69
id select_type table type possible_keys key key_len ref rows filtered Extra
87
70
1 SIMPLE NULL NULL NULL NULL NULL NULL NULL NULL No tables used