Debian Codegraph @

mysql-test/suite/binlog/r/compression_extra.result

raw
1 SET SESSION binlog_transaction_compression = ON;
2 CREATE TABLE t1(c1 INT PRIMARY KEY, data TEXT(30000));
3 CREATE TABLE t2(c1 INT PRIMARY KEY, data TEXT(30000));
4 RESET MASTER;
5 BEGIN;
6 INSERT INTO t1 VALUES (1, REPEAT ('a', 1000));
7 INSERT INTO t2 VALUES (1, REPEAT ('b', 1000));
8 COMMIT;
9 include/assert.inc [Query event has same end_log_pos as the Transaction_payload_event]
10 include/assert.inc [Table_map event has same end_log_pos as the Transaction_payload_event]
11 include/assert.inc [Write_rows event has same end_log_pos as the Transaction_payload_event]
12 include/assert.inc [Table_map event has same end_log_pos as the Transaction_payload_event]
13 include/assert.inc [Write_rows event has same end_log_pos as the Transaction_payload_event]
14 include/assert.inc [Xid event has same end_log_pos as the Transaction_payload_event]
15 DROP TABLE IF EXISTS t1, t2;
16 SET SESSION binlog_transaction_compression = SAVED;
17 RESET MASTER;
18 TRUNCATE performance_schema.binary_log_transaction_compression_stats;
19 SET SESSION binlog_transaction_compression = ON;
20 CREATE TABLE t1(c1 INT PRIMARY KEY, data TEXT(30000));
21 BEGIN;
22 INSERT INTO t1 VALUES (1, REPEAT ('1', 1000));
23 COMMIT;
24 SET @@binlog_transaction_compression_level_zstd = 10;
25 BEGIN;
26 INSERT INTO t1 VALUES (2, REPEAT ('2', 1000));
27 COMMIT;
28 DROP TABLE t1;
29 SET SESSION binlog_transaction_compression = SAVED;
30 SET SESSION binlog_transaction_compression_level_zstd = SAVED;
31 TRUNCATE performance_schema.binary_log_transaction_compression_stats;
32 RESET MASTER;