Debian Codegraph @

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

raw
1 # MDEV-11675 two phase logged ALTER
2 #
3 # The tests verifies execution of non-ALTER queries that are handled
4 # through mysql_alter_table function.
5
6 --source include/have_log_bin.inc
7 --source include/have_innodb.inc
8 --source include/master-slave.inc
9
10 --connection master
11 set binlog_alter_two_phase = ON;
12
13 --connection master
14 CREATE TABLE t1 (i int) engine=innodb;
15 CREATE TABLE t2 (i int) engine=innodb;
16
17 ALTER TABLE t1 DROP CONSTRAINT IF EXISTS y;
18 OPTIMIZE TABLE t2;
19
20 --sync_slave_with_master
21
22 --connection master
23 drop table t1,t2;
24
25 --source include/rpl_end.inc