diff options
Diffstat (limited to 'mysql-test/t/partition_alter.test')
| -rw-r--r-- | mysql-test/t/partition_alter.test | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/t/partition_alter.test b/mysql-test/t/partition_alter.test index e320efcefb9..ce6672c4b9d 100644 --- a/mysql-test/t/partition_alter.test +++ b/mysql-test/t/partition_alter.test @@ -105,3 +105,12 @@ show create table t1; insert t1 values (2, '2020-01-03', 20); drop table t1; --list_files $datadir/test + +# +# MDEV-13097 Online alter of a partitioned MyISAM table with auto_increment +# +create table t1 (id_1 int auto_increment, id_2 int, id_3 int, d1 date, dt1 datetime default current_timestamp, dt2 datetime default current_timestamp on update current_timestamp, primary key (id_2, id_3), key(id_1)) partition by hash(id_2) partitions 3 (partition p01, partition p02, partition p03); +insert into t1 values(0, 1, 1, NULL, now(), now()); +alter online table t1 delay_key_write=1; +show create table t1; +drop table t1; |