Debian Codegraph @

mysql-test/suite/binlog/t/binlog_stm_sp.test

raw
1 --source include/have_binlog_format_statement.inc
2
3 --disable_query_log
4 reset master; # get rid of previous tests binlog
5 --enable_query_log
6
7 --echo #
8 --echo # MDEV-11815 SP variables of temporal data types do not replicate correctly
9 --echo #
10
11 CREATE TABLE t1(a INT);
12 DELIMITER $$;
13 CREATE PROCEDURE p1()
14 BEGIN
15 DECLARE i INT DEFAULT 123;
16 DECLARE b8 BIT(8) DEFAULT 0x61;
17 DECLARE t0 TIME DEFAULT '01:01:01';
18 DECLARE t6 TIME(6) DEFAULT '01:01:01.123456';
19 DECLARE d DATE DEFAULT '2001-01-01';
20 DECLARE dt0 DATETIME DEFAULT '2001-01-01 01:01:01';
21 DECLARE dt6 DATETIME(6) DEFAULT '2001-01-01 01:01:01.123456';
22 DECLARE ts0 TIMESTAMP DEFAULT '2001-01-01 01:01:01';
23 DECLARE ts6 TIMESTAMP(6) DEFAULT '2001-01-01 01:01:01.123456';
24 INSERT INTO t1 VALUES (i=0x61);
25 INSERT INTO t1 VALUES (b8=0x61);
26 INSERT INTO t1 VALUES (t0=10101);
27 INSERT INTO t1 VALUES (t6=10101);
28 INSERT INTO t1 VALUES (d=20010101);
29 INSERT INTO t1 VALUES (dt0=20010101010101);
30 INSERT INTO t1 VALUES (dt6=20010101010101);
31 INSERT INTO t1 VALUES (ts0=20010101010101);
32 INSERT INTO t1 VALUES (ts6=20010101010101);
33 END;
34 $$
35 DELIMITER ;$$
36 CALL p1;
37 DROP TABLE t1;
38 DROP PROCEDURE p1;
39
40 --let $binlog_file = LAST
41 source include/show_binlog_events.inc;
42
43 --echo #
44 --echo # MDEV-16020 SP variables inside GROUP BY..WITH ROLLUP break replication
45 --echo #
46
47 FLUSH LOGS;
48 CREATE TABLE t1 (d DATE);
49 INSERT INTO t1 VALUES ('1985-05-13'),('1989-12-24');
50 CREATE TABLE t2 (d DATE, c BIGINT);
51 DELIMITER $$;
52 BEGIN NOT ATOMIC
53 BEGIN
54 DECLARE var INT DEFAULT 10;
55 INSERT INTO t2 SELECT d, COUNT(*) FROM t1 GROUP BY d, var;
56 INSERT INTO t2 SELECT d, COUNT(*) FROM t1 GROUP BY d, var WITH ROLLUP;
57 END;
58 BEGIN
59 DECLARE atomic INT DEFAULT 20;
60 INSERT INTO t2 SELECT d, COUNT(*) FROM t1 GROUP BY d, atomic;
61 INSERT INTO t2 SELECT d, COUNT(*) FROM t1 GROUP BY d, atomic WITH ROLLUP;
62 INSERT INTO t2 SELECT d, COUNT(*) FROM t1 GROUP BY d, `atomic`;
63 INSERT INTO t2 SELECT d, COUNT(*) FROM t1 GROUP BY d, `atomic` WITH ROLLUP;
64 END;
65 BEGIN
66 DECLARE atomic ROW (atomic INT, xxx INT) DEFAULT (31,32);
67 INSERT INTO t2 SELECT d, COUNT(*) FROM t1 GROUP BY d, atomic.atomic;
68 INSERT INTO t2 SELECT d, COUNT(*) FROM t1 GROUP BY d, atomic.atomic WITH ROLLUP;
69 INSERT INTO t2 SELECT d, COUNT(*) FROM t1 GROUP BY d, `atomic`.`atomic`;
70 INSERT INTO t2 SELECT d, COUNT(*) FROM t1 GROUP BY d, `atomic`.`atomic` WITH ROLLUP;
71 INSERT INTO t2 SELECT d, COUNT(*) FROM t1 GROUP BY d, atomic.xxx;
72 INSERT INTO t2 SELECT d, COUNT(*) FROM t1 GROUP BY d, atomic.xxx WITH ROLLUP;
73 INSERT INTO t2 SELECT d, COUNT(*) FROM t1 GROUP BY d, `atomic`.`xxx`;
74 INSERT INTO t2 SELECT d, COUNT(*) FROM t1 GROUP BY d, `atomic`.`xxx` WITH ROLLUP;
75 END;
76 END;
77 $$
78 DELIMITER ;$$
79 DROP TABLE t1,t2;
80
81 --let $binlog_file = LAST
82 source include/show_binlog_events.inc;