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