1include/master-slave.inc
2[connection master]
3#
4# MDEV-13685 Can not replay binary log due to Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation 'concat'
5#
6connection master;
7SET NAMES utf8;
8CREATE TABLE t1 (a VARCHAR(10) CHARACTER SET utf8);
9CREATE PROCEDURE p1()
10BEGIN
11DECLARE v_id INT DEFAULT 2017;
12INSERT INTO test.t1 SELECT CONCAT(v_id, '오');
13END;
14$$
15CALL p1;
16SELECT * FROM t1;
17a
182017오
19connection slave;
20SET NAMES utf8;
21SELECT * FROM t1;
22a
232017오
24connection master;
25DROP PROCEDURE p1;
26DROP TABLE t1;
27connection slave;
28include/rpl_end.inc
29