Debian Codegraph @

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

raw
1 include/master-slave.inc
2 Warnings:
3 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
4 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
5 [connection master]
6 create table t1 (a varchar(10) character set utf8);
7 Warnings:
8 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
9 load data infile '../../std_data/loaddata6.dat' into table t1 CHARACTER SET latin1;
10 set @@character_set_database=koi8r;
11 Warnings:
12 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
13 load data infile '../../std_data/loaddata6.dat' into table t1;
14 set @@character_set_database=latin1;
15 Warnings:
16 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
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 Warnings:
22 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
23 load data infile '../../std_data/loaddata6.dat' into table t1;
24 set @@character_set_database=DEFAULT;
25 Warnings:
26 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
27 load data infile '../../std_data/loaddata6.dat' into table t1 character set koi8r;
28 select hex(a) from t1;
29 hex(a)
30 C3BF
31 D0AA
32 C3BF
33 C3BF
34 C3BF
35 D0AA
36 D0AA
37 include/sync_slave_sql_with_master.inc
38 select hex(a) from t1;
39 hex(a)
40 C3BF
41 D0AA
42 C3BF
43 C3BF
44 C3BF
45 D0AA
46 D0AA
47 drop table t1;
48 include/sync_slave_sql_with_master.inc
49 -------------test bug#45516------------------
50 DROP DATABASE IF EXISTS mysqltest;
51 CREATE DATABASE mysqltest CHARSET UTF8;
52 Warnings:
53 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
54 USE mysqltest;
55 CREATE TABLE t (cl varchar(100)) CHARSET UTF8;
56 Warnings:
57 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
58 LOAD DATA LOCAL INFILE './std_data/loaddata_utf8.dat' INTO TABLE t
59 FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n';
60 ----------content on master----------
61 SELECT hex(cl) FROM t;
62 hex(cl)
63 E4B880E4BA8CE4B889
64 E59B9BE4BA94E585AD
65 E4B883E585ABE4B99D
66 E4B880E4BA8CE4B889
67 E59B9BE4BA94E585AD
68 E4B883E585ABE4B99D0A
69 ----------content on slave----------
70 USE mysqltest;
71 SELECT hex(cl) FROM t;
72 hex(cl)
73 E4B880E4BA8CE4B889
74 E59B9BE4BA94E585AD
75 E4B883E585ABE4B99D
76 E4B880E4BA8CE4B889
77 E59B9BE4BA94E585AD
78 E4B883E585ABE4B99D0A
79 DROP DATABASE mysqltest;
80 DROP DATABASE IF EXISTS mysqltest;
81 CREATE DATABASE mysqltest CHARSET UTF8;
82 Warnings:
83 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
84 USE mysqltest;
85 CREATE TABLE t (cl varchar(100)) CHARSET UTF8;
86 Warnings:
87 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
88 LOAD DATA INFILE '../../std_data/loaddata_utf8.dat' INTO TABLE t
89 FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n';
90 ----------content on master----------
91 SELECT hex(cl) FROM t;
92 hex(cl)
93 E4B880E4BA8CE4B889
94 E59B9BE4BA94E585AD
95 E4B883E585ABE4B99D
96 E4B880E4BA8CE4B889
97 E59B9BE4BA94E585AD
98 E4B883E585ABE4B99D0A
99 ----------content on slave----------
100 USE mysqltest;
101 SELECT hex(cl) FROM t;
102 hex(cl)
103 E4B880E4BA8CE4B889
104 E59B9BE4BA94E585AD
105 E4B883E585ABE4B99D
106 E4B880E4BA8CE4B889
107 E59B9BE4BA94E585AD
108 E4B883E585ABE4B99D0A
109 DROP DATABASE mysqltest;
110 include/rpl_end.inc