Debian Codegraph @

mysql-test/suite/rpl/r/rpl_start_alter_bugs.result

raw
1 include/master-slave.inc
2 [connection master]
3 connection master;
4 set global binlog_alter_two_phase=true;
5 connection slave;
6 stop slave;
7 SET global slave_parallel_threads=2;
8 set global slave_parallel_mode=optimistic;
9 start slave;
10 connection master;
11 CREATE TABLE t1 (i int primary key) ENGINE = InnoDB;
12 connection master1;
13 ALTER TABLE t1 DROP PRIMARY KEY;
14 ALTER TABLE t1 ADD UNIQUE KEY ui (i);
15 ALTER TABLE t1 ADD PRIMARY KEY (i);
16 connection slave;
17 connection master;
18 drop table t1;
19 CREATE TABLE t1 (a int)engine=innodb;
20 ALTER TABLE t1 add column b int, LOCK=EXCLUSIVE;
21 drop table t1;
22 CREATE TABLE t1 (pk int)engine=innodb;
23 ALTER TABLE t1 DROP FOREIGN KEY y, LOCK=EXCLUSIVE;
24 ERROR 42000: Can't DROP FOREIGN KEY `y`; check that it exists
25 drop table t1;
26 connection slave;
27 connection master;
28 set global binlog_alter_two_phase=false;
29 connection slave;
30 include/stop_slave.inc
31 SET global slave_parallel_threads=0;
32 include/start_slave.inc
33 include/rpl_end.inc