1
by brian
clean slate |
1 |
#
|
2 |
# Check LOAD DATA + character sets + replication
|
|
3 |
#
|
|
4 |
source include/master-slave.inc; |
|
5 |
||
6 |
#
|
|
7 |
# Bug#15126 character_set_database is not replicated
|
|
8 |
# (LOAD DATA INFILE need it)
|
|
9 |
#
|
|
10 |
connection master; |
|
11 |
create table t1 (a varchar(10) character set utf8); |
|
12 |
load data infile '../std_data_ln/loaddata6.dat' into table t1; |
|
13 |
set @@character_set_database=koi8r; |
|
14 |
load data infile '../std_data_ln/loaddata6.dat' into table t1; |
|
15 |
set @@character_set_database=DEFAULT; |
|
16 |
load data infile '../std_data_ln/loaddata6.dat' into table t1; |
|
17 |
load data infile '../std_data_ln/loaddata6.dat' into table t1; |
|
18 |
load data infile '../std_data_ln/loaddata6.dat' into table t1; |
|
19 |
set @@character_set_database=koi8r; |
|
20 |
load data infile '../std_data_ln/loaddata6.dat' into table t1; |
|
21 |
set @@character_set_database=DEFAULT; |
|
22 |
load data infile '../std_data_ln/loaddata6.dat' into table t1 character set koi8r; |
|
23 |
||
24 |
select hex(a) from t1; |
|
25 |
||
26 |
save_master_pos; |
|
27 |
connection slave; |
|
28 |
sync_with_master; |
|
29 |
||
30 |
select hex(a) from t1; |
|
31 |
connection master; |
|
32 |
drop table t1; |
|
33 |
sync_slave_with_master; |