diff options
| author | mikael/pappa@dator5.(none) <> | 2006-08-08 08:52:51 -0400 |
|---|---|---|
| committer | mikael/pappa@dator5.(none) <> | 2006-08-08 08:52:51 -0400 |
| commit | 79ab9cef2715d433e905385c8cf20ee9694bf036 (patch) | |
| tree | 85931e220bc8936b370fcc37cbaf2a1b5cae33b5 /mysql-test/r/partition_mgm.result | |
| parent | a4eb61b88cbe4e8f6e43db2ca841fa60ec73467c (diff) | |
| download | mariadb-git-79ab9cef2715d433e905385c8cf20ee9694bf036.tar.gz | |
BUG#21143: mysqld hangs when using wrong number of subpartitions
Rewrote if-statement a bit shorter
Added check for subpartitions in REORGANIZE partitions to be of same number as
in base table.
Diffstat (limited to 'mysql-test/r/partition_mgm.result')
| -rw-r--r-- | mysql-test/r/partition_mgm.result | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/r/partition_mgm.result b/mysql-test/r/partition_mgm.result index f64ffaff495..9b5a34bda50 100644 --- a/mysql-test/r/partition_mgm.result +++ b/mysql-test/r/partition_mgm.result @@ -1,4 +1,14 @@ DROP TABLE IF EXISTS t1; +create table t1 (a int) +partition by range (a) +subpartition by key (a) +(partition p0 values less than (10) (subpartition sp00, subpartition sp01), +partition p1 values less than (20) (subpartition sp10, subpartition sp11)); +alter table t1 reorganize partition p0 into +(partition p0 values less than (10) (subpartition sp00, +subpartition sp01, subpartition sp02)); +ERROR HY000: Wrong number of subpartitions defined, mismatch with previous setting +drop table t1; CREATE TABLE t1 (f_date DATE, f_varchar VARCHAR(30)) PARTITION BY HASH(CAST(YEAR(f_date) AS SIGNED INTEGER)) PARTITIONS 2; SHOW CREATE TABLE t1; |