| 1 |
'#--------------------FN_DYNVARS_165_01-------------------------#' |
| 2 |
SET @start_global_value = @@global.sql_slave_skip_counter; |
| 3 |
SELECT @@global.sql_slave_skip_counter; |
| 4 |
@@global.sql_slave_skip_counter |
| 5 |
0 |
| 6 |
'#--------------------FN_DYNVARS_165_02-------------------------#' |
| 7 |
SET @@global.sql_slave_skip_counter = DEFAULT; |
| 8 |
'#--------------------FN_DYNVARS_165_03-------------------------#' |
| 9 |
SET @@global.sql_slave_skip_counter = 0; |
| 10 |
SET @@global.sql_slave_skip_counter = 5; |
| 11 |
SET @@global.sql_slave_skip_counter = 1024; |
| 12 |
SET @@global.sql_slave_skip_counter = 2147483648; |
| 13 |
SET @@global.sql_slave_skip_counter = 2147483648*2; |
| 14 |
Warnings: |
| 15 |
Warning 1292 Truncated incorrect sql_slave_skip_counter value: '4294967296' |
| 16 |
SET @@global.sql_slave_skip_counter = 2147483648*2-1; |
| 17 |
SET @@global.sql_slave_skip_counter = 18446744065119617025; |
| 18 |
Warnings: |
| 19 |
Warning 1292 Truncated incorrect sql_slave_skip_counter value: '18446744065119617025' |
| 20 |
'#--------------------FN_DYNVARS_165_03-------------------------#' |
| 21 |
SET @@global.sql_slave_skip_counter = '5'; |
| 22 |
ERROR 42000: Incorrect argument type to variable 'sql_slave_skip_counter' |
| 23 |
SET @@global.sql_slave_skip_counter = 5.5; |
| 24 |
ERROR 42000: Incorrect argument type to variable 'sql_slave_skip_counter' |
| 25 |
SET @@global.sql_slave_skip_counter = -.5; |
| 26 |
ERROR 42000: Incorrect argument type to variable 'sql_slave_skip_counter' |
| 27 |
SET @@global.sql_slave_skip_counter = -.0; |
| 28 |
ERROR 42000: Incorrect argument type to variable 'sql_slave_skip_counter' |
| 29 |
'#--------------------FN_DYNVARS_165_03-------------------------#' |
| 30 |
SET @@global.sql_slave_skip_counter = 1024; |
| 31 |
SELECT VARIABLE_VALUE |
| 32 |
FROM INFORMATION_SCHEMA.SESSION_VARIABLES |
| 33 |
WHERE VARIABLE_NAME='sql_slave_skip_counter'; |
| 34 |
VARIABLE_VALUE |
| 35 |
1024 |
| 36 |
'#--------------------FN_DYNVARS_165_03-------------------------#' |
| 37 |
SET @@sql_slave_skip_counter = 10; |
| 38 |
SET @@session.sql_slave_skip_counter = 12; |
| 39 |
SET @@local.sql_slave_skip_counter = 13; |
| 40 |
SET @@global.sql_slave_skip_counter = 0; |