Debian Codegraph @

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

raw
1 include/master-slave.inc
2 [connection master]
3 connection slave;
4 set sql_log_bin=0;
5 create database y;
6 set sql_log_bin=1;
7 connection master;
8 drop database if exists mysqltest1;
9 drop database if exists x;
10 create database mysqltest1;
11 set sql_log_bin=0;
12 create database x;
13 set sql_log_bin=1;
14 use mysqltest1;
15 create table t1 (a int);
16 insert into t1 values(9);
17 use x;
18 create table t1 (a int);
19 insert into t1 values(9);
20 select * from mysqltest1.t1;
21 a
22 9
23 select * from x.t1;
24 a
25 9
26 connection slave;
27 show databases like 'mysqltest1';
28 Database (mysqltest1)
29 mysqltest1
30 select * from test.t1;
31 a
32 9
33 select * from y.t1;
34 a
35 9
36 connection master;
37 use mysqltest1;
38 drop table t1;
39 drop database mysqltest1;
40 connection slave;
41 connection slave;
42 drop database if exists rewrite;
43 create database rewrite;
44 connection master;
45 use test;
46 create table t1 (a date, b date, c date not null, d date);
47 load data infile '../../std_data/loaddata1.dat' ignore into table t1 character set latin1 fields terminated by ',';
48 Warnings:
49 Warning 1265 Data truncated for column 'a' at row 1
50 Warning 1265 Data truncated for column 'c' at row 1
51 Warning 1265 Data truncated for column 'd' at row 1
52 Warning 1265 Data truncated for column 'a' at row 2
53 Warning 1265 Data truncated for column 'b' at row 2
54 Warning 1265 Data truncated for column 'd' at row 2
55 load data infile '../../std_data/loaddata1.dat' into table t1 character set latin1 fields terminated by ',' IGNORE 2 LINES;
56 connection slave;
57 connection slave;
58 select * from rewrite.t1;
59 a b c d
60 0000-00-00 NULL 0000-00-00 0000-00-00
61 0000-00-00 0000-00-00 0000-00-00 0000-00-00
62 2003-03-03 2003-03-03 2003-03-03 NULL
63 2003-03-03 2003-03-03 2003-03-03 NULL
64 connection master;
65 truncate table t1;
66 load data infile '../../std_data/loaddata1.dat' ignore into table t1 character set latin1 fields terminated by ',' LINES STARTING BY ',' (b,c,d);
67 Warnings:
68 Warning 1265 Data truncated for column 'c' at row 1
69 Warning 1265 Data truncated for column 'd' at row 1
70 Warning 1265 Data truncated for column 'b' at row 2
71 Warning 1265 Data truncated for column 'd' at row 2
72 connection slave;
73 connection slave;
74 select * from rewrite.t1;
75 a b c d
76 NULL NULL 0000-00-00 0000-00-00
77 NULL 0000-00-00 0000-00-00 0000-00-00
78 NULL 2003-03-03 2003-03-03 NULL
79 connection master;
80 drop table t1;
81 create table t1 (a text, b text) character set latin1;
82 load data infile '../../std_data/loaddata2.dat' into table t1 character set latin1 fields terminated by ',' enclosed by '''';
83 Warnings:
84 Warning 1261 Row 3 doesn't contain data for all columns
85 connection slave;
86 connection slave;
87 select concat('|',a,'|'), concat('|',b,'|') from rewrite.t1;
88 concat('|',a,'|') concat('|',b,'|')
89 |Field A| |Field B|
90 |Field 1| |Field 2'
91 Field 3,'Field 4|
92 |Field 5' ,'Field 6| NULL
93 |Field 6| | 'Field 7'|
94 connection master;
95 drop table t1;
96 create table t1 (a int, b char(10)) character set latin1;
97 load data infile '../../std_data/loaddata3.dat' into table t1 character set latin1 fields terminated by '' enclosed by '' ignore 1 lines;
98 Warnings:
99 Note 1265 Data truncated for column 'a' at row 1
100 Note 1265 Data truncated for column 'a' at row 2
101 Warning 1366 Incorrect integer value: 'error ' for column `test`.`t1`.`a` at row 3
102 Warning 1262 Row 3 was truncated; it contained more data than there were input columns
103 Note 1265 Data truncated for column 'a' at row 4
104 Warning 1366 Incorrect integer value: 'wrong end ' for column `test`.`t1`.`a` at row 5
105 Warning 1262 Row 5 was truncated; it contained more data than there were input columns
106 connection slave;
107 connection slave;
108 select * from rewrite.t1;
109 a b
110 1 row 1
111 2 row 2
112 0 1234567890
113 3 row 3
114 0 1234567890
115 connection master;
116 truncate table t1;
117 load data infile '../../std_data/loaddata4.dat' into table t1 character set latin1 fields terminated by '' enclosed by '' lines terminated by '' ignore 1 lines;
118 Warnings:
119 Note 1265 Data truncated for column 'a' at row 1
120 Note 1265 Data truncated for column 'a' at row 2
121 Note 1265 Data truncated for column 'a' at row 3
122 Warning 1366 Incorrect integer value: '
123 ' for column `test`.`t1`.`a` at row 4
124 Warning 1261 Row 4 doesn't contain data for all columns
125 connection slave;
126 connection slave;
127 select * from rewrite.t1;
128 a b
129 1 row 1
130 2 row 2
131 3 row 3
132 0
133 set sql_log_bin= 0;
134 drop database rewrite;
135 set sql_log_bin= 1;
136 connection master;
137 set sql_log_bin= 0;
138 drop table t1;
139 set sql_log_bin= 1;
140
141 ****
142 **** Bug #46861 Auto-closing of temporary tables broken by replicate-rewrite-db
143 ****
144
145 ****
146 **** Preparing the environment
147 ****
148 connection master;
149 connect con_temp_03,127.0.0.1,root,,test,$MASTER_MYPORT,;
150 connect con_temp_02,127.0.0.1,root,,test,$MASTER_MYPORT,;
151 connect con_temp_01,127.0.0.1,root,,test,$MASTER_MYPORT,;
152 connection master;
153 SET sql_log_bin= 0;
154 CREATE DATABASE database_master_temp_01;
155 CREATE DATABASE database_master_temp_02;
156 CREATE DATABASE database_master_temp_03;
157 SET sql_log_bin= 1;
158 connection slave;
159 SET sql_log_bin= 0;
160 CREATE DATABASE database_slave_temp_01;
161 CREATE DATABASE database_slave_temp_02;
162 CREATE DATABASE database_slave_temp_03;
163 SET sql_log_bin= 1;
164
165 ****
166 **** Creating temporary tables on different databases with different connections
167 ****
168 **** con_temp_01 --> creates
169 **** t_01_01_temp on database_master_temp_01
170 ****
171 **** con_temp_02 --> creates
172 **** t_01_01_temp on database_master_temp_01
173 **** t_02_01_temp, t_02_02_temp on database_master_temp_02
174 ****
175 **** con_temp_02 --> creates
176 **** t_01_01_temp on database_master_temp_01
177 **** t_02_01_temp, t_02_02_temp on database_master_temp_02
178 **** t_03_01_temp, t_03_02_temp, t_03_03_temp on database_master_temp_03
179 ****
180 connection con_temp_01;
181 USE database_master_temp_01;
182 CREATE TEMPORARY TABLE t_01_01_temp(a int);
183 INSERT INTO t_01_01_temp VALUES(1);
184 connection con_temp_02;
185 USE database_master_temp_01;
186 CREATE TEMPORARY TABLE t_01_01_temp(a int);
187 INSERT INTO t_01_01_temp VALUES(1);
188 USE database_master_temp_02;
189 CREATE TEMPORARY TABLE t_02_01_temp(a int);
190 INSERT INTO t_02_01_temp VALUES(1);
191 CREATE TEMPORARY TABLE t_02_02_temp(a int);
192 INSERT INTO t_02_02_temp VALUES(1);
193 connection con_temp_03;
194 USE database_master_temp_01;
195 CREATE TEMPORARY TABLE t_01_01_temp(a int);
196 INSERT INTO t_01_01_temp VALUES(1);
197 USE database_master_temp_02;
198 CREATE TEMPORARY TABLE t_02_01_temp(a int);
199 INSERT INTO t_02_01_temp VALUES(1);
200 CREATE TEMPORARY TABLE t_02_02_temp(a int);
201 INSERT INTO t_02_02_temp VALUES(1);
202 USE database_master_temp_03;
203 CREATE TEMPORARY TABLE t_03_01_temp(a int);
204 INSERT INTO t_03_01_temp VALUES(1);
205 CREATE TEMPORARY TABLE t_03_02_temp(a int);
206 INSERT INTO t_03_02_temp VALUES(1);
207 CREATE TEMPORARY TABLE t_03_03_temp(a int);
208 INSERT INTO t_03_03_temp VALUES(1);
209
210 **** Dropping the connections
211 **** We want to SHOW BINLOG EVENTS, to know what was logged. But there is no
212 **** guarantee that logging of the terminated con1 has been done yet.a To be
213 **** sure that logging has been done, we use a user lock.
214
215 connection master;
216 connection slave;
217 connection slave;
218 show status like 'Slave_open_temp_tables';
219 Variable_name Value
220 Slave_open_temp_tables 10
221 connection master;
222 connection con_temp_01;
223 select get_lock("con_01",10);
224 get_lock("con_01",10)
225 1
226 connection master;
227 disconnect con_temp_01;
228 select get_lock("con_01",10);
229 get_lock("con_01",10)
230 1
231 connection con_temp_02;
232 select get_lock("con_02",10);
233 get_lock("con_02",10)
234 1
235 connection master;
236 disconnect con_temp_02;
237 select get_lock("con_02",10);
238 get_lock("con_02",10)
239 1
240 connection con_temp_03;
241 select get_lock("con_03",10);
242 get_lock("con_03",10)
243 1
244 connection master;
245 disconnect con_temp_03;
246 select get_lock("con_03",10);
247 get_lock("con_03",10)
248 1
249
250 **** Checking the binary log and temporary tables
251
252 connection master;
253 connection slave;
254 connection slave;
255 show status like 'Slave_open_temp_tables';
256 Variable_name Value
257 Slave_open_temp_tables 0
258 connection master;
259 include/show_binlog_events.inc
260 Log_name Pos Event_type Server_id End_log_pos Info
261 master-bin.000001 # Gtid # # GTID #-#-#
262 master-bin.000001 # Query # # use `database_master_temp_01`; DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `t_01_01_temp`
263 master-bin.000001 # Gtid # # GTID #-#-#
264 master-bin.000001 # Query # # use `database_master_temp_02`; DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `t_02_02_temp`,`t_02_01_temp`
265 master-bin.000001 # Gtid # # GTID #-#-#
266 master-bin.000001 # Query # # use `database_master_temp_01`; DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `t_01_01_temp`
267 master-bin.000001 # Gtid # # GTID #-#-#
268 master-bin.000001 # Query # # use `database_master_temp_03`; DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `t_03_03_temp`,`t_03_02_temp`,`t_03_01_temp`
269 master-bin.000001 # Gtid # # GTID #-#-#
270 master-bin.000001 # Query # # use `database_master_temp_02`; DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `t_02_02_temp`,`t_02_01_temp`
271 master-bin.000001 # Gtid # # GTID #-#-#
272 master-bin.000001 # Query # # use `database_master_temp_01`; DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `t_01_01_temp`
273 ****
274 **** Cleaning up the test case
275 ****
276 connection master;
277 SET sql_log_bin= 0;
278 DROP DATABASE database_master_temp_01;
279 DROP DATABASE database_master_temp_02;
280 DROP DATABASE database_master_temp_03;
281 DROP DATABASE x;
282 SET sql_log_bin= 1;
283 connection slave;
284 SET sql_log_bin= 0;
285 DROP DATABASE database_slave_temp_01;
286 DROP DATABASE database_slave_temp_02;
287 DROP DATABASE database_slave_temp_03;
288 DROP DATABASE y;
289 SET sql_log_bin= 1;
290 connection master;
291 connection slave;
292 include/rpl_end.inc