Debian Codegraph @

mysql-test/suite/rpl/r/rpl_multi_engine.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 drop table if exists t1;
7 CREATE TABLE t1 (id MEDIUMINT NOT NULL, b1 BIT(8), vc
8 VARCHAR(255), bc CHAR(255), d DECIMAL(10,4) DEFAULT 0, f FLOAT DEFAULT
9 0, total BIGINT UNSIGNED, y YEAR, t TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
10 ON UPDATE CURRENT_TIMESTAMP,PRIMARY KEY(id));
11 include/sync_slave_sql_with_master.inc
12 alter table t1 engine=myisam;
13 show create table t1;
14 Table Create Table
15 t1 CREATE TABLE `t1` (
16 `id` mediumint 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 unsigned DEFAULT NULL,
23 `y` year 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_0900_ai_ci
27 include/sync_slave_sql_with_master.inc
28 alter table t1 engine=myisam;
29 show create table t1;
30 Table Create Table
31 t1 CREATE TABLE `t1` (
32 `id` mediumint NOT NULL,
33 `b1` bit(8) DEFAULT NULL,
34 `vc` varchar(255) DEFAULT NULL,
35 `bc` char(255) DEFAULT NULL,
36 `d` decimal(10,4) DEFAULT '0.0000',
37 `f` float DEFAULT '0',
38 `total` bigint unsigned DEFAULT NULL,
39 `y` year DEFAULT NULL,
40 `t` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
41 PRIMARY KEY (`id`)
42 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
43 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");
44 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
45 id hex(b1) vc bc d f total y t
46 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
47 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
48 id hex(b1) vc bc d f total y t
49 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
50 UPDATE t1 SET b1 = 0, t="2005-09-09" WHERE b1 = 1;
51 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
52 id hex(b1) vc bc d f total y t
53 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
54 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
55 id hex(b1) vc bc d f total y t
56 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
57 DELETE FROM t1 WHERE id = 42;
58 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
59 id hex(b1) vc bc d f total y t
60 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
61 id hex(b1) vc bc d f total y t
62 alter table t1 engine=innodb;
63 show create table t1;
64 Table Create Table
65 t1 CREATE TABLE `t1` (
66 `id` mediumint NOT NULL,
67 `b1` bit(8) DEFAULT NULL,
68 `vc` varchar(255) DEFAULT NULL,
69 `bc` char(255) DEFAULT NULL,
70 `d` decimal(10,4) DEFAULT '0.0000',
71 `f` float DEFAULT '0',
72 `total` bigint unsigned DEFAULT NULL,
73 `y` year DEFAULT NULL,
74 `t` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
75 PRIMARY KEY (`id`)
76 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
77 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");
78 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
79 id hex(b1) vc bc d f total y t
80 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
81 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
82 id hex(b1) vc bc d f total y t
83 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
84 UPDATE t1 SET b1 = 0, t="2005-09-09" WHERE b1 = 1;
85 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
86 id hex(b1) vc bc d f total y t
87 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
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 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
91 DELETE FROM t1 WHERE id = 42;
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 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
95 id hex(b1) vc bc d f total y t
96 alter table t1 engine=memory;
97 show create table t1;
98 Table Create Table
99 t1 CREATE TABLE `t1` (
100 `id` mediumint NOT NULL,
101 `b1` bit(8) DEFAULT NULL,
102 `vc` varchar(255) DEFAULT NULL,
103 `bc` char(255) DEFAULT NULL,
104 `d` decimal(10,4) DEFAULT '0.0000',
105 `f` float DEFAULT '0',
106 `total` bigint unsigned DEFAULT NULL,
107 `y` year DEFAULT NULL,
108 `t` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
109 PRIMARY KEY (`id`)
110 ) ENGINE=MEMORY DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
111 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");
112 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
113 id hex(b1) vc bc d f total y t
114 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
115 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
116 id hex(b1) vc bc d f total y t
117 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
118 UPDATE t1 SET b1 = 0, t="2005-09-09" WHERE b1 = 1;
119 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
120 id hex(b1) vc bc d f total y t
121 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
122 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
123 id hex(b1) vc bc d f total y t
124 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
125 DELETE FROM t1 WHERE id = 42;
126 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
127 id hex(b1) vc bc d f total y t
128 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
129 id hex(b1) vc bc d f total y t
130 alter table t1 engine=memory;
131 show create table t1;
132 Table Create Table
133 t1 CREATE TABLE `t1` (
134 `id` mediumint NOT NULL,
135 `b1` bit(8) DEFAULT NULL,
136 `vc` varchar(255) DEFAULT NULL,
137 `bc` char(255) DEFAULT NULL,
138 `d` decimal(10,4) DEFAULT '0.0000',
139 `f` float DEFAULT '0',
140 `total` bigint unsigned DEFAULT NULL,
141 `y` year DEFAULT NULL,
142 `t` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
143 PRIMARY KEY (`id`)
144 ) ENGINE=MEMORY DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
145 include/sync_slave_sql_with_master.inc
146 alter table t1 engine=myisam;
147 show create table t1;
148 Table Create Table
149 t1 CREATE TABLE `t1` (
150 `id` mediumint NOT NULL,
151 `b1` bit(8) DEFAULT NULL,
152 `vc` varchar(255) DEFAULT NULL,
153 `bc` char(255) DEFAULT NULL,
154 `d` decimal(10,4) DEFAULT '0.0000',
155 `f` float DEFAULT '0',
156 `total` bigint unsigned DEFAULT NULL,
157 `y` year DEFAULT NULL,
158 `t` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
159 PRIMARY KEY (`id`)
160 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
161 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");
162 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
163 id hex(b1) vc bc d f total y t
164 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
165 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
166 id hex(b1) vc bc d f total y t
167 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
168 UPDATE t1 SET b1 = 0, t="2005-09-09" WHERE b1 = 1;
169 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
170 id hex(b1) vc bc d f total y t
171 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
172 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
173 id hex(b1) vc bc d f total y t
174 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
175 DELETE FROM t1 WHERE id = 42;
176 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
177 id hex(b1) vc bc d f total y t
178 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
179 id hex(b1) vc bc d f total y t
180 alter table t1 engine=innodb;
181 show create table t1;
182 Table Create Table
183 t1 CREATE TABLE `t1` (
184 `id` mediumint NOT NULL,
185 `b1` bit(8) DEFAULT NULL,
186 `vc` varchar(255) DEFAULT NULL,
187 `bc` char(255) DEFAULT NULL,
188 `d` decimal(10,4) DEFAULT '0.0000',
189 `f` float DEFAULT '0',
190 `total` bigint unsigned DEFAULT NULL,
191 `y` year DEFAULT NULL,
192 `t` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
193 PRIMARY KEY (`id`)
194 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
195 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");
196 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
197 id hex(b1) vc bc d f total y t
198 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
199 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
200 id hex(b1) vc bc d f total y t
201 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
202 UPDATE t1 SET b1 = 0, t="2005-09-09" WHERE b1 = 1;
203 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
204 id hex(b1) vc bc d f total y t
205 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
206 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
207 id hex(b1) vc bc d f total y t
208 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
209 DELETE FROM t1 WHERE id = 42;
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 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
213 id hex(b1) vc bc d f total y t
214 alter table t1 engine=memory;
215 show create table t1;
216 Table Create Table
217 t1 CREATE TABLE `t1` (
218 `id` mediumint 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 unsigned DEFAULT NULL,
225 `y` year DEFAULT NULL,
226 `t` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
227 PRIMARY KEY (`id`)
228 ) ENGINE=MEMORY DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
229 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");
230 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
231 id hex(b1) vc bc d f total y t
232 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
233 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
234 id hex(b1) vc bc d f total y t
235 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
236 UPDATE t1 SET b1 = 0, t="2005-09-09" WHERE b1 = 1;
237 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
238 id hex(b1) vc bc d f total y t
239 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
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 DELETE FROM t1 WHERE id = 42;
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 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
247 id hex(b1) vc bc d f total y t
248 alter table t1 engine=innodb;
249 show create table t1;
250 Table Create Table
251 t1 CREATE TABLE `t1` (
252 `id` mediumint NOT NULL,
253 `b1` bit(8) DEFAULT NULL,
254 `vc` varchar(255) DEFAULT NULL,
255 `bc` char(255) DEFAULT NULL,
256 `d` decimal(10,4) DEFAULT '0.0000',
257 `f` float DEFAULT '0',
258 `total` bigint unsigned DEFAULT NULL,
259 `y` year DEFAULT NULL,
260 `t` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
261 PRIMARY KEY (`id`)
262 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
263 include/sync_slave_sql_with_master.inc
264 alter table t1 engine=myisam;
265 show create table t1;
266 Table Create Table
267 t1 CREATE TABLE `t1` (
268 `id` mediumint NOT NULL,
269 `b1` bit(8) DEFAULT NULL,
270 `vc` varchar(255) DEFAULT NULL,
271 `bc` char(255) DEFAULT NULL,
272 `d` decimal(10,4) DEFAULT '0.0000',
273 `f` float DEFAULT '0',
274 `total` bigint unsigned DEFAULT NULL,
275 `y` year DEFAULT NULL,
276 `t` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
277 PRIMARY KEY (`id`)
278 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
279 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");
280 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
281 id hex(b1) vc bc d f total y t
282 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
283 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
284 id hex(b1) vc bc d f total y t
285 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
286 UPDATE t1 SET b1 = 0, t="2005-09-09" WHERE b1 = 1;
287 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
288 id hex(b1) vc bc d f total y t
289 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
290 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
291 id hex(b1) vc bc d f total y t
292 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
293 DELETE FROM t1 WHERE id = 42;
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 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
297 id hex(b1) vc bc d f total y t
298 alter table t1 engine=innodb;
299 show create table t1;
300 Table Create Table
301 t1 CREATE TABLE `t1` (
302 `id` mediumint 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 unsigned DEFAULT NULL,
309 `y` year 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_0900_ai_ci
313 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");
314 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
315 id hex(b1) vc bc d f total y t
316 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
317 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
318 id hex(b1) vc bc d f total y t
319 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
320 UPDATE t1 SET b1 = 0, t="2005-09-09" WHERE b1 = 1;
321 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
322 id hex(b1) vc bc d f total y t
323 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
324 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
325 id hex(b1) vc bc d f total y t
326 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
327 DELETE FROM t1 WHERE id = 42;
328 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
329 id hex(b1) vc bc d f total y t
330 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
331 id hex(b1) vc bc d f total y t
332 alter table t1 engine=memory;
333 show create table t1;
334 Table Create Table
335 t1 CREATE TABLE `t1` (
336 `id` mediumint NOT NULL,
337 `b1` bit(8) DEFAULT NULL,
338 `vc` varchar(255) DEFAULT NULL,
339 `bc` char(255) DEFAULT NULL,
340 `d` decimal(10,4) DEFAULT '0.0000',
341 `f` float DEFAULT '0',
342 `total` bigint unsigned DEFAULT NULL,
343 `y` year DEFAULT NULL,
344 `t` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
345 PRIMARY KEY (`id`)
346 ) ENGINE=MEMORY DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
347 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");
348 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
349 id hex(b1) vc bc d f total y t
350 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
351 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
352 id hex(b1) vc bc d f total y t
353 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
354 UPDATE t1 SET b1 = 0, t="2005-09-09" WHERE b1 = 1;
355 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
356 id hex(b1) vc bc d f total y t
357 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
358 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
359 id hex(b1) vc bc d f total y t
360 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
361 DELETE FROM t1 WHERE id = 42;
362 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
363 id hex(b1) vc bc d f total y t
364 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
365 id hex(b1) vc bc d f total y t
366 DROP TABLE t1;
367 include/sync_slave_sql_with_master.inc
368 include/rpl_end.inc