summaryrefslogtreecommitdiff
path: root/mysql-test/t/partition.test
diff options
context:
space:
mode:
authorMattias Jonsson <mattias.jonsson@sun.com>2009-11-17 22:48:28 +0100
committerMattias Jonsson <mattias.jonsson@sun.com>2009-11-17 22:48:28 +0100
commit7a6ab645ab02d5cb19288f1b3b5fcd271732bb4a (patch)
treeb810d1968b20f6183ecba6aca50fdaccb79bf2d0 /mysql-test/t/partition.test
parente6d02a127e9ba439bc6afba885678b51a523210c (diff)
parent785b5c4e7a06445d2b23b57c3dce120828844c69 (diff)
downloadmariadb-git-7a6ab645ab02d5cb19288f1b3b5fcd271732bb4a.tar.gz
merge
Diffstat (limited to 'mysql-test/t/partition.test')
-rw-r--r--mysql-test/t/partition.test9
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/t/partition.test b/mysql-test/t/partition.test
index 2bd2e7c6821..5e00d67a65e 100644
--- a/mysql-test/t/partition.test
+++ b/mysql-test/t/partition.test
@@ -15,6 +15,15 @@ drop table if exists t1, t2;
--enable_warnings
#
+# Bug#48276: can't add column if subpartition exists
+CREATE TABLE t1 (a INT, b INT)
+PARTITION BY LIST (a)
+SUBPARTITION BY HASH (b)
+(PARTITION p1 VALUES IN (1));
+ALTER TABLE t1 ADD COLUMN c INT;
+DROP TABLE t1;
+
+#
# Bug#46639: 1030 (HY000): Got error 124 from storage engine on
# INSERT ... SELECT ...
CREATE TABLE t1 (