diff options
Diffstat (limited to 'mysql-test/r/alter_table-big.result')
-rw-r--r-- | mysql-test/r/alter_table-big.result | 32 |
1 files changed, 32 insertions, 0 deletions
diff --git a/mysql-test/r/alter_table-big.result b/mysql-test/r/alter_table-big.result index f7a3ec6502e..32689daa3a6 100644 --- a/mysql-test/r/alter_table-big.result +++ b/mysql-test/r/alter_table-big.result @@ -1,5 +1,8 @@ drop table if exists t1, t2; set debug_sync='RESET'; +connect addconroot, localhost, root,,; +connect addconroot2, localhost, root,,; +connection default; create table t1 (n1 int, n2 int, n3 int, key (n1, n2, n3), key (n2, n3, n1), @@ -10,10 +13,15 @@ insert into t1 values (1, 2, 3); reset master; set debug_sync='alter_table_enable_indexes SIGNAL parked WAIT_FOR go'; alter table t1 enable keys;; +connection addconroot; set debug_sync='now WAIT_FOR parked'; insert into t2 values (1); insert into t1 values (1, 1, 1);; +connection addconroot2; set debug_sync='now SIGNAL go'; +connection default; +connection addconroot; +connection default; include/show_binlog_events.inc Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Gtid # # BEGIN GTID #-#-# @@ -25,36 +33,60 @@ master-bin.000001 # Gtid # # BEGIN GTID #-#-# master-bin.000001 # Query # # use `test`; insert into t1 values (1, 1, 1) master-bin.000001 # Query # # COMMIT drop tables t1, t2; +disconnect addconroot; +disconnect addconroot2; set debug_sync='RESET'; End of 5.0 tests drop table if exists t1, t2, t3; +connect addconroot, localhost, root,,; +connect addconroot2, localhost, root,,; +connection default; create table t1 (i int); reset master; set debug_sync='alter_table_before_main_binlog SIGNAL parked WAIT_FOR go'; alter table t1 change i c char(10) default 'Test1';; +connection addconroot; set debug_sync='now WAIT_FOR parked'; insert into t1 values ();; +connection addconroot2; set debug_sync='now SIGNAL go'; +connection default; +connection addconroot; +connection default; select * from t1; c Test1 set debug_sync='alter_table_before_main_binlog SIGNAL parked WAIT_FOR go'; alter table t1 change c vc varchar(100) default 'Test2';; +connection addconroot; set debug_sync='now WAIT_FOR parked'; rename table t1 to t2;; +connection addconroot2; set debug_sync='now SIGNAL go'; +connection default; +connection addconroot; +connection default; drop table t2; create table t1 (i int); set debug_sync='alter_table_before_main_binlog SIGNAL parked WAIT_FOR go'; alter table t1 change i c char(10) default 'Test3', rename to t2;; +connection addconroot; set debug_sync='now WAIT_FOR parked'; insert into t2 values();; +connection addconroot2; set debug_sync='now SIGNAL go'; +connection default; +connection addconroot; +connection default; select * from t2; c Test3 alter table t2 change c vc varchar(100) default 'Test2', rename to t1;; +connection addconroot; +connection default; rename table t1 to t3; +disconnect addconroot; +disconnect addconroot2; drop table t3; set debug_sync='alter_table_before_main_binlog SIGNAL parked WAIT_FOR go'; set debug_sync='RESET'; |