1SET @start_global_value = @@global.net_read_timeout;
2SELECT @start_global_value;
3@start_global_value
430
5SET @start_session_value = @@session.net_read_timeout;
6SELECT @start_session_value;
7@start_session_value
830
9'#--------------------FN_DYNVARS_110_01-------------------------#'
10SET @@global.net_read_timeout = 100;
11SET @@global.net_read_timeout = DEFAULT;
12SELECT @@global.net_read_timeout;
13@@global.net_read_timeout
1430
15SET @@session.net_read_timeout = 200;
16SET @@session.net_read_timeout = DEFAULT;
17SELECT @@session.net_read_timeout;
18@@session.net_read_timeout
1930
20'#--------------------FN_DYNVARS_110_02-------------------------#'
21SET @@global.net_read_timeout = DEFAULT;
22SELECT @@global.net_read_timeout = 30;
23@@global.net_read_timeout = 30
241
25SET @@session.net_read_timeout = DEFAULT;
26SELECT @@session.net_read_timeout = 30;
27@@session.net_read_timeout = 30
281
29'#--------------------FN_DYNVARS_110_03-------------------------#'
30SET @@global.net_read_timeout = 1;
31SELECT @@global.net_read_timeout;
32@@global.net_read_timeout
331
34SET @@global.net_read_timeout = 60020;
35SELECT @@global.net_read_timeout;
36@@global.net_read_timeout
3760020
38SET @@global.net_read_timeout = 65535;
39SELECT @@global.net_read_timeout;
40@@global.net_read_timeout
4165535
42'#--------------------FN_DYNVARS_110_04-------------------------#'
43SET @@session.net_read_timeout = 1;
44SELECT @@session.net_read_timeout;
45@@session.net_read_timeout
461
47SET @@session.net_read_timeout = 50050;
48SELECT @@session.net_read_timeout;
49@@session.net_read_timeout
5050050
51SET @@session.net_read_timeout = 65535;
52SELECT @@session.net_read_timeout;
53@@session.net_read_timeout
5465535
55'#------------------FN_DYNVARS_110_05-----------------------#'
56SET @@global.net_read_timeout = 0;
57Warnings:
58Warning	1292	Truncated incorrect net_read_timeout value: '0'
59SELECT @@global.net_read_timeout;
60@@global.net_read_timeout
611
62SET @@global.net_read_timeout = -1024;
63Warnings:
64Warning	1292	Truncated incorrect net_read_timeout value: '-1024'
65SELECT @@global.net_read_timeout;
66@@global.net_read_timeout
671
68SET @@global.net_read_timeout = 655360354;
69Warnings:
70Warning	1292	Truncated incorrect net_read_timeout value: '655360354'
71SELECT @@global.net_read_timeout;
72@@global.net_read_timeout
7331536000
74SET @@global.net_read_timeout = 65530.34;
75ERROR 42000: Incorrect argument type to variable 'net_read_timeout'
76SELECT @@global.net_read_timeout;
77@@global.net_read_timeout
7831536000
79SET @@global.net_read_timeout = test;
80ERROR 42000: Incorrect argument type to variable 'net_read_timeout'
81SELECT @@global.net_read_timeout;
82@@global.net_read_timeout
8331536000
84SET @@global.net_read_timeout = ' ';
85ERROR 42000: Incorrect argument type to variable 'net_read_timeout'
86SELECT @@global.net_read_timeout;
87@@global.net_read_timeout
8831536000
89SET @@session.net_read_timeout = 0;
90Warnings:
91Warning	1292	Truncated incorrect net_read_timeout value: '0'
92SELECT @@session.net_read_timeout;
93@@session.net_read_timeout
941
95SET @@session.net_read_timeout = -2;
96Warnings:
97Warning	1292	Truncated incorrect net_read_timeout value: '-2'
98SELECT @@session.net_read_timeout;
99@@session.net_read_timeout
1001
101SET @@session.net_read_timeout = 65530.34;
102ERROR 42000: Incorrect argument type to variable 'net_read_timeout'
103SET @@session.net_read_timeout = 6555015425;
104Warnings:
105Warning	1292	Truncated incorrect net_read_timeout value: '6555015425'
106SELECT @@session.net_read_timeout;
107@@session.net_read_timeout
10831536000
109SET @@session.net_read_timeout = test;
110ERROR 42000: Incorrect argument type to variable 'net_read_timeout'
111SELECT @@session.net_read_timeout;
112@@session.net_read_timeout
11331536000
114SET @@session.net_read_timeout = ' ';
115ERROR 42000: Incorrect argument type to variable 'net_read_timeout'
116SELECT @@session.net_read_timeout;
117@@session.net_read_timeout
11831536000
119'#------------------FN_DYNVARS_110_06-----------------------#'
120SELECT @@global.net_read_timeout = VARIABLE_VALUE
121FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
122WHERE VARIABLE_NAME='net_read_timeout';
123@@global.net_read_timeout = VARIABLE_VALUE
1241
125'#------------------FN_DYNVARS_110_07-----------------------#'
126SELECT @@session.net_read_timeout = VARIABLE_VALUE
127FROM INFORMATION_SCHEMA.SESSION_VARIABLES
128WHERE VARIABLE_NAME='net_read_timeout';
129@@session.net_read_timeout = VARIABLE_VALUE
1301
131'#------------------FN_DYNVARS_110_08-----------------------#'
132SET @@global.net_read_timeout = TRUE;
133SELECT @@global.net_read_timeout;
134@@global.net_read_timeout
1351
136SET @@global.net_read_timeout = FALSE;
137Warnings:
138Warning	1292	Truncated incorrect net_read_timeout value: '0'
139SELECT @@global.net_read_timeout;
140@@global.net_read_timeout
1411
142'#---------------------FN_DYNVARS_110_09----------------------#'
143SET @@global.net_read_timeout = 10;
144SELECT @@net_read_timeout = @@global.net_read_timeout;
145@@net_read_timeout = @@global.net_read_timeout
1460
147'#---------------------FN_DYNVARS_110_10----------------------#'
148SET @@net_read_timeout = 100;
149SELECT @@net_read_timeout = @@local.net_read_timeout;
150@@net_read_timeout = @@local.net_read_timeout
1511
152SELECT @@local.net_read_timeout = @@session.net_read_timeout;
153@@local.net_read_timeout = @@session.net_read_timeout
1541
155'#---------------------FN_DYNVARS_110_11----------------------#'
156SET net_read_timeout = 1;
157SELECT @@net_read_timeout;
158@@net_read_timeout
1591
160SELECT local.net_read_timeout;
161ERROR 42S02: Unknown table 'local' in field list
162SELECT session.net_read_timeout;
163ERROR 42S02: Unknown table 'session' in field list
164SELECT net_read_timeout = @@session.net_read_timeout;
165ERROR 42S22: Unknown column 'net_read_timeout' in 'field list'
166SET @@global.net_read_timeout = @start_global_value;
167SELECT @@global.net_read_timeout;
168@@global.net_read_timeout
16930
170SET @@session.net_read_timeout = @start_session_value;
171SELECT @@session.net_read_timeout;
172@@session.net_read_timeout
17330
174