1 files changed, 60 insertions, 0 deletions
diff --git a/mysql-test/suite/engines/funcs/r/tc_partition_check.result b/mysql-test/suite/engines/funcs/r/tc_partition_check.result
new file mode 100644
index 00000000000..c03de001177
--- /dev/null
+++ b/mysql-test/suite/engines/funcs/r/tc_partition_check.result
@@ -0,0 +1,60 @@
+DROP TABLE IF EXISTS t1;
+CREATE TABLE t1 ( c1 INTEGER NOT NULL PRIMARY KEY, c2 CHAR(10)) PARTITION BY RANGE (c1) (
+PARTITION p0 VALUES LESS THAN (100),
+PARTITION p1 VALUES LESS THAN (200),
+PARTITION p2 VALUES LESS THAN (300),
+PARTITION p3 VALUES LESS THAN (400),
+PARTITION p4 VALUES LESS THAN (500),
+PARTITION p5 VALUES LESS THAN MAXVALUE);
+SHOW TABLES;
+Tables_in_test
+t1
+INSERT INTO t1 VALUES(0,'abc'),(100,'abc'),(200,'abc'),(300,'abc'),(400,'abc');
+SELECT * FROM t1 ORDER BY c1;
+c1	c2
+0	abc
+100	abc
+200	abc
+300	abc
+400	abc
+SHOW CREATE TABLE t1;
+Table	Create Table
+t1	CREATE TABLE `t1` (
+  `c1` int(11) NOT NULL,
+  `c2` char(10) DEFAULT NULL,
+  PRIMARY KEY (`c1`)
+) ENGINE=ENGINE DEFAULT CHARSET=latin1
+/*!50100 PARTITION BY RANGE (c1)
+(PARTITION p0 VALUES LESS THAN (100) ENGINE = ENGINE,
+ PARTITION p1 VALUES LESS THAN (200) ENGINE = ENGINE,
+ PARTITION p2 VALUES LESS THAN (300) ENGINE = ENGINE,
+ PARTITION p3 VALUES LESS THAN (400) ENGINE = ENGINE,
+ PARTITION p4 VALUES LESS THAN (500) ENGINE = ENGINE,
+ PARTITION p5 VALUES LESS THAN MAXVALUE ENGINE = ENGINE) */
+ALTER TABLE t1 CHECK PARTITION p1,p2;
+Table	Op	Msg_type	Msg_text
+test.t1	check	status	OK
+SELECT * FROM t1 ORDER BY c1;
+c1	c2
+0	abc
+100	abc
+200	abc
+300	abc
+400	abc
+SHOW CREATE TABLE t1;
+Table	Create Table
+t1	CREATE TABLE `t1` (
+  `c1` int(11) NOT NULL,
+  `c2` char(10) DEFAULT NULL,
+  PRIMARY KEY (`c1`)
+) ENGINE=ENGINE DEFAULT CHARSET=latin1
+/*!50100 PARTITION BY RANGE (c1)
+(PARTITION p0 VALUES LESS THAN (100) ENGINE = ENGINE,
+ PARTITION p1 VALUES LESS THAN (200) ENGINE = ENGINE,
+ PARTITION p2 VALUES LESS THAN (300) ENGINE = ENGINE,
+ PARTITION p3 VALUES LESS THAN (400) ENGINE = ENGINE,
+ PARTITION p4 VALUES LESS THAN (500) ENGINE = ENGINE,
+ PARTITION p5 VALUES LESS THAN MAXVALUE ENGINE = ENGINE) */
+DROP TABLE t1;
+SHOW TABLES;
+Tables_in_test