diff options
| author | unknown <mikael@zim.(none)> | 2006-03-11 06:17:10 -0800 |
|---|---|---|
| committer | unknown <mikael@zim.(none)> | 2006-03-11 06:17:10 -0800 |
| commit | 29cd6ff642e9072972f9f4fc73ba550170355b8f (patch) | |
| tree | d3467f4786669be6477b2588daa724c88a877bab /mysql-test/r/partition_mgm_err.result | |
| parent | a264a79eb769bb156e9fa9f96025272ef48f6395 (diff) | |
| download | mariadb-git-29cd6ff642e9072972f9f4fc73ba550170355b8f.tar.gz | |
BUG#15961: SUBPARTITION defined in non-subpartitioned table no error
Made sure that no subpartition stuff in non-subpartitioned table
mysql-test/r/partition.result:
New test case
mysql-test/r/partition_mgm_err.result:
Fixed bug in test case
mysql-test/t/partition.test:
New test case
mysql-test/t/partition_mgm_err.test:
Fixed bug in test case
sql/sql_partition.cc:
Made sure that no subpartition stuff in non-subpartitioned table
Diffstat (limited to 'mysql-test/r/partition_mgm_err.result')
| -rw-r--r-- | mysql-test/r/partition_mgm_err.result | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/mysql-test/r/partition_mgm_err.result b/mysql-test/r/partition_mgm_err.result index c7003c6e14c..f899801e7cd 100644 --- a/mysql-test/r/partition_mgm_err.result +++ b/mysql-test/r/partition_mgm_err.result @@ -141,7 +141,9 @@ DROP TABLE t1; CREATE TABLE t1 (a INT) PARTITION BY HASH(a); ALTER TABLE t1 ADD PARTITION PARTITIONS 4; DROP TABLE t1; -CREATE TABLE t1 (s1 int, s2 int) PARTITION BY LIST (s1) ( +CREATE TABLE t1 (s1 int, s2 int) +PARTITION BY LIST (s1) +SUBPARTITION BY KEY (s2) ( PARTITION p1 VALUES IN (0) (SUBPARTITION p1b), PARTITION p2 VALUES IN (2) (SUBPARTITION p1b) ); |