Debian Codegraph @

mysql-test/suite/sys_vars/t/binlog_checksum_basic.test

raw
1
2 # suite/rpl/t/rpl_checksum.test contains similar testing of
3 # all checksum related system variables.
4
5 set @save_binlog_checksum= @@global.binlog_checksum;
6 set @@global.binlog_checksum = default;
7
8 select @@global.binlog_checksum as 'must be CRC32 by default';
9 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
10 select @@session.binlog_checksum as 'no session var';
11
12
13 # testing lack of side-effects in non-effective update of binlog_checksum:
14 set @@global.binlog_checksum = CRC32;
15 set @@global.binlog_checksum = CRC32;
16
17 set @@global.source_verify_checksum = 0;
18 set @@global.source_verify_checksum = default;
19
20 --error ER_WRONG_VALUE_FOR_VAR
21 set @@global.binlog_checksum = ADLER32;
22
23 --echo #
24 --echo # Bug#22914463 SET BINLOG_CHECKSUM CRASHES WHEN EXECUTED INSIDE
25 --echo # TRANSACTION
26 --echo #
27
28 --echo # Check that changing binlog_checksum inside transacation
29 --echo # is not allowed.
30 --echo #
31 BEGIN;
32 --error ER_VARIABLE_NOT_SETTABLE_IN_TRANSACTION
33 SET @@global.binlog_checksum = CRC32;
34 COMMIT;
35
36 XA START 'trx1';
37 --error ER_VARIABLE_NOT_SETTABLE_IN_TRANSACTION
38 SET @@global.binlog_checksum = CRC32;
39 XA END 'trx1';
40 XA ROLLBACK 'trx1';
41
42 --echo #
43 --echo # Check that changing binlog_checksum if the session owns
44 --echo # a GTID is not allowed.
45 --echo #
46 SET GLOBAL GTID_MODE=OFF_PERMISSIVE;
47 SET GLOBAL GTID_MODE=ON_PERMISSIVE;
48 SET GLOBAL ENFORCE_GTID_CONSISTENCY=ON;
49 SET GLOBAL GTID_MODE=ON;
50 SET SESSION GTID_NEXT='11111111-AAAA-2222-BBBB-000000000000:5';
51 --error ER_CANT_SET_VARIABLE_WHEN_OWNING_GTID
52 SET @@global.binlog_checksum = CRC32;
53 SET SESSION GTID_NEXT='AUTOMATIC';
54 SET GLOBAL GTID_MODE=ON_PERMISSIVE;
55 SET GLOBAL GTID_MODE=OFF_PERMISSIVE;
56 SET GLOBAL ENFORCE_GTID_CONSISTENCY=OFF;
57 SET GLOBAL GTID_MODE=OFF;
58
59 # cleanup
60 set @@global.binlog_checksum = @save_binlog_checksum;