summaryrefslogtreecommitdiff
path: root/mysql-test/t/func_math.test
diff options
context:
space:
mode:
authorSergey Glukhov <sergey.glukhov@oracle.com>2011-03-28 12:52:47 +0400
committerSergey Glukhov <sergey.glukhov@oracle.com>2011-03-28 12:52:47 +0400
commit4ab6313b81e12fd6f6e0edf6f04403eff53ea913 (patch)
tree2bb3251262891d9d8923ebadb0d566ee47cc322f /mysql-test/t/func_math.test
parentb1b17093c890d622e38db4667eb3bd24127251e5 (diff)
parenta88faf2a4af5f60722647a8e01de6aac20305bb7 (diff)
downloadmariadb-git-4ab6313b81e12fd6f6e0edf6f04403eff53ea913.tar.gz
5.1 -> 5.5 merge
Diffstat (limited to 'mysql-test/t/func_math.test')
-rw-r--r--mysql-test/t/func_math.test9
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/t/func_math.test b/mysql-test/t/func_math.test
index daa338a8424..687d96f8804 100644
--- a/mysql-test/t/func_math.test
+++ b/mysql-test/t/func_math.test
@@ -345,6 +345,15 @@ CREATE TABLE t1 SELECT CAST((CASE(('')) WHEN (CONVERT(1, CHAR(1))) THEN (('' / 1
SHOW CREATE TABLE t1;
DROP TABLE t1;
+--echo #
+--echo # Bug#11764994 57900: CREATE TABLE .. SELECT ASSERTS SCALE >= 0 && PRECISION > 0 && SCALE <= PR
+--echo #
+
+CREATE TABLE t1 SELECT CEIL(LINESTRINGFROMWKB(1) DIV NULL);
+DROP TABLE t1;
+CREATE TABLE t1 SELECT FLOOR(LINESTRINGFROMWKB(1) DIV NULL);
+DROP TABLE t1;
+
--echo End of 5.1 tests
--echo #