Debian Codegraph @

mysql-test/suite/rpl/t/rpl_sp_variables.test

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