1-- source include/have_binlog_format_mixed_or_statement.inc
2-- source include/have_gbk.inc
3
4RESET MASTER;
5SET NAMES gbk;
6--character_set gbk
7
8CREATE TABLE t1 (
9  f1 BLOB
10) ENGINE=MyISAM DEFAULT CHARSET=gbk;
11
12delimiter |;
13CREATE PROCEDURE p1(IN val BLOB)
14BEGIN
15     SET @tval = val;
16     SET @sql_cmd = CONCAT_WS(' ', 'insert into t1(f1) values(?)');
17     PREPARE stmt FROM @sql_cmd;
18     EXECUTE stmt USING @tval;
19     DEALLOCATE PREPARE stmt;
20END|
21delimiter ;|
22
23SET @`tcontent`:=_binary 0x50434B000900000000000000E9000000 COLLATE `binary`/*!*/;
24CALL p1(@`tcontent`);
25
26FLUSH LOGS;
27DROP PROCEDURE p1;
28RENAME TABLE t1 to t2;
29
30let $MYSQLD_DATADIR= `select @@datadir`;
31--exec $MYSQL_BINLOG --force-if-open --short-form $MYSQLD_DATADIR/master-bin.000001 | $MYSQL
32SELECT hex(f1) FROM t2;
33SELECT hex(f1) FROM t1;
34
35DROP PROCEDURE p1;
36DROP TABLE t1;
37DROP TABLE t2;
38