1include/master-slave.inc
2[connection master]
3drop table if exists t1;
4drop procedure if exists p1;
5create table t1 (a varchar(255) character set sjis);
6create procedure p1 (in a varchar(255) character set sjis) insert into t1 values (a);
7SET NAMES binary;
8CALL p1 ('�\\');
9select hex(a) from t1 ;
10hex(a)
11965C
12connection slave;
13connection slave;
14select hex(a) from t1;
15hex(a)
16965C
17connection master;
18drop table t1;
19drop procedure p1;
20connection slave;
21connection master;
22#
23# Start of 5.5 tests
24#
25#
26# Bug#MDEV-4489 Replication of big5, cp932, gbk, sjis strings makes wrong values on slave
27#
28connection master;
29SET NAMES sjis;
30CREATE TABLE t1 (a INT);
31INSERT INTO t1 VALUES (0x31),(X'31'),('1');
32PREPARE stmt FROM 'INSERT INTO t1 (a) VALUES (?)';
33SET @a='1';
34EXECUTE stmt USING @a;
35DROP PREPARE stmt;
36SELECT * FROM t1;
37a
3849
391
401
411
42connection slave;
43connection slave;
44SELECT * FROM t1;
45a
4649
471
481
491
50connection master;
51DROP TABLE t1;
52connection slave;
53connection master;
54#
55# End of 5.5 tests
56#
57include/rpl_end.inc
58