Debian Codegraph @

mysql-test/suite/rpl/r/rpl_loaddata_charset.result

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