1
SET @start_global_value = @@global.slave_net_timeout;
2
SELECT @start_global_value;
5
'#--------------------FN_DYNVARS_146_01-------------------------#'
6
SET @@global.slave_net_timeout = 500000;
7
SET @@global.slave_net_timeout = DEFAULT;
8
SELECT @@global.slave_net_timeout;
9
@@global.slave_net_timeout
11
'#--------------------FN_DYNVARS_146_02-------------------------#'
12
SET @@global.slave_net_timeout = DEFAULT;
13
SELECT @@global.slave_net_timeout = 3600;
14
@@global.slave_net_timeout = 3600
16
'#--------------------FN_DYNVARS_146_03-------------------------#'
17
SET @@global.slave_net_timeout = 0;
19
Warning 1292 Truncated incorrect slave_net_timeout value: '0'
20
SELECT @@global.slave_net_timeout;
21
@@global.slave_net_timeout
23
SET @@global.slave_net_timeout = 1;
24
SELECT @@global.slave_net_timeout;
25
@@global.slave_net_timeout
27
SET @@global.slave_net_timeout = 15;
28
SELECT @@global.slave_net_timeout;
29
@@global.slave_net_timeout
31
SET @@global.slave_net_timeout = 1024;
32
SELECT @@global.slave_net_timeout;
33
@@global.slave_net_timeout
35
SET @@global.slave_net_timeout = 3600+1;
36
SELECT @@global.slave_net_timeout;
37
@@global.slave_net_timeout
39
SET @@global.slave_net_timeout = 2147483648;
41
Warning 1292 Truncated incorrect slave_net_timeout value: '2147483648'
42
SELECT @@global.slave_net_timeout;
43
@@global.slave_net_timeout
45
SET @@global.slave_net_timeout = 2147483648*2-1;
47
Warning 1292 Truncated incorrect slave_net_timeout value: '4294967295'
48
SELECT @@global.slave_net_timeout;
49
@@global.slave_net_timeout
51
'#--------------------FN_DYNVARS_146_04-------------------------#'
52
SET @@slave_net_timeout = 2;
53
ERROR HY000: Variable 'slave_net_timeout' is a GLOBAL variable and should be set with SET GLOBAL
54
SET @@session.slave_net_timeout = 3;
55
ERROR HY000: Variable 'slave_net_timeout' is a GLOBAL variable and should be set with SET GLOBAL
56
SET @@local.slave_net_timeout = 4;
57
ERROR HY000: Variable 'slave_net_timeout' is a GLOBAL variable and should be set with SET GLOBAL
58
'#------------------FN_DYNVARS_146_05-----------------------#'
59
SET @@global.slave_net_timeout = -1;
61
Warning 1292 Truncated incorrect slave_net_timeout value: '0'
62
SELECT @@global.slave_net_timeout;
63
@@global.slave_net_timeout
65
SET @@global.slave_net_timeout = -2147483648;
67
Warning 1292 Truncated incorrect slave_net_timeout value: '0'
68
SELECT @@global.slave_net_timeout;
69
@@global.slave_net_timeout
71
SET @@global.slave_net_timeout = 2147483649*2;
73
Warning 1292 Truncated incorrect slave_net_timeout value: '4294967298'
74
SELECT @@global.slave_net_timeout;
75
@@global.slave_net_timeout
77
SET @@global.slave_net_timeout = 65530.34.;
78
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.' at line 1
79
SET @@global.slave_net_timeout = 100s;
80
ERROR 42000: Incorrect argument type to variable 'slave_net_timeout'
81
SET @@global.slave_net_timeout = 7483649.56;
82
ERROR 42000: Incorrect argument type to variable 'slave_net_timeout'
83
SET @@global.slave_net_timeout = 0.6;
84
ERROR 42000: Incorrect argument type to variable 'slave_net_timeout'
85
'Bug# 34877: Invalid Values are coming in variable on assigning valid values';
86
'#------------------FN_DYNVARS_146_06-----------------------#'
87
SET @@global.slave_net_timeout = 3000;
88
SELECT @@global.slave_net_timeout = VARIABLE_VALUE
89
FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
90
WHERE VARIABLE_NAME='slave_net_timeout';
91
@@global.slave_net_timeout = VARIABLE_VALUE
93
'#------------------FN_DYNVARS_146_07-----------------------#'
94
SELECT count(VARIABLE_VALUE)
95
FROM INFORMATION_SCHEMA.SESSION_VARIABLES
96
WHERE VARIABLE_NAME='slave_net_timeout';
99
'#------------------FN_DYNVARS_146_08-----------------------#'
100
SET @@global.slave_net_timeout = TRUE;
101
SELECT @@global.slave_net_timeout;
102
@@global.slave_net_timeout
104
SET @@global.slave_net_timeout = FALSE;
106
Warning 1292 Truncated incorrect slave_net_timeout value: '0'
107
SELECT @@global.slave_net_timeout;
108
@@global.slave_net_timeout
110
'#---------------------FN_DYNVARS_001_09----------------------#'
111
SET @@global.slave_net_timeout = 60*60;
112
SELECT @@slave_net_timeout = @@global.slave_net_timeout;
113
@@slave_net_timeout = @@global.slave_net_timeout
115
'#---------------------FN_DYNVARS_001_10----------------------#'
116
SET slave_net_timeout = 2048;
117
ERROR HY000: Variable 'slave_net_timeout' is a GLOBAL variable and should be set with SET GLOBAL
118
SELECT slave_net_timeout;
119
ERROR 42S22: Unknown column 'slave_net_timeout' in 'field list'
120
SELECT @@slave_net_timeout;
123
SET global slave_net_timeout = 99;
124
SET @@global.slave_net_timeout = @start_global_value;
125
SELECT @@global.slave_net_timeout;
126
@@global.slave_net_timeout