rpl_rewrt_db.result 3.09 KB
Newer Older
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
stop slave;
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
reset master;
reset slave;
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
start slave;
drop database if exists mysqltest1;
create database mysqltest1;
use mysqltest1;
create table t1 (a int);
insert into t1 values(9);
select * from mysqltest1.t1;
a
9
show databases like 'mysqltest1';
Database (mysqltest1)
mysqltest1
select * from test.t1;
a
9
drop table t1;
drop database mysqltest1;
unknown's avatar
unknown committed
23 24 25 26
drop database if exists rewrite;
create database rewrite;
use test;
create table t1 (a date, b date, c date not null, d date);
27
load data infile '../std_data_ln/loaddata1.dat' into table t1 fields terminated by ',';
unknown's avatar
unknown committed
28 29 30 31 32 33 34
Warnings:
Warning	1265	Data truncated for column 'a' at row 1
Warning	1265	Data truncated for column 'c' at row 1
Warning	1265	Data truncated for column 'd' at row 1
Warning	1265	Data truncated for column 'a' at row 2
Warning	1265	Data truncated for column 'b' at row 2
Warning	1265	Data truncated for column 'd' at row 2
35
load data infile '../std_data_ln/loaddata1.dat' into table t1 fields terminated by ',' IGNORE 2 LINES;
unknown's avatar
unknown committed
36 37 38 39 40 41 42
select * from rewrite.t1;
a	b	c	d
0000-00-00	NULL	0000-00-00	0000-00-00
0000-00-00	0000-00-00	0000-00-00	0000-00-00
2003-03-03	2003-03-03	2003-03-03	NULL
2003-03-03	2003-03-03	2003-03-03	NULL
truncate table t1;
43
load data infile '../std_data_ln/loaddata1.dat' into table t1 fields terminated by ',' LINES STARTING BY ',' (b,c,d);
unknown's avatar
unknown committed
44 45 46 47 48 49 50 51 52 53 54 55
Warnings:
Warning	1265	Data truncated for column 'c' at row 1
Warning	1265	Data truncated for column 'd' at row 1
Warning	1265	Data truncated for column 'b' at row 2
Warning	1265	Data truncated for column 'd' at row 2
select * from rewrite.t1;
a	b	c	d
NULL	NULL	0000-00-00	0000-00-00
NULL	0000-00-00	0000-00-00	0000-00-00
NULL	2003-03-03	2003-03-03	NULL
drop table t1;
create table t1 (a text, b text);
56
load data infile '../std_data_ln/loaddata2.dat' into table t1 fields terminated by ',' enclosed by '''';
unknown's avatar
unknown committed
57 58 59 60 61 62 63 64 65 66 67
Warnings:
Warning	1261	Row 3 doesn't contain data for all columns
select concat('|',a,'|'), concat('|',b,'|') from rewrite.t1;
concat('|',a,'|')	concat('|',b,'|')
|Field A|	|Field B|
|Field 1|	|Field 2' 
Field 3,'Field 4|
|Field 5' ,'Field 6|	NULL
|Field 6|	| 'Field 7'|
drop table t1;
create table t1 (a int, b char(10));
68
load data infile '../std_data_ln/loaddata3.dat' into table t1 fields terminated by '' enclosed by '' ignore 1 lines;
unknown's avatar
unknown committed
69
Warnings:
70
Warning	1366	Incorrect integer value: 'error      ' for column 'a' at row 3
unknown's avatar
unknown committed
71
Warning	1262	Row 3 was truncated; it contained more data than there were input columns
72
Warning	1366	Incorrect integer value: 'wrong end  ' for column 'a' at row 5
unknown's avatar
unknown committed
73 74 75 76 77 78 79 80 81
Warning	1262	Row 5 was truncated; it contained more data than there were input columns
select * from rewrite.t1;
a	b
1	row 1
2	row 2
0	1234567890
3	row 3
0	1234567890
truncate table t1;
82
load data infile '../std_data_ln/loaddata4.dat' into table t1 fields terminated by '' enclosed by '' lines terminated by '' ignore 1 lines;
unknown's avatar
unknown committed
83
Warnings:
84 85
Warning	1366	Incorrect integer value: '
' for column 'a' at row 4
unknown's avatar
unknown committed
86 87 88 89 90 91 92
Warning	1261	Row 4 doesn't contain data for all columns
select * from rewrite.t1;
a	b
1	row 1
2	row 2
3	row 3
0	
unknown's avatar
unknown committed
93
drop database rewrite;
unknown's avatar
unknown committed
94
drop table t1;