diff options
| author | Marko Mäkelä <marko.makela@mariadb.com> | 2021-11-09 09:40:29 +0200 |
|---|---|---|
| committer | Marko Mäkelä <marko.makela@mariadb.com> | 2021-11-09 09:40:29 +0200 |
| commit | 06988bdcaa2d1af2c178c199b7f65dbafda45a2c (patch) | |
| tree | e94f851b10a83bfde159fd3adf692352cfe9cdf3 /mysql-test/main/alter_table.result | |
| parent | 662fe08232d807f06da9665fa5a288717407f735 (diff) | |
| parent | ba4f8e317de33330c882b5de14979685a0216ce0 (diff) | |
| download | mariadb-git-06988bdcaa2d1af2c178c199b7f65dbafda45a2c.tar.gz | |
Merge 10.6 into 10.7
Diffstat (limited to 'mysql-test/main/alter_table.result')
| -rw-r--r-- | mysql-test/main/alter_table.result | 42 |
1 files changed, 42 insertions, 0 deletions
diff --git a/mysql-test/main/alter_table.result b/mysql-test/main/alter_table.result index bef7f393d1d..ceeebd52978 100644 --- a/mysql-test/main/alter_table.result +++ b/mysql-test/main/alter_table.result @@ -2588,6 +2588,22 @@ set max_statement_time= 0; drop table t1; drop view v1; # +# MDEV-25803 Inplace ALTER breaks MyISAM/Aria tables when order of keys is changed +# +set @save_default_engine= @@default_storage_engine; +create or replace table t1 (x int, y int, unique (y), unique (x), primary key(x)) engine myisam; +alter table t1 change x xx int, algorithm=inplace; +check table t1; +Table Op Msg_type Msg_text +test.t1 check status OK +create or replace table t1 (x int, y int, unique (y), unique (x), primary key(x)); +alter table t1 change x xx int, algorithm=inplace; +check table t1; +Table Op Msg_type Msg_text +test.t1 check status OK +drop table t1; +set @@default_storage_engine= @save_default_engine; +# # End of 10.3 tests # # @@ -3373,6 +3389,32 @@ t1 CREATE TABLE `t1` ( ) ENGINE=MyISAM DEFAULT CHARSET=latin1 drop table t1; # +# MDEV-25803 Inplace ALTER breaks MyISAM/Aria tables when order of keys is changed +# +set @save_default_engine= @@default_storage_engine; +create or replace table t1 (x int, y int, unique (y), unique (x), primary key(x)) engine myisam; +alter table t1 change x xx int, algorithm=inplace; +check table t1; +Table Op Msg_type Msg_text +test.t1 check status OK +create or replace table t1 (x int, y int, unique (y), unique (x), primary key(x)); +alter table t1 change x xx int, algorithm=inplace; +check table t1; +Table Op Msg_type Msg_text +test.t1 check status OK +drop table t1; +set @@default_storage_engine= @save_default_engine; +# +# MDEV-25555 Server crashes in tree_record_pos after INPLACE-recreating index on HEAP table +# +create table t1 (a int, key idx1(a), key idx2 using btree(a)) engine=memory; +alter table t1 rename index idx1 to idx3, algorithm=inplace; +delete from t1 where a = 10; +alter table t1 drop key idx3, add key idx1(a), algorithm=inplace; +ERROR 0A000: ALGORITHM=INPLACE is not supported for this operation. Try ALGORITHM=COPY +delete from t1 where a = 11; +drop table t1; +# # End of 10.5 tests # # |