From 21e654a828fb553a05fa59ce1e24a9360e377835 Mon Sep 17 00:00:00 2001
From: unknown <mikael@dator6.(none)>
Date: Mon, 28 Jan 2008 16:11:43 +0100
Subject: BUG#33429: No check for maxvalue before adding partition

mysql-test/r/partition_range.result:
  Added new test cases
mysql-test/t/partition_range.test:
  Added new test cases
sql/sql_partition.cc:
  Added check that last partition hasn't got maxvalue defined when
  executing ADD PARTITION
---
 mysql-test/t/partition_range.test | 11 +++++++++++
 1 file changed, 11 insertions(+)

(limited to 'mysql-test/t/partition_range.test')

diff --git a/mysql-test/t/partition_range.test b/mysql-test/t/partition_range.test
index 6ed3abab46a..035a895dbab 100644
--- a/mysql-test/t/partition_range.test
+++ b/mysql-test/t/partition_range.test
@@ -9,6 +9,17 @@
 drop table if exists t1, t2;
 --enable_warnings
 
+#
+# BUG 33429: Succeeds in  adding partition when maxvalue on last partition
+#
+create table t1 (a int)
+partition by range (a)
+( partition p0 values less than (maxvalue));
+--error ER_PARTITION_MAXVALUE_ERROR
+alter table t1 add partition (partition p1 values less than (100000));
+show create table t1;
+drop table t1;
+
 #
 # BUG 18198: Various tests for partition functions
 #
-- 
cgit v1.2.1