diff options
| author | unknown <mikael@c-870ae253.1238-1-64736c10.cust.bredbandsbolaget.se> | 2006-05-27 20:30:53 -0400 |
|---|---|---|
| committer | unknown <mikael@c-870ae253.1238-1-64736c10.cust.bredbandsbolaget.se> | 2006-05-27 20:30:53 -0400 |
| commit | 93cde729c0c57d50283d8602332af22ebbc26110 (patch) | |
| tree | ed1539b066ac78b91776da8eb1ea454e2ab1593f /mysql-test/t/partition_innodb.test | |
| parent | d13c5aa3b709c079a0ce83dab49b51d517dfb438 (diff) | |
| download | mariadb-git-93cde729c0c57d50283d8602332af22ebbc26110.tar.gz | |
BUG#19310: Add partition using InnoDB crashes MySQL Server
Added new test case
mysql-test/r/partition_innodb.result:
Added new test case
mysql-test/t/partition_innodb.test:
Added new test case
Diffstat (limited to 'mysql-test/t/partition_innodb.test')
| -rw-r--r-- | mysql-test/t/partition_innodb.test | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/t/partition_innodb.test b/mysql-test/t/partition_innodb.test index 0190479d908..6a95dd7c8b0 100644 --- a/mysql-test/t/partition_innodb.test +++ b/mysql-test/t/partition_innodb.test @@ -47,6 +47,16 @@ SELECT IF(9999 - 1000 + 1 > @max_row, @max_row , 9999 - 1000 + 1) ALTER TABLE t1 PARTITION BY HASH(CAST(YEAR(f_date) AS SIGNED INTEGER)); --echo # 1.1.5 Add two named partitions + test ALTER TABLE t1 ADD PARTITION (PARTITION part1, PARTITION part7); +drop table t1; + +CREATE TABLE t1 (f_date DATE, f_varchar VARCHAR(30)) +ENGINE=InnoDB +PARTITION BY HASH(CAST(YEAR(f_date) AS SIGNED INTEGER)); + +--echo # This statement crashes the server. +--echo # CREATE partitioned table with three partitions in one step +--echo # would be harmless. +ALTER TABLE t1 ADD PARTITION PARTITIONS 1; --disable_warnings DROP VIEW IF EXISTS v1; |