diff options
Diffstat (limited to 'mysql-test/t/partition_innodb.test')
| -rw-r--r-- | mysql-test/t/partition_innodb.test | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/mysql-test/t/partition_innodb.test b/mysql-test/t/partition_innodb.test index 62a9173b526..97130eb1a84 100644 --- a/mysql-test/t/partition_innodb.test +++ b/mysql-test/t/partition_innodb.test @@ -825,6 +825,7 @@ DROP TABLE t1; CREATE TABLE t1 (f1 VARCHAR(512) CHARACTER SET utf8) ENGINE=InnoDB; INSERT INTO t1 VALUES ('j'); +--error ER_INDEX_COLUMN_TOO_LONG CREATE TABLE t2 ( f2 VARCHAR(5) CHARACTER SET latin1, f3 VARCHAR(5) CHARACTER SET utf8, @@ -840,6 +841,22 @@ CREATE TABLE t2 ( PARTITION p1 VALUES IN (2,4,0) ); +CREATE TABLE t2 ( + f2 VARCHAR(5) CHARACTER SET latin1, + f3 VARCHAR(5) CHARACTER SET utf8, + f4 INT, + f5 VARCHAR(512) CHARACTER SET utf8, + f6 VARCHAR(256) CHARACTER SET utf8, + key (f2), + key (f3), + key (f5) +) ENGINE=InnoDB ROW_FORMAT=DYNAMIC + PARTITION BY LIST COLUMNS (f4) + SUBPARTITION BY KEY(f6) SUBPARTITIONS 4 ( + PARTITION p0 VALUES IN (1,3,9,null), + PARTITION p1 VALUES IN (2,4,0) +); + INSERT INTO t2 VALUES ('k','s',3,'b','j'),('a','b',NULL,'v','j'),('c','m',9,'t',NULL), ('b','l',9,'b',NULL),('i','y',3,'o','w'),('c','m',NULL,'a','m'), |