Debian Codegraph @

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

raw
1 #
2 # Check LOAD DATA + character sets + replication
3 #
4 source include/master-slave.inc;
5
6 #
7 # Bug#15126 character_set_database is not replicated
8 # (LOAD DATA INFILE need it)
9 #
10 connection master;
11 set @@character_set_database=latin1;
12 create table t1 (a varchar(10) character set utf8);
13 load data infile '../../std_data/loaddata6.dat' into table t1;
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=latin1;
23 load data infile '../../std_data/loaddata6.dat' into table t1 character set koi8r;
24
25 select hex(a) from t1;
26
27 sync_slave_with_master;
28
29 select hex(a) from t1;
30 connection master;
31 drop table t1;
32 sync_slave_with_master;
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