Debian Codegraph @

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

raw
1 --source include/have_binlog_format_statement.inc
2 --source include/master-slave.inc
3
4 --echo #
5 --echo # MDEV-11815 SP variables of temporal data types do not replicate correctly
6 --echo #
7
8 connection master;
9 CREATE TABLE t1(a INT);
10 DELIMITER $$;
11 CREATE PROCEDURE p1()
12 BEGIN
13 DECLARE a TIME DEFAULT '01:01:01';
14 INSERT INTO t1 VALUES (a=10101);
15 END;
16 $$
17 DELIMITER ;$$
18 CALL p1;
19 SELECT * FROM t1;
20
21 sync_slave_with_master;
22 SELECT * FROM t1;
23
24 connection master;
25 DROP TABLE t1;
26 DROP PROCEDURE p1;
27 sync_slave_with_master;
28
29
30 --source include/rpl_end.inc