Debian Codegraph @

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

raw
1 #
2 # BUG#49562: SBR out of sync when using numeric data types + user variable
3 #
4
5 -- source include/not_group_replication_plugin.inc
6 -- source include/have_binlog_format_statement.inc
7 -- source include/master-slave.inc
8
9 SET sql_mode = default;
10
11 --echo
12 --echo # The GET DIAGNOSTICS itself is not replicated, but it can set
13 --echo # variables which can be used in statements that are replicated.
14 --echo
15
16 --source include/rpl_reset.inc
17 connection master;
18
19 CREATE TABLE t1 (a INT, b INT);
20 GET DIAGNOSTICS @var1 = NUMBER;
21 INSERT INTO t1 VALUES (@var1, 0), (@var1, 0);
22
23 DELIMITER |;
24 CREATE PROCEDURE p1()
25 LANGUAGE SQL
26 BEGIN
27 DECLARE count INT;
28 UPDATE t1 SET b = 2 WHERE a = 0;
29 GET DIAGNOSTICS count = ROW_COUNT;
30 INSERT INTO t1 VALUES (1, count);
31 END|
32 DELIMITER ;|
33
34 CALL p1();
35
36 --source include/sync_slave_sql_with_master.inc
37
38 connection slave;
39 --echo # On slave, check if the statement was replicated.
40 SELECT * FROM t1 ORDER BY a;
41
42 connection master;
43 --let $mask_binlog_commit_events= 1
44 --echo # Show events and cleanup
45 --source include/show_binlog_events.inc
46 --let $mask_binlog_commit_events= 0
47 DROP TABLE t1;
48 DROP PROCEDURE p1;
49
50 --source include/sync_slave_sql_with_master.inc
51
52 --source include/rpl_end.inc