~drizzle-trunk/drizzle/development

select round(5.64,1),round(5.64,2),round(5.64,-1),round(5.64,-2);

select abs(-10), sign(-5), sign(5), sign(0);

explain extended select abs(-10), sign(-5), sign(5), sign(0);

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);

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);

select ln(exp(10)),exp(ln(sqrt(10))*2),ln(-1),ln(0),ln(NULL);

explain extended select ln(exp(10)),exp(ln(sqrt(10))*2),ln(-1),ln(0),ln(NULL);

select log2(8),log2(15),log2(-2),log2(0),log2(NULL);

explain extended select log2(8),log2(15),log2(-2),log2(0),log2(NULL);

select log10(100),log10(18),log10(-4),log10(0),log10(NULL);

explain extended select log10(100),log10(18),log10(-4),log10(0),log10(NULL);

select pow(10,log10(10)),power(2,4);