Debian Codegraph @

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

raw
1 include/master-slave.inc
2 [connection master]
3 connection slave;
4 connection master;
5 drop table if exists t1;
6 CREATE TABLE t1 (id MEDIUMINT NOT NULL, b1 BIT(8), vc
7 VARCHAR(255), bc CHAR(255), d DECIMAL(10,4) DEFAULT 0, f FLOAT DEFAULT
8 0, total BIGINT UNSIGNED, y YEAR, t TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
9 ON UPDATE CURRENT_TIMESTAMP,PRIMARY KEY(id));
10 connection slave;
11 connection master;
12 alter table t1 engine=myisam;
13 show create table t1;
14 Table Create Table
15 t1 CREATE TABLE `t1` (
16 `id` mediumint(9) NOT NULL,
17 `b1` bit(8) DEFAULT NULL,
18 `vc` varchar(255) DEFAULT NULL,
19 `bc` char(255) DEFAULT NULL,
20 `d` decimal(10,4) DEFAULT 0.0000,
21 `f` float DEFAULT 0,
22 `total` bigint(20) unsigned DEFAULT NULL,
23 `y` year(4) DEFAULT NULL,
24 `t` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
25 PRIMARY KEY (`id`)
26 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
27 connection slave;
28 connection slave;
29 alter table t1 engine=myisam;
30 show create table t1;
31 Table Create Table
32 t1 CREATE TABLE `t1` (
33 `id` mediumint(9) NOT NULL,
34 `b1` bit(8) DEFAULT NULL,
35 `vc` varchar(255) DEFAULT NULL,
36 `bc` char(255) DEFAULT NULL,
37 `d` decimal(10,4) DEFAULT 0.0000,
38 `f` float DEFAULT 0,
39 `total` bigint(20) unsigned DEFAULT NULL,
40 `y` year(4) DEFAULT NULL,
41 `t` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
42 PRIMARY KEY (`id`)
43 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
44 connection master;
45 INSERT INTO t1 VALUES(42,1,'Testing MySQL databases is a cool ', 'Must make it bug free for the customer',654321.4321,15.21,0,1965,"2005-11-14");
46 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
47 id hex(b1) vc bc d f total y t
48 42 1 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-11-14 00:00:00
49 connection slave;
50 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
51 id hex(b1) vc bc d f total y t
52 42 1 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-11-14 00:00:00
53 connection master;
54 UPDATE t1 SET b1 = 0, t="2005-09-09" WHERE b1 = 1;
55 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
56 id hex(b1) vc bc d f total y t
57 42 0 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-09-09 00:00:00
58 connection slave;
59 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
60 id hex(b1) vc bc d f total y t
61 42 0 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-09-09 00:00:00
62 connection master;
63 DELETE FROM t1 WHERE id = 42;
64 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
65 id hex(b1) vc bc d f total y t
66 connection slave;
67 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
68 id hex(b1) vc bc d f total y t
69 connection master;
70 connection slave;
71 alter table t1 engine=innodb;
72 show create table t1;
73 Table Create Table
74 t1 CREATE TABLE `t1` (
75 `id` mediumint(9) NOT NULL,
76 `b1` bit(8) DEFAULT NULL,
77 `vc` varchar(255) DEFAULT NULL,
78 `bc` char(255) DEFAULT NULL,
79 `d` decimal(10,4) DEFAULT 0.0000,
80 `f` float DEFAULT 0,
81 `total` bigint(20) unsigned DEFAULT NULL,
82 `y` year(4) DEFAULT NULL,
83 `t` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
84 PRIMARY KEY (`id`)
85 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
86 connection master;
87 INSERT INTO t1 VALUES(42,1,'Testing MySQL databases is a cool ', 'Must make it bug free for the customer',654321.4321,15.21,0,1965,"2005-11-14");
88 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
89 id hex(b1) vc bc d f total y t
90 42 1 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-11-14 00:00:00
91 connection slave;
92 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
93 id hex(b1) vc bc d f total y t
94 42 1 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-11-14 00:00:00
95 connection master;
96 UPDATE t1 SET b1 = 0, t="2005-09-09" WHERE b1 = 1;
97 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
98 id hex(b1) vc bc d f total y t
99 42 0 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-09-09 00:00:00
100 connection slave;
101 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
102 id hex(b1) vc bc d f total y t
103 42 0 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-09-09 00:00:00
104 connection master;
105 DELETE FROM t1 WHERE id = 42;
106 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
107 id hex(b1) vc bc d f total y t
108 connection slave;
109 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
110 id hex(b1) vc bc d f total y t
111 connection master;
112 connection slave;
113 alter table t1 engine=memory;
114 show create table t1;
115 Table Create Table
116 t1 CREATE TABLE `t1` (
117 `id` mediumint(9) NOT NULL,
118 `b1` bit(8) DEFAULT NULL,
119 `vc` varchar(255) DEFAULT NULL,
120 `bc` char(255) DEFAULT NULL,
121 `d` decimal(10,4) DEFAULT 0.0000,
122 `f` float DEFAULT 0,
123 `total` bigint(20) unsigned DEFAULT NULL,
124 `y` year(4) DEFAULT NULL,
125 `t` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
126 PRIMARY KEY (`id`)
127 ) ENGINE=MEMORY DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
128 connection master;
129 INSERT INTO t1 VALUES(42,1,'Testing MySQL databases is a cool ', 'Must make it bug free for the customer',654321.4321,15.21,0,1965,"2005-11-14");
130 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
131 id hex(b1) vc bc d f total y t
132 42 1 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-11-14 00:00:00
133 connection slave;
134 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
135 id hex(b1) vc bc d f total y t
136 42 1 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-11-14 00:00:00
137 connection master;
138 UPDATE t1 SET b1 = 0, t="2005-09-09" WHERE b1 = 1;
139 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
140 id hex(b1) vc bc d f total y t
141 42 0 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-09-09 00:00:00
142 connection slave;
143 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
144 id hex(b1) vc bc d f total y t
145 42 0 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-09-09 00:00:00
146 connection master;
147 DELETE FROM t1 WHERE id = 42;
148 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
149 id hex(b1) vc bc d f total y t
150 connection slave;
151 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
152 id hex(b1) vc bc d f total y t
153 connection master;
154 connection master;
155 alter table t1 engine=memory;
156 show create table t1;
157 Table Create Table
158 t1 CREATE TABLE `t1` (
159 `id` mediumint(9) NOT NULL,
160 `b1` bit(8) DEFAULT NULL,
161 `vc` varchar(255) DEFAULT NULL,
162 `bc` char(255) DEFAULT NULL,
163 `d` decimal(10,4) DEFAULT 0.0000,
164 `f` float DEFAULT 0,
165 `total` bigint(20) unsigned DEFAULT NULL,
166 `y` year(4) DEFAULT NULL,
167 `t` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
168 PRIMARY KEY (`id`)
169 ) ENGINE=MEMORY DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
170 connection slave;
171 connection slave;
172 alter table t1 engine=myisam;
173 show create table t1;
174 Table Create Table
175 t1 CREATE TABLE `t1` (
176 `id` mediumint(9) NOT NULL,
177 `b1` bit(8) DEFAULT NULL,
178 `vc` varchar(255) DEFAULT NULL,
179 `bc` char(255) DEFAULT NULL,
180 `d` decimal(10,4) DEFAULT 0.0000,
181 `f` float DEFAULT 0,
182 `total` bigint(20) unsigned DEFAULT NULL,
183 `y` year(4) DEFAULT NULL,
184 `t` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
185 PRIMARY KEY (`id`)
186 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
187 connection master;
188 INSERT INTO t1 VALUES(42,1,'Testing MySQL databases is a cool ', 'Must make it bug free for the customer',654321.4321,15.21,0,1965,"2005-11-14");
189 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
190 id hex(b1) vc bc d f total y t
191 42 1 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-11-14 00:00:00
192 connection slave;
193 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
194 id hex(b1) vc bc d f total y t
195 42 1 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-11-14 00:00:00
196 connection master;
197 UPDATE t1 SET b1 = 0, t="2005-09-09" WHERE b1 = 1;
198 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
199 id hex(b1) vc bc d f total y t
200 42 0 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-09-09 00:00:00
201 connection slave;
202 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
203 id hex(b1) vc bc d f total y t
204 42 0 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-09-09 00:00:00
205 connection master;
206 DELETE FROM t1 WHERE id = 42;
207 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
208 id hex(b1) vc bc d f total y t
209 connection slave;
210 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
211 id hex(b1) vc bc d f total y t
212 connection master;
213 connection slave;
214 alter table t1 engine=innodb;
215 show create table t1;
216 Table Create Table
217 t1 CREATE TABLE `t1` (
218 `id` mediumint(9) NOT NULL,
219 `b1` bit(8) DEFAULT NULL,
220 `vc` varchar(255) DEFAULT NULL,
221 `bc` char(255) DEFAULT NULL,
222 `d` decimal(10,4) DEFAULT 0.0000,
223 `f` float DEFAULT 0,
224 `total` bigint(20) unsigned DEFAULT NULL,
225 `y` year(4) DEFAULT NULL,
226 `t` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
227 PRIMARY KEY (`id`)
228 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
229 connection master;
230 INSERT INTO t1 VALUES(42,1,'Testing MySQL databases is a cool ', 'Must make it bug free for the customer',654321.4321,15.21,0,1965,"2005-11-14");
231 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
232 id hex(b1) vc bc d f total y t
233 42 1 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-11-14 00:00:00
234 connection slave;
235 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
236 id hex(b1) vc bc d f total y t
237 42 1 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-11-14 00:00:00
238 connection master;
239 UPDATE t1 SET b1 = 0, t="2005-09-09" WHERE b1 = 1;
240 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
241 id hex(b1) vc bc d f total y t
242 42 0 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-09-09 00:00:00
243 connection slave;
244 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
245 id hex(b1) vc bc d f total y t
246 42 0 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-09-09 00:00:00
247 connection master;
248 DELETE FROM t1 WHERE id = 42;
249 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
250 id hex(b1) vc bc d f total y t
251 connection slave;
252 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
253 id hex(b1) vc bc d f total y t
254 connection master;
255 connection slave;
256 alter table t1 engine=memory;
257 show create table t1;
258 Table Create Table
259 t1 CREATE TABLE `t1` (
260 `id` mediumint(9) NOT NULL,
261 `b1` bit(8) DEFAULT NULL,
262 `vc` varchar(255) DEFAULT NULL,
263 `bc` char(255) DEFAULT NULL,
264 `d` decimal(10,4) DEFAULT 0.0000,
265 `f` float DEFAULT 0,
266 `total` bigint(20) unsigned DEFAULT NULL,
267 `y` year(4) DEFAULT NULL,
268 `t` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
269 PRIMARY KEY (`id`)
270 ) ENGINE=MEMORY DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
271 connection master;
272 INSERT INTO t1 VALUES(42,1,'Testing MySQL databases is a cool ', 'Must make it bug free for the customer',654321.4321,15.21,0,1965,"2005-11-14");
273 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
274 id hex(b1) vc bc d f total y t
275 42 1 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-11-14 00:00:00
276 connection slave;
277 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
278 id hex(b1) vc bc d f total y t
279 42 1 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-11-14 00:00:00
280 connection master;
281 UPDATE t1 SET b1 = 0, t="2005-09-09" WHERE b1 = 1;
282 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
283 id hex(b1) vc bc d f total y t
284 42 0 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-09-09 00:00:00
285 connection slave;
286 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
287 id hex(b1) vc bc d f total y t
288 42 0 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-09-09 00:00:00
289 connection master;
290 DELETE FROM t1 WHERE id = 42;
291 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
292 id hex(b1) vc bc d f total y t
293 connection slave;
294 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
295 id hex(b1) vc bc d f total y t
296 connection master;
297 connection master;
298 alter table t1 engine=innodb;
299 show create table t1;
300 Table Create Table
301 t1 CREATE TABLE `t1` (
302 `id` mediumint(9) NOT NULL,
303 `b1` bit(8) DEFAULT NULL,
304 `vc` varchar(255) DEFAULT NULL,
305 `bc` char(255) DEFAULT NULL,
306 `d` decimal(10,4) DEFAULT 0.0000,
307 `f` float DEFAULT 0,
308 `total` bigint(20) unsigned DEFAULT NULL,
309 `y` year(4) DEFAULT NULL,
310 `t` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
311 PRIMARY KEY (`id`)
312 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
313 connection slave;
314 connection slave;
315 alter table t1 engine=myisam;
316 show create table t1;
317 Table Create Table
318 t1 CREATE TABLE `t1` (
319 `id` mediumint(9) NOT NULL,
320 `b1` bit(8) DEFAULT NULL,
321 `vc` varchar(255) DEFAULT NULL,
322 `bc` char(255) DEFAULT NULL,
323 `d` decimal(10,4) DEFAULT 0.0000,
324 `f` float DEFAULT 0,
325 `total` bigint(20) unsigned DEFAULT NULL,
326 `y` year(4) DEFAULT NULL,
327 `t` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
328 PRIMARY KEY (`id`)
329 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
330 connection master;
331 INSERT INTO t1 VALUES(42,1,'Testing MySQL databases is a cool ', 'Must make it bug free for the customer',654321.4321,15.21,0,1965,"2005-11-14");
332 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
333 id hex(b1) vc bc d f total y t
334 42 1 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-11-14 00:00:00
335 connection slave;
336 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
337 id hex(b1) vc bc d f total y t
338 42 1 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-11-14 00:00:00
339 connection master;
340 UPDATE t1 SET b1 = 0, t="2005-09-09" WHERE b1 = 1;
341 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
342 id hex(b1) vc bc d f total y t
343 42 0 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-09-09 00:00:00
344 connection slave;
345 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
346 id hex(b1) vc bc d f total y t
347 42 0 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-09-09 00:00:00
348 connection master;
349 DELETE FROM t1 WHERE id = 42;
350 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
351 id hex(b1) vc bc d f total y t
352 connection slave;
353 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
354 id hex(b1) vc bc d f total y t
355 connection master;
356 connection slave;
357 alter table t1 engine=innodb;
358 show create table t1;
359 Table Create Table
360 t1 CREATE TABLE `t1` (
361 `id` mediumint(9) NOT NULL,
362 `b1` bit(8) DEFAULT NULL,
363 `vc` varchar(255) DEFAULT NULL,
364 `bc` char(255) DEFAULT NULL,
365 `d` decimal(10,4) DEFAULT 0.0000,
366 `f` float DEFAULT 0,
367 `total` bigint(20) unsigned DEFAULT NULL,
368 `y` year(4) DEFAULT NULL,
369 `t` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
370 PRIMARY KEY (`id`)
371 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
372 connection master;
373 INSERT INTO t1 VALUES(42,1,'Testing MySQL databases is a cool ', 'Must make it bug free for the customer',654321.4321,15.21,0,1965,"2005-11-14");
374 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
375 id hex(b1) vc bc d f total y t
376 42 1 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-11-14 00:00:00
377 connection slave;
378 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
379 id hex(b1) vc bc d f total y t
380 42 1 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-11-14 00:00:00
381 connection master;
382 UPDATE t1 SET b1 = 0, t="2005-09-09" WHERE b1 = 1;
383 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
384 id hex(b1) vc bc d f total y t
385 42 0 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-09-09 00:00:00
386 connection slave;
387 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
388 id hex(b1) vc bc d f total y t
389 42 0 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-09-09 00:00:00
390 connection master;
391 DELETE FROM t1 WHERE id = 42;
392 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
393 id hex(b1) vc bc d f total y t
394 connection slave;
395 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
396 id hex(b1) vc bc d f total y t
397 connection master;
398 connection slave;
399 alter table t1 engine=memory;
400 show create table t1;
401 Table Create Table
402 t1 CREATE TABLE `t1` (
403 `id` mediumint(9) NOT NULL,
404 `b1` bit(8) DEFAULT NULL,
405 `vc` varchar(255) DEFAULT NULL,
406 `bc` char(255) DEFAULT NULL,
407 `d` decimal(10,4) DEFAULT 0.0000,
408 `f` float DEFAULT 0,
409 `total` bigint(20) unsigned DEFAULT NULL,
410 `y` year(4) DEFAULT NULL,
411 `t` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
412 PRIMARY KEY (`id`)
413 ) ENGINE=MEMORY DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
414 connection master;
415 INSERT INTO t1 VALUES(42,1,'Testing MySQL databases is a cool ', 'Must make it bug free for the customer',654321.4321,15.21,0,1965,"2005-11-14");
416 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
417 id hex(b1) vc bc d f total y t
418 42 1 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-11-14 00:00:00
419 connection slave;
420 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
421 id hex(b1) vc bc d f total y t
422 42 1 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-11-14 00:00:00
423 connection master;
424 UPDATE t1 SET b1 = 0, t="2005-09-09" WHERE b1 = 1;
425 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
426 id hex(b1) vc bc d f total y t
427 42 0 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-09-09 00:00:00
428 connection slave;
429 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
430 id hex(b1) vc bc d f total y t
431 42 0 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-09-09 00:00:00
432 connection master;
433 DELETE FROM t1 WHERE id = 42;
434 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
435 id hex(b1) vc bc d f total y t
436 connection slave;
437 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
438 id hex(b1) vc bc d f total y t
439 connection master;
440 connection master;
441 DROP TABLE t1;
442 connection slave;
443 include/rpl_end.inc