Debian Codegraph @

mysql-test/suite/rpl_gtid/r/rpl_gtid_stm_drop_table.result

raw
1 include/rpl_init.inc [topology=1->2->3]
2 Warnings:
3 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
4 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
5 Warnings:
6 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
7 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
8 include/rpl_default_connections.inc
9 #
10 # First part
11 #
12 [connection master]
13 CREATE TABLE trans_t1 (c1 INT) ENGINE=InnoDB;
14 CREATE TABLE non_trans_t1 (c1 INT) ENGINE=MyISAM;
15 CREATE TEMPORARY TABLE temp_trans_t1 (c1 INT) ENGINE=InnoDB;
16 CREATE TEMPORARY TABLE temp_non_trans_t1 (c1 INT) ENGINE=MyISAM;
17 # Error cases ER_GTID_UNSAFE_BINLOG_SPLITTABLE_STATEMENT_AND_ASSIGNED_GTID
18 SET GTID_NEXT= '11111111-1111-1111-1111-111111111111:1';
19 ## Expecting error ER_GTID_UNSAFE_BINLOG_SPLITTABLE_STATEMENT_AND_ASSIGNED_GTID after the statement
20 DROP TABLE trans_t1, non_trans_t1, temp_trans_t1;
21 ERROR HY000: Cannot execute statement because it needs to be written to the binary log as multiple statements, and this is not allowed when @@SESSION.GTID_NEXT == 'UUID:NUMBER'.
22 ROLLBACK;
23 SET GTID_NEXT= '11111111-1111-1111-1111-111111111111:1';
24 ## Expecting error ER_GTID_UNSAFE_BINLOG_SPLITTABLE_STATEMENT_AND_ASSIGNED_GTID after the statement
25 DROP TABLE trans_t1, non_trans_t1, temp_trans_t1, temp_non_trans_t1;
26 ERROR HY000: Cannot execute statement because it needs to be written to the binary log as multiple statements, and this is not allowed when @@SESSION.GTID_NEXT == 'UUID:NUMBER'.
27 ROLLBACK;
28 SET GTID_NEXT= '11111111-1111-1111-1111-111111111111:1';
29 ## Expecting error ER_GTID_UNSAFE_BINLOG_SPLITTABLE_STATEMENT_AND_ASSIGNED_GTID after the statement
30 DROP TABLE trans_t1, non_trans_t1, temp_trans_t1, temp_non_trans_t1, non_existent;
31 ERROR HY000: Cannot execute statement because it needs to be written to the binary log as multiple statements, and this is not allowed when @@SESSION.GTID_NEXT == 'UUID:NUMBER'.
32 ROLLBACK;
33 SET GTID_NEXT= '11111111-1111-1111-1111-111111111111:1';
34 ## Expecting error ER_GTID_UNSAFE_BINLOG_SPLITTABLE_STATEMENT_AND_ASSIGNED_GTID after the statement
35 DROP TABLE trans_t1, non_trans_t1, temp_trans_t1, non_existent;
36 ERROR HY000: Cannot execute statement because it needs to be written to the binary log as multiple statements, and this is not allowed when @@SESSION.GTID_NEXT == 'UUID:NUMBER'.
37 ROLLBACK;
38 SET GTID_NEXT= '11111111-1111-1111-1111-111111111111:1';
39 ## Expecting error ER_GTID_UNSAFE_BINLOG_SPLITTABLE_STATEMENT_AND_ASSIGNED_GTID after the statement
40 DROP TABLE trans_t1, non_trans_t1, temp_non_trans_t1;
41 ERROR HY000: Cannot execute statement because it needs to be written to the binary log as multiple statements, and this is not allowed when @@SESSION.GTID_NEXT == 'UUID:NUMBER'.
42 ROLLBACK;
43 SET GTID_NEXT= '11111111-1111-1111-1111-111111111111:1';
44 ## Expecting error ER_GTID_UNSAFE_BINLOG_SPLITTABLE_STATEMENT_AND_ASSIGNED_GTID after the statement
45 DROP TABLE trans_t1, non_trans_t1, temp_non_trans_t1, non_existent;
46 ERROR HY000: Cannot execute statement because it needs to be written to the binary log as multiple statements, and this is not allowed when @@SESSION.GTID_NEXT == 'UUID:NUMBER'.
47 ROLLBACK;
48 SET GTID_NEXT= '11111111-1111-1111-1111-111111111111:1';
49 ## Expecting error ER_GTID_UNSAFE_BINLOG_SPLITTABLE_STATEMENT_AND_ASSIGNED_GTID after the statement
50 DROP TABLE trans_t1, temp_trans_t1;
51 ERROR HY000: Cannot execute statement because it needs to be written to the binary log as multiple statements, and this is not allowed when @@SESSION.GTID_NEXT == 'UUID:NUMBER'.
52 ROLLBACK;
53 SET GTID_NEXT= '11111111-1111-1111-1111-111111111111:1';
54 ## Expecting error ER_GTID_UNSAFE_BINLOG_SPLITTABLE_STATEMENT_AND_ASSIGNED_GTID after the statement
55 DROP TABLE trans_t1, temp_trans_t1, temp_non_trans_t1;
56 ERROR HY000: Cannot execute statement because it needs to be written to the binary log as multiple statements, and this is not allowed when @@SESSION.GTID_NEXT == 'UUID:NUMBER'.
57 ROLLBACK;
58 SET GTID_NEXT= '11111111-1111-1111-1111-111111111111:1';
59 ## Expecting error ER_GTID_UNSAFE_BINLOG_SPLITTABLE_STATEMENT_AND_ASSIGNED_GTID after the statement
60 DROP TABLE trans_t1, temp_trans_t1, temp_non_trans_t1, non_existent;
61 ERROR HY000: Cannot execute statement because it needs to be written to the binary log as multiple statements, and this is not allowed when @@SESSION.GTID_NEXT == 'UUID:NUMBER'.
62 ROLLBACK;
63 SET GTID_NEXT= '11111111-1111-1111-1111-111111111111:1';
64 ## Expecting error ER_GTID_UNSAFE_BINLOG_SPLITTABLE_STATEMENT_AND_ASSIGNED_GTID after the statement
65 DROP TABLE trans_t1, temp_trans_t1, non_existent;
66 ERROR HY000: Cannot execute statement because it needs to be written to the binary log as multiple statements, and this is not allowed when @@SESSION.GTID_NEXT == 'UUID:NUMBER'.
67 ROLLBACK;
68 SET GTID_NEXT= '11111111-1111-1111-1111-111111111111:1';
69 ## Expecting error ER_GTID_UNSAFE_BINLOG_SPLITTABLE_STATEMENT_AND_ASSIGNED_GTID after the statement
70 DROP TABLE trans_t1, temp_non_trans_t1;
71 ERROR HY000: Cannot execute statement because it needs to be written to the binary log as multiple statements, and this is not allowed when @@SESSION.GTID_NEXT == 'UUID:NUMBER'.
72 ROLLBACK;
73 SET GTID_NEXT= '11111111-1111-1111-1111-111111111111:1';
74 ## Expecting error ER_GTID_UNSAFE_BINLOG_SPLITTABLE_STATEMENT_AND_ASSIGNED_GTID after the statement
75 DROP TABLE trans_t1, temp_non_trans_t1, non_existent;
76 ERROR HY000: Cannot execute statement because it needs to be written to the binary log as multiple statements, and this is not allowed when @@SESSION.GTID_NEXT == 'UUID:NUMBER'.
77 ROLLBACK;
78 SET GTID_NEXT= '11111111-1111-1111-1111-111111111111:1';
79 ## Expecting error ER_GTID_UNSAFE_BINLOG_SPLITTABLE_STATEMENT_AND_ASSIGNED_GTID after the statement
80 DROP TABLE non_trans_t1, temp_trans_t1;
81 ERROR HY000: Cannot execute statement because it needs to be written to the binary log as multiple statements, and this is not allowed when @@SESSION.GTID_NEXT == 'UUID:NUMBER'.
82 ROLLBACK;
83 SET GTID_NEXT= '11111111-1111-1111-1111-111111111111:1';
84 ## Expecting error ER_GTID_UNSAFE_BINLOG_SPLITTABLE_STATEMENT_AND_ASSIGNED_GTID after the statement
85 DROP TABLE non_trans_t1, temp_trans_t1, temp_non_trans_t1;
86 ERROR HY000: Cannot execute statement because it needs to be written to the binary log as multiple statements, and this is not allowed when @@SESSION.GTID_NEXT == 'UUID:NUMBER'.
87 ROLLBACK;
88 SET GTID_NEXT= '11111111-1111-1111-1111-111111111111:1';
89 ## Expecting error ER_GTID_UNSAFE_BINLOG_SPLITTABLE_STATEMENT_AND_ASSIGNED_GTID after the statement
90 DROP TABLE non_trans_t1, temp_trans_t1, temp_non_trans_t1, non_existent;
91 ERROR HY000: Cannot execute statement because it needs to be written to the binary log as multiple statements, and this is not allowed when @@SESSION.GTID_NEXT == 'UUID:NUMBER'.
92 ROLLBACK;
93 SET GTID_NEXT= '11111111-1111-1111-1111-111111111111:1';
94 ## Expecting error ER_GTID_UNSAFE_BINLOG_SPLITTABLE_STATEMENT_AND_ASSIGNED_GTID after the statement
95 DROP TABLE non_trans_t1, temp_trans_t1, non_existent;
96 ERROR HY000: Cannot execute statement because it needs to be written to the binary log as multiple statements, and this is not allowed when @@SESSION.GTID_NEXT == 'UUID:NUMBER'.
97 ROLLBACK;
98 SET GTID_NEXT= '11111111-1111-1111-1111-111111111111:1';
99 ## Expecting error ER_GTID_UNSAFE_BINLOG_SPLITTABLE_STATEMENT_AND_ASSIGNED_GTID after the statement
100 DROP TABLE non_trans_t1, temp_non_trans_t1;
101 ERROR HY000: Cannot execute statement because it needs to be written to the binary log as multiple statements, and this is not allowed when @@SESSION.GTID_NEXT == 'UUID:NUMBER'.
102 ROLLBACK;
103 SET GTID_NEXT= '11111111-1111-1111-1111-111111111111:1';
104 ## Expecting error ER_GTID_UNSAFE_BINLOG_SPLITTABLE_STATEMENT_AND_ASSIGNED_GTID after the statement
105 DROP TABLE non_trans_t1, temp_non_trans_t1, non_existent;
106 ERROR HY000: Cannot execute statement because it needs to be written to the binary log as multiple statements, and this is not allowed when @@SESSION.GTID_NEXT == 'UUID:NUMBER'.
107 ROLLBACK;
108 SET GTID_NEXT= '11111111-1111-1111-1111-111111111111:1';
109 ## Expecting error ER_GTID_UNSAFE_BINLOG_SPLITTABLE_STATEMENT_AND_ASSIGNED_GTID after the statement
110 DROP TABLE temp_trans_t1, temp_non_trans_t1;
111 ERROR HY000: Cannot execute statement because it needs to be written to the binary log as multiple statements, and this is not allowed when @@SESSION.GTID_NEXT == 'UUID:NUMBER'.
112 ROLLBACK;
113 SET GTID_NEXT= '11111111-1111-1111-1111-111111111111:1';
114 ## Expecting error ER_GTID_UNSAFE_BINLOG_SPLITTABLE_STATEMENT_AND_ASSIGNED_GTID after the statement
115 DROP TABLE temp_trans_t1, temp_non_trans_t1, non_existent;
116 ERROR HY000: Cannot execute statement because it needs to be written to the binary log as multiple statements, and this is not allowed when @@SESSION.GTID_NEXT == 'UUID:NUMBER'.
117 ROLLBACK;
118 SET GTID_NEXT= '11111111-1111-1111-1111-111111111111:1';
119 ## Expecting error ER_GTID_UNSAFE_BINLOG_SPLITTABLE_STATEMENT_AND_ASSIGNED_GTID after the statement
120 DROP TABLE temp_trans_t1, non_existent;
121 ERROR HY000: Cannot execute statement because it needs to be written to the binary log as multiple statements, and this is not allowed when @@SESSION.GTID_NEXT == 'UUID:NUMBER'.
122 ROLLBACK;
123 SET GTID_NEXT= '11111111-1111-1111-1111-111111111111:1';
124 ## Expecting error ER_GTID_UNSAFE_BINLOG_SPLITTABLE_STATEMENT_AND_ASSIGNED_GTID after the statement
125 DROP TABLE temp_non_trans_t1, non_existent;
126 ERROR HY000: Cannot execute statement because it needs to be written to the binary log as multiple statements, and this is not allowed when @@SESSION.GTID_NEXT == 'UUID:NUMBER'.
127 ROLLBACK;
128 # Error cases ER_BAD_TABLE_ERROR.
129 SET GTID_NEXT= '11111111-1111-1111-1111-111111111111:1';
130 ## Expecting error ER_BAD_TABLE_ERROR after the statement
131 DROP TABLE trans_t1, non_trans_t1, non_existent;
132 ERROR 42S02: Unknown table 'test.non_existent'
133 ROLLBACK;
134 SET GTID_NEXT= '11111111-1111-1111-1111-111111111111:2';
135 ## Expecting error ER_BAD_TABLE_ERROR after the statement
136 DROP TABLE trans_t1, non_existent;
137 ERROR 42S02: Unknown table 'test.non_existent'
138 ROLLBACK;
139 SET GTID_NEXT= '11111111-1111-1111-1111-111111111111:3';
140 ## Expecting error ER_BAD_TABLE_ERROR after the statement
141 DROP TABLE non_trans_t1, non_existent;
142 ERROR 42S02: Unknown table 'test.non_existent'
143 ROLLBACK;
144 # Non-error cases
145 SET GTID_NEXT= '11111111-1111-1111-1111-111111111111:4';
146 DROP TABLE trans_t1, non_trans_t1;
147 SET GTID_NEXT= AUTOMATIC;
148 CREATE TABLE trans_t1 (c1 INT) ENGINE=InnoDB;
149 #
150 # Second part
151 #
152 CREATE TEMPORARY TABLE temp_ignore (c1 INT) ENGINE=MyISAM;
153 DROP TEMPORARY TABLE IF EXISTS temp_ignore, temp_non_trans_t1;
154 include/sync_slave_sql_with_master.inc
155 [connection master]
156 CREATE TEMPORARY TABLE temp_ignore (c1 INT) ENGINE=InnoDB;
157 DROP TEMPORARY TABLE IF EXISTS temp_ignore, temp_trans_t1;
158 include/sync_slave_sql_with_master.inc
159 #
160 # Third part
161 #
162 [connection master]
163 SET SESSION sql_log_bin= 0;
164 call mtr.add_suppression("Error: table .* does not exist in the InnoDB internal");
165 SET SESSION sql_log_bin= 1;
166 CREATE DATABASE test2;
167 CREATE DATABASE test3;
168 use test;
169 CREATE TEMPORARY TABLE temp_trans_t1 (c1 INT) ENGINE=InnoDB;
170 CREATE TEMPORARY TABLE temp_non_trans_t1 (c1 INT) ENGINE=MyISAM;
171 USE test2;
172 CREATE TEMPORARY TABLE temp_trans_t1 (c1 INT) ENGINE=InnoDB;
173 USE test3;
174 CREATE TEMPORARY TABLE temp_trans_t1 (c1 INT) ENGINE=InnoDB;
175 CREATE TEMPORARY TABLE temp_trans_t2 (c1 INT) ENGINE=InnoDB;
176 [connection master1]
177 use test;
178 CREATE TEMPORARY TABLE temp_trans_t1 (c1 INT) ENGINE=InnoDB;
179 CREATE TEMPORARY TABLE temp_non_trans_t1 (c1 INT) ENGINE=MyISAM;
180 USE test2;
181 CREATE TEMPORARY TABLE temp_non_trans_t1 (c1 INT) ENGINE=MyISAM;
182 USE test3;
183 CREATE TEMPORARY TABLE temp_non_trans_t1 (c1 INT) ENGINE=MyISAM;
184 CREATE TEMPORARY TABLE temp_non_trans_t2 (c1 INT) ENGINE=MyISAM;
185 include/sync_slave_sql_with_master.inc
186 include/stop_slave_io.inc
187 include/rpl_stop_server.inc [server_number=1]
188 include/rpl_start_server.inc [server_number=1]
189 [connection slave]
190 include/start_slave_io.inc
191 [connection master]
192 include/sync_slave_io_with_master.inc
193 include/assert.inc [Replica_open_temp_tables should be 0]
194 [connection master]
195 USE test;
196 DROP TABLE trans_t1;
197 DROP DATABASE test2;
198 DROP DATABASE test3;
199 include/rpl_end.inc