Debian Codegraph @

mysql-test/suite/ndb_binlog/r/ndb_binlog_ddl_multi.result

raw
1 reset master;
2 reset master;
3 create database mysqltest;
4 use mysqltest;
5 create table t1 (a int primary key) engine=ndb;
6 create table t2 (a int primary key) engine=ndb;
7 include/show_binlog_events.inc
8 Log_name Pos Event_type Server_id End_log_pos Info
9 binlog.000001 # Query # # create database mysqltest
10 binlog.000001 # Query # # use `mysqltest`; create table t1 (a int primary key) engine=ndb
11 binlog.000001 # Query # # use `test`; create table t2 (a int primary key) engine=ndb
12 include/show_binlog_events.inc
13 Log_name Pos Event_type Server_id End_log_pos Info
14 binlog.000001 # Query # # create database mysqltest
15 binlog.000001 # Query # # use `mysqltest`; create table t1 (a int primary key) engine=ndb
16 binlog.000001 # Query # # use `test`; create table t2 (a int primary key) engine=ndb
17 reset master;
18 reset master;
19 alter table t2 add column (b int);
20 Warnings:
21 Warning 1478 Converted FIXED field 'b' to DYNAMIC to enable online ADD COLUMN
22 include/show_binlog_events.inc
23 Log_name Pos Event_type Server_id End_log_pos Info
24 binlog.000001 # Query # # use `test`; alter table t2 add column (b int)
25 reset master;
26 reset master;
27 ALTER DATABASE mysqltest CHARACTER SET latin1;
28 include/show_binlog_events.inc
29 Log_name Pos Event_type Server_id End_log_pos Info
30 binlog.000001 # Query # # ALTER DATABASE mysqltest CHARACTER SET latin1
31 drop table mysqltest.t1;
32 reset master;
33 reset master;
34 use test;
35 insert into t2 values (1,2);
36 drop database mysqltest;
37 create table t1 (a int primary key) engine=ndb;
38 include/show_binlog_events.inc
39 Log_name Pos Event_type Server_id End_log_pos Info
40 binlog.000001 # Query # # BEGIN
41 binlog.000001 # Table_map # # table_id: # (test.t2)
42 binlog.000001 # Table_map # # table_id: # (mysql.ndb_apply_status)
43 binlog.000001 # Write_rows # # table_id: #
44 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
45 binlog.000001 # Query # # COMMIT
46 binlog.000001 # Query # # drop database mysqltest
47 binlog.000001 # Query # # use `test`; create table t1 (a int primary key) engine=ndb
48 drop table t2;
49 reset master;
50 reset master;
51 CREATE LOGFILE GROUP lg1
52 ADD UNDOFILE 'undofile.dat'
53 INITIAL_SIZE 16M
54 UNDO_BUFFER_SIZE = 1M
55 ENGINE=NDB;
56 ALTER LOGFILE GROUP lg1
57 ADD UNDOFILE 'undofile02.dat'
58 INITIAL_SIZE = 4M
59 ENGINE=NDB;
60 CREATE TABLESPACE ts1
61 ADD DATAFILE 'datafile.dat'
62 USE LOGFILE GROUP lg1
63 INITIAL_SIZE 12M
64 ENGINE NDB;
65 ALTER TABLESPACE ts1
66 ADD DATAFILE 'datafile02.dat'
67 INITIAL_SIZE = 4M;
68 ALTER TABLESPACE ts1
69 DROP DATAFILE 'datafile.dat';
70 ALTER TABLESPACE ts1
71 DROP DATAFILE 'datafile02.dat';
72 DROP TABLESPACE ts1;
73 DROP LOGFILE GROUP lg1
74 ENGINE =NDB;
75 include/show_binlog_events.inc
76 Log_name Pos Event_type Server_id End_log_pos Info
77 binlog.000001 # Query # # CREATE LOGFILE GROUP lg1
78 ADD UNDOFILE 'undofile.dat'
79 INITIAL_SIZE 16M
80 UNDO_BUFFER_SIZE = 1M
81 ENGINE=NDB
82 binlog.000001 # Query # # ALTER LOGFILE GROUP lg1
83 ADD UNDOFILE 'undofile02.dat'
84 INITIAL_SIZE = 4M
85 ENGINE=NDB
86 binlog.000001 # Query # # CREATE TABLESPACE ts1
87 ADD DATAFILE 'datafile.dat'
88 USE LOGFILE GROUP lg1
89 INITIAL_SIZE 12M
90 ENGINE NDB
91 binlog.000001 # Query # # ALTER TABLESPACE ts1
92 ADD DATAFILE 'datafile02.dat'
93 INITIAL_SIZE = 4M
94 binlog.000001 # Query # # ALTER TABLESPACE ts1
95 DROP DATAFILE 'datafile.dat'
96 binlog.000001 # Query # # ALTER TABLESPACE ts1
97 DROP DATAFILE 'datafile02.dat'
98 binlog.000001 # Query # # DROP TABLESPACE ts1
99 binlog.000001 # Query # # DROP LOGFILE GROUP lg1
100 ENGINE =NDB
101 drop table t1;
102 reset master;
103 show tables;
104 Tables_in_test
105 reset master;
106 show tables;
107 Tables_in_test
108 create table t1 (a int key) engine=ndb;
109 create table t2 (a int key) engine=ndb;
110 create table t3 (a int key) engine=ndb;
111 rename table t3 to t4, t2 to t3, t1 to t2, t4 to t1;
112 include/show_binlog_events.inc
113 Log_name Pos Event_type Server_id End_log_pos Info
114 binlog.000001 # Query # # use `test`; create table t1 (a int key) engine=ndb
115 binlog.000001 # Query # # use `test`; create table t2 (a int key) engine=ndb
116 binlog.000001 # Query # # use `test`; create table t3 (a int key) engine=ndb
117 binlog.000001 # Query # # use `test`; rename table `test`.`t3` to `test`.`t4`
118 binlog.000001 # Query # # use `test`; rename table `test`.`t2` to `test`.`t3`
119 binlog.000001 # Query # # use `test`; rename table `test`.`t1` to `test`.`t2`
120 binlog.000001 # Query # # use `test`; rename table `test`.`t4` to `test`.`t1`
121 drop table t1;
122 drop table t2;
123 drop table t3;
124 reset master;
125 show tables;
126 Tables_in_test
127 reset master;
128 show tables;
129 Tables_in_test
130 create table t1 (a int key) engine=ndb;
131 insert into t1 values(1);
132 rename table t1 to t2;
133 insert into t2 values(2);
134 drop table t2;
135 include/show_binlog_events.inc
136 Log_name Pos Event_type Server_id End_log_pos Info
137 binlog.000001 # Query # # use `test`; create table t1 (a int key) engine=ndb
138 binlog.000001 # Query # # BEGIN
139 binlog.000001 # Table_map # # table_id: # (test.t1)
140 binlog.000001 # Table_map # # table_id: # (mysql.ndb_apply_status)
141 binlog.000001 # Write_rows # # table_id: #
142 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
143 binlog.000001 # Query # # COMMIT
144 binlog.000001 # Query # # use `test`; rename table `test`.`t1` to `test`.`t2`
145 binlog.000001 # Query # # BEGIN
146 binlog.000001 # Table_map # # table_id: # (test.t2)
147 binlog.000001 # Table_map # # table_id: # (mysql.ndb_apply_status)
148 binlog.000001 # Write_rows # # table_id: #
149 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
150 binlog.000001 # Query # # COMMIT
151 binlog.000001 # Query # # use `test`; DROP TABLE `t2` /* generated by server */
152 reset master;
153 reset master;
154 use test;
155 The relative order between DML and DDL statements below are
156 expected to follow the same order in binlog as shown below.
157 create database mysqltest;
158 create table t1 (a int primary key) engine=ndb;
159 insert into t1 values (1);
160 drop database mysqltest;
161 drop table t1;
162 create database mysqltest;
163 create table t1 (a int primary key) engine=ndb;
164 insert into t1 values (1);
165 drop database mysqltest;
166 drop table t1;
167 create database mysqltest;
168 create table t1 (a int primary key) engine=ndb;
169 insert into t1 values (1);
170 drop database mysqltest;
171 drop table t1;
172 create database mysqltest;
173 create table t1 (a int primary key) engine=ndb;
174 insert into t1 values (1);
175 drop database mysqltest;
176 drop table t1;
177 create database mysqltest;
178 create table t1 (a int primary key) engine=ndb;
179 insert into t1 values (1);
180 drop database mysqltest;
181 drop table t1;
182 create table dummy (dummyk int primary key) engine = ndb;
183 drop table dummy;
184 include/show_binlog_events.inc
185 Log_name Pos Event_type Server_id End_log_pos Info
186 binlog.000001 # Query # # create database mysqltest
187 binlog.000001 # Query # # use `test`; create table t1 (a int primary key) engine=ndb
188 binlog.000001 # Query # # BEGIN
189 binlog.000001 # Table_map # # table_id: # (test.t1)
190 binlog.000001 # Table_map # # table_id: # (mysql.ndb_apply_status)
191 binlog.000001 # Write_rows # # table_id: #
192 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
193 binlog.000001 # Query # # COMMIT
194 binlog.000001 # Query # # drop database mysqltest
195 binlog.000001 # Query # # use `test`; drop table `test`.`t1`
196 binlog.000001 # Query # # create database mysqltest
197 binlog.000001 # Query # # use `test`; create table t1 (a int primary key) engine=ndb
198 binlog.000001 # Query # # BEGIN
199 binlog.000001 # Table_map # # table_id: # (test.t1)
200 binlog.000001 # Table_map # # table_id: # (mysql.ndb_apply_status)
201 binlog.000001 # Write_rows # # table_id: #
202 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
203 binlog.000001 # Query # # COMMIT
204 binlog.000001 # Query # # drop database mysqltest
205 binlog.000001 # Query # # use `test`; drop table `test`.`t1`
206 binlog.000001 # Query # # create database mysqltest
207 binlog.000001 # Query # # use `test`; create table t1 (a int primary key) engine=ndb
208 binlog.000001 # Query # # BEGIN
209 binlog.000001 # Table_map # # table_id: # (test.t1)
210 binlog.000001 # Table_map # # table_id: # (mysql.ndb_apply_status)
211 binlog.000001 # Write_rows # # table_id: #
212 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
213 binlog.000001 # Query # # COMMIT
214 binlog.000001 # Query # # drop database mysqltest
215 binlog.000001 # Query # # use `test`; drop table `test`.`t1`
216 binlog.000001 # Query # # create database mysqltest
217 binlog.000001 # Query # # use `test`; create table t1 (a int primary key) engine=ndb
218 binlog.000001 # Query # # BEGIN
219 binlog.000001 # Table_map # # table_id: # (test.t1)
220 binlog.000001 # Table_map # # table_id: # (mysql.ndb_apply_status)
221 binlog.000001 # Write_rows # # table_id: #
222 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
223 binlog.000001 # Query # # COMMIT
224 binlog.000001 # Query # # drop database mysqltest
225 binlog.000001 # Query # # use `test`; drop table `test`.`t1`
226 binlog.000001 # Query # # create database mysqltest
227 binlog.000001 # Query # # use `test`; create table t1 (a int primary key) engine=ndb
228 binlog.000001 # Query # # BEGIN
229 binlog.000001 # Table_map # # table_id: # (test.t1)
230 binlog.000001 # Table_map # # table_id: # (mysql.ndb_apply_status)
231 binlog.000001 # Write_rows # # table_id: #
232 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
233 binlog.000001 # Query # # COMMIT
234 binlog.000001 # Query # # drop database mysqltest
235 binlog.000001 # Query # # use `test`; drop table `test`.`t1`
236 binlog.000001 # Query # # use `test`; create table dummy (dummyk int primary key) engine = ndb
237 binlog.000001 # Query # # use `test`; DROP TABLE `dummy` /* generated by server */
238 CREATE TABLE progress(
239 cnt int, stop_flag int
240 ) ENGINE NDB;
241 insert into progress value(0,0);
242 Start background load distributing schema changes.
243 call p1();
244 Restart mysqld 'server2'
245 # restart
246 Checking for schema ops. still making progress
247 Restart mysqld 'server2'
248 # restart
249 Checking for schema ops. still making progress
250 Restart mysqld 'server2'
251 # restart
252 Checking for schema ops. still making progress
253 Restart mysqld 'server2'
254 # restart
255 Checking for schema ops. still making progress
256 Stopping background load distributing schema changes.
257 update progress set stop_flag=1;
258 Wait for background schema distribution load to complete.
259 Cleanup
260 drop procedure p1;
261 drop table progress;
262 #
263 # WL#12936 : Implement DDL transaction context logger in ndbcluster
264 #
265 reset master;
266 show tables;
267 Tables_in_test
268 reset master;
269 show tables;
270 Tables_in_test
271 # Setup
272 CREATE TABLE t1 (
273 a int,
274 b int
275 ) ENGINE NDB;
276 INSERT INTO t1 VALUES (1, NULL);
277 CREATE TABLE t2 (
278 a int,
279 b int not null
280 ) ENGINE NDB
281 AS SELECT * FROM t1;
282 ERROR 23000: Column 'b' cannot be null
283 # Verify that table does not exist
284 SELECT * FROM t2;
285 ERROR 42S02: Table 'test.t2' doesn't exist
286 # Verify that the CREATE TABLE t2 query is not present in binlog
287 include/show_binlog_events.inc
288 Log_name Pos Event_type Server_id End_log_pos Info
289 binlog.000001 # Query # # use `test`; CREATE TABLE t1 (
290 a int,
291 b int
292 ) ENGINE NDB
293 binlog.000001 # Query # # BEGIN
294 binlog.000001 # Table_map # # table_id: # (test.t1)
295 binlog.000001 # Table_map # # table_id: # (mysql.ndb_apply_status)
296 binlog.000001 # Write_rows # # table_id: #
297 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
298 binlog.000001 # Query # # COMMIT
299 # Table should not exist in participant also
300 SELECT * FROM t2;
301 ERROR 42S02: Table 'test.t2' doesn't exist
302 # Verify that the CREATE TABLE t2 query is present in binlog
303 include/show_binlog_events.inc
304 Log_name Pos Event_type Server_id End_log_pos Info
305 binlog.000001 # Query # # use `test`; CREATE TABLE t1 (
306 a int,
307 b int
308 ) ENGINE NDB
309 binlog.000001 # Query # # BEGIN
310 binlog.000001 # Table_map # # table_id: # (test.t1)
311 binlog.000001 # Table_map # # table_id: # (mysql.ndb_apply_status)
312 binlog.000001 # Write_rows # # table_id: #
313 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
314 binlog.000001 # Query # # COMMIT
315 binlog.000001 # Query # # use `test`; CREATE TABLE t2 (
316 a int,
317 b int not null
318 ) ENGINE NDB
319 AS SELECT * FROM t1
320 #Cleanup
321 DROP TABLE t1;