| 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.master_verify_checksum = 0; |
| 11 |
set @@global.master_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 |
set @@global.binlog_checksum = @save_binlog_checksum; |