summaryrefslogtreecommitdiff
path: root/mysql-test/r/func_math.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/r/func_math.result')
-rw-r--r--mysql-test/r/func_math.result22
1 files changed, 22 insertions, 0 deletions
diff --git a/mysql-test/r/func_math.result b/mysql-test/r/func_math.result
new file mode 100644
index 00000000000..33d1dfe65e7
--- /dev/null
+++ b/mysql-test/r/func_math.result
@@ -0,0 +1,22 @@
+floor(5.5) floor(-5.5)
+5 -6
+ceiling(5.5) ceiling(-5.5)
+6 -5
+truncate(52.64,1) truncate(52.64,2) truncate(52.64,-1) truncate(52.64,-2)
+52.6 52.64 50 0
+round(5.5) round(-5.5)
+6 -6
+round(5.64,1) round(5.64,2) round(5.64,-1) round(5.64,-2)
+5.6 5.64 10 0
+abs(-10) sign(-5) sign(5) sign(0)
+10 -1 1 0
+log(exp(10)) exp(log(sqrt(10))*2)
+10.000000 10.000000
+pow(10,log10(10)) power(2,4)
+10.000000 16.000000
+rand(999999) rand()
+0.18435012473199 0.76373626176616
+PI() sin(pi()/2) cos(pi()/2) tan(pi()) cot(1) asin(1) acos(0) atan(1)
+3.141593 1.000000 0.000000 -0.000000 0.64209262 1.570796 1.570796 0.785398
+degrees(pi()) radians(360)
+180 6.2831853071796