Debian Codegraph @

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

raw
1 drop table if exists t1,t2,t3;
2 reset master;
3 drop table if exists t1,t2,t3;
4 reset master;
5 set SQL_LOG_BIN=0;
6 create database mysqltest;
7 use mysqltest;
8 create table t1 (a int key, b int) engine=ndb;
9 create table t2 (a int key, b int) engine=ndb;
10 insert into t1 values (1,1);
11 alter table t1 add c int;
12 Warnings:
13 Warning 1478 Converted FIXED field 'c' to DYNAMIC to enable online ADD COLUMN
14 include/show_binlog_events.inc
15 Log_name Pos Event_type Server_id End_log_pos Info
16 reset master;
17 use mysqltest;
18 insert into t2 values (1,1);
19 include/show_binlog_events.inc
20 Log_name Pos Event_type Server_id End_log_pos Info
21 binlog.000001 # Query # # BEGIN
22 binlog.000001 # Table_map # # table_id: # (mysqltest.t2)
23 binlog.000001 # Table_map # # table_id: # (mysql.ndb_apply_status)
24 binlog.000001 # Write_rows # # table_id: #
25 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
26 binlog.000001 # Query # # COMMIT
27 reset master;
28 use mysqltest;
29 drop table t1;
30 drop table t2;
31 create table t1 (d int key, e int) engine=ndb;
32 create table t2 (d int key, e int) engine=ndb;
33 insert into t1 values (1,1);
34 include/show_binlog_events.inc
35 Log_name Pos Event_type Server_id End_log_pos Info
36 binlog.000001 # Query # # BEGIN
37 binlog.000001 # Table_map # # table_id: # (mysqltest.t2)
38 binlog.000001 # Table_map # # table_id: # (mysql.ndb_apply_status)
39 binlog.000001 # Write_rows # # table_id: #
40 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
41 binlog.000001 # Query # # COMMIT
42 binlog.000001 # Query # # use `mysqltest`; DROP TABLE `t1` /* generated by server */
43 binlog.000001 # Query # # use `mysqltest`; DROP TABLE `t2` /* generated by server */
44 binlog.000001 # Query # # use `mysqltest`; create table t1 (d int key, e int) engine=ndb
45 binlog.000001 # Query # # use `mysqltest`; create table t2 (d int key, e int) engine=ndb
46 binlog.000001 # Query # # BEGIN
47 binlog.000001 # Table_map # # table_id: # (mysqltest.t1)
48 binlog.000001 # Table_map # # table_id: # (mysql.ndb_apply_status)
49 binlog.000001 # Write_rows # # table_id: #
50 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
51 binlog.000001 # Query # # COMMIT
52 use mysqltest;
53 insert into t2 values (1,1);
54 include/show_binlog_events.inc
55 Log_name Pos Event_type Server_id End_log_pos Info
56 binlog.000001 # Query # # use `mysqltest`; drop table `mysqltest`.`t1`
57 binlog.000001 # Query # # use `mysqltest`; drop table `mysqltest`.`t2`
58 binlog.000001 # Query # # use `mysqltest`; create table t1 (d int key, e int) engine=ndb
59 binlog.000001 # Query # # use `mysqltest`; create table t2 (d int key, e int) engine=ndb
60 binlog.000001 # Query # # BEGIN
61 binlog.000001 # Table_map # # table_id: # (mysqltest.t1)
62 binlog.000001 # Table_map # # table_id: # (mysql.ndb_apply_status)
63 binlog.000001 # Write_rows # # table_id: #
64 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
65 binlog.000001 # Query # # COMMIT
66 binlog.000001 # Query # # BEGIN
67 binlog.000001 # Table_map # # table_id: # (mysqltest.t2)
68 binlog.000001 # Table_map # # table_id: # (mysql.ndb_apply_status)
69 binlog.000001 # Write_rows # # table_id: #
70 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
71 binlog.000001 # Query # # COMMIT
72 drop database mysqltest;