summaryrefslogtreecommitdiff
path: root/mysql-test
diff options
context:
space:
mode:
authormonty@hundin.mysql.fi <>2002-06-02 20:46:03 +0300
committermonty@hundin.mysql.fi <>2002-06-02 20:46:03 +0300
commit544f95c45112993df1d31d3eda859dd5e4efff89 (patch)
tree8de3d7e1875b8751450433ee53331ffb7322e7b5 /mysql-test
parent44a631f1fc75abc897d606eb4c75e9898bff7e54 (diff)
parent5f93b1e46ac09a45524acb9803b8cd7f951599ef (diff)
downloadmariadb-git-544f95c45112993df1d31d3eda859dd5e4efff89.tar.gz
merge with 3.23
Diffstat (limited to 'mysql-test')
-rw-r--r--mysql-test/r/func_math.result6
-rw-r--r--mysql-test/t/func_math.test2
2 files changed, 3 insertions, 5 deletions
diff --git a/mysql-test/r/func_math.result b/mysql-test/r/func_math.result
index fce98a58682..b961c839510 100644
--- a/mysql-test/r/func_math.result
+++ b/mysql-test/r/func_math.result
@@ -4,10 +4,8 @@ floor(5.5) floor(-5.5)
select ceiling(5.5),ceiling(-5.5);
ceiling(5.5) ceiling(-5.5)
6 -5
-select truncate(52.64,1),truncate(52.64,2),truncate(52.64,-1),truncate(52.64,-2);
-truncate(52.64,1) truncate(52.64,2) truncate(52.64,-1) truncate(52.64,-2)
-52.6 52.64 50 0
-select round(5.5),round(-5.5);
+truncate(52.64,1) truncate(52.64,2) truncate(52.64,-1) truncate(52.64,-2) truncate(-52.64,1) truncate(-52.64,-1)
+52.6 52.64 50 0 -52.6 -50
round(5.5) round(-5.5)
6 -6
select round(5.64,1),round(5.64,2),round(5.64,-1),round(5.64,-2);
diff --git a/mysql-test/t/func_math.test b/mysql-test/t/func_math.test
index ab7990eea79..5299897d0f0 100644
--- a/mysql-test/t/func_math.test
+++ b/mysql-test/t/func_math.test
@@ -4,7 +4,7 @@
select floor(5.5),floor(-5.5);
select ceiling(5.5),ceiling(-5.5);
-select truncate(52.64,1),truncate(52.64,2),truncate(52.64,-1),truncate(52.64,-2);
+select truncate(52.64,1),truncate(52.64,2),truncate(52.64,-1),truncate(52.64,-2), truncate(-52.64,1),truncate(-52.64,-1);
select round(5.5),round(-5.5);
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);