Debian Codegraph @

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

raw
1 #
2 # WL#3549
3 #
4 # Additional tests
5 #
6 --source include/have_binlog_format_row.inc
7
8 --let $saved_binlog_transaction_compression_session = `SELECT @@SESSION.binlog_transaction_compression`
9 --let $saved_binlog_transaction_compression_level_zstd_session = `SELECT @@SESSION.binlog_transaction_compression_level_zstd`
10 --let $pfs_table = performance_schema.binary_log_transaction_compression_stats
11
12 #
13 # Test 1: Check that end_log_pos is the same for all events
14 # packed inside Transaction_payload_event
15 #
16
17 SET SESSION binlog_transaction_compression = ON;
18 CREATE TABLE t1(c1 INT PRIMARY KEY, data TEXT(30000));
19 CREATE TABLE t2(c1 INT PRIMARY KEY, data TEXT(30000));
20
21 RESET MASTER;
22
23 BEGIN;
24 INSERT INTO t1 VALUES (1, REPEAT ('a', 1000));
25 INSERT INTO t2 VALUES (1, REPEAT ('b', 1000));
26 COMMIT;
27
28 # 1 - Format_desc event, 2 - Previous_gtids event, 3 - Gtid event
29 --let $tple_elp= query_get_value(SHOW BINLOG EVENTS, End_log_pos, 4)
30
31 --let $i = 5
32
33 while ($i < 11)
34 {
35 # 5 - Query, 6 - Table_map, 7 - Write_rows, 8 - Table_map, 9 - Write_rows, 10 - Xid
36 if ($i == 5) { let $evt_expected = Query; }
37 if ($i == 6) { let $evt_expected = Table_map; }
38 if ($i == 7) { let $evt_expected = Write_rows; }
39 if ($i == 8) { let $evt_expected = Table_map; }
40 if ($i == 9) { let $evt_expected = Write_rows; }
41 if ($i == 10) { let $evt_expected = Xid; }
42
43 --let $evt_elp= query_get_value(SHOW BINLOG EVENTS, End_log_pos, $i)
44 --let $assert_text = $evt_expected event has same end_log_pos as the Transaction_payload_event
45 --let $assert_cond = $evt_elp = $tple_elp
46 --source include/assert.inc
47
48 --inc $i
49 }
50
51 DROP TABLE IF EXISTS t1, t2;
52 --replace_result $saved_binlog_transaction_compression_session SAVED
53 --eval SET SESSION binlog_transaction_compression = $saved_binlog_transaction_compression_session
54 RESET MASTER;
55 --eval TRUNCATE $pfs_table
56
57 #
58 # Test 2: coverage for the compression level
59 #
60
61 SET SESSION binlog_transaction_compression = ON;
62 CREATE TABLE t1(c1 INT PRIMARY KEY, data TEXT(30000));
63
64 BEGIN;
65 INSERT INTO t1 VALUES (1, REPEAT ('1', 1000));
66 COMMIT;
67
68 SET @@binlog_transaction_compression_level_zstd = 10;
69
70 BEGIN;
71 INSERT INTO t1 VALUES (2, REPEAT ('2', 1000));
72 COMMIT;
73
74 DROP TABLE t1;
75
76 --replace_result $saved_binlog_transaction_compression_session SAVED
77 --eval SET SESSION binlog_transaction_compression = $saved_binlog_transaction_compression_session
78
79 --replace_result $saved_binlog_transaction_compression_level_zstd_session SAVED
80 --eval SET SESSION binlog_transaction_compression_level_zstd = $saved_binlog_transaction_compression_level_zstd_session
81
82 --eval TRUNCATE $pfs_table
83 RESET MASTER;