Debian Codegraph @

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

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