Debian Codegraph @

mysql-test/suite/rpl/r/rpl_innodb_mixed_ddl.result

raw
1 include/master-slave.inc
2 [connection master]
3 connection master;
4 show global variables like 'binlog_format%';
5 Variable_name Value
6 binlog_format MIXED
7 show session variables like 'binlog_format%';
8 Variable_name Value
9 binlog_format MIXED
10 select @@global.binlog_format, @@session.binlog_format;
11 @@global.binlog_format @@session.binlog_format
12 MIXED MIXED
13 connection slave;
14 show global variables like 'binlog_format%';
15 Variable_name Value
16 binlog_format MIXED
17 show session variables like 'binlog_format%';
18 Variable_name Value
19 binlog_format MIXED
20 select @@global.binlog_format, @@session.binlog_format;
21 @@global.binlog_format @@session.binlog_format
22 MIXED MIXED
23 connection master;
24
25 ******************** DDL for database ********************
26 DROP DATABASE IF EXISTS test_rpl;
27 DROP DATABASE IF EXISTS test_rpl_1;
28 CREATE DATABASE test_rpl_1 CHARACTER SET utf8 COLLATE utf8_general_ci;
29 ALTER DATABASE test_rpl_1 CHARACTER SET latin1 COLLATE latin1_general_ci;
30 DROP DATABASE test_rpl_1;
31 CREATE DATABASE test_rpl CHARACTER SET utf8 COLLATE utf8_general_ci;
32 ALTER DATABASE test_rpl CHARACTER SET latin1 COLLATE latin1_swedish_ci;
33 SHOW DATABASES LIKE 'test_rpl%';
34 Database (test_rpl%)
35 test_rpl
36 connection slave;
37 SHOW DATABASES LIKE 'test_rpl%';
38 Database (test_rpl%)
39 test_rpl
40 connection master;
41 USE test_rpl;
42
43 ******************** DDL for tables ********************
44 CREATE TABLE t0 (a int auto_increment not null, c int not null, PRIMARY KEY(a), KEY index2 (c)) ENGINE=innodb;
45 ALTER TABLE t0 DROP INDEX index2;
46 ALTER TABLE t0 ADD COLUMN b char(254);
47 ALTER TABLE t0 ADD INDEX index1 (b);
48 ALTER TABLE t0 DROP COLUMN c;
49 RENAME TABLE t0 TO t1;
50 CREATE TABLE t2 LIKE t1;
51 SHOW CREATE TABLE t1;
52 Table Create Table
53 t1 CREATE TABLE `t1` (
54 `a` int(11) NOT NULL AUTO_INCREMENT,
55 `b` char(254) DEFAULT NULL,
56 PRIMARY KEY (`a`),
57 KEY `index1` (`b`)
58 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
59 SHOW CREATE TABLE t2;
60 Table Create Table
61 t2 CREATE TABLE `t2` (
62 `a` int(11) NOT NULL AUTO_INCREMENT,
63 `b` char(254) DEFAULT NULL,
64 PRIMARY KEY (`a`),
65 KEY `index1` (`b`)
66 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
67 connection slave;
68 USE test_rpl;
69 SHOW CREATE TABLE t1;
70 Table Create Table
71 t1 CREATE TABLE `t1` (
72 `a` int(11) NOT NULL AUTO_INCREMENT,
73 `b` char(254) DEFAULT NULL,
74 PRIMARY KEY (`a`),
75 KEY `index1` (`b`)
76 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
77 SHOW CREATE TABLE t2;
78 Table Create Table
79 t2 CREATE TABLE `t2` (
80 `a` int(11) NOT NULL AUTO_INCREMENT,
81 `b` char(254) DEFAULT NULL,
82 PRIMARY KEY (`a`),
83 KEY `index1` (`b`)
84 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
85 connection master;
86
87 ******************** DDL for indexes ********************
88 ALTER TABLE t2 ADD COLUMN d datetime;
89 CREATE INDEX index2 on t2 (d);
90 CREATE INDEX index3 on t2 (a, d);
91 SHOW CREATE TABLE t1;
92 Table Create Table
93 t1 CREATE TABLE `t1` (
94 `a` int(11) NOT NULL AUTO_INCREMENT,
95 `b` char(254) DEFAULT NULL,
96 PRIMARY KEY (`a`),
97 KEY `index1` (`b`)
98 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
99 SHOW CREATE TABLE t2;
100 Table Create Table
101 t2 CREATE TABLE `t2` (
102 `a` int(11) NOT NULL AUTO_INCREMENT,
103 `b` char(254) DEFAULT NULL,
104 `d` datetime DEFAULT NULL,
105 PRIMARY KEY (`a`),
106 KEY `index1` (`b`),
107 KEY `index2` (`d`),
108 KEY `index3` (`a`,`d`)
109 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
110 connection slave;
111 USE test_rpl;
112 SHOW CREATE TABLE t1;
113 Table Create Table
114 t1 CREATE TABLE `t1` (
115 `a` int(11) NOT NULL AUTO_INCREMENT,
116 `b` char(254) DEFAULT NULL,
117 PRIMARY KEY (`a`),
118 KEY `index1` (`b`)
119 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
120 SHOW CREATE TABLE t2;
121 Table Create Table
122 t2 CREATE TABLE `t2` (
123 `a` int(11) NOT NULL AUTO_INCREMENT,
124 `b` char(254) DEFAULT NULL,
125 `d` datetime DEFAULT NULL,
126 PRIMARY KEY (`a`),
127 KEY `index1` (`b`),
128 KEY `index2` (`d`),
129 KEY `index3` (`a`,`d`)
130 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
131 connection master;
132 ALTER TABLE t2 DROP COLUMN d;
133
134
135 ******************** SHOW BINLOG EVENTS ********************
136 include/show_binlog_events.inc
137 Log_name Pos Event_type Server_id End_log_pos Info
138 master-bin.000001 # Gtid # # GTID #-#-#
139 master-bin.000001 # Query # # DROP DATABASE IF EXISTS test_rpl
140 master-bin.000001 # Gtid # # GTID #-#-#
141 master-bin.000001 # Query # # DROP DATABASE IF EXISTS test_rpl_1
142 master-bin.000001 # Gtid # # GTID #-#-#
143 master-bin.000001 # Query # # CREATE DATABASE test_rpl_1 CHARACTER SET utf8 COLLATE utf8_general_ci
144 master-bin.000001 # Gtid # # GTID #-#-#
145 master-bin.000001 # Query # # ALTER DATABASE test_rpl_1 CHARACTER SET latin1 COLLATE latin1_general_ci
146 master-bin.000001 # Gtid # # GTID #-#-#
147 master-bin.000001 # Query # # DROP DATABASE test_rpl_1
148 master-bin.000001 # Gtid # # GTID #-#-#
149 master-bin.000001 # Query # # CREATE DATABASE test_rpl CHARACTER SET utf8 COLLATE utf8_general_ci
150 master-bin.000001 # Gtid # # GTID #-#-#
151 master-bin.000001 # Query # # ALTER DATABASE test_rpl CHARACTER SET latin1 COLLATE latin1_swedish_ci
152 master-bin.000001 # Gtid # # GTID #-#-#
153 master-bin.000001 # Query # # use `test_rpl`; CREATE TABLE t0 (a int auto_increment not null, c int not null, PRIMARY KEY(a), KEY index2 (c)) ENGINE=innodb
154 master-bin.000001 # Gtid # # GTID #-#-#
155 master-bin.000001 # Query # # use `test_rpl`; ALTER TABLE t0 DROP INDEX index2
156 master-bin.000001 # Gtid # # GTID #-#-#
157 master-bin.000001 # Query # # use `test_rpl`; ALTER TABLE t0 ADD COLUMN b char(254)
158 master-bin.000001 # Gtid # # GTID #-#-#
159 master-bin.000001 # Query # # use `test_rpl`; ALTER TABLE t0 ADD INDEX index1 (b)
160 master-bin.000001 # Gtid # # GTID #-#-#
161 master-bin.000001 # Query # # use `test_rpl`; ALTER TABLE t0 DROP COLUMN c
162 master-bin.000001 # Gtid # # GTID #-#-#
163 master-bin.000001 # Query # # use `test_rpl`; RENAME TABLE t0 TO t1
164 master-bin.000001 # Gtid # # GTID #-#-#
165 master-bin.000001 # Query # # use `test_rpl`; CREATE TABLE t2 LIKE t1
166 master-bin.000001 # Gtid # # GTID #-#-#
167 master-bin.000001 # Query # # use `test_rpl`; ALTER TABLE t2 ADD COLUMN d datetime
168 master-bin.000001 # Gtid # # GTID #-#-#
169 master-bin.000001 # Query # # use `test_rpl`; CREATE INDEX index2 on t2 (d)
170 master-bin.000001 # Gtid # # GTID #-#-#
171 master-bin.000001 # Query # # use `test_rpl`; CREATE INDEX index3 on t2 (a, d)
172 master-bin.000001 # Gtid # # GTID #-#-#
173 master-bin.000001 # Query # # use `test_rpl`; ALTER TABLE t2 DROP COLUMN d
174 connection slave;
175 connection master;
176 drop database test_rpl;
177 connection slave;
178 include/rpl_end.inc