1include/master-slave.inc
2[connection master]
3connection master;
4create table t1 (a varchar(10) character set utf8);
5load data infile '../../std_data/loaddata6.dat' into table t1;
6set @@character_set_database=koi8r;
7load data infile '../../std_data/loaddata6.dat' into table t1;
8set @@character_set_database=DEFAULT;
9load data infile '../../std_data/loaddata6.dat' into table t1;
10load data infile '../../std_data/loaddata6.dat' into table t1;
11load data infile '../../std_data/loaddata6.dat' into table t1;
12set @@character_set_database=koi8r;
13load data infile '../../std_data/loaddata6.dat' into table t1;
14set @@character_set_database=DEFAULT;
15load data infile '../../std_data/loaddata6.dat' into table t1 character set koi8r;
16select hex(a) from t1;
17hex(a)
18C3BF
19D0AA
20C3BF
21C3BF
22C3BF
23D0AA
24D0AA
25connection slave;
26select hex(a) from t1;
27hex(a)
28C3BF
29D0AA
30C3BF
31C3BF
32C3BF
33D0AA
34D0AA
35connection master;
36drop table t1;
37connection slave;
38-------------test bug#45516------------------
39connection master;
40DROP DATABASE IF EXISTS mysqltest;
41CREATE DATABASE mysqltest CHARSET UTF8;
42USE mysqltest;
43CREATE TABLE t (cl varchar(100)) CHARSET UTF8;
44LOAD DATA LOCAL INFILE './std_data/loaddata_utf8.dat' INTO TABLE t
45FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n';
46SELECT hex(cl) FROM t;
47hex(cl)
48E4B880E4BA8CE4B889
49E59B9BE4BA94E585AD
50E4B883E585ABE4B99D
51connection slave;
52USE mysqltest;
53SELECT hex(cl) FROM t;
54hex(cl)
55E4B880E4BA8CE4B889
56E59B9BE4BA94E585AD
57E4B883E585ABE4B99D
58connection master;
59DROP DATABASE mysqltest;
60connection slave;
61connection master;
62DROP DATABASE IF EXISTS mysqltest;
63CREATE DATABASE mysqltest CHARSET UTF8;
64USE mysqltest;
65CREATE TABLE t (cl varchar(100)) CHARSET UTF8;
66LOAD DATA INFILE '../../std_data/loaddata_utf8.dat' INTO TABLE t
67FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n';
68SELECT hex(cl) FROM t;
69hex(cl)
70E4B880E4BA8CE4B889
71E59B9BE4BA94E585AD
72E4B883E585ABE4B99D
73connection slave;
74USE mysqltest;
75SELECT hex(cl) FROM t;
76hex(cl)
77E4B880E4BA8CE4B889
78E59B9BE4BA94E585AD
79E4B883E585ABE4B99D
80connection master;
81DROP DATABASE mysqltest;
82connection slave;
83include/rpl_end.inc
84