Debian Codegraph @

mysql-test/suite/rpl/r/rpl_loaddata.result

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