1include/master-slave.inc 2[connection master] 3select last_insert_id(); 4last_insert_id() 50 6create table t1(a int not null auto_increment, b int, primary key(a) ); 7load data infile '../../std_data/rpl_loaddata.dat' into table t1; 8select last_insert_id(); 9last_insert_id() 101 11create temporary table t2 (day date,id int(9),category enum('a','b','c'),name varchar(60)); 12load 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; 13create table t3 (day date,id int(9),category enum('a','b','c'),name varchar(60)); 14insert into t3 select * from t2; 15connection slave; 16select * from t1; 17a b 181 10 192 15 20select * from t3; 21day id category name 222003-02-22 2461 b a a a @ % ' " a 232003-03-22 2161 c asdf 242003-03-22 2416 a bbbbb 25connection master; 26drop table t1; 27drop table t2; 28drop table t3; 29create table t1(a int, b int, unique(b)); 30connection slave; 31insert into t1 values(1,10); 32connection master; 33load data infile '../../std_data/rpl_loaddata.dat' into table t1; 34connection slave; 35call mtr.add_suppression("Slave SQL.*Error .Duplicate entry .10. for key .b.. on query.* error.* 1062"); 36call mtr.add_suppression("Slave SQL.*Query caused different errors on master and slave.*Error on master:.*error code=1062.*Error on slave:.*error.* 0"); 37include/wait_for_slave_sql_error_and_skip.inc [errno=1062] 38include/check_slave_no_error.inc 39connection master; 40set sql_log_bin=0; 41delete from t1; 42set sql_log_bin=1; 43load data infile '../../std_data/rpl_loaddata.dat' into table t1; 44connection slave; 45include/wait_for_slave_sql_error.inc [errno=1062] 46include/stop_slave_io.inc 47change master to master_user='test'; 48change master to master_user='root'; 49include/check_slave_no_error.inc 50set global sql_slave_skip_counter=1; 51start slave; 52connection master; 53set sql_log_bin=0; 54delete from t1; 55set sql_log_bin=1; 56load data infile '../../std_data/rpl_loaddata.dat' into table t1; 57connection slave; 58include/wait_for_slave_sql_error.inc [errno=1062] 59stop slave; 60reset slave; 61include/check_slave_no_error.inc 62connection master; 63reset master; 64create table t2 (day date,id int(9),category enum('a','b','c'),name varchar(60), 65unique(day)) engine=MyISAM; 66load data infile '../../std_data/rpl_loaddata2.dat' into table t2 fields 67terminated by ',' optionally enclosed by '%' escaped by '@' lines terminated by 68'\n##\n' starting by '>' ignore 1 lines; 69ERROR 23000: Duplicate entry '2003-03-22' for key 'day' 70select * from t2; 71day id category name 722003-02-22 2461 b a a a @ % ' " a 732003-03-22 2161 c asdf 74connection slave; 75start slave; 76select * from t2; 77day id category name 782003-02-22 2461 b a a a @ % ' " a 792003-03-22 2161 c asdf 80alter table t2 drop key day; 81connection master; 82delete from t2; 83load data infile '../../std_data/rpl_loaddata2.dat' into table t2 fields 84terminated by ',' optionally enclosed by '%' escaped by '@' lines terminated by 85'\n##\n' starting by '>' ignore 1 lines; 86ERROR 23000: Duplicate entry '2003-03-22' for key 'day' 87connection slave; 88include/wait_for_slave_sql_error.inc [errno=0] 89drop table t1, t2; 90connection master; 91drop table t1, t2; 92CREATE TABLE t1 (word CHAR(20) NOT NULL PRIMARY KEY) ENGINE=INNODB; 93LOAD DATA INFILE "../../std_data/words.dat" INTO TABLE t1; 94ERROR 23000: Duplicate entry 'Aarhus' for key 'PRIMARY' 95DROP TABLE t1; 96include/rpl_reset.inc 97connection master; 98drop database if exists b48297_db1; 99drop database if exists b42897_db2; 100create database b48297_db1; 101create database b42897_db2; 102use b48297_db1; 103CREATE TABLE t1 (c1 VARCHAR(256)) engine=MyISAM;; 104use b42897_db2; 105### assertion: works with cross-referenced database 106LOAD DATA LOCAL INFILE 'MYSQLTEST_VARDIR/std_data/loaddata5.dat' INTO TABLE b48297_db1.t1; 107use b48297_db1; 108### assertion: works with fully qualified name on current database 109LOAD DATA LOCAL INFILE 'MYSQLTEST_VARDIR/std_data/loaddata5.dat' INTO TABLE b48297_db1.t1; 110### assertion: works without fully qualified name on current database 111LOAD DATA LOCAL INFILE 'MYSQLTEST_VARDIR/std_data/loaddata5.dat' INTO TABLE t1; 112### create connection without default database 113connect conn2,localhost,root,,*NO-ONE*; 114connection conn2; 115### assertion: works without stating the default database 116LOAD DATA LOCAL INFILE 'MYSQLTEST_VARDIR/std_data/loaddata5.dat' INTO TABLE b48297_db1.t1; 117disconnect conn2; 118connection master; 119connection slave; 120use b48297_db1; 121include/diff_tables.inc [master:b48297_db1.t1, slave:b48297_db1.t1] 122connection master; 123DROP DATABASE b48297_db1; 124DROP DATABASE b42897_db2; 125connection slave; 126include/rpl_reset.inc 127connection master; 128use test; 129CREATE TABLE t1 (`key` TEXT, `text` TEXT); 130LOAD DATA INFILE '../../std_data/loaddata2.dat' REPLACE INTO TABLE `t1` FIELDS TERMINATED BY ','; 131SELECT * FROM t1; 132key text 133Field A 'Field B' 134Field 1 'Field 2' 135Field 3 'Field 4' 136'Field 5' 'Field 6' 137Field 6 'Field 7' 138connection slave; 139connection master; 140DROP TABLE t1; 141include/rpl_end.inc 142