|
1
by brian
clean slate |
1 |
-- source include/have_binlog_format_mixed_or_statement.inc
|
2 |
-- source include/have_cp932.inc
|
|
3 |
-- source include/have_log_bin.inc
|
|
4 |
||
5 |
# Bug#16217 (mysql client did not know how not switch its internal charset) |
|
6 |
flush logs; |
|
7 |
create table t3 (f text character set utf8); |
|
8 |
create table t4 (f text character set cp932); |
|
9 |
--exec $MYSQL --default-character-set=utf8 test -e "insert into t3 values(_utf8'ãœ')"
|
|
10 |
--exec $MYSQL --default-character-set=cp932 test -e "insert into t4 values(_cp932'\');"
|
|
11 |
flush logs; |
|
12 |
rename table t3 to t03, t4 to t04; |
|
13 |
--exec $MYSQL_BINLOG --short-form $MYSQLTEST_VARDIR/log/master-bin.000002 | $MYSQL --default-character-set=utf8
|
|
14 |
# original and recovered data must be equal |
|
15 |
select HEX(f) from t03; |
|
16 |
select HEX(f) from t3; |
|
17 |
select HEX(f) from t04; |
|
18 |
select HEX(f) from t4; |
|
19 |
||
20 |
drop table t3, t4, t03, t04; |
|
21 |
--echo End of 5.0 tests
|