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