Debian Codegraph @

mysql-test/suite/rpl/t/rpl_loaddata_charset.test

raw
1 #
2 # Check LOAD DATA + character sets + replication
3 #
4 --source include/not_group_replication_plugin.inc
5 source include/master-slave.inc;
6
7 #
8 # Bug#15126 character_set_database is not replicated
9 # (LOAD DATA INFILE need it)
10 #
11 connection master;
12 create table t1 (a varchar(10) character set utf8);
13 load data infile '../../std_data/loaddata6.dat' into table t1 CHARACTER SET latin1;
14 set @@character_set_database=koi8r;
15 load data infile '../../std_data/loaddata6.dat' into table t1;
16 set @@character_set_database=latin1;
17 load data infile '../../std_data/loaddata6.dat' into table t1;
18 load data infile '../../std_data/loaddata6.dat' into table t1;
19 load data infile '../../std_data/loaddata6.dat' into table t1;
20 set @@character_set_database=koi8r;
21 load data infile '../../std_data/loaddata6.dat' into table t1;
22 set @@character_set_database=DEFAULT;
23 load data infile '../../std_data/loaddata6.dat' into table t1 character set koi8r;
24
25 select hex(a) from t1;
26
27 --source include/sync_slave_sql_with_master.inc
28
29 select hex(a) from t1;
30 connection master;
31 drop table t1;
32 --source include/sync_slave_sql_with_master.inc
33
34 #
35 # Bug#45516
36 # When slave SQL thread executing LOAD DATA command, the
37 # thd->variables.collation_database was not set properly to the default
38 # database charset
39 #
40
41 echo -------------test bug#45516------------------;
42
43 # LOAD DATA INFILE
44 let $LOAD_LOCAL=1;
45 source include/rpl_loaddata_charset.inc;
46
47 # LOAD DATA LOCAL INFILE
48 let $LOAD_LOCAL=0;
49 source include/rpl_loaddata_charset.inc;
50 --source include/rpl_end.inc