Debian Codegraph @

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

raw
1 include/master-slave.inc
2 Warnings:
3 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
4 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
5 [connection master]
6 select last_insert_id();
7 last_insert_id()
8 0
9 create table t1(a int not null auto_increment, b int, primary key(a) );
10 load data infile '../../std_data/rpl_loaddata.dat' into table t1;
11 select last_insert_id();
12 last_insert_id()
13 1
14 create temporary table t2 (day date,id int(9),category enum('a','b','c'),name varchar(60));
15 Warnings:
16 Warning 1681 Integer display width is deprecated and will be removed in a future release.
17 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;
18 create table t3 (day date,id int(9),category enum('a','b','c'),name varchar(60));
19 Warnings:
20 Warning 1681 Integer display width is deprecated and will be removed in a future release.
21 insert into t3 select * from t2;
22 include/sync_slave_sql_with_master.inc
23 select * from t1;
24 a b
25 1 10
26 2 15
27 select * from t3;
28 day id category name
29 2003-02-22 2461 b a a a @ %  ' " a
30 2003-03-22 2161 c asdf
31 2003-03-22 2416 a bbbbb
32 drop table t1;
33 drop table t2;
34 drop table t3;
35 create table t1(a int, b int, unique(b));
36 include/sync_slave_sql_with_master.inc
37 insert into t1 values(1,10);
38 load data infile '../../std_data/rpl_loaddata.dat' into table t1;
39 call mtr.add_suppression("Replica SQL.*Error .Duplicate entry .10. for key .t1.b.. on query.* Error_code: MY-001062");
40 call mtr.add_suppression("Replica SQL.*Query caused different errors on source and replica.*Error on source:.*error code=1062.*Error on replica:.*Error_code: MY-013113");
41 call mtr.add_suppression("The replica coordinator and worker threads are stopped, possibly leaving data in inconsistent state");
42 include/wait_for_slave_sql_error_and_skip.inc [errno=1062]
43 include/check_slave_no_error.inc
44 set sql_log_bin=0;
45 delete from t1;
46 set sql_log_bin=1;
47 load data infile '../../std_data/rpl_loaddata.dat' into table t1;
48 include/wait_for_slave_sql_error.inc [errno=1062]
49 include/stop_slave_io.inc
50 CHANGE REPLICATION SOURCE to SOURCE_USER='test';
51 Warnings:
52 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
53 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
54 CHANGE REPLICATION SOURCE to SOURCE_USER='root';
55 Warnings:
56 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
57 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
58 include/check_slave_no_error.inc
59 set global sql_replica_skip_counter=1;
60 start slave;
61 Warnings:
62 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
63 set sql_log_bin=0;
64 delete from t1;
65 set sql_log_bin=1;
66 load data infile '../../std_data/rpl_loaddata.dat' into table t1;
67 include/wait_for_slave_sql_error.inc [errno=1062]
68 stop slave;
69 Warnings:
70 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
71 reset slave;
72 Warnings:
73 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
74 include/check_slave_no_error.inc
75 reset master;
76 create table t2 (day date,id int(9),category enum('a','b','c'),name varchar(60),
77 unique(day)) engine=MyISAM;
78 Warnings:
79 Warning 1681 Integer display width is deprecated and will be removed in a future release.
80 load data infile '../../std_data/rpl_loaddata2.dat' into table t2 fields
81 terminated by ',' optionally enclosed by '%' escaped by '@' lines terminated by
82 '\n##\n' starting by '>' ignore 1 lines;
83 ERROR 23000: Duplicate entry '2003-03-22' for key 't2.day'
84 select * from t2;
85 day id category name
86 2003-02-22 2461 b a a a @ %  ' " a
87 2003-03-22 2161 c asdf
88 start slave;
89 Warnings:
90 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
91 select * from t2;
92 day id category name
93 2003-02-22 2461 b a a a @ %  ' " a
94 2003-03-22 2161 c asdf
95 alter table t2 drop key day;
96 delete from t2;
97 load data infile '../../std_data/rpl_loaddata2.dat' into table t2 fields
98 terminated by ',' optionally enclosed by '%' escaped by '@' lines terminated by
99 '\n##\n' starting by '>' ignore 1 lines;
100 ERROR 23000: Duplicate entry '2003-03-22' for key 't2.day'
101 include/wait_for_slave_sql_error.inc [errno=13113]
102 drop table t1, t2;
103 drop table t1, t2;
104 include/stop_slave_io.inc
105 RESET REPLICA;
106 include/rpl_reset.inc
107 drop database if exists b48297_db1;
108 drop database if exists b42897_db2;
109 create database b48297_db1;
110 create database b42897_db2;
111 use b48297_db1;
112 CREATE TABLE t1 (c1 VARCHAR(256)) engine=MyISAM;;
113 use b42897_db2;
114 ### assertion: works with cross-referenced database
115 LOAD DATA LOCAL INFILE 'MYSQLTEST_VARDIR/std_data/loaddata5.dat' INTO TABLE b48297_db1.t1;
116 use b48297_db1;
117 ### assertion: works with fully qualified name on current database
118 LOAD DATA LOCAL INFILE 'MYSQLTEST_VARDIR/std_data/loaddata5.dat' INTO TABLE b48297_db1.t1;
119 ### assertion: works without fully qualified name on current database
120 LOAD DATA LOCAL INFILE 'MYSQLTEST_VARDIR/std_data/loaddata5.dat' INTO TABLE t1;
121 ### create connection without default database
122 ### connect (conn2,localhost,root,,*NO-ONE*);
123 ### assertion: works without stating the default database
124 LOAD DATA LOCAL INFILE 'MYSQLTEST_VARDIR/std_data/loaddata5.dat' INTO TABLE b48297_db1.t1;
125 ### disconnect and switch back to master connection
126 include/sync_slave_sql_with_master.inc
127 use b48297_db1;
128 include/diff_tables.inc [master:b48297_db1.t1, slave:b48297_db1.t1]
129 DROP DATABASE b48297_db1;
130 DROP DATABASE b42897_db2;
131 include/sync_slave_sql_with_master.inc
132 include/rpl_reset.inc
133 use test;
134 CREATE TABLE t1 (`key` TEXT, `text` TEXT);
135 LOAD DATA INFILE '../../std_data/loaddata2.dat' REPLACE INTO TABLE `t1` FIELDS TERMINATED BY ',';
136 SELECT * FROM t1;
137 key text
138 Field A 'Field B'
139 Field 1 'Field 2'
140 Field 3 'Field 4'
141 'Field 5' 'Field 6'
142 Field 6 'Field 7'
143 include/sync_slave_sql_with_master.inc
144 DROP TABLE t1;
145 include/rpl_end.inc