~stewart/drizzle/embedded-innodb-create-select-transaction-arrgh

« back to all changes in this revision

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

  • Committer: brian
  • Date: 2008-06-25 05:29:13 UTC
  • Revision ID: brian@localhost.localdomain-20080625052913-6upwo0jsrl4lnapl
clean slate

Show diffs side-by-side

added added

removed removed

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