diff options
Diffstat (limited to 'mysql-test/t/ndb_partition_key.test')
| -rw-r--r-- | mysql-test/t/ndb_partition_key.test | 20 |
1 files changed, 20 insertions, 0 deletions
diff --git a/mysql-test/t/ndb_partition_key.test b/mysql-test/t/ndb_partition_key.test index ce939663ab8..9309dc7b36f 100644 --- a/mysql-test/t/ndb_partition_key.test +++ b/mysql-test/t/ndb_partition_key.test @@ -196,3 +196,23 @@ CREATE TABLE t1 ( ALTER TABLE t1 ADD COLUMN c4 INT AFTER c1; DROP TABLE t1; + +# +# BUG 19010: ALTER TABLE from NDB to other engine without primary key +# doesn't work. +# +create table t1 (a int) engine = ndb; +show create table t1; +alter table t1 add column b int; +show create table t1; +alter table t1 engine = myisam; +alter table t1 engine = ndb; +show create table t1; +alter table t1 coalesce partition 1; +show create table t1; +drop table t1 ; +create table t1 (a int) engine = ndb; +alter table t1 add partition partitions 1; +show create table t1; +drop table t1; + |