diff options
Diffstat (limited to 'mysql-test/main/alter_table_lock.result')
| -rw-r--r-- | mysql-test/main/alter_table_lock.result | 45 |
1 files changed, 45 insertions, 0 deletions
diff --git a/mysql-test/main/alter_table_lock.result b/mysql-test/main/alter_table_lock.result index 620fca23..5a787055 100644 --- a/mysql-test/main/alter_table_lock.result +++ b/mysql-test/main/alter_table_lock.result @@ -14,4 +14,49 @@ ALTER TABLE t1 CHANGE COLUMN IF EXISTS b c INT; SET SESSION max_session_mem_used = @max_session_mem_used_save; UNLOCK TABLES; DROP TABLE t1; +# # End of 10.5 tests +# +# +# MDEV-28943 Online alter fails under LOCK TABLE with ER_ALTER_OPERATION_NOT_SUPPORTED_REASON +# +create table t1 (f int) engine=innodb; +insert t1 values (1); +alter table t1 force, algorithm=copy, lock=none; +alter table t1 force, algorithm=inplace, lock=none; +alter table t1 force, algorithm=copy, lock=shared; +alter table t1 force, algorithm=inplace, lock=shared; +alter table t1 force, algorithm=copy, lock=exclusive; +alter table t1 force, algorithm=inplace, lock=exclusive; +lock table t1 write; +connect con1, localhost, root; +select count(*) as 'must be 0' from t1; +connection default; +alter table t1 force, algorithm=copy, lock=none; +alter table t1 force, algorithm=inplace, lock=none; +alter table t1 force, algorithm=copy, lock=shared; +alter table t1 force, algorithm=inplace, lock=shared; +alter table t1 force, algorithm=copy, lock=exclusive; +alter table t1 force, algorithm=inplace, lock=exclusive; +delete from t1; +unlock tables; +connection con1; +must be 0 +0 +connection default; +drop table t1; +# +# MDEV-29056 Replica SQL thread stops with 1846 error on ALTER ONLINE after LOCK WRITE +# +create table t1 (c varchar(1), key (c)) engine=innodb; +insert into t1 (c) values ('g') ; +alter table t1 add fulltext key(c), algorithm=inplace; +alter online table t1 add column s blob not null, algorithm=inplace; +ERROR 0A000: LOCK=NONE is not supported. Reason: Fulltext index creation requires a lock. Try LOCK=SHARED +lock table t1 write; +alter online table t1 add column s blob not null, algorithm=inplace; +ERROR 0A000: LOCK=NONE is not supported. Reason: Fulltext index creation requires a lock. Try LOCK=SHARED +drop table t1; +# +# End of 10.11 tests +# |