Debian Codegraph @

mysql-test/suite/rpl/r/rpl_innodb_mixed_ddl.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 ==========MASTER==========
7 show global variables like 'binlog_format%';
8 Variable_name Value
9 binlog_format MIXED
10 show session variables like 'binlog_format%';
11 Variable_name Value
12 binlog_format MIXED
13 select @@global.binlog_format, @@session.binlog_format;
14 @@global.binlog_format @@session.binlog_format
15 MIXED MIXED
16 Warnings:
17 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
18 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
19 ==========SLAVE===========
20 show global variables like 'binlog_format%';
21 Variable_name Value
22 binlog_format MIXED
23 show session variables like 'binlog_format%';
24 Variable_name Value
25 binlog_format MIXED
26 select @@global.binlog_format, @@session.binlog_format;
27 @@global.binlog_format @@session.binlog_format
28 MIXED MIXED
29 Warnings:
30 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
31 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
32
33 ******************** DDL for database ********************
34 DROP DATABASE IF EXISTS test_rpl;
35 DROP DATABASE IF EXISTS test_rpl_1;
36 CREATE DATABASE test_rpl_1 CHARACTER SET utf8 COLLATE utf8_general_ci;
37 Warnings:
38 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
39 Warning 3778 'utf8mb3_general_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
40 ALTER DATABASE test_rpl_1 CHARACTER SET latin1 COLLATE latin1_general_ci;
41 DROP DATABASE test_rpl_1;
42 CREATE DATABASE test_rpl CHARACTER SET utf8 COLLATE utf8_general_ci;
43 Warnings:
44 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
45 Warning 3778 'utf8mb3_general_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
46 ALTER DATABASE test_rpl CHARACTER SET latin1 COLLATE latin1_swedish_ci;
47 ==========MASTER==========
48 SHOW DATABASES LIKE 'test_rpl%';
49 Database (test_rpl%)
50 test_rpl
51 ==========SLAVE===========
52 SHOW DATABASES LIKE 'test_rpl%';
53 Database (test_rpl%)
54 test_rpl
55 USE test_rpl;
56
57 ******************** DDL for tables ********************
58 CREATE TABLE t0 (a int auto_increment not null, c int not null, PRIMARY KEY(a), KEY index2 (c)) ENGINE=innodb;
59 ALTER TABLE t0 DROP INDEX index2;
60 ALTER TABLE t0 ADD COLUMN b char(254);
61 ALTER TABLE t0 ADD INDEX index1 (b);
62 ALTER TABLE t0 DROP COLUMN c;
63 RENAME TABLE t0 TO t1;
64 CREATE TABLE t2 LIKE t1;
65 ==========MASTER==========
66 SHOW CREATE TABLE t1;
67 Table Create Table
68 t1 CREATE TABLE `t1` (
69 `a` int NOT NULL AUTO_INCREMENT,
70 `b` char(254) DEFAULT NULL,
71 PRIMARY KEY (`a`),
72 KEY `index1` (`b`)
73 ) ENGINE=InnoDB DEFAULT CHARSET=latin1
74 SHOW CREATE TABLE t2;
75 Table Create Table
76 t2 CREATE TABLE `t2` (
77 `a` int NOT NULL AUTO_INCREMENT,
78 `b` char(254) DEFAULT NULL,
79 PRIMARY KEY (`a`),
80 KEY `index1` (`b`)
81 ) ENGINE=InnoDB DEFAULT CHARSET=latin1
82 ==========SLAVE===========
83 USE test_rpl;
84 SHOW CREATE TABLE t1;
85 Table Create Table
86 t1 CREATE TABLE `t1` (
87 `a` int NOT NULL AUTO_INCREMENT,
88 `b` char(254) DEFAULT NULL,
89 PRIMARY KEY (`a`),
90 KEY `index1` (`b`)
91 ) ENGINE=InnoDB DEFAULT CHARSET=latin1
92 SHOW CREATE TABLE t2;
93 Table Create Table
94 t2 CREATE TABLE `t2` (
95 `a` int NOT NULL AUTO_INCREMENT,
96 `b` char(254) DEFAULT NULL,
97 PRIMARY KEY (`a`),
98 KEY `index1` (`b`)
99 ) ENGINE=InnoDB DEFAULT CHARSET=latin1
100
101 ******************** DDL for indexes ********************
102 ALTER TABLE t2 ADD COLUMN d datetime;
103 CREATE INDEX index2 on t2 (d);
104 CREATE INDEX index3 on t2 (a, d);
105 ==========MASTER==========
106 SHOW CREATE TABLE t1;
107 Table Create Table
108 t1 CREATE TABLE `t1` (
109 `a` int NOT NULL AUTO_INCREMENT,
110 `b` char(254) DEFAULT NULL,
111 PRIMARY KEY (`a`),
112 KEY `index1` (`b`)
113 ) ENGINE=InnoDB DEFAULT CHARSET=latin1
114 SHOW CREATE TABLE t2;
115 Table Create Table
116 t2 CREATE TABLE `t2` (
117 `a` int NOT NULL AUTO_INCREMENT,
118 `b` char(254) DEFAULT NULL,
119 `d` datetime DEFAULT NULL,
120 PRIMARY KEY (`a`),
121 KEY `index1` (`b`),
122 KEY `index2` (`d`),
123 KEY `index3` (`a`,`d`)
124 ) ENGINE=InnoDB DEFAULT CHARSET=latin1
125 ==========SLAVE===========
126 USE test_rpl;
127 SHOW CREATE TABLE t1;
128 Table Create Table
129 t1 CREATE TABLE `t1` (
130 `a` int NOT NULL AUTO_INCREMENT,
131 `b` char(254) DEFAULT NULL,
132 PRIMARY KEY (`a`),
133 KEY `index1` (`b`)
134 ) ENGINE=InnoDB DEFAULT CHARSET=latin1
135 SHOW CREATE TABLE t2;
136 Table Create Table
137 t2 CREATE TABLE `t2` (
138 `a` int NOT NULL AUTO_INCREMENT,
139 `b` char(254) DEFAULT NULL,
140 `d` datetime DEFAULT NULL,
141 PRIMARY KEY (`a`),
142 KEY `index1` (`b`),
143 KEY `index2` (`d`),
144 KEY `index3` (`a`,`d`)
145 ) ENGINE=InnoDB DEFAULT CHARSET=latin1
146 ALTER TABLE t2 DROP COLUMN d;
147
148
149 ******************** SHOW BINLOG EVENTS ********************
150 include/show_binlog_events.inc
151 Log_name Pos Event_type Server_id End_log_pos Info
152 master-bin.000001 # Query # # DROP DATABASE IF EXISTS test_rpl
153 master-bin.000001 # Query # # DROP DATABASE IF EXISTS test_rpl_1
154 master-bin.000001 # Query # # CREATE DATABASE test_rpl_1 CHARACTER SET utf8 COLLATE utf8_general_ci
155 master-bin.000001 # Query # # ALTER DATABASE test_rpl_1 CHARACTER SET latin1 COLLATE latin1_general_ci
156 master-bin.000001 # Query # # DROP DATABASE test_rpl_1
157 master-bin.000001 # Query # # CREATE DATABASE test_rpl CHARACTER SET utf8 COLLATE utf8_general_ci
158 master-bin.000001 # Query # # ALTER DATABASE test_rpl CHARACTER SET latin1 COLLATE latin1_swedish_ci
159 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
160 master-bin.000001 # Query # # use `test_rpl`; ALTER TABLE t0 DROP INDEX index2
161 master-bin.000001 # Query # # use `test_rpl`; ALTER TABLE t0 ADD COLUMN b char(254)
162 master-bin.000001 # Query # # use `test_rpl`; ALTER TABLE t0 ADD INDEX index1 (b)
163 master-bin.000001 # Query # # use `test_rpl`; ALTER TABLE t0 DROP COLUMN c
164 master-bin.000001 # Query # # use `test_rpl`; RENAME TABLE t0 TO t1
165 master-bin.000001 # Query # # use `test_rpl`; CREATE TABLE t2 LIKE t1
166 master-bin.000001 # Query # # use `test_rpl`; ALTER TABLE t2 ADD COLUMN d datetime
167 master-bin.000001 # Query # # use `test_rpl`; CREATE INDEX index2 on t2 (d)
168 master-bin.000001 # Query # # use `test_rpl`; CREATE INDEX index3 on t2 (a, d)
169 master-bin.000001 # Query # # use `test_rpl`; ALTER TABLE t2 DROP COLUMN d
170 drop database test_rpl;
171 include/rpl_end.inc