diff options
Diffstat (limited to '')
| -rw-r--r-- | mysql-test/main/mdl_sync.test | 10 |
1 files changed, 5 insertions, 5 deletions
diff --git a/mysql-test/main/mdl_sync.test b/mysql-test/main/mdl_sync.test index 29d95460..aa3bd60e 100644 --- a/mysql-test/main/mdl_sync.test +++ b/mysql-test/main/mdl_sync.test @@ -1196,14 +1196,14 @@ insert into t1 values (1); connection default; --echo # Add pending SNW lock. --echo # Sending: ---send alter table t1 add primary key (c1); +--send alter table t1 add primary key (c1), lock=shared; --echo # connection mdl_con1; --echo # Check that ALTER TABLE is waiting with pending SNW lock. let $wait_condition= select count(*) = 1 from information_schema.processlist where state = "Waiting for table metadata lock" and - info = "alter table t1 add primary key (c1)"; + info = "alter table t1 add primary key (c1), lock=shared"; --source include/wait_condition.inc --echo # Check that S, SH and SR locks are compatible with pending SNW handler t1 open t; @@ -2431,7 +2431,7 @@ create table t1 (i int); --echo # Ensure that ALTER waits once it has acquired SNW lock. set debug_sync='alter_table_copy_after_lock_upgrade SIGNAL parked1 WAIT_FOR go1'; --echo # Sending: ---send alter table t1 add column j int +--send alter table t1 add column j int, lock=shared --echo # connection deadlock_con1; @@ -2986,7 +2986,7 @@ select * from t1 where c2 = 3; --echo # connection con46273; set debug_sync='alter_table_copy_after_lock_upgrade SIGNAL alter_table_locked WAIT_FOR alter_go'; ---send alter table t1 add column e int, rename to t2; +--send alter table t1 add column e int, rename to t2, lock=shared; --echo # connection default; @@ -3341,7 +3341,7 @@ connection default; --echo # table lock and get blocked on sync point. set debug_sync= 'alter_table_copy_after_lock_upgrade SIGNAL parked WAIT_FOR go'; --echo # Sending: ---send alter table t1 add column j int +--send alter table t1 add column j int, lock=shared connection con1; --echo # Wait until ALTER TABLE gets blocked on a sync point. |