Debian Codegraph @

mysql-test/suite/sys_vars/r/sql_slave_skip_counter_basic.result

raw
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;