Debian Codegraph @

mysql-test/suite/sys_vars/r/binlog_checksum_basic.result

raw
1 set @save_binlog_checksum= @@global.binlog_checksum;
2 set @@global.binlog_checksum = default;
3 select @@global.binlog_checksum as 'must be CRC32 by default';
4 must be CRC32 by default
5 CRC32
6 select @@session.binlog_checksum as 'no session var';
7 ERROR HY000: Variable 'binlog_checksum' is a GLOBAL variable
8 set @@global.binlog_checksum = CRC32;
9 set @@global.binlog_checksum = CRC32;
10 set @@global.source_verify_checksum = 0;
11 set @@global.source_verify_checksum = default;
12 set @@global.binlog_checksum = ADLER32;
13 ERROR 42000: Variable 'binlog_checksum' can't be set to the value of 'ADLER32'
14 #
15 # Bug#22914463 SET BINLOG_CHECKSUM CRASHES WHEN EXECUTED INSIDE
16 # TRANSACTION
17 #
18 # Check that changing binlog_checksum inside transacation
19 # is not allowed.
20 #
21 BEGIN;
22 SET @@global.binlog_checksum = CRC32;
23 ERROR HY000: The system variable binlog_checksum cannot be set when there is an ongoing transaction.
24 COMMIT;
25 XA START 'trx1';
26 SET @@global.binlog_checksum = CRC32;
27 ERROR HY000: The system variable binlog_checksum cannot be set when there is an ongoing transaction.
28 XA END 'trx1';
29 XA ROLLBACK 'trx1';
30 #
31 # Check that changing binlog_checksum if the session owns
32 # a GTID is not allowed.
33 #
34 SET GLOBAL GTID_MODE=OFF_PERMISSIVE;
35 SET GLOBAL GTID_MODE=ON_PERMISSIVE;
36 SET GLOBAL ENFORCE_GTID_CONSISTENCY=ON;
37 SET GLOBAL GTID_MODE=ON;
38 SET SESSION GTID_NEXT='11111111-AAAA-2222-BBBB-000000000000:5';
39 SET @@global.binlog_checksum = CRC32;
40 ERROR HY000: Variable binlog_checksum cannot be changed by a client that owns a GTID. The client owns 11111111-aaaa-2222-bbbb-000000000000:5. Ownership is released on COMMIT or ROLLBACK.
41 SET SESSION GTID_NEXT='AUTOMATIC';
42 SET GLOBAL GTID_MODE=ON_PERMISSIVE;
43 SET GLOBAL GTID_MODE=OFF_PERMISSIVE;
44 SET GLOBAL ENFORCE_GTID_CONSISTENCY=OFF;
45 SET GLOBAL GTID_MODE=OFF;
46 set @@global.binlog_checksum = @save_binlog_checksum;