summaryrefslogtreecommitdiffstats
path: root/mysql-test/suite/rpl/r/rpl_charset_sjis.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/suite/rpl/r/rpl_charset_sjis.result')
-rw-r--r--mysql-test/suite/rpl/r/rpl_charset_sjis.result57
1 files changed, 57 insertions, 0 deletions
diff --git a/mysql-test/suite/rpl/r/rpl_charset_sjis.result b/mysql-test/suite/rpl/r/rpl_charset_sjis.result
new file mode 100644
index 00000000..844142cc
--- /dev/null
+++ b/mysql-test/suite/rpl/r/rpl_charset_sjis.result
@@ -0,0 +1,57 @@
+include/master-slave.inc
+[connection master]
+drop table if exists t1;
+drop procedure if exists p1;
+create table t1 (a varchar(255) character set sjis);
+create procedure p1 (in a varchar(255) character set sjis) insert into t1 values (a);
+SET NAMES binary;
+CALL p1 ('–\\');
+select hex(a) from t1 ;
+hex(a)
+965C
+connection slave;
+connection slave;
+select hex(a) from t1;
+hex(a)
+965C
+connection master;
+drop table t1;
+drop procedure p1;
+connection slave;
+connection master;
+#
+# Start of 5.5 tests
+#
+#
+# Bug#MDEV-4489 Replication of big5, cp932, gbk, sjis strings makes wrong values on slave
+#
+connection master;
+SET NAMES sjis;
+CREATE TABLE t1 (a INT);
+INSERT INTO t1 VALUES (0x31),(X'31'),('1');
+PREPARE stmt FROM 'INSERT INTO t1 (a) VALUES (?)';
+SET @a='1';
+EXECUTE stmt USING @a;
+DROP PREPARE stmt;
+SELECT * FROM t1;
+a
+49
+1
+1
+1
+connection slave;
+connection slave;
+SELECT * FROM t1;
+a
+49
+1
+1
+1
+connection master;
+DROP TABLE t1;
+connection slave;
+connection master;
+#
+# End of 5.5 tests
+#
+include/rpl_end.inc