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