1
include/master-slave.inc
3
select last_insert_id();
6
create table t1(a int not null auto_increment, b int, primary key(a) );
7
load data infile '../../std_data/rpl_loaddata.dat' into table t1;
8
select last_insert_id();
11
create temporary table t2 (day date,id int(9),category enum('a','b','c'),name varchar(60));
12
load data infile '../../std_data/rpl_loaddata2.dat' into table t2 fields terminated by ',' optionally enclosed by '%' escaped by '@' lines terminated by '\n##\n' starting by '>' ignore 1 lines;
13
create table t3 (day date,id int(9),category enum('a','b','c'),name varchar(60));
14
insert into t3 select * from t2;
21
2003-02-22 2461 b a a a @ % ' " a
22
2003-03-22 2161 c asdf
23
2003-03-22 2416 a bbbbb
27
create table t1(a int, b int, unique(b));
28
insert into t1 values(1,10);
29
load data infile '../../std_data/rpl_loaddata.dat' into table t1;
30
call mtr.add_suppression("Slave SQL.*Error .Duplicate entry .10. for key .b.. on query.* Error_code: 1062");
31
call mtr.add_suppression("Slave SQL.*Query caused different errors on master and slave.*Error on master:.*error code=1062.*Error on slave:.*Error_code: 0");
32
include/wait_for_slave_sql_error_and_skip.inc [errno=1062]
33
include/check_slave_no_error.inc
37
load data infile '../../std_data/rpl_loaddata.dat' into table t1;
38
include/wait_for_slave_sql_error.inc [errno=1062]
39
include/stop_slave_io.inc
40
change master to master_user='test';
41
change master to master_user='root';
42
include/check_slave_no_error.inc
43
set global sql_slave_skip_counter=1;
48
load data infile '../../std_data/rpl_loaddata.dat' into table t1;
49
include/wait_for_slave_sql_error.inc [errno=1062]
52
include/check_slave_no_error.inc
54
create table t2 (day date,id int(9),category enum('a','b','c'),name varchar(60),
55
unique(day)) engine=MyISAM;
56
load data infile '../../std_data/rpl_loaddata2.dat' into table t2 fields
57
terminated by ',' optionally enclosed by '%' escaped by '@' lines terminated by
58
'\n##\n' starting by '>' ignore 1 lines;
59
ERROR 23000: Duplicate entry '2003-03-22' for key 'day'
62
2003-02-22 2461 b a a a @ % ' " a
63
2003-03-22 2161 c asdf
67
2003-02-22 2461 b a a a @ % ' " a
68
2003-03-22 2161 c asdf
69
alter table t2 drop key day;
71
load data infile '../../std_data/rpl_loaddata2.dat' into table t2 fields
72
terminated by ',' optionally enclosed by '%' escaped by '@' lines terminated by
73
'\n##\n' starting by '>' ignore 1 lines;
74
ERROR 23000: Duplicate entry '2003-03-22' for key 'day'
75
include/wait_for_slave_sql_error.inc [errno=0]
78
CREATE TABLE t1 (word CHAR(20) NOT NULL PRIMARY KEY) ENGINE=INNODB;
79
LOAD DATA INFILE "../../std_data/words.dat" INTO TABLE t1;
80
ERROR 23000: Duplicate entry 'Aarhus' for key 'PRIMARY'
83
drop database if exists b48297_db1;
84
drop database if exists b42897_db2;
85
create database b48297_db1;
86
create database b42897_db2;
88
CREATE TABLE t1 (c1 VARCHAR(256)) engine=MyISAM;;
90
### assertion: works with cross-referenced database
91
LOAD DATA LOCAL INFILE 'MYSQLTEST_VARDIR/std_data/loaddata5.dat' INTO TABLE b48297_db1.t1;
93
### assertion: works with fully qualified name on current database
94
LOAD DATA LOCAL INFILE 'MYSQLTEST_VARDIR/std_data/loaddata5.dat' INTO TABLE b48297_db1.t1;
95
### assertion: works without fully qualified name on current database
96
LOAD DATA LOCAL INFILE 'MYSQLTEST_VARDIR/std_data/loaddata5.dat' INTO TABLE t1;
97
### create connection without default database
98
### connect (conn2,localhost,root,,*NO-ONE*);
99
### assertion: works without stating the default database
100
LOAD DATA LOCAL INFILE 'MYSQLTEST_VARDIR/std_data/loaddata5.dat' INTO TABLE b48297_db1.t1;
101
### disconnect and switch back to master connection
103
include/diff_tables.inc [master:b48297_db1.t1, slave:b48297_db1.t1]
104
DROP DATABASE b48297_db1;
105
DROP DATABASE b42897_db2;
106
include/rpl_reset.inc
108
CREATE TABLE t1 (`key` TEXT, `text` TEXT);
109
LOAD DATA INFILE '../../std_data/loaddata2.dat' REPLACE INTO TABLE `t1` FIELDS TERMINATED BY ',';