Debian Codegraph @

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

raw
1 #
2 # Test verifies that "ROLLBACK ALTER" is written to binary log upon
3 #ALTER command execution failure.
4 #
5 include/master-slave.inc
6 [connection master]
7 connection master;
8 set global binlog_alter_two_phase = ON;
9 set binlog_alter_two_phase = ON;
10 create table t1 (f1 int primary key) engine=InnoDB;
11 create table t2 (f1 int primary key,
12 constraint c1 foreign key (f1) references t1(f1),
13 constraint c1 foreign key (f1) references t1(f1)) engine=InnoDB;
14 ERROR HY000: Can't create table `test`.`t2` (errno: 150 "Foreign key constraint is incorrectly formed")
15 create table t2 (f1 int primary key,
16 constraint c1 foreign key (f1) references t1(f1)) engine=innodb;
17 alter table t2 add constraint c1 foreign key (f1) references t1(f1);
18 ERROR HY000: Can't create table `test`.`t2` (errno: 121 "Duplicate key on write or update")
19 include/show_binlog_events.inc
20 Log_name Pos Event_type Server_id End_log_pos Info
21 master-bin.000001 # Gtid # # GTID #-#-#
22 master-bin.000001 # Query # # use `test`; create table t1 (f1 int primary key) engine=InnoDB
23 master-bin.000001 # Gtid # # GTID #-#-#
24 master-bin.000001 # Query # # use `test`; create table t2 (f1 int primary key,
25 constraint c1 foreign key (f1) references t1(f1)) engine=innodb
26 master-bin.000001 # Gtid # # GTID #-#-# START ALTER
27 master-bin.000001 # Query # # use `test`; alter table t2 add constraint c1 foreign key (f1) references t1(f1)
28 master-bin.000001 # Gtid # # GTID #-#-# ROLLBACK ALTER id=#
29 master-bin.000001 # Query # # use `test`; alter table t2 add constraint c1 foreign key (f1) references t1(f1)
30 set foreign_key_checks = 0;
31 alter table t2 add constraint c1 foreign key (f1) references t1(f1);
32 ERROR HY000: Duplicate FOREIGN KEY constraint name 'test/c1'
33 include/show_binlog_events.inc
34 Log_name Pos Event_type Server_id End_log_pos Info
35 master-bin.000001 # Gtid # # GTID #-#-#
36 master-bin.000001 # Query # # use `test`; create table t1 (f1 int primary key) engine=InnoDB
37 master-bin.000001 # Gtid # # GTID #-#-#
38 master-bin.000001 # Query # # use `test`; create table t2 (f1 int primary key,
39 constraint c1 foreign key (f1) references t1(f1)) engine=innodb
40 master-bin.000001 # Gtid # # GTID #-#-# START ALTER
41 master-bin.000001 # Query # # use `test`; alter table t2 add constraint c1 foreign key (f1) references t1(f1)
42 master-bin.000001 # Gtid # # GTID #-#-# ROLLBACK ALTER id=#
43 master-bin.000001 # Query # # use `test`; alter table t2 add constraint c1 foreign key (f1) references t1(f1)
44 master-bin.000001 # Gtid # # GTID #-#-# START ALTER
45 master-bin.000001 # Query # # use `test`; set foreign_key_checks=0; alter table t2 add constraint c1 foreign key (f1) references t1(f1)
46 master-bin.000001 # Gtid # # GTID #-#-# ROLLBACK ALTER id=#
47 master-bin.000001 # Query # # use `test`; set foreign_key_checks=0; alter table t2 add constraint c1 foreign key (f1) references t1(f1)
48 connection slave;
49 connection master;
50 drop table t2, t1;
51 connection slave;
52 connection master;
53 set global binlog_alter_two_phase=0;;
54 include/rpl_end.inc