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