Debian Codegraph @

mysql-test/suite/rpl/r/rpl_sp_variables.result

raw
1 include/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 #
6 connection master;
7 SET NAMES utf8;
8 CREATE TABLE t1 (a VARCHAR(10) CHARACTER SET utf8);
9 CREATE PROCEDURE p1()
10 BEGIN
11 DECLARE v_id INT DEFAULT 2017;
12 INSERT INTO test.t1 SELECT CONCAT(v_id, '오');
13 END;
14 $$
15 CALL p1;
16 SELECT * FROM t1;
17 a
18 2017오
19 connection slave;
20 SET NAMES utf8;
21 SELECT * FROM t1;
22 a
23 2017오
24 connection master;
25 DROP PROCEDURE p1;
26 DROP TABLE t1;
27 connection slave;
28 include/rpl_end.inc