diff options
Diffstat (limited to 'mysql-test/suite/rpl/r/rpl_loaddata_charset.result')
| -rw-r--r-- | mysql-test/suite/rpl/r/rpl_loaddata_charset.result | 16 |
1 files changed, 12 insertions, 4 deletions
diff --git a/mysql-test/suite/rpl/r/rpl_loaddata_charset.result b/mysql-test/suite/rpl/r/rpl_loaddata_charset.result index 6b60bffa365..b89f7005405 100644 --- a/mysql-test/suite/rpl/r/rpl_loaddata_charset.result +++ b/mysql-test/suite/rpl/r/rpl_loaddata_charset.result @@ -1,5 +1,6 @@ include/master-slave.inc [connection master] +connection master; create table t1 (a varchar(10) character set utf8); load data infile '../../std_data/loaddata6.dat' into table t1; set @@character_set_database=koi8r; @@ -21,6 +22,7 @@ C3BF C3BF D0AA D0AA +connection slave; select hex(a) from t1; hex(a) C3BF @@ -30,46 +32,52 @@ C3BF C3BF D0AA D0AA +connection master; drop table t1; +connection slave; -------------test bug#45516------------------ +connection master; DROP DATABASE IF EXISTS mysqltest; CREATE DATABASE mysqltest CHARSET UTF8; USE mysqltest; CREATE TABLE t (cl varchar(100)) CHARSET UTF8; LOAD DATA LOCAL INFILE './std_data/loaddata_utf8.dat' INTO TABLE t FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n'; -----------content on master---------- SELECT hex(cl) FROM t; hex(cl) E4B880E4BA8CE4B889 E59B9BE4BA94E585AD E4B883E585ABE4B99D -----------content on slave---------- +connection slave; USE mysqltest; SELECT hex(cl) FROM t; hex(cl) E4B880E4BA8CE4B889 E59B9BE4BA94E585AD E4B883E585ABE4B99D +connection master; DROP DATABASE mysqltest; +connection slave; +connection master; DROP DATABASE IF EXISTS mysqltest; CREATE DATABASE mysqltest CHARSET UTF8; USE mysqltest; CREATE TABLE t (cl varchar(100)) CHARSET UTF8; LOAD DATA INFILE '../../std_data/loaddata_utf8.dat' INTO TABLE t FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n'; -----------content on master---------- SELECT hex(cl) FROM t; hex(cl) E4B880E4BA8CE4B889 E59B9BE4BA94E585AD E4B883E585ABE4B99D -----------content on slave---------- +connection slave; USE mysqltest; SELECT hex(cl) FROM t; hex(cl) E4B880E4BA8CE4B889 E59B9BE4BA94E585AD E4B883E585ABE4B99D +connection master; DROP DATABASE mysqltest; +connection slave; include/rpl_end.inc |