1
SET @start_global_value = @@global.net_read_timeout;
2
SELECT @start_global_value;
5
SET @start_session_value = @@session.net_read_timeout;
6
SELECT @start_session_value;
9
'#--------------------FN_DYNVARS_110_01-------------------------#'
10
SET @@global.net_read_timeout = 100;
11
SET @@global.net_read_timeout = DEFAULT;
12
SELECT @@global.net_read_timeout;
13
@@global.net_read_timeout
15
SET @@session.net_read_timeout = 200;
16
SET @@session.net_read_timeout = DEFAULT;
17
SELECT @@session.net_read_timeout;
18
@@session.net_read_timeout
20
'#--------------------FN_DYNVARS_110_02-------------------------#'
21
SET @@global.net_read_timeout = DEFAULT;
22
SELECT @@global.net_read_timeout = 30;
23
@@global.net_read_timeout = 30
25
SET @@session.net_read_timeout = DEFAULT;
26
SELECT @@session.net_read_timeout = 30;
27
@@session.net_read_timeout = 30
29
'#--------------------FN_DYNVARS_110_03-------------------------#'
30
SET @@global.net_read_timeout = 1;
31
SELECT @@global.net_read_timeout;
32
@@global.net_read_timeout
34
SET @@global.net_read_timeout = 60020;
35
SELECT @@global.net_read_timeout;
36
@@global.net_read_timeout
38
SET @@global.net_read_timeout = 65535;
39
SELECT @@global.net_read_timeout;
40
@@global.net_read_timeout
42
'#--------------------FN_DYNVARS_110_04-------------------------#'
43
SET @@session.net_read_timeout = 1;
44
SELECT @@session.net_read_timeout;
45
@@session.net_read_timeout
47
SET @@session.net_read_timeout = 50050;
48
SELECT @@session.net_read_timeout;
49
@@session.net_read_timeout
51
SET @@session.net_read_timeout = 65535;
52
SELECT @@session.net_read_timeout;
53
@@session.net_read_timeout
55
'#------------------FN_DYNVARS_110_05-----------------------#'
56
SET @@global.net_read_timeout = 0;
58
Warning 1292 Truncated incorrect net_read_timeout value: '0'
59
SELECT @@global.net_read_timeout;
60
@@global.net_read_timeout
62
SET @@global.net_read_timeout = -1024;
64
Warning 1292 Truncated incorrect net_read_timeout value: '-1024'
65
SELECT @@global.net_read_timeout;
66
@@global.net_read_timeout
68
SET @@global.net_read_timeout = 655360354;
70
Warning 1292 Truncated incorrect net_read_timeout value: '655360354'
71
SELECT @@global.net_read_timeout;
72
@@global.net_read_timeout
74
SET @@global.net_read_timeout = 65530.34;
75
ERROR 42000: Incorrect argument type to variable 'net_read_timeout'
76
SELECT @@global.net_read_timeout;
77
@@global.net_read_timeout
79
SET @@global.net_read_timeout = test;
80
ERROR 42000: Incorrect argument type to variable 'net_read_timeout'
81
SELECT @@global.net_read_timeout;
82
@@global.net_read_timeout
84
SET @@session.net_read_timeout = 0;
86
Warning 1292 Truncated incorrect net_read_timeout value: '0'
87
SELECT @@session.net_read_timeout;
88
@@session.net_read_timeout
90
SET @@session.net_read_timeout = -2;
92
Warning 1292 Truncated incorrect net_read_timeout value: '-2'
93
SELECT @@session.net_read_timeout;
94
@@session.net_read_timeout
96
SET @@session.net_read_timeout = 65530.34;
97
ERROR 42000: Incorrect argument type to variable 'net_read_timeout'
98
SET @@session.net_read_timeout = 6555015425;
100
Warning 1292 Truncated incorrect net_read_timeout value: '6555015425'
101
SELECT @@session.net_read_timeout;
102
@@session.net_read_timeout
104
SET @@session.net_read_timeout = test;
105
ERROR 42000: Incorrect argument type to variable 'net_read_timeout'
106
SELECT @@session.net_read_timeout;
107
@@session.net_read_timeout
109
'#------------------FN_DYNVARS_110_06-----------------------#'
110
SELECT @@global.net_read_timeout = VARIABLE_VALUE
111
FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
112
WHERE VARIABLE_NAME='net_read_timeout';
113
@@global.net_read_timeout = VARIABLE_VALUE
115
'#------------------FN_DYNVARS_110_07-----------------------#'
116
SELECT @@session.net_read_timeout = VARIABLE_VALUE
117
FROM INFORMATION_SCHEMA.SESSION_VARIABLES
118
WHERE VARIABLE_NAME='net_read_timeout';
119
@@session.net_read_timeout = VARIABLE_VALUE
121
'#------------------FN_DYNVARS_110_08-----------------------#'
122
SET @@global.net_read_timeout = TRUE;
123
SELECT @@global.net_read_timeout;
124
@@global.net_read_timeout
126
SET @@global.net_read_timeout = FALSE;
128
Warning 1292 Truncated incorrect net_read_timeout value: '0'
129
SELECT @@global.net_read_timeout;
130
@@global.net_read_timeout
132
'#---------------------FN_DYNVARS_110_09----------------------#'
133
SET @@global.net_read_timeout = 10;
134
SELECT @@net_read_timeout = @@global.net_read_timeout;
135
@@net_read_timeout = @@global.net_read_timeout
137
'#---------------------FN_DYNVARS_110_10----------------------#'
138
SET @@net_read_timeout = 100;
139
SELECT @@net_read_timeout = @@local.net_read_timeout;
140
@@net_read_timeout = @@local.net_read_timeout
142
SELECT @@local.net_read_timeout = @@session.net_read_timeout;
143
@@local.net_read_timeout = @@session.net_read_timeout
145
'#---------------------FN_DYNVARS_110_11----------------------#'
146
SET net_read_timeout = 1;
147
SELECT @@net_read_timeout;
150
SELECT local.net_read_timeout;
151
ERROR 42S02: Unknown table 'local' in field list
152
SELECT session.net_read_timeout;
153
ERROR 42S02: Unknown table 'session' in field list
154
SELECT net_read_timeout = @@session.net_read_timeout;
155
ERROR 42S22: Unknown column 'net_read_timeout' in 'field list'
156
SET @@global.net_read_timeout = @start_global_value;
157
SELECT @@global.net_read_timeout;
158
@@global.net_read_timeout
160
SET @@session.net_read_timeout = @start_session_value;
161
SELECT @@session.net_read_timeout;
162
@@session.net_read_timeout