summaryrefslogtreecommitdiff
path: root/mysql-test/r/partition.result
diff options
context:
space:
mode:
authorunknown <mikael@dator6.(none)>2008-01-28 22:05:25 +0100
committerunknown <mikael@dator6.(none)>2008-01-28 22:05:25 +0100
commitbb091abb145f89e2332a5b49cbc221793bce3452 (patch)
tree4b0273ce5af7e1cbf67c72480e876a4ff2c115a7 /mysql-test/r/partition.result
parent4bacd53715ac860c6ba2d9c148f87d22cae9c62a (diff)
downloadmariadb-git-bb091abb145f89e2332a5b49cbc221793bce3452.tar.gz
BUG#33182: Disallow division due to div_precision_increment problems
mysql-test/r/partition.result: New test case to validate that '/' is no longer allowed, only integer division is allowed mysql-test/t/partition.test: New test case to validate that '/' is no longer allowed, only integer division is allowed sql/item_func.h: +,-,*, mod is allowed / is disallowed
Diffstat (limited to 'mysql-test/r/partition.result')
-rw-r--r--mysql-test/r/partition.result3
1 files changed, 3 insertions, 0 deletions
diff --git a/mysql-test/r/partition.result b/mysql-test/r/partition.result
index a361a8f6bcc..d3275cec922 100644
--- a/mysql-test/r/partition.result
+++ b/mysql-test/r/partition.result
@@ -1,4 +1,7 @@
drop table if exists t1;
+create table t1 (a int) partition by list ((a/3)*10 div 1)
+(partition p0 values in (0), partition p1 values in (1));
+ERROR HY000: This partition function is not allowed
CREATE TABLE t1 (
d DATE NOT NULL
)