~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/mysqlbinlog-cp932.test

  • Committer: Toru Maesaka
  • Date: 2008-07-17 05:59:20 UTC
  • mto: (202.1.1 toru)
  • mto: This revision was merged to the branch mainline in revision 204.
  • Revision ID: dev@torum.net-20080717055920-10okif50x6nh7b1d
forgot to bzr-add new files in the previous push

Show diffs side-by-side

added added

removed removed

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