diff options
Diffstat (limited to 'mysql-test/main/partition_alter.test')
| -rw-r--r-- | mysql-test/main/partition_alter.test | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/main/partition_alter.test b/mysql-test/main/partition_alter.test index 72b09549b18..48d9657c7bd 100644 --- a/mysql-test/main/partition_alter.test +++ b/mysql-test/main/partition_alter.test @@ -126,7 +126,7 @@ alter table t1 drop primary key, drop column x, add primary key (pk); select * from t1 partition (p0); drop table t1; -create or replace table t1 (pk int not null, x timestamp(6), unique u(pk, x)) engine innodb +create or replace table t1 (pk int not null, x timestamp(6) not null, unique u(pk, x)) engine innodb partition by key() partitions 2; insert into t1 (pk, x) values (1, '2000-01-01 00:00'), (2, '2000-01-01 00:01'); --echo # Same for NOT NULL UNIQUE KEY as this is actually primary key @@ -136,7 +136,7 @@ alter table t1 drop key u, drop column x, add unique (pk); select * from t1 partition (p0); drop table t1; -create or replace table t1 (pk int, x timestamp(6), primary key (pk)) engine innodb +create or replace table t1 (pk int, x timestamp(6) not null, primary key (pk)) engine innodb partition by key(pk) partitions 2; insert into t1 (pk, x) values (1, '2000-01-01 00:00'), (2, '2000-01-01 00:01'); --echo # Inplace for DROP PRIMARY KEY when partitioned by explicit field list is allowed |