Debian Codegraph @

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

raw
1 CREATE TABLE t1 (c1 char(50));
2 LOAD DATA INFILE '../../std_data/words.dat' INTO TABLE t1;
3 LOAD DATA CONCURRENT INFILE '../../std_data/words.dat' INTO TABLE t1;
4 show binlog events from <binlog_start>;
5 Log_name Pos Event_type Server_id End_log_pos Info
6 master-bin.000001 # Query # # use `test`; CREATE TABLE t1 (c1 char(50))
7 master-bin.000001 # Query # # BEGIN
8 master-bin.000001 # Table_map # # table_id: # (test.t1)
9 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
10 master-bin.000001 # Xid # # COMMIT /* XID */
11 master-bin.000001 # Query # # BEGIN
12 master-bin.000001 # Table_map # # table_id: # (test.t1)
13 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
14 master-bin.000001 # Xid # # COMMIT /* XID */
15 DROP TABLE t1;
16 include/master-slave.inc
17 [connection master]
18 select last_insert_id();
19 last_insert_id()
20 0
21 create table t1(a int not null auto_increment, b int, primary key(a) );
22 load data CONCURRENT infile '../../std_data/rpl_loaddata.dat' into table t1;
23 select last_insert_id();
24 last_insert_id()
25 1
26 create temporary table t2 (day date,id int(9),category enum('a','b','c'),name varchar(60));
27 load data CONCURRENT 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;
28 create table t3 (day date,id int(9),category enum('a','b','c'),name varchar(60));
29 insert into t3 select * from t2;
30 select * from t1;
31 a b
32 1 10
33 2 15
34 select * from t3;
35 day id category name
36 2003-02-22 2461 b a a a @ %  ' " a
37 2003-03-22 2161 c asdf
38 2003-03-22 2416 a bbbbb
39 drop table t1;
40 drop table t2;
41 drop table t3;
42 create table t1(a int, b int, unique(b));
43 insert into t1 values(1,10);
44 load data CONCURRENT infile '../../std_data/rpl_loaddata.dat' into table t1;
45 include/wait_for_slave_sql_error_and_skip.inc [errno=1062]
46 include/check_slave_no_error.inc
47 set sql_log_bin=0;
48 delete from t1;
49 set sql_log_bin=1;
50 load data CONCURRENT infile '../../std_data/rpl_loaddata.dat' into table t1;
51 include/wait_for_slave_sql_error.inc [errno=1062]
52 include/stop_slave_io.inc
53 CHANGE REPLICATION SOURCE to SOURCE_USER='test';
54 CHANGE REPLICATION SOURCE to SOURCE_USER='root';
55 include/check_slave_no_error.inc
56 set global sql_replica_skip_counter=1;
57 start slave;
58 set sql_log_bin=0;
59 delete from t1;
60 set sql_log_bin=1;
61 load data CONCURRENT infile '../../std_data/rpl_loaddata.dat' into table t1;
62 include/wait_for_slave_sql_error.inc [errno=1062]
63 stop slave;
64 reset slave;
65 include/check_slave_no_error.inc
66 reset master;
67 create table t2 (day date,id int(9),category enum('a','b','c'),name varchar(60),
68 unique(day)) engine=MyISAM;
69 load data CONCURRENT infile '../../std_data/rpl_loaddata2.dat' into table t2 fields
70 terminated by ',' optionally enclosed by '%' escaped by '@' lines terminated by
71 '\n##\n' starting by '>' ignore 1 lines;
72 ERROR 23000: Duplicate entry '2003-03-22' for key 'day'
73 select * from t2;
74 day id category name
75 2003-02-22 2461 b a a a @ %  ' " a
76 2003-03-22 2161 c asdf
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 delete from t2;
84 load data CONCURRENT infile '../../std_data/rpl_loaddata2.dat' into table t2 fields
85 terminated by ',' optionally enclosed by '%' escaped by '@' lines terminated by
86 '\n##\n' starting by '>' ignore 1 lines;
87 ERROR 23000: Duplicate entry '2003-03-22' for key 'day'
88 drop table t1, t2;
89 CREATE TABLE t1 (word CHAR(20) NOT NULL PRIMARY KEY) ENGINE=INNODB;
90 LOAD DATA CONCURRENT INFILE "../../std_data/words.dat" INTO TABLE t1;
91 ERROR 23000: Duplicate entry 'Aarhus' for key 'PRIMARY'
92 DROP TABLE t1;
93 include/rpl_reset.inc
94 drop database if exists b48297_db1;
95 drop database if exists b42897_db2;
96 create database b48297_db1;
97 create database b42897_db2;
98 use b48297_db1;
99 CREATE TABLE t1 (c1 VARCHAR(256)) engine=MyISAM;;
100 use b42897_db2;
101 ### assertion: works with cross-referenced database
102 LOAD DATA CONCURRENT LOCAL INFILE 'MYSQLTEST_VARDIR/std_data/loaddata5.dat' INTO TABLE b48297_db1.t1;
103 use b48297_db1;
104 ### assertion: works with fully qualified name on current database
105 LOAD DATA CONCURRENT LOCAL INFILE 'MYSQLTEST_VARDIR/std_data/loaddata5.dat' INTO TABLE b48297_db1.t1;
106 ### assertion: works without fully qualified name on current database
107 LOAD DATA CONCURRENT LOCAL INFILE 'MYSQLTEST_VARDIR/std_data/loaddata5.dat' INTO TABLE t1;
108 ### create connection without default database
109 ### connect (conn2,localhost,root,,*NO-ONE*);
110 ### assertion: works without stating the default database
111 LOAD DATA CONCURRENT LOCAL INFILE 'MYSQLTEST_VARDIR/std_data/loaddata5.dat' INTO TABLE b48297_db1.t1;
112 ### disconnect and switch back to master connection
113 use b48297_db1;
114 include/diff_tables.inc [master:b48297_db1.t1, slave:b48297_db1.t1]
115 DROP DATABASE b48297_db1;
116 DROP DATABASE b42897_db2;
117 include/rpl_reset.inc
118 use test;
119 CREATE TABLE t1 (`key` TEXT, `text` TEXT);
120 LOAD DATA INFILE '../../std_data/loaddata2.dat' REPLACE INTO TABLE `t1` FIELDS TERMINATED BY ',';
121 SELECT * FROM t1;
122 key text
123 Field A 'Field B'
124 Field 1 'Field 2'
125 Field 3 'Field 4'
126 'Field 5' 'Field 6'
127 Field 6 'Field 7'
128 DROP TABLE t1;
129 include/rpl_end.inc