Debian Codegraph @

mysql-test/suite/rpl/t/rpl_start_alter_instant.test

raw
1 # MDEV-11675
2 # Prove that "fast" ALTER options also combine with @@binlog_alter_two_phase.
3 --source include/have_innodb.inc
4 --source include/master-slave.inc
5
6 --connection master
7 set binlog_alter_two_phase=true;
8 CREATE OR REPLACE TABLE tab (
9 a int PRIMARY KEY,
10 b varchar(50),
11 c varchar(50)
12 ) CHARACTER SET=latin1 engine=innodb;
13
14
15 ALTER TABLE tab MODIFY COLUMN b varchar(100), algorithm=instant;
16 ALTER TABLE tab MODIFY COLUMN c varchar(100), algorithm=nocopy;
17 SHOW CREATE TABLE tab;
18 --source include/show_binlog_events.inc
19
20 --sync_slave_with_master
21 SHOW CREATE TABLE tab;
22 --source include/show_binlog_events.inc
23
24 --connection master
25 DROP TABLE tab;
26
27 --sync_slave_with_master
28
29 --source include/rpl_end.inc