Debian Codegraph @

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

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