diff options
| author | Marko Mäkelä <marko.makela@mariadb.com> | 2021-11-09 08:50:33 +0200 |
|---|---|---|
| committer | Marko Mäkelä <marko.makela@mariadb.com> | 2021-11-09 08:50:33 +0200 |
| commit | 9c18b9660302a76a6ff9bd505888048a13586a4c (patch) | |
| tree | 8f0cd57e97ccca5f633825863e9e0f8e705ed8ff /mysql-test/main/alter_table.result | |
| parent | d8d6e995282dd9485f65517efbb684eabaf52322 (diff) | |
| parent | 47ab793d71f2755b026672e4657174a1740b6ae2 (diff) | |
| download | mariadb-git-9c18b9660302a76a6ff9bd505888048a13586a4c.tar.gz | |
Merge 10.4 into 10.5
Diffstat (limited to 'mysql-test/main/alter_table.result')
| -rw-r--r-- | mysql-test/main/alter_table.result | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/mysql-test/main/alter_table.result b/mysql-test/main/alter_table.result index faa74fb935f..755de4336b9 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 # # |