mirror of
https://github.com/MariaDB/server.git
synced 2025-02-22 05:13:08 +01:00
50 lines
1.4 KiB
Text
50 lines
1.4 KiB
Text
#
|
|
# Check LOAD DATA + character sets + replication
|
|
#
|
|
source include/master-slave.inc;
|
|
|
|
#
|
|
# Bug#15126 character_set_database is not replicated
|
|
# (LOAD DATA INFILE need it)
|
|
#
|
|
connection master;
|
|
set @@character_set_database=latin1;
|
|
create table t1 (a varchar(10) character set utf8);
|
|
load data infile '../../std_data/loaddata6.dat' into table t1;
|
|
set @@character_set_database=koi8r;
|
|
load data infile '../../std_data/loaddata6.dat' into table t1;
|
|
set @@character_set_database=latin1;
|
|
load data infile '../../std_data/loaddata6.dat' into table t1;
|
|
load data infile '../../std_data/loaddata6.dat' into table t1;
|
|
load data infile '../../std_data/loaddata6.dat' into table t1;
|
|
set @@character_set_database=koi8r;
|
|
load data infile '../../std_data/loaddata6.dat' into table t1;
|
|
set @@character_set_database=latin1;
|
|
load data infile '../../std_data/loaddata6.dat' into table t1 character set koi8r;
|
|
|
|
select hex(a) from t1;
|
|
|
|
sync_slave_with_master;
|
|
|
|
select hex(a) from t1;
|
|
connection master;
|
|
drop table t1;
|
|
sync_slave_with_master;
|
|
|
|
#
|
|
# Bug#45516
|
|
# When slave SQL thread executing LOAD DATA command, the
|
|
# thd->variables.collation_database was not set properly to the default
|
|
# database charset
|
|
#
|
|
|
|
echo -------------test bug#45516------------------;
|
|
|
|
# LOAD DATA INFILE
|
|
let $LOAD_LOCAL=1;
|
|
source include/rpl_loaddata_charset.inc;
|
|
|
|
# LOAD DATA LOCAL INFILE
|
|
let $LOAD_LOCAL=0;
|
|
source include/rpl_loaddata_charset.inc;
|
|
--source include/rpl_end.inc
|