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