Debian Codegraph @

mysql-test/suite/galera_sr/t/MDEV-18585.test

raw
1 #
2 # MDEV-18686 Verify that the Annotate_rows_log_event is written only
3 # once per statement into binlog.
4 #
5 --source include/galera_cluster.inc
6
7 CREATE TABLE t1 (f1 INT PRIMARY KEY);
8
9 #
10 # Unit ROW
11 #
12 SET SESSION wsrep_trx_fragment_unit='ROWS';
13 SET SESSION wsrep_trx_fragment_size=1;
14
15 --let $start_pos= query_get_value(SHOW MASTER STATUS, Position, 1)
16
17 INSERT INTO t1 VALUES (1), (2);
18
19 #
20 # Unit BYTE
21 #
22 SET SESSION wsrep_trx_fragment_unit='BYTES';
23 SET SESSION wsrep_trx_fragment_size=1;
24
25 INSERT INTO t1 VALUES (3), (4);
26
27 #
28 # Unit STATEMENT
29 #
30 SET SESSION wsrep_trx_fragment_unit='STATEMENTS';
31 SET SESSION wsrep_trx_fragment_size=1;
32
33 INSERT INTO t1 VALUES (5), (6);
34
35 #
36 # Reset to default settings
37 #
38 SET SESSION wsrep_trx_fragment_unit=default;
39 SET SESSION wsrep_trx_fragment_size=default;
40
41 --replace_regex /table_id: [0-9]+/table_id: #/ /xid=[0-9]+/xid=#/
42 --replace_column 2 # 5 #
43 --eval SHOW BINLOG EVENTS IN 'mysqld-bin.000002' FROM $start_pos
44
45 DROP TABLE t1;