Debian Codegraph @

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

raw
1 # The test file contains tests specific to one phase commit
2 # execution and binlogging.
3 #
4 # MDEV-26031 unnessary xid logging in one phase commit case
5 #
6 --source include/have_innodb.inc
7 --source include/have_aria.inc
8 --source include/have_binlog_format_mixed.inc
9
10 RESET MASTER;
11
12 CREATE TABLE t (f INT) ENGINE=INNODB;
13 CREATE TABLE ta (f INT) ENGINE=Aria;
14
15 --let $binlog_start = query_get_value(SHOW MASTER STATUS, Position, 1)
16 BEGIN;
17 INSERT INTO t SET f = 1;
18 INSERT INTO ta SET f = 1;
19 COMMIT;
20 --let $binlog_file = query_get_value(SHOW MASTER STATUS, File, 1)
21 --source include/show_binlog_events.inc
22
23 --echo # Prove that binlog is resettable. Under the bug condition it was not.
24 RESET MASTER;
25
26 --let $binlog_start = query_get_value(SHOW MASTER STATUS, Position, 1)
27 --let $binlog_file = query_get_value(SHOW MASTER STATUS, File, 1)
28 SET @@binlog_format = ROW;
29 CREATE TABLE ta2 ENGINE = Aria SELECT * from t;
30 --source include/show_binlog_events.inc
31
32 --echo # Prove that binlog is resettable. Under the bug condition it was not.
33 RESET MASTER;
34
35
36 --echo # Cleanup
37 DROP TABLE ta2, ta, t;
38
39 --echo # End of the tests