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