| 1 |
set @save_slave_sql_verify_checksum = @@global.slave_sql_verify_checksum; |
| 2 |
select @@global.slave_sql_verify_checksum as 'must be one because of default'; |
| 3 |
must be one because of default |
| 4 |
1 |
| 5 |
select @@session.slave_sql_verify_checksum as 'no session var'; |
| 6 |
ERROR HY000: Variable 'slave_sql_verify_checksum' is a GLOBAL variable |
| 7 |
set @@global.slave_sql_verify_checksum = 0; |
| 8 |
set @@global.slave_sql_verify_checksum = default; |
| 9 |
set @@global.slave_sql_verify_checksum = 2; |
| 10 |
ERROR 42000: Variable 'slave_sql_verify_checksum' can't be set to the value of '2' |
| 11 |
set @@global.slave_sql_verify_checksum = @save_slave_sql_verify_checksum; |