summaryrefslogtreecommitdiff
path: root/mysql-test/t/func_math.test
diff options
context:
space:
mode:
authorunknown <jimw@mysql.com>2005-08-01 17:54:57 -0700
committerunknown <jimw@mysql.com>2005-08-01 17:54:57 -0700
commitd083e4ac1b1450e99984dcf488cfd95cefaf78cb (patch)
treec2a4f1c838bccde279f578e1d54a016a0d377f51 /mysql-test/t/func_math.test
parent8fc1e27fb7604b93358a15f26a0c849faa21a1ca (diff)
parentc679cb67bc8958a15dab68febf236ea1edeff5c5 (diff)
downloadmariadb-git-d083e4ac1b1450e99984dcf488cfd95cefaf78cb.tar.gz
Merge mysql.com:/home/jimw/my/mysql-4.1-clean
into mysql.com:/home/jimw/my/mysql-5.0-clean mysql-test/r/key_cache.result: Auto merged mysql-test/r/ps_1general.result: Auto merged mysql-test/r/variables.result: Auto merged mysql-test/r/func_math.result: Resolve conflicts mysql-test/r/user_var.result: Resolve conflicts mysql-test/t/func_math.test: Resolve conflicts mysql-test/t/user_var.test: Resolve conflicts sql/item_func.cc: Resolve conflicts sql/sql_parse.cc: Resolve conflicts
Diffstat (limited to 'mysql-test/t/func_math.test')
-rw-r--r--mysql-test/t/func_math.test15
1 files changed, 15 insertions, 0 deletions
diff --git a/mysql-test/t/func_math.test b/mysql-test/t/func_math.test
index bc3a1cd239c..bf692325a6a 100644
--- a/mysql-test/t/func_math.test
+++ b/mysql-test/t/func_math.test
@@ -93,3 +93,18 @@ select round(150, 2);
select ceil(0.09);
select ceil(0.000000000000000009);
+#
+# Bug #9837: problem with round()
+#
+
+create table t1 select round(1, 6);
+show create table t1;
+select * from t1;
+drop table t1;
+
+#
+# Bug #11402: abs() forces rest of calculation to unsigned
+#
+select abs(-2) * -2;
+
+# End of 4.1 tests