| blob | 9a77ae6ca195834d9decf422c054230dc783f3b5 |
1 stop slave;
2 drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
3 reset master;
4 reset slave;
5 drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
6 start slave;
7 set binlog_format=row;
8 CREATE TABLE t1 (f1 INT, f2 INT, f3 INT PRIMARY KEY, f4 CHAR(20),
9 /* extra */
10 f5 FLOAT DEFAULT '2.00',
11 f6 CHAR(4) DEFAULT 'TEST',
12 f7 INT DEFAULT '0',
13 f8 TEXT,
14 f9 LONGBLOB,
15 f10 BIT(63),
16 f11 VARBINARY(64))
17 ENGINE='MyISAM';
18 alter table t1 drop f5, drop f6, drop f7, drop f8, drop f9, drop f10, drop f11;
19 INSERT into t1 values (1, 1, 1, 'first', 1.0, 'yksi', 1, 'lounge of happiness', 'very fat blob', b'01010101010101', 0x123456);
20 INSERT into t1 values (2, 2, 2, 'second', 2.0, 'kaks', 2, 'got stolen from the paradise', 'very fat blob', b'01010101010101', 0x123456), (3, 3, 3, 'third', 3.0, 'kolm', 3, 'got stolen from the paradise', 'very fat blob', b'01010101010101', 0x123456);
21 update t1 set f4= 'next' where f1=1;
22 delete from t1 where f1=1;
23 select * from t1 order by f3;
24 f1 f2 f3 f4 f5 f6 f7 f8 f9 f10 f11
27 show slave status;;
28 Slave_IO_State #
29 Master_Host 127.0.0.1
30 Master_User root
31 Master_Port #
32 Connect_Retry 1
33 Master_Log_File master-bin.000001
34 Read_Master_Log_Pos #
35 Relay_Log_File #
36 Relay_Log_Pos #
37 Relay_Master_Log_File master-bin.000001
38 Slave_IO_Running Yes
39 Slave_SQL_Running Yes
40 Replicate_Do_DB
41 Replicate_Ignore_DB
42 Replicate_Do_Table
43 Replicate_Ignore_Table
44 Replicate_Wild_Do_Table
45 Replicate_Wild_Ignore_Table
46 Last_Errno 0
47 Last_Error
48 Skip_Counter 0
49 Exec_Master_Log_Pos #
50 Relay_Log_Space #
51 Until_Condition None
52 Until_Log_File
53 Until_Log_Pos 0
54 Master_SSL_Allowed No
55 Master_SSL_CA_File
56 Master_SSL_CA_Path
57 Master_SSL_Cert
58 Master_SSL_Cipher
59 Master_SSL_Key
60 Seconds_Behind_Master #
61 Master_SSL_Verify_Server_Cert No
62 select * from t1 order by f3;
63 f1 f2 f3 f4
64 2 2 2 second
65 3 3 3 third
66 CREATE TABLE t2 (f1 INT, f2 INT, f3 INT PRIMARY KEY, f4 CHAR(20),
67 /* extra */
68 f5 DOUBLE DEFAULT '2.00',
69 f6 ENUM('a', 'b', 'c') default 'a',
70 f7 DECIMAL(17,9) default '1000.00',
71 f8 MEDIUMBLOB,
72 f9 NUMERIC(6,4) default '2000.00',
73 f10 VARCHAR(1024),
74 f11 BINARY(20) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
75 f12 SET('a', 'b', 'c') default 'b')
76 ENGINE='MyISAM';
77 Warnings:
78 Warning 1264 Out of range value for column 'f9' at row 1
79 CREATE TABLE t3 (f1 INT, f2 INT, f3 INT PRIMARY KEY, f4 CHAR(20),
80 /* extra */
81 f5 DOUBLE DEFAULT '2.00',
82 f6 ENUM('a', 'b', 'c') default 'a',
83 f8 MEDIUMBLOB,
84 f10 VARCHAR(1024),
85 f11 BINARY(20) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
86 f12 SET('a', 'b', 'c') default 'b')
87 ENGINE='MyISAM';
88 CREATE TABLE t4 (f1 INT, f2 INT, f3 INT PRIMARY KEY, f4 CHAR(20),
89 /* extra */
90 f5 DOUBLE DEFAULT '2.00',
91 f6 DECIMAL(17,9) default '1000.00',
92 f7 MEDIUMBLOB,
93 f8 NUMERIC(6,4) default '2000.00',
94 f9 VARCHAR(1024),
95 f10 BINARY(20) not null default '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
96 f11 CHAR(255))
97 ENGINE='MyISAM';
98 Warnings:
99 Warning 1264 Out of range value for column 'f8' at row 1
100 CREATE TABLE t31 (f1 INT, f2 INT, f3 INT PRIMARY KEY, f4 CHAR(20),
101 /* extra */
102 f5 BIGINT,
103 f6 BLOB,
104 f7 DATE,
105 f8 DATETIME,
106 f9 FLOAT,
107 f10 INT,
108 f11 LONGBLOB,
109 f12 LONGTEXT,
110 f13 MEDIUMBLOB,
111 f14 MEDIUMINT,
112 f15 MEDIUMTEXT,
113 f16 REAL,
114 f17 SMALLINT,
115 f18 TEXT,
116 f19 TIME,
117 f20 TIMESTAMP,
118 f21 TINYBLOB,
119 f22 TINYINT,
120 f23 TINYTEXT,
121 f24 YEAR,
122 f25 BINARY(255),
123 f26 BIT(64),
124 f27 CHAR(255),
125 f28 DECIMAL(30,7),
126 f29 DOUBLE,
127 f30 ENUM ('a','b', 'c') default 'a',
128 f31 FLOAT,
129 f32 NUMERIC(17,9),
130 f33 SET ('a', 'b', 'c') default 'b',
131 f34 VARBINARY(1025),
132 f35 VARCHAR(257)
133 ) ENGINE='MyISAM';
134 alter table t2 drop f5, drop f6, drop f7, drop f8, drop f9, drop f10, drop f11, drop
135 f12;
136 alter table t3 drop f5, drop f6, drop f8, drop f10, drop f11, drop f12;
137 alter table t4 drop f5, drop f6, drop f7, drop f8, drop f9, drop f10, drop f11;
138 alter table t31
139 drop f5, drop f6, drop f7, drop f8, drop f9, drop f10, drop f11,
140 drop f12, drop f13, drop f14, drop f15, drop f16, drop f17, drop f18,
141 drop f19, drop f20, drop f21, drop f22, drop f23, drop f24, drop f25,
142 drop f26, drop f27, drop f28, drop f29, drop f30, drop f31, drop f32,
143 drop f33, drop f34, drop f35;
144 INSERT into t2 set f1=1, f2=1, f3=1, f4='first', f8='f8: medium size blob', f10='f10:
145 some var char';
146 INSERT into t2 values (2, 2, 2, 'second',
147 2.0, 'b', 2000.0002, 'f8: medium size blob', 2000, 'f10: some var char',
148 '01234567', 'c'),
149 (3, 3, 3, 'third',
150 3.0, 'b', 3000.0003, 'f8: medium size blob', 3000, 'f10: some var char',
151 '01234567', 'c');
152 Warnings:
153 Warning 1264 Out of range value for column 'f9' at row 1
154 Warning 1264 Out of range value for column 'f9' at row 2
155 INSERT into t3 set f1=1, f2=1, f3=1, f4='first', f10='f10: some var char';
156 INSERT into t4 set f1=1, f2=1, f3=1, f4='first', f7='f7: medium size blob', f10='f10:
157 binary data';
158 INSERT into t31 set f1=1, f2=1, f3=1, f4='first';
159 INSERT into t31 set f1=1, f2=1, f3=2, f4='second',
160 f9=2.2, f10='seven samurai', f28=222.222, f35='222';
161 Warnings:
162 Warning 1366 Incorrect integer value: 'seven samurai' for column 'f10' at row 1
163 INSERT into t31 values (1, 1, 3, 'third',
164 /* f5 BIGINT, */ 333333333333333333333333,
165 /* f6 BLOB, */ '3333333333333333333333',
166 /* f7 DATE, */ '2007-07-18',
167 /* f8 DATETIME, */ "2007-07-18",
168 /* f9 FLOAT, */ 3.33333333,
169 /* f10 INT, */ 333333333,
170 /* f11 LONGBLOB, */ '3333333333333333333',
171 /* f12 LONGTEXT, */ '3333333333333333333',
172 /* f13 MEDIUMBLOB, */ '3333333333333333333',
173 /* f14 MEDIUMINT, */ 33,
174 /* f15 MEDIUMTEXT, */ 3.3,
175 /* f16 REAL, */ 3.3,
176 /* f17 SMALLINT, */ 3,
177 /* f18 TEXT, */ '33',
178 /* f19 TIME, */ '2:59:58.999',
179 /* f20 TIMESTAMP, */ 20000303000000,
180 /* f21 TINYBLOB, */ '3333',
181 /* f22 TINYINT, */ 3,
182 /* f23 TINYTEXT, */ '3',
183 /* f24 YEAR, */ 3000,
184 /* f25 BINARY(255), */ 'three_33333',
185 /* f26 BIT(64), */ b'011',
186 /* f27 CHAR(255), */ 'three',
187 /* f28 DECIMAL(30,7), */ 3.333,
188 /* f29 DOUBLE, */ 3.333333333333333333333333333,
189 /* f30 ENUM ('a','b','c')*/ 'c',
190 /* f31 FLOAT, */ 3.0,
191 /* f32 NUMERIC(17,9), */ 3.3333,
192 /* f33 SET ('a','b','c'),*/ 'c',
193 /*f34 VARBINARY(1025),*/ '3333 minus 3',
194 /*f35 VARCHAR(257),*/ 'three times three'
195 );
196 Warnings:
197 Warning 1264 Out of range value for column 'f5' at row 1
198 Warning 1264 Out of range value for column 'f24' at row 1
199 INSERT into t31 values (1, 1, 4, 'fourth',
200 /* f5 BIGINT, */ 333333333333333333333333,
201 /* f6 BLOB, */ '3333333333333333333333',
202 /* f7 DATE, */ '2007-07-18',
203 /* f8 DATETIME, */ "2007-07-18",
204 /* f9 FLOAT, */ 3.33333333,
205 /* f10 INT, */ 333333333,
206 /* f11 LONGBLOB, */ '3333333333333333333',
207 /* f12 LONGTEXT, */ '3333333333333333333',
208 /* f13 MEDIUMBLOB, */ '3333333333333333333',
209 /* f14 MEDIUMINT, */ 33,
210 /* f15 MEDIUMTEXT, */ 3.3,
211 /* f16 REAL, */ 3.3,
212 /* f17 SMALLINT, */ 3,
213 /* f18 TEXT, */ '33',
214 /* f19 TIME, */ '2:59:58.999',
215 /* f20 TIMESTAMP, */ 20000303000000,
216 /* f21 TINYBLOB, */ '3333',
217 /* f22 TINYINT, */ 3,
218 /* f23 TINYTEXT, */ '3',
219 /* f24 YEAR, */ 3000,
220 /* f25 BINARY(255), */ 'three_33333',
221 /* f26 BIT(64), */ b'011',
222 /* f27 CHAR(255), */ 'three',
223 /* f28 DECIMAL(30,7), */ 3.333,
224 /* f29 DOUBLE, */ 3.333333333333333333333333333,
225 /* f30 ENUM ('a','b','c')*/ 'c',
226 /* f31 FLOAT, */ 3.0,
227 /* f32 NUMERIC(17,9), */ 3.3333,
228 /* f33 SET ('a','b','c'),*/ 'c',
229 /*f34 VARBINARY(1025),*/ '3333 minus 3',
230 /*f35 VARCHAR(257),*/ 'three times three'
231 ),
232 (1, 1, 5, 'fifth',
233 /* f5 BIGINT, */ 333333333333333333333333,
234 /* f6 BLOB, */ '3333333333333333333333',
235 /* f7 DATE, */ '2007-07-18',
236 /* f8 DATETIME, */ "2007-07-18",
237 /* f9 FLOAT, */ 3.33333333,
238 /* f10 INT, */ 333333333,
239 /* f11 LONGBLOB, */ '3333333333333333333',
240 /* f12 LONGTEXT, */ '3333333333333333333',
241 /* f13 MEDIUMBLOB, */ '3333333333333333333',
242 /* f14 MEDIUMINT, */ 33,
243 /* f15 MEDIUMTEXT, */ 3.3,
244 /* f16 REAL, */ 3.3,
245 /* f17 SMALLINT, */ 3,
246 /* f18 TEXT, */ '33',
247 /* f19 TIME, */ '2:59:58.999',
248 /* f20 TIMESTAMP, */ 20000303000000,
249 /* f21 TINYBLOB, */ '3333',
250 /* f22 TINYINT, */ 3,
251 /* f23 TINYTEXT, */ '3',
252 /* f24 YEAR, */ 3000,
253 /* f25 BINARY(255), */ 'three_33333',
254 /* f26 BIT(64), */ b'011',
255 /* f27 CHAR(255), */ 'three',
256 /* f28 DECIMAL(30,7), */ 3.333,
257 /* f29 DOUBLE, */ 3.333333333333333333333333333,
258 /* f30 ENUM ('a','b','c')*/ 'c',
259 /* f31 FLOAT, */ 3.0,
260 /* f32 NUMERIC(17,9), */ 3.3333,
261 /* f33 SET ('a','b','c'),*/ 'c',
262 /*f34 VARBINARY(1025),*/ '3333 minus 3',
263 /*f35 VARCHAR(257),*/ 'three times three'
264 ),
265 (1, 1, 6, 'sixth',
266 /* f5 BIGINT, */ NULL,
267 /* f6 BLOB, */ '3333333333333333333333',
268 /* f7 DATE, */ '2007-07-18',
269 /* f8 DATETIME, */ "2007-07-18",
270 /* f9 FLOAT, */ 3.33333333,
271 /* f10 INT, */ 333333333,
272 /* f11 LONGBLOB, */ '3333333333333333333',
273 /* f12 LONGTEXT, */ '3333333333333333333',
274 /* f13 MEDIUMBLOB, */ '3333333333333333333',
275 /* f14 MEDIUMINT, */ 33,
276 /* f15 MEDIUMTEXT, */ 3.3,
277 /* f16 REAL, */ 3.3,
278 /* f17 SMALLINT, */ 3,
279 /* f18 TEXT, */ '33',
280 /* f19 TIME, */ '2:59:58.999',
281 /* f20 TIMESTAMP, */ 20000303000000,
282 /* f21 TINYBLOB, */ '3333',
283 /* f22 TINYINT, */ 3,
284 /* f23 TINYTEXT, */ '3',
285 /* f24 YEAR, */ 3000,
286 /* f25 BINARY(255), */ 'three_33333',
287 /* f26 BIT(64), */ b'011',
288 /* f27 CHAR(255), */ 'three',
289 /* f28 DECIMAL(30,7), */ 3.333,
290 /* f29 DOUBLE, */ 3.333333333333333333333333333,
291 /* f30 ENUM ('a','b','c')*/ 'c',
292 /* f31 FLOAT, */ 3.0,
293 /* f32 NUMERIC(17,9), */ 3.3333,
294 /* f33 SET ('a','b','c'),*/ 'c',
295 /*f34 VARBINARY(1025),*/ '3333 minus 3',
296 /*f35 VARCHAR(257),*/ NULL
297 );
298 Warnings:
299 Warning 1264 Out of range value for column 'f5' at row 1
300 Warning 1264 Out of range value for column 'f24' at row 1
301 Warning 1264 Out of range value for column 'f5' at row 2
302 Warning 1264 Out of range value for column 'f24' at row 2
303 Warning 1264 Out of range value for column 'f24' at row 3
304 select * from t1 order by f3;
305 f1 f2 f3 f4
306 2 2 2 second
307 3 3 3 third
308 select * from t2 order by f1;
309 f1 f2 f3 f4
310 1 1 1 first
311 2 2 2 second
312 3 3 3 third
313 select * from t3 order by f1;
314 f1 f2 f3 f4
315 1 1 1 first
316 select * from t4 order by f1;
317 f1 f2 f3 f4
318 1 1 1 first
319 select * from t31 order by f1;
320 f1 f2 f3 f4
321 1 1 1 first
322 1 1 2 second
323 1 1 3 third
324 1 1 4 fourth
325 1 1 5 fifth
326 1 1 6 sixth
327 update t31 set f5=555555555555555 where f3=6;
328 update t31 set f2=2 where f3=2;
329 update t31 set f1=NULL where f3=1;
330 update t31 set f3=NULL, f27=NULL, f35='f35 new value' where f3=3;
331 Warnings:
332 Warning 1048 Column 'f3' cannot be null
333 delete from t1;
334 delete from t2;
335 delete from t3;
336 delete from t4;
337 delete from t31;
338 select * from t31;
339 f1 f2 f3 f4
340 show slave status;;
341 Slave_IO_State #
342 Master_Host 127.0.0.1
343 Master_User root
344 Master_Port #
345 Connect_Retry 1
346 Master_Log_File master-bin.000001
347 Read_Master_Log_Pos #
348 Relay_Log_File #
349 Relay_Log_Pos #
350 Relay_Master_Log_File master-bin.000001
351 Slave_IO_Running Yes
352 Slave_SQL_Running Yes
353 Replicate_Do_DB
354 Replicate_Ignore_DB
355 Replicate_Do_Table
356 Replicate_Ignore_Table
357 Replicate_Wild_Do_Table
358 Replicate_Wild_Ignore_Table
359 Last_Errno 0
360 Last_Error
361 Skip_Counter 0
362 Exec_Master_Log_Pos #
363 Relay_Log_Space #
364 Until_Condition None
365 Until_Log_File
366 Until_Log_Pos 0
367 Master_SSL_Allowed No
368 Master_SSL_CA_File
369 Master_SSL_CA_Path
370 Master_SSL_Cert
371 Master_SSL_Cipher
372 Master_SSL_Key
373 Seconds_Behind_Master #
374 Master_SSL_Verify_Server_Cert No
375 set binlog_format=statement;
376 CREATE TABLE t1 (f1 INT, f2 INT, f3 INT PRIMARY KEY, f4 CHAR(20),
377 /* extra */
378 f5 FLOAT DEFAULT '2.00',
379 f6 CHAR(4) DEFAULT 'TEST',
380 f7 INT DEFAULT '0',
381 f8 TEXT,
382 f9 LONGBLOB,
383 f10 BIT(63),
384 f11 VARBINARY(64))
385 ENGINE='MyISAM';
386 alter table t1 drop f5, drop f6, drop f7, drop f8, drop f9, drop f10, drop f11;
387 INSERT into t1 values (1, 1, 1, 'first', 1.0, 'yksi', 1, 'lounge of happiness', 'very fat blob', b'01010101010101', 0x123456);
388 INSERT into t1 values (2, 2, 2, 'second', 2.0, 'kaks', 2, 'got stolen from the paradise', 'very fat blob', b'01010101010101', 0x123456), (3, 3, 3, 'third', 3.0, 'kolm', 3, 'got stolen from the paradise', 'very fat blob', b'01010101010101', 0x123456);
389 update t1 set f4= 'next' where f1=1;
390 delete from t1 where f1=1;
391 select * from t1 order by f3;
392 f1 f2 f3 f4 f5 f6 f7 f8 f9 f10 f11
395 show slave status;;
396 Slave_IO_State #
397 Master_Host 127.0.0.1
398 Master_User root
399 Master_Port #
400 Connect_Retry 1
401 Master_Log_File master-bin.000001
402 Read_Master_Log_Pos #
403 Relay_Log_File #
404 Relay_Log_Pos #
405 Relay_Master_Log_File master-bin.000001
406 Slave_IO_Running Yes
407 Slave_SQL_Running Yes
408 Replicate_Do_DB
409 Replicate_Ignore_DB
410 Replicate_Do_Table
411 Replicate_Ignore_Table
412 Replicate_Wild_Do_Table
413 Replicate_Wild_Ignore_Table
414 Last_Errno 0
415 Last_Error
416 Skip_Counter 0
417 Exec_Master_Log_Pos #
418 Relay_Log_Space #
419 Until_Condition None
420 Until_Log_File
421 Until_Log_Pos 0
422 Master_SSL_Allowed No
423 Master_SSL_CA_File
424 Master_SSL_CA_Path
425 Master_SSL_Cert
426 Master_SSL_Cipher
427 Master_SSL_Key
428 Seconds_Behind_Master #
429 Master_SSL_Verify_Server_Cert No
430 select * from t1 order by f3;
431 f1 f2 f3 f4
432 2 2 2 second
433 3 3 3 third
434 CREATE TABLE t2 (f1 INT, f2 INT, f3 INT PRIMARY KEY, f4 CHAR(20),
435 /* extra */
436 f5 DOUBLE DEFAULT '2.00',
437 f6 ENUM('a', 'b', 'c') default 'a',
438 f7 DECIMAL(17,9) default '1000.00',
439 f8 MEDIUMBLOB,
440 f9 NUMERIC(6,4) default '2000.00',
441 f10 VARCHAR(1024),
442 f11 BINARY(20) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
443 f12 SET('a', 'b', 'c') default 'b')
444 ENGINE='MyISAM';
445 Warnings:
446 Warning 1264 Out of range value for column 'f9' at row 1
447 CREATE TABLE t3 (f1 INT, f2 INT, f3 INT PRIMARY KEY, f4 CHAR(20),
448 /* extra */
449 f5 DOUBLE DEFAULT '2.00',
450 f6 ENUM('a', 'b', 'c') default 'a',
451 f8 MEDIUMBLOB,
452 f10 VARCHAR(1024),
453 f11 BINARY(20) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
454 f12 SET('a', 'b', 'c') default 'b')
455 ENGINE='MyISAM';
456 CREATE TABLE t4 (f1 INT, f2 INT, f3 INT PRIMARY KEY, f4 CHAR(20),
457 /* extra */
458 f5 DOUBLE DEFAULT '2.00',
459 f6 DECIMAL(17,9) default '1000.00',
460 f7 MEDIUMBLOB,
461 f8 NUMERIC(6,4) default '2000.00',
462 f9 VARCHAR(1024),
463 f10 BINARY(20) not null default '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
464 f11 CHAR(255))
465 ENGINE='MyISAM';
466 Warnings:
467 Warning 1264 Out of range value for column 'f8' at row 1
468 CREATE TABLE t31 (f1 INT, f2 INT, f3 INT PRIMARY KEY, f4 CHAR(20),
469 /* extra */
470 f5 BIGINT,
471 f6 BLOB,
472 f7 DATE,
473 f8 DATETIME,
474 f9 FLOAT,
475 f10 INT,
476 f11 LONGBLOB,
477 f12 LONGTEXT,
478 f13 MEDIUMBLOB,
479 f14 MEDIUMINT,
480 f15 MEDIUMTEXT,
481 f16 REAL,
482 f17 SMALLINT,
483 f18 TEXT,
484 f19 TIME,
485 f20 TIMESTAMP,
486 f21 TINYBLOB,
487 f22 TINYINT,
488 f23 TINYTEXT,
489 f24 YEAR,
490 f25 BINARY(255),
491 f26 BIT(64),
492 f27 CHAR(255),
493 f28 DECIMAL(30,7),
494 f29 DOUBLE,
495 f30 ENUM ('a','b', 'c') default 'a',
496 f31 FLOAT,
497 f32 NUMERIC(17,9),
498 f33 SET ('a', 'b', 'c') default 'b',
499 f34 VARBINARY(1025),
500 f35 VARCHAR(257)
501 ) ENGINE='MyISAM';
502 alter table t2 drop f5, drop f6, drop f7, drop f8, drop f9, drop f10, drop f11, drop
503 f12;
504 alter table t3 drop f5, drop f6, drop f8, drop f10, drop f11, drop f12;
505 alter table t4 drop f5, drop f6, drop f7, drop f8, drop f9, drop f10, drop f11;
506 alter table t31
507 drop f5, drop f6, drop f7, drop f8, drop f9, drop f10, drop f11,
508 drop f12, drop f13, drop f14, drop f15, drop f16, drop f17, drop f18,
509 drop f19, drop f20, drop f21, drop f22, drop f23, drop f24, drop f25,
510 drop f26, drop f27, drop f28, drop f29, drop f30, drop f31, drop f32,
511 drop f33, drop f34, drop f35;
512 INSERT into t2 set f1=1, f2=1, f3=1, f4='first', f8='f8: medium size blob', f10='f10:
513 some var char';
514 INSERT into t2 values (2, 2, 2, 'second',
515 2.0, 'b', 2000.0002, 'f8: medium size blob', 2000, 'f10: some var char',
516 '01234567', 'c'),
517 (3, 3, 3, 'third',
518 3.0, 'b', 3000.0003, 'f8: medium size blob', 3000, 'f10: some var char',
519 '01234567', 'c');
520 Warnings:
521 Warning 1264 Out of range value for column 'f9' at row 1
522 Warning 1264 Out of range value for column 'f9' at row 2
523 INSERT into t3 set f1=1, f2=1, f3=1, f4='first', f10='f10: some var char';
524 INSERT into t4 set f1=1, f2=1, f3=1, f4='first', f7='f7: medium size blob', f10='f10:
525 binary data';
526 INSERT into t31 set f1=1, f2=1, f3=1, f4='first';
527 INSERT into t31 set f1=1, f2=1, f3=2, f4='second',
528 f9=2.2, f10='seven samurai', f28=222.222, f35='222';
529 Warnings:
530 Warning 1366 Incorrect integer value: 'seven samurai' for column 'f10' at row 1
531 INSERT into t31 values (1, 1, 3, 'third',
532 /* f5 BIGINT, */ 333333333333333333333333,
533 /* f6 BLOB, */ '3333333333333333333333',
534 /* f7 DATE, */ '2007-07-18',
535 /* f8 DATETIME, */ "2007-07-18",
536 /* f9 FLOAT, */ 3.33333333,
537 /* f10 INT, */ 333333333,
538 /* f11 LONGBLOB, */ '3333333333333333333',
539 /* f12 LONGTEXT, */ '3333333333333333333',
540 /* f13 MEDIUMBLOB, */ '3333333333333333333',
541 /* f14 MEDIUMINT, */ 33,
542 /* f15 MEDIUMTEXT, */ 3.3,
543 /* f16 REAL, */ 3.3,
544 /* f17 SMALLINT, */ 3,
545 /* f18 TEXT, */ '33',
546 /* f19 TIME, */ '2:59:58.999',
547 /* f20 TIMESTAMP, */ 20000303000000,
548 /* f21 TINYBLOB, */ '3333',
549 /* f22 TINYINT, */ 3,
550 /* f23 TINYTEXT, */ '3',
551 /* f24 YEAR, */ 3000,
552 /* f25 BINARY(255), */ 'three_33333',
553 /* f26 BIT(64), */ b'011',
554 /* f27 CHAR(255), */ 'three',
555 /* f28 DECIMAL(30,7), */ 3.333,
556 /* f29 DOUBLE, */ 3.333333333333333333333333333,
557 /* f30 ENUM ('a','b','c')*/ 'c',
558 /* f31 FLOAT, */ 3.0,
559 /* f32 NUMERIC(17,9), */ 3.3333,
560 /* f33 SET ('a','b','c'),*/ 'c',
561 /*f34 VARBINARY(1025),*/ '3333 minus 3',
562 /*f35 VARCHAR(257),*/ 'three times three'
563 );
564 Warnings:
565 Warning 1264 Out of range value for column 'f5' at row 1
566 Warning 1264 Out of range value for column 'f24' at row 1
567 INSERT into t31 values (1, 1, 4, 'fourth',
568 /* f5 BIGINT, */ 333333333333333333333333,
569 /* f6 BLOB, */ '3333333333333333333333',
570 /* f7 DATE, */ '2007-07-18',
571 /* f8 DATETIME, */ "2007-07-18",
572 /* f9 FLOAT, */ 3.33333333,
573 /* f10 INT, */ 333333333,
574 /* f11 LONGBLOB, */ '3333333333333333333',
575 /* f12 LONGTEXT, */ '3333333333333333333',
576 /* f13 MEDIUMBLOB, */ '3333333333333333333',
577 /* f14 MEDIUMINT, */ 33,
578 /* f15 MEDIUMTEXT, */ 3.3,
579 /* f16 REAL, */ 3.3,
580 /* f17 SMALLINT, */ 3,
581 /* f18 TEXT, */ '33',
582 /* f19 TIME, */ '2:59:58.999',
583 /* f20 TIMESTAMP, */ 20000303000000,
584 /* f21 TINYBLOB, */ '3333',
585 /* f22 TINYINT, */ 3,
586 /* f23 TINYTEXT, */ '3',
587 /* f24 YEAR, */ 3000,
588 /* f25 BINARY(255), */ 'three_33333',
589 /* f26 BIT(64), */ b'011',
590 /* f27 CHAR(255), */ 'three',
591 /* f28 DECIMAL(30,7), */ 3.333,
592 /* f29 DOUBLE, */ 3.333333333333333333333333333,
593 /* f30 ENUM ('a','b','c')*/ 'c',
594 /* f31 FLOAT, */ 3.0,
595 /* f32 NUMERIC(17,9), */ 3.3333,
596 /* f33 SET ('a','b','c'),*/ 'c',
597 /*f34 VARBINARY(1025),*/ '3333 minus 3',
598 /*f35 VARCHAR(257),*/ 'three times three'
599 ),
600 (1, 1, 5, 'fifth',
601 /* f5 BIGINT, */ 333333333333333333333333,
602 /* f6 BLOB, */ '3333333333333333333333',
603 /* f7 DATE, */ '2007-07-18',
604 /* f8 DATETIME, */ "2007-07-18",
605 /* f9 FLOAT, */ 3.33333333,
606 /* f10 INT, */ 333333333,
607 /* f11 LONGBLOB, */ '3333333333333333333',
608 /* f12 LONGTEXT, */ '3333333333333333333',
609 /* f13 MEDIUMBLOB, */ '3333333333333333333',
610 /* f14 MEDIUMINT, */ 33,
611 /* f15 MEDIUMTEXT, */ 3.3,
612 /* f16 REAL, */ 3.3,
613 /* f17 SMALLINT, */ 3,
614 /* f18 TEXT, */ '33',
615 /* f19 TIME, */ '2:59:58.999',
616 /* f20 TIMESTAMP, */ 20000303000000,
617 /* f21 TINYBLOB, */ '3333',
618 /* f22 TINYINT, */ 3,
619 /* f23 TINYTEXT, */ '3',
620 /* f24 YEAR, */ 3000,
621 /* f25 BINARY(255), */ 'three_33333',
622 /* f26 BIT(64), */ b'011',
623 /* f27 CHAR(255), */ 'three',
624 /* f28 DECIMAL(30,7), */ 3.333,
625 /* f29 DOUBLE, */ 3.333333333333333333333333333,
626 /* f30 ENUM ('a','b','c')*/ 'c',
627 /* f31 FLOAT, */ 3.0,
628 /* f32 NUMERIC(17,9), */ 3.3333,
629 /* f33 SET ('a','b','c'),*/ 'c',
630 /*f34 VARBINARY(1025),*/ '3333 minus 3',
631 /*f35 VARCHAR(257),*/ 'three times three'
632 ),
633 (1, 1, 6, 'sixth',
634 /* f5 BIGINT, */ NULL,
635 /* f6 BLOB, */ '3333333333333333333333',
636 /* f7 DATE, */ '2007-07-18',
637 /* f8 DATETIME, */ "2007-07-18",
638 /* f9 FLOAT, */ 3.33333333,
639 /* f10 INT, */ 333333333,
640 /* f11 LONGBLOB, */ '3333333333333333333',
641 /* f12 LONGTEXT, */ '3333333333333333333',
642 /* f13 MEDIUMBLOB, */ '3333333333333333333',
643 /* f14 MEDIUMINT, */ 33,
644 /* f15 MEDIUMTEXT, */ 3.3,
645 /* f16 REAL, */ 3.3,
646 /* f17 SMALLINT, */ 3,
647 /* f18 TEXT, */ '33',
648 /* f19 TIME, */ '2:59:58.999',
649 /* f20 TIMESTAMP, */ 20000303000000,
650 /* f21 TINYBLOB, */ '3333',
651 /* f22 TINYINT, */ 3,
652 /* f23 TINYTEXT, */ '3',
653 /* f24 YEAR, */ 3000,
654 /* f25 BINARY(255), */ 'three_33333',
655 /* f26 BIT(64), */ b'011',
656 /* f27 CHAR(255), */ 'three',
657 /* f28 DECIMAL(30,7), */ 3.333,
658 /* f29 DOUBLE, */ 3.333333333333333333333333333,
659 /* f30 ENUM ('a','b','c')*/ 'c',
660 /* f31 FLOAT, */ 3.0,
661 /* f32 NUMERIC(17,9), */ 3.3333,
662 /* f33 SET ('a','b','c'),*/ 'c',
663 /*f34 VARBINARY(1025),*/ '3333 minus 3',
664 /*f35 VARCHAR(257),*/ NULL
665 );
666 Warnings:
667 Warning 1264 Out of range value for column 'f5' at row 1
668 Warning 1264 Out of range value for column 'f24' at row 1
669 Warning 1264 Out of range value for column 'f5' at row 2
670 Warning 1264 Out of range value for column 'f24' at row 2
671 Warning 1264 Out of range value for column 'f24' at row 3
672 select * from t1 order by f3;
673 f1 f2 f3 f4
674 2 2 2 second
675 3 3 3 third
676 select * from t2 order by f1;
677 f1 f2 f3 f4
678 1 1 1 first
679 2 2 2 second
680 3 3 3 third
681 select * from t3 order by f1;
682 f1 f2 f3 f4
683 1 1 1 first
684 select * from t4 order by f1;
685 f1 f2 f3 f4
686 1 1 1 first
687 select * from t31 order by f1;
688 f1 f2 f3 f4
689 1 1 1 first
690 1 1 2 second
691 1 1 3 third
692 1 1 4 fourth
693 1 1 5 fifth
694 1 1 6 sixth
695 update t31 set f5=555555555555555 where f3=6;
696 update t31 set f2=2 where f3=2;
697 update t31 set f1=NULL where f3=1;
698 update t31 set f3=NULL, f27=NULL, f35='f35 new value' where f3=3;
699 Warnings:
700 Warning 1048 Column 'f3' cannot be null
701 delete from t1;
702 delete from t2;
703 delete from t3;
704 delete from t4;
705 delete from t31;
706 select * from t31;
707 f1 f2 f3 f4
708 show slave status;;
709 Slave_IO_State #
710 Master_Host 127.0.0.1
711 Master_User root
712 Master_Port #
713 Connect_Retry 1
714 Master_Log_File master-bin.000001
715 Read_Master_Log_Pos #
716 Relay_Log_File #
717 Relay_Log_Pos #
718 Relay_Master_Log_File master-bin.000001
719 Slave_IO_Running Yes
720 Slave_SQL_Running Yes
721 Replicate_Do_DB
722 Replicate_Ignore_DB
723 Replicate_Do_Table
724 Replicate_Ignore_Table
725 Replicate_Wild_Do_Table
726 Replicate_Wild_Ignore_Table
727 Last_Errno 0
728 Last_Error
729 Skip_Counter 0
730 Exec_Master_Log_Pos #
731 Relay_Log_Space #
732 Until_Condition None
733 Until_Log_File
734 Until_Log_Pos 0
735 Master_SSL_Allowed No
736 Master_SSL_CA_File
737 Master_SSL_CA_Path
738 Master_SSL_Cert
739 Master_SSL_Cipher
740 Master_SSL_Key
741 Seconds_Behind_Master #
742 Master_SSL_Verify_Server_Cert No