Debian Codegraph @

mysql-test/suite/rpl_ndb/r/rpl_ndb_mixed_implicit_commit_binlog.result

raw
1 include/master-slave.inc
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 [connection master]
6 #########################################################################
7 # CONFIGURATION
8 #########################################################################
9 CREATE TABLE tt_1 (ddl_case INT, PRIMARY KEY(ddl_case)) ENGINE = NDB;
10 CREATE TABLE tt_2 (ddl_case INT, PRIMARY KEY(ddl_case)) ENGINE = NDB;
11 CREATE TABLE nt_1 (ddl_case INT, PRIMARY KEY(ddl_case)) ENGINE = MyIsam;
12 INSERT INTO tt_1(ddl_case) VALUES(0);
13 INSERT INTO tt_2(ddl_case) VALUES(0);
14 #########################################################################
15 # CHECK IMPLICT COMMIT
16 #########################################################################
17 SET AUTOCOMMIT= 0;
18 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
19 INSERT INTO tt_1(ddl_case) VALUES (41);
20 LOAD INDEX INTO CACHE nt_1 IGNORE LEAVES;
21 Table Op Msg_type Msg_text
22 test.nt_1 preload_keys status OK
23 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
24 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
25 Log_name Pos Event_type Server_id End_log_pos Info
26 master-bin.000001 # Query # # BEGIN
27 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
28 master-bin.000001 # Table_map # # table_id: # (test.tt_2)
29 master-bin.000001 # Table_map # # table_id: # (mysql.ndb_apply_status)
30 master-bin.000001 # Write_rows # # table_id: #
31 master-bin.000001 # Write_rows # # table_id: #
32 master-bin.000001 # Write_rows # # table_id: #
33 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
34 master-bin.000001 # Query # # COMMIT
35 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
36
37 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
38 INSERT INTO tt_1(ddl_case) VALUES (40);
39 LOAD INDEX INTO CACHE tt_1, tt_2 IGNORE LEAVES;
40 Table Op Msg_type Msg_text
41 test.tt_1 preload_keys note The storage engine for the table doesn't support preload_keys
42 test.tt_2 preload_keys note The storage engine for the table doesn't support preload_keys
43 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
44 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
45 Log_name Pos Event_type Server_id End_log_pos Info
46 master-bin.000001 # Query # # BEGIN
47 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
48 master-bin.000001 # Table_map # # table_id: # (mysql.ndb_apply_status)
49 master-bin.000001 # Write_rows # # table_id: #
50 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
51 master-bin.000001 # Query # # COMMIT
52 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
53
54 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
55 INSERT INTO tt_1(ddl_case) VALUES (39);
56 ANALYZE TABLE nt_1;
57 Table Op Msg_type Msg_text
58 test.nt_1 analyze status Table is already up to date
59 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
60 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
61 Log_name Pos Event_type Server_id End_log_pos Info
62 master-bin.000001 # Query # # use `test`; ANALYZE TABLE nt_1
63 master-bin.000001 # Query # # BEGIN
64 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
65 master-bin.000001 # Table_map # # table_id: # (mysql.ndb_apply_status)
66 master-bin.000001 # Write_rows # # table_id: #
67 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
68 master-bin.000001 # Query # # COMMIT
69 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
70
71 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
72 INSERT INTO tt_1(ddl_case) VALUES (38);
73 CHECK TABLE nt_1;
74 Table Op Msg_type Msg_text
75 test.nt_1 check status OK
76 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
77 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
78 Log_name Pos Event_type Server_id End_log_pos Info
79 master-bin.000001 # Query # # BEGIN
80 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
81 master-bin.000001 # Table_map # # table_id: # (mysql.ndb_apply_status)
82 master-bin.000001 # Write_rows # # table_id: #
83 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
84 master-bin.000001 # Query # # COMMIT
85 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
86
87 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
88 INSERT INTO tt_1(ddl_case) VALUES (37);
89 OPTIMIZE TABLE nt_1;
90 Table Op Msg_type Msg_text
91 test.nt_1 optimize status Table is already up to date
92 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
93 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
94 Log_name Pos Event_type Server_id End_log_pos Info
95 master-bin.000001 # Query # # use `test`; OPTIMIZE TABLE nt_1
96 master-bin.000001 # Query # # BEGIN
97 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
98 master-bin.000001 # Table_map # # table_id: # (mysql.ndb_apply_status)
99 master-bin.000001 # Write_rows # # table_id: #
100 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
101 master-bin.000001 # Query # # COMMIT
102 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
103
104 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
105 INSERT INTO tt_1(ddl_case) VALUES (36);
106 REPAIR TABLE nt_1;
107 Table Op Msg_type Msg_text
108 test.nt_1 repair status OK
109 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
110 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
111 Log_name Pos Event_type Server_id End_log_pos Info
112 master-bin.000001 # Query # # use `test`; REPAIR TABLE nt_1
113 master-bin.000001 # Query # # BEGIN
114 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
115 master-bin.000001 # Table_map # # table_id: # (mysql.ndb_apply_status)
116 master-bin.000001 # Write_rows # # table_id: #
117 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
118 master-bin.000001 # Query # # COMMIT
119 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
120
121 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
122 INSERT INTO tt_1(ddl_case) VALUES (35);
123 LOCK TABLES tt_1 WRITE;
124 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
125 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
126 Log_name Pos Event_type Server_id End_log_pos Info
127 master-bin.000001 # Query # # BEGIN
128 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
129 master-bin.000001 # Table_map # # table_id: # (mysql.ndb_apply_status)
130 master-bin.000001 # Write_rows # # table_id: #
131 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
132 master-bin.000001 # Query # # COMMIT
133 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
134
135 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
136 INSERT INTO tt_1(ddl_case) VALUES (34);
137 UNLOCK TABLES;
138 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
139 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
140 Log_name Pos Event_type Server_id End_log_pos Info
141 master-bin.000001 # Query # # BEGIN
142 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
143 master-bin.000001 # Table_map # # table_id: # (mysql.ndb_apply_status)
144 master-bin.000001 # Write_rows # # table_id: #
145 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
146 master-bin.000001 # Query # # COMMIT
147 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
148
149 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
150 INSERT INTO tt_1(ddl_case) VALUES (33);
151 CREATE USER 'user'@'localhost';
152 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
153 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
154 Log_name Pos Event_type Server_id End_log_pos Info
155 master-bin.000001 # Query # # use `test`; CREATE USER 'user'@'localhost'
156 master-bin.000001 # Query # # BEGIN
157 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
158 master-bin.000001 # Table_map # # table_id: # (mysql.ndb_apply_status)
159 master-bin.000001 # Write_rows # # table_id: #
160 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
161 master-bin.000001 # Query # # COMMIT
162 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
163
164 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
165 INSERT INTO tt_1(ddl_case) VALUES (32);
166 GRANT ALL ON *.* TO 'user'@'localhost';
167 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
168 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
169 Log_name Pos Event_type Server_id End_log_pos Info
170 master-bin.000001 # Query # # use `test`; GRANT ALL ON *.* TO 'user'@'localhost'
171 master-bin.000001 # Query # # BEGIN
172 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
173 master-bin.000001 # Table_map # # table_id: # (mysql.ndb_apply_status)
174 master-bin.000001 # Write_rows # # table_id: #
175 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
176 master-bin.000001 # Query # # COMMIT
177 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
178
179 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
180 INSERT INTO tt_1(ddl_case) VALUES (31);
181 SET PASSWORD FOR 'user'@'localhost' = PASSWORD('newpass');
182 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
183 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
184 Log_name Pos Event_type Server_id End_log_pos Info
185 master-bin.000001 # Query # # use `test`; SET PASSWORD FOR 'user'@'localhost'='*D8DECEC305209EEFEC43008E1D420E1AA06B19E0'
186 master-bin.000001 # Query # # BEGIN
187 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
188 master-bin.000001 # Table_map # # table_id: # (mysql.ndb_apply_status)
189 master-bin.000001 # Write_rows # # table_id: #
190 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
191 master-bin.000001 # Query # # COMMIT
192 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
193
194 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
195 INSERT INTO tt_1(ddl_case) VALUES (30);
196 REVOKE ALL PRIVILEGES, GRANT OPTION FROM 'user'@'localhost';
197 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
198 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
199 Log_name Pos Event_type Server_id End_log_pos Info
200 master-bin.000001 # Query # # use `test`; REVOKE ALL PRIVILEGES, GRANT OPTION FROM 'user'@'localhost'
201 master-bin.000001 # Query # # BEGIN
202 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
203 master-bin.000001 # Table_map # # table_id: # (mysql.ndb_apply_status)
204 master-bin.000001 # Write_rows # # table_id: #
205 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
206 master-bin.000001 # Query # # COMMIT
207 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
208
209 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
210 INSERT INTO tt_1(ddl_case) VALUES (29);
211 RENAME USER 'user'@'localhost' TO 'user_new'@'localhost';
212 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
213 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
214 Log_name Pos Event_type Server_id End_log_pos Info
215 master-bin.000001 # Query # # use `test`; RENAME USER 'user'@'localhost' TO 'user_new'@'localhost'
216 master-bin.000001 # Query # # BEGIN
217 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
218 master-bin.000001 # Table_map # # table_id: # (mysql.ndb_apply_status)
219 master-bin.000001 # Write_rows # # table_id: #
220 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
221 master-bin.000001 # Query # # COMMIT
222 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
223
224 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
225 INSERT INTO tt_1(ddl_case) VALUES (28);
226 DROP USER 'user_new'@'localhost';
227 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
228 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
229 Log_name Pos Event_type Server_id End_log_pos Info
230 master-bin.000001 # Query # # use `test`; DROP USER 'user_new'@'localhost'
231 master-bin.000001 # Query # # BEGIN
232 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
233 master-bin.000001 # Table_map # # table_id: # (mysql.ndb_apply_status)
234 master-bin.000001 # Write_rows # # table_id: #
235 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
236 master-bin.000001 # Query # # COMMIT
237 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
238
239 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
240 INSERT INTO tt_1(ddl_case) VALUES (27);
241 CREATE EVENT evt ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 1 HOUR DO SELECT * FROM tt_1;
242 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
243 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
244 Log_name Pos Event_type Server_id End_log_pos Info
245 master-bin.000001 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` EVENT evt ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 1 HOUR DO SELECT * FROM tt_1
246 master-bin.000001 # Query # # BEGIN
247 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
248 master-bin.000001 # Table_map # # table_id: # (mysql.ndb_apply_status)
249 master-bin.000001 # Write_rows # # table_id: #
250 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
251 master-bin.000001 # Query # # COMMIT
252 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
253
254 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
255 INSERT INTO tt_1(ddl_case) VALUES (26);
256 ALTER EVENT evt COMMENT 'evt';
257 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
258 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
259 Log_name Pos Event_type Server_id End_log_pos Info
260 master-bin.000001 # Query # # use `test`; ALTER EVENT evt COMMENT 'evt'
261 master-bin.000001 # Query # # BEGIN
262 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
263 master-bin.000001 # Table_map # # table_id: # (mysql.ndb_apply_status)
264 master-bin.000001 # Write_rows # # table_id: #
265 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
266 master-bin.000001 # Query # # COMMIT
267 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
268
269 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
270 INSERT INTO tt_1(ddl_case) VALUES (25);
271 DROP EVENT evt;
272 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
273 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
274 Log_name Pos Event_type Server_id End_log_pos Info
275 master-bin.000001 # Query # # use `test`; DROP EVENT evt
276 master-bin.000001 # Query # # BEGIN
277 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
278 master-bin.000001 # Table_map # # table_id: # (mysql.ndb_apply_status)
279 master-bin.000001 # Write_rows # # table_id: #
280 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
281 master-bin.000001 # Query # # COMMIT
282 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
283
284 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
285 INSERT INTO tt_1(ddl_case) VALUES (24);
286 CREATE TRIGGER tr AFTER INSERT ON tt_1 FOR EACH ROW UPDATE tt_2 SET ddl_case = ddl_case WHERE ddl_case= NEW.ddl_case;
287 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
288 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
289 Log_name Pos Event_type Server_id End_log_pos Info
290 master-bin.000001 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` TRIGGER tr AFTER INSERT ON tt_1 FOR EACH ROW UPDATE tt_2 SET ddl_case = ddl_case WHERE ddl_case= NEW.ddl_case
291 master-bin.000001 # Query # # BEGIN
292 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
293 master-bin.000001 # Table_map # # table_id: # (mysql.ndb_apply_status)
294 master-bin.000001 # Write_rows # # table_id: #
295 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
296 master-bin.000001 # Query # # COMMIT
297 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
298
299 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
300 INSERT INTO tt_1(ddl_case) VALUES (23);
301 DROP TRIGGER tr;
302 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
303 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
304 Log_name Pos Event_type Server_id End_log_pos Info
305 master-bin.000001 # Query # # use `test`; DROP TRIGGER tr
306 master-bin.000001 # Query # # BEGIN
307 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
308 master-bin.000001 # Table_map # # table_id: # (mysql.ndb_apply_status)
309 master-bin.000001 # Write_rows # # table_id: #
310 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
311 master-bin.000001 # Query # # COMMIT
312 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
313
314 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
315 INSERT INTO tt_1(ddl_case) VALUES (22);
316 CREATE FUNCTION fc () RETURNS VARCHAR(64) RETURN "fc";
317 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
318 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
319 Log_name Pos Event_type Server_id End_log_pos Info
320 master-bin.000001 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` FUNCTION `fc`() RETURNS varchar(64) CHARSET latin1
321 RETURN "fc"
322 master-bin.000001 # Query # # BEGIN
323 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
324 master-bin.000001 # Table_map # # table_id: # (mysql.ndb_apply_status)
325 master-bin.000001 # Write_rows # # table_id: #
326 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
327 master-bin.000001 # Query # # COMMIT
328 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
329
330 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
331 INSERT INTO tt_1(ddl_case) VALUES (21);
332 ALTER FUNCTION fc COMMENT 'fc';
333 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
334 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
335 Log_name Pos Event_type Server_id End_log_pos Info
336 master-bin.000001 # Query # # use `test`; ALTER FUNCTION fc COMMENT 'fc'
337 master-bin.000001 # Query # # BEGIN
338 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
339 master-bin.000001 # Table_map # # table_id: # (mysql.ndb_apply_status)
340 master-bin.000001 # Write_rows # # table_id: #
341 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
342 master-bin.000001 # Query # # COMMIT
343 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
344
345 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
346 INSERT INTO tt_1(ddl_case) VALUES (20);
347 DROP FUNCTION fc;
348 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
349 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
350 Log_name Pos Event_type Server_id End_log_pos Info
351 master-bin.000001 # Query # # use `test`; DROP FUNCTION fc
352 master-bin.000001 # Query # # BEGIN
353 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
354 master-bin.000001 # Table_map # # table_id: # (mysql.ndb_apply_status)
355 master-bin.000001 # Write_rows # # table_id: #
356 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
357 master-bin.000001 # Query # # COMMIT
358 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
359
360 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
361 INSERT INTO tt_1(ddl_case) VALUES (19);
362 CREATE PROCEDURE pc () UPDATE tt_2 SET ddl_case = ddl_case WHERE ddl_case= NEW.ddl_case;
363 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
364 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
365 Log_name Pos Event_type Server_id End_log_pos Info
366 master-bin.000001 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` PROCEDURE `pc`()
367 UPDATE tt_2 SET ddl_case = ddl_case WHERE ddl_case= NEW.ddl_case
368 master-bin.000001 # Query # # BEGIN
369 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
370 master-bin.000001 # Table_map # # table_id: # (mysql.ndb_apply_status)
371 master-bin.000001 # Write_rows # # table_id: #
372 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
373 master-bin.000001 # Query # # COMMIT
374 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
375
376 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
377 INSERT INTO tt_1(ddl_case) VALUES (18);
378 ALTER PROCEDURE pc COMMENT 'pc';
379 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
380 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
381 Log_name Pos Event_type Server_id End_log_pos Info
382 master-bin.000001 # Query # # use `test`; ALTER PROCEDURE pc COMMENT 'pc'
383 master-bin.000001 # Query # # BEGIN
384 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
385 master-bin.000001 # Table_map # # table_id: # (mysql.ndb_apply_status)
386 master-bin.000001 # Write_rows # # table_id: #
387 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
388 master-bin.000001 # Query # # COMMIT
389 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
390
391 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
392 INSERT INTO tt_1(ddl_case) VALUES (17);
393 DROP PROCEDURE pc;
394 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
395 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
396 Log_name Pos Event_type Server_id End_log_pos Info
397 master-bin.000001 # Query # # use `test`; DROP PROCEDURE pc
398 master-bin.000001 # Query # # BEGIN
399 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
400 master-bin.000001 # Table_map # # table_id: # (mysql.ndb_apply_status)
401 master-bin.000001 # Write_rows # # table_id: #
402 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
403 master-bin.000001 # Query # # COMMIT
404 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
405
406 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
407 INSERT INTO tt_1(ddl_case) VALUES (16);
408 CREATE VIEW v AS SELECT * FROM tt_1;
409 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
410 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
411 Log_name Pos Event_type Server_id End_log_pos Info
412 master-bin.000001 # Query # # use `test`; CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v` AS SELECT * FROM tt_1
413 master-bin.000001 # Query # # BEGIN
414 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
415 master-bin.000001 # Table_map # # table_id: # (mysql.ndb_apply_status)
416 master-bin.000001 # Write_rows # # table_id: #
417 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
418 master-bin.000001 # Query # # COMMIT
419 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
420
421 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
422 INSERT INTO tt_1(ddl_case) VALUES (15);
423 ALTER VIEW v AS SELECT * FROM tt_1;
424 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
425 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
426 Log_name Pos Event_type Server_id End_log_pos Info
427 master-bin.000001 # Query # # use `test`; ALTER ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v` AS SELECT * FROM tt_1
428 master-bin.000001 # Query # # BEGIN
429 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
430 master-bin.000001 # Table_map # # table_id: # (mysql.ndb_apply_status)
431 master-bin.000001 # Write_rows # # table_id: #
432 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
433 master-bin.000001 # Query # # COMMIT
434 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
435
436 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
437 INSERT INTO tt_1(ddl_case) VALUES (14);
438 DROP VIEW v;
439 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
440 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
441 Log_name Pos Event_type Server_id End_log_pos Info
442 master-bin.000001 # Query # # use `test`; DROP VIEW v
443 master-bin.000001 # Query # # BEGIN
444 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
445 master-bin.000001 # Table_map # # table_id: # (mysql.ndb_apply_status)
446 master-bin.000001 # Write_rows # # table_id: #
447 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
448 master-bin.000001 # Query # # COMMIT
449 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
450
451 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
452 INSERT INTO tt_1(ddl_case) VALUES (13);
453 CREATE INDEX ix ON tt_1(ddl_case);
454 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
455 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
456 Log_name Pos Event_type Server_id End_log_pos Info
457 master-bin.000001 # Query # # BEGIN
458 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
459 master-bin.000001 # Table_map # # table_id: # (mysql.ndb_apply_status)
460 master-bin.000001 # Write_rows # # table_id: #
461 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
462 master-bin.000001 # Query # # COMMIT
463 master-bin.000001 # Query # # use `test`; CREATE INDEX ix ON tt_1(ddl_case)
464 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
465
466 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
467 INSERT INTO tt_1(ddl_case) VALUES (12);
468 DROP INDEX ix ON tt_1;
469 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
470 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
471 Log_name Pos Event_type Server_id End_log_pos Info
472 master-bin.000001 # Query # # BEGIN
473 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
474 master-bin.000001 # Table_map # # table_id: # (mysql.ndb_apply_status)
475 master-bin.000001 # Write_rows # # table_id: #
476 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
477 master-bin.000001 # Query # # COMMIT
478 master-bin.000001 # Query # # use `test`; DROP INDEX ix ON tt_1
479 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
480
481 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
482 INSERT INTO tt_1(ddl_case) VALUES (11);
483 CREATE TEMPORARY TABLE tt_xx (a int);
484 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
485 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
486 Log_name Pos Event_type Server_id End_log_pos Info
487 master-bin.000001 # Query # # BEGIN
488 master-bin.000001 # Query # # use `test`; CREATE TEMPORARY TABLE tt_xx (a int)
489 master-bin.000001 # Query # # COMMIT
490 master-bin.000001 # Query # # BEGIN
491 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
492 master-bin.000001 # Table_map # # table_id: # (mysql.ndb_apply_status)
493 master-bin.000001 # Write_rows # # table_id: #
494 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
495 master-bin.000001 # Query # # COMMIT
496 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
497
498 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
499 INSERT INTO tt_1(ddl_case) VALUES (10);
500 ALTER TABLE tt_xx ADD COLUMN (b int);
501 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
502 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
503 Log_name Pos Event_type Server_id End_log_pos Info
504 master-bin.000001 # Query # # BEGIN
505 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
506 master-bin.000001 # Table_map # # table_id: # (mysql.ndb_apply_status)
507 master-bin.000001 # Write_rows # # table_id: #
508 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
509 master-bin.000001 # Query # # COMMIT
510 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
511
512 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
513 INSERT INTO tt_1(ddl_case) VALUES (9);
514 ALTER TABLE tt_xx RENAME new_tt_xx;
515 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
516 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
517 Log_name Pos Event_type Server_id End_log_pos Info
518 master-bin.000001 # Query # # BEGIN
519 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
520 master-bin.000001 # Table_map # # table_id: # (mysql.ndb_apply_status)
521 master-bin.000001 # Write_rows # # table_id: #
522 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
523 master-bin.000001 # Query # # COMMIT
524 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
525
526 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
527 INSERT INTO tt_1(ddl_case) VALUES (8);
528 DROP TEMPORARY TABLE IF EXISTS new_tt_xx;
529 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
530 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
531 Log_name Pos Event_type Server_id End_log_pos Info
532 master-bin.000001 # Query # # BEGIN
533 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `new_tt_xx` /* generated by server */
534 master-bin.000001 # Query # # COMMIT
535 master-bin.000001 # Query # # BEGIN
536 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
537 master-bin.000001 # Table_map # # table_id: # (mysql.ndb_apply_status)
538 master-bin.000001 # Write_rows # # table_id: #
539 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
540 master-bin.000001 # Query # # COMMIT
541 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
542
543 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
544 INSERT INTO tt_1(ddl_case) VALUES (7);
545 CREATE TABLE tt_xx (a int);
546 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
547 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
548 Log_name Pos Event_type Server_id End_log_pos Info
549 master-bin.000001 # Query # # use `test`; CREATE TABLE tt_xx (a int)
550 master-bin.000001 # Query # # BEGIN
551 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
552 master-bin.000001 # Table_map # # table_id: # (mysql.ndb_apply_status)
553 master-bin.000001 # Write_rows # # table_id: #
554 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
555 master-bin.000001 # Query # # COMMIT
556 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
557
558 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
559 INSERT INTO tt_1(ddl_case) VALUES (6);
560 ALTER TABLE tt_xx ADD COLUMN (b int);
561 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
562 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
563 Log_name Pos Event_type Server_id End_log_pos Info
564 master-bin.000001 # Query # # use `test`; ALTER TABLE tt_xx ADD COLUMN (b int)
565 master-bin.000001 # Query # # BEGIN
566 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
567 master-bin.000001 # Table_map # # table_id: # (mysql.ndb_apply_status)
568 master-bin.000001 # Write_rows # # table_id: #
569 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
570 master-bin.000001 # Query # # COMMIT
571 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
572
573 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
574 INSERT INTO tt_1(ddl_case) VALUES (5);
575 RENAME TABLE tt_xx TO new_tt_xx;
576 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
577 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
578 Log_name Pos Event_type Server_id End_log_pos Info
579 master-bin.000001 # Query # # use `test`; RENAME TABLE tt_xx TO new_tt_xx
580 master-bin.000001 # Query # # BEGIN
581 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
582 master-bin.000001 # Table_map # # table_id: # (mysql.ndb_apply_status)
583 master-bin.000001 # Write_rows # # table_id: #
584 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
585 master-bin.000001 # Query # # COMMIT
586 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
587
588 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
589 INSERT INTO tt_1(ddl_case) VALUES (4);
590 TRUNCATE TABLE new_tt_xx;
591 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
592 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
593 Log_name Pos Event_type Server_id End_log_pos Info
594 master-bin.000001 # Query # # use `test`; TRUNCATE TABLE new_tt_xx
595 master-bin.000001 # Query # # BEGIN
596 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
597 master-bin.000001 # Table_map # # table_id: # (mysql.ndb_apply_status)
598 master-bin.000001 # Write_rows # # table_id: #
599 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
600 master-bin.000001 # Query # # COMMIT
601 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
602
603 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
604 INSERT INTO tt_1(ddl_case) VALUES (3);
605 DROP TABLE IF EXISTS tt_xx, new_tt_xx;
606 Warnings:
607 Note 1051 Unknown table 'tt_xx'
608 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
609 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
610 Log_name Pos Event_type Server_id End_log_pos Info
611 master-bin.000001 # Query # # use `test`; DROP TABLE IF EXISTS `tt_xx`,`new_tt_xx` /* generated by server */
612 master-bin.000001 # Query # # BEGIN
613 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
614 master-bin.000001 # Table_map # # table_id: # (mysql.ndb_apply_status)
615 master-bin.000001 # Write_rows # # table_id: #
616 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
617 master-bin.000001 # Query # # COMMIT
618 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
619
620 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
621 INSERT INTO tt_1(ddl_case) VALUES (2);
622 CREATE DATABASE db;
623 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
624 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
625 Log_name Pos Event_type Server_id End_log_pos Info
626 master-bin.000001 # Query # # BEGIN
627 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
628 master-bin.000001 # Table_map # # table_id: # (mysql.ndb_apply_status)
629 master-bin.000001 # Write_rows # # table_id: #
630 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
631 master-bin.000001 # Query # # COMMIT
632 master-bin.000001 # Query # # CREATE DATABASE db
633 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
634
635 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
636 INSERT INTO tt_1(ddl_case) VALUES (1);
637 DROP DATABASE IF EXISTS db;
638 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
639 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
640 Log_name Pos Event_type Server_id End_log_pos Info
641 master-bin.000001 # Query # # BEGIN
642 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
643 master-bin.000001 # Table_map # # table_id: # (mysql.ndb_apply_status)
644 master-bin.000001 # Write_rows # # table_id: #
645 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
646 master-bin.000001 # Query # # COMMIT
647 master-bin.000001 # Query # # DROP DATABASE IF EXISTS db
648 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
649
650 ###################################################################################
651 # CHECK CONSISTENCY
652 ###################################################################################
653 include/diff_tables.inc [master:tt_1,slave:tt_1]
654 ###################################################################################
655 # CLEAN
656 ###################################################################################
657 include/rpl_end.inc