1 include/master-slave.inc
3 drop table if exists t1;
4 CREATE TABLE t1 (id MEDIUMINT NOT NULL, b1 BIT(8), vc
5 VARCHAR(255), bc CHAR(255), d DECIMAL(10,4) DEFAULT 0, f FLOAT DEFAULT
6 0, total BIGINT UNSIGNED, y YEAR, t TIMESTAMP,PRIMARY KEY(id));
7 alter table t1 engine=myisam;
10 t1 CREATE TABLE `t1` (
11 `id` mediumint(9) NOT NULL,
12 `b1` bit(8) DEFAULT NULL,
13 `vc` varchar(255) DEFAULT NULL,
14 `bc` char(255) DEFAULT NULL,
15 `d` decimal(10,4) DEFAULT '0.0000',
16 `f` float DEFAULT '0',
17 `total` bigint(20) unsigned DEFAULT NULL,
18 `y` year(4) DEFAULT NULL,
19 `t` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
21 ) ENGINE=MyISAM DEFAULT CHARSET=latin1
22 alter table t1 engine=myisam;
25 t1 CREATE TABLE `t1` (
26 `id` mediumint(9) NOT NULL,
27 `b1` bit(8) DEFAULT NULL,
28 `vc` varchar(255) DEFAULT NULL,
29 `bc` char(255) DEFAULT NULL,
30 `d` decimal(10,4) DEFAULT '0.0000',
31 `f` float DEFAULT '0',
32 `total` bigint(20) unsigned DEFAULT NULL,
33 `y` year(4) DEFAULT NULL,
34 `t` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
36 ) ENGINE=MyISAM DEFAULT CHARSET=latin1
37 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");
38 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
39 id hex(b1) vc bc d f total y t
40 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
41 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
42 id hex(b1) vc bc d f total y t
43 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
44 UPDATE t1 SET b1 = 0, t="2005-09-09" WHERE b1 = 1;
45 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
46 id hex(b1) vc bc d f total y t
47 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
48 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
49 id hex(b1) vc bc d f total y t
50 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
51 DELETE FROM t1 WHERE id = 42;
52 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
53 id hex(b1) vc bc d f total y t
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 alter table t1 engine=innodb;
59 t1 CREATE TABLE `t1` (
60 `id` mediumint(9) NOT NULL,
61 `b1` bit(8) DEFAULT NULL,
62 `vc` varchar(255) DEFAULT NULL,
63 `bc` char(255) DEFAULT NULL,
64 `d` decimal(10,4) DEFAULT '0.0000',
65 `f` float DEFAULT '0',
66 `total` bigint(20) unsigned DEFAULT NULL,
67 `y` year(4) DEFAULT NULL,
68 `t` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
70 ) ENGINE=InnoDB DEFAULT CHARSET=latin1
71 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");
72 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
73 id hex(b1) vc bc d f total y t
74 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
75 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
76 id hex(b1) vc bc d f total y t
77 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
78 UPDATE t1 SET b1 = 0, t="2005-09-09" WHERE b1 = 1;
79 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
80 id hex(b1) vc bc d f total y t
81 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
82 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
83 id hex(b1) vc bc d f total y t
84 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
85 DELETE FROM t1 WHERE id = 42;
86 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
87 id hex(b1) vc bc d f total y t
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 alter table t1 engine=memory;
93 t1 CREATE TABLE `t1` (
94 `id` mediumint(9) NOT NULL,
95 `b1` bit(8) DEFAULT NULL,
96 `vc` varchar(255) DEFAULT NULL,
97 `bc` char(255) DEFAULT NULL,
98 `d` decimal(10,4) DEFAULT '0.0000',
99 `f` float DEFAULT '0',
100 `total` bigint(20) unsigned DEFAULT NULL,
101 `y` year(4) DEFAULT NULL,
102 `t` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
104 ) ENGINE=MEMORY DEFAULT CHARSET=latin1
105 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");
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 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
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 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
112 UPDATE t1 SET b1 = 0, t="2005-09-09" WHERE b1 = 1;
113 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
114 id hex(b1) vc bc d f total y t
115 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
116 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
117 id hex(b1) vc bc d f total y t
118 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
119 DELETE FROM t1 WHERE id = 42;
120 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
121 id hex(b1) vc bc d f total y t
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 alter table t1 engine=memory;
125 show create table t1;
127 t1 CREATE TABLE `t1` (
128 `id` mediumint(9) NOT NULL,
129 `b1` bit(8) DEFAULT NULL,
130 `vc` varchar(255) DEFAULT NULL,
131 `bc` char(255) DEFAULT NULL,
132 `d` decimal(10,4) DEFAULT '0.0000',
133 `f` float DEFAULT '0',
134 `total` bigint(20) unsigned DEFAULT NULL,
135 `y` year(4) DEFAULT NULL,
136 `t` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
138 ) ENGINE=MEMORY DEFAULT CHARSET=latin1
139 alter table t1 engine=myisam;
140 show create table t1;
142 t1 CREATE TABLE `t1` (
143 `id` mediumint(9) NOT NULL,
144 `b1` bit(8) DEFAULT NULL,
145 `vc` varchar(255) DEFAULT NULL,
146 `bc` char(255) DEFAULT NULL,
147 `d` decimal(10,4) DEFAULT '0.0000',
148 `f` float DEFAULT '0',
149 `total` bigint(20) unsigned DEFAULT NULL,
150 `y` year(4) DEFAULT NULL,
151 `t` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
153 ) ENGINE=MyISAM DEFAULT CHARSET=latin1
154 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");
155 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
156 id hex(b1) vc bc d f total y t
157 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
158 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
159 id hex(b1) vc bc d f total y t
160 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
161 UPDATE t1 SET b1 = 0, t="2005-09-09" WHERE b1 = 1;
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 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
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 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
168 DELETE FROM t1 WHERE id = 42;
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 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
172 id hex(b1) vc bc d f total y t
173 alter table t1 engine=innodb;
174 show create table t1;
176 t1 CREATE TABLE `t1` (
177 `id` mediumint(9) NOT NULL,
178 `b1` bit(8) DEFAULT NULL,
179 `vc` varchar(255) DEFAULT NULL,
180 `bc` char(255) DEFAULT NULL,
181 `d` decimal(10,4) DEFAULT '0.0000',
182 `f` float DEFAULT '0',
183 `total` bigint(20) unsigned DEFAULT NULL,
184 `y` year(4) DEFAULT NULL,
185 `t` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
187 ) ENGINE=InnoDB DEFAULT CHARSET=latin1
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 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
193 id hex(b1) vc bc d f total y t
194 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
195 UPDATE t1 SET b1 = 0, t="2005-09-09" WHERE b1 = 1;
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 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
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 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
202 DELETE FROM t1 WHERE id = 42;
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 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
206 id hex(b1) vc bc d f total y t
207 alter table t1 engine=memory;
208 show create table t1;
210 t1 CREATE TABLE `t1` (
211 `id` mediumint(9) NOT NULL,
212 `b1` bit(8) DEFAULT NULL,
213 `vc` varchar(255) DEFAULT NULL,
214 `bc` char(255) DEFAULT NULL,
215 `d` decimal(10,4) DEFAULT '0.0000',
216 `f` float DEFAULT '0',
217 `total` bigint(20) unsigned DEFAULT NULL,
218 `y` year(4) DEFAULT NULL,
219 `t` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
221 ) ENGINE=MEMORY DEFAULT CHARSET=latin1
222 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");
223 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
224 id hex(b1) vc bc d f total y t
225 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
226 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
227 id hex(b1) vc bc d f total y t
228 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
229 UPDATE t1 SET b1 = 0, t="2005-09-09" WHERE b1 = 1;
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 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
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 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
236 DELETE FROM t1 WHERE id = 42;
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 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
240 id hex(b1) vc bc d f total y t
241 alter table t1 engine=innodb;
242 show create table t1;
244 t1 CREATE TABLE `t1` (
245 `id` mediumint(9) NOT NULL,
246 `b1` bit(8) DEFAULT NULL,
247 `vc` varchar(255) DEFAULT NULL,
248 `bc` char(255) DEFAULT NULL,
249 `d` decimal(10,4) DEFAULT '0.0000',
250 `f` float DEFAULT '0',
251 `total` bigint(20) unsigned DEFAULT NULL,
252 `y` year(4) DEFAULT NULL,
253 `t` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
255 ) ENGINE=InnoDB DEFAULT CHARSET=latin1
256 alter table t1 engine=myisam;
257 show create table t1;
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,
270 ) ENGINE=MyISAM DEFAULT CHARSET=latin1
271 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");
272 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
273 id hex(b1) vc bc d f total y t
274 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
275 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
276 id hex(b1) vc bc d f total y t
277 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
278 UPDATE t1 SET b1 = 0, t="2005-09-09" WHERE b1 = 1;
279 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
280 id hex(b1) vc bc d f total y t
281 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
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 DELETE FROM t1 WHERE id = 42;
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 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
289 id hex(b1) vc bc d f total y t
290 alter table t1 engine=innodb;
291 show create table t1;
293 t1 CREATE TABLE `t1` (
294 `id` mediumint(9) NOT NULL,
295 `b1` bit(8) DEFAULT NULL,
296 `vc` varchar(255) DEFAULT NULL,
297 `bc` char(255) DEFAULT NULL,
298 `d` decimal(10,4) DEFAULT '0.0000',
299 `f` float DEFAULT '0',
300 `total` bigint(20) unsigned DEFAULT NULL,
301 `y` year(4) DEFAULT NULL,
302 `t` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
304 ) ENGINE=InnoDB DEFAULT CHARSET=latin1
305 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");
306 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
307 id hex(b1) vc bc d f total y t
308 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
309 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
310 id hex(b1) vc bc d f total y t
311 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
312 UPDATE t1 SET b1 = 0, t="2005-09-09" WHERE b1 = 1;
313 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
314 id hex(b1) vc bc d f total y t
315 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
316 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
317 id hex(b1) vc bc d f total y t
318 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
319 DELETE FROM t1 WHERE id = 42;
320 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
321 id hex(b1) vc bc d f total y t
322 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
323 id hex(b1) vc bc d f total y t
324 alter table t1 engine=memory;
325 show create table t1;
327 t1 CREATE TABLE `t1` (
328 `id` mediumint(9) NOT NULL,
329 `b1` bit(8) DEFAULT NULL,
330 `vc` varchar(255) DEFAULT NULL,
331 `bc` char(255) DEFAULT NULL,
332 `d` decimal(10,4) DEFAULT '0.0000',
333 `f` float DEFAULT '0',
334 `total` bigint(20) unsigned DEFAULT NULL,
335 `y` year(4) DEFAULT NULL,
336 `t` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
338 ) ENGINE=MEMORY DEFAULT CHARSET=latin1
339 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");
340 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
341 id hex(b1) vc bc d f total y t
342 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
343 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
344 id hex(b1) vc bc d f total y t
345 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
346 UPDATE t1 SET b1 = 0, t="2005-09-09" WHERE b1 = 1;
347 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
348 id hex(b1) vc bc d f total y t
349 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
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 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
353 DELETE FROM t1 WHERE id = 42;
354 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
355 id hex(b1) vc bc d f total y t
356 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
357 id hex(b1) vc bc d f total y t