Debian Codegraph @

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

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