1SET @start_global_value = @@global.net_retry_count;
2SELECT @start_global_value;
3@start_global_value
410
5SET @start_session_value = @@session.net_retry_count;
6SELECT @start_session_value;
7@start_session_value
810
9'#--------------------FN_DYNVARS_111_01-------------------------#'
10SET @@global.net_retry_count = 100;
11SET @@global.net_retry_count = DEFAULT;
12SELECT @@global.net_retry_count;
13@@global.net_retry_count
1410
15SET @@session.net_retry_count = 200;
16SET @@session.net_retry_count = DEFAULT;
17SELECT @@session.net_retry_count;
18@@session.net_retry_count
1910
20'#--------------------FN_DYNVARS_111_02-------------------------#'
21SET @@global.net_retry_count = DEFAULT;
22SELECT @@global.net_retry_count = 10;
23@@global.net_retry_count = 10
241
25SET @@session.net_retry_count = DEFAULT;
26SELECT @@session.net_retry_count = 10;
27@@session.net_retry_count = 10
281
29'#--------------------FN_DYNVARS_111_03-------------------------#'
30SET @@global.net_retry_count = 1;
31SELECT @@global.net_retry_count;
32@@global.net_retry_count
331
34SET @@global.net_retry_count = 2;
35SELECT @@global.net_retry_count;
36@@global.net_retry_count
372
38SET @@global.net_retry_count = 4294967295;
39SELECT @@global.net_retry_count;
40@@global.net_retry_count
414294967295
42SET @@global.net_retry_count = 4294967294;
43SELECT @@global.net_retry_count;
44@@global.net_retry_count
454294967294
46SET @@global.net_retry_count = 65536;
47SELECT @@global.net_retry_count;
48@@global.net_retry_count
4965536
50'#--------------------FN_DYNVARS_111_04-------------------------#'
51SET @@session.net_retry_count = 1;
52SELECT @@session.net_retry_count;
53@@session.net_retry_count
541
55SET @@session.net_retry_count = 2;
56SELECT @@session.net_retry_count;
57@@session.net_retry_count
582
59SET @@session.net_retry_count = 65535;
60SELECT @@session.net_retry_count;
61@@session.net_retry_count
6265535
63SET @@session.net_retry_count = 4294967295;
64SELECT @@session.net_retry_count;
65@@session.net_retry_count
664294967295
67SET @@session.net_retry_count = 4294967294;
68SELECT @@session.net_retry_count;
69@@session.net_retry_count
704294967294
71'#------------------FN_DYNVARS_111_05-----------------------#'
72SET @@global.net_retry_count = 0;
73Warnings:
74Warning	1292	Truncated incorrect net_retry_count value: '0'
75SELECT @@global.net_retry_count;
76@@global.net_retry_count
771
78SET @@global.net_retry_count = -1024;
79Warnings:
80Warning	1292	Truncated incorrect net_retry_count value: '-1024'
81SELECT @@global.net_retry_count;
82@@global.net_retry_count
831
84SET @@global.net_retry_count = 4294967296;
85Warnings:
86Warning	1292	Truncated incorrect net_retry_count value: '4294967296'
87SELECT @@global.net_retry_count;
88@@global.net_retry_count
894294967295
90SET @@global.net_retry_count = 429496729500;
91Warnings:
92Warning	1292	Truncated incorrect net_retry_count value: '429496729500'
93SELECT @@global.net_retry_count;
94@@global.net_retry_count
954294967295
96SET @@global.net_retry_count = 65530.34;
97ERROR 42000: Incorrect argument type to variable 'net_retry_count'
98SELECT @@global.net_retry_count;
99@@global.net_retry_count
1004294967295
101SET @@global.net_retry_count = test;
102ERROR 42000: Incorrect argument type to variable 'net_retry_count'
103SELECT @@global.net_retry_count;
104@@global.net_retry_count
1054294967295
106SET @@session.net_retry_count = 0;
107Warnings:
108Warning	1292	Truncated incorrect net_retry_count value: '0'
109SELECT @@session.net_retry_count;
110@@session.net_retry_count
1111
112SET @@session.net_retry_count = -2;
113Warnings:
114Warning	1292	Truncated incorrect net_retry_count value: '-2'
115SELECT @@session.net_retry_count;
116@@session.net_retry_count
1171
118SET @@session.net_retry_count = 65530.34;
119ERROR 42000: Incorrect argument type to variable 'net_retry_count'
120SET @@session.net_retry_count = 6555015425;
121Warnings:
122Warning	1292	Truncated incorrect net_retry_count value: '6555015425'
123SELECT @@session.net_retry_count;
124@@session.net_retry_count
1254294967295
126SET @@session.net_retry_count = 4294967296;
127Warnings:
128Warning	1292	Truncated incorrect net_retry_count value: '4294967296'
129SELECT @@session.net_retry_count;
130@@session.net_retry_count
1314294967295
132SET @@session.net_retry_count = test;
133ERROR 42000: Incorrect argument type to variable 'net_retry_count'
134SELECT @@session.net_retry_count;
135@@session.net_retry_count
1364294967295
137'#------------------FN_DYNVARS_111_06-----------------------#'
138SELECT @@global.net_retry_count = VARIABLE_VALUE
139FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
140WHERE VARIABLE_NAME='net_retry_count';
141@@global.net_retry_count = VARIABLE_VALUE
1421
143'#------------------FN_DYNVARS_111_07-----------------------#'
144SELECT @@session.net_retry_count = VARIABLE_VALUE
145FROM INFORMATION_SCHEMA.SESSION_VARIABLES
146WHERE VARIABLE_NAME='net_retry_count';
147@@session.net_retry_count = VARIABLE_VALUE
1481
149'#------------------FN_DYNVARS_111_08-----------------------#'
150SET @@global.net_retry_count = TRUE;
151SELECT @@global.net_retry_count;
152@@global.net_retry_count
1531
154SET @@global.net_retry_count = FALSE;
155Warnings:
156Warning	1292	Truncated incorrect net_retry_count value: '0'
157SELECT @@global.net_retry_count;
158@@global.net_retry_count
1591
160'#---------------------FN_DYNVARS_111_09----------------------#'
161SET @@global.net_retry_count = 10;
162SELECT @@net_retry_count = @@global.net_retry_count;
163@@net_retry_count = @@global.net_retry_count
1640
165'#---------------------FN_DYNVARS_111_10----------------------#'
166SET @@net_retry_count = 100;
167SELECT @@net_retry_count = @@local.net_retry_count;
168@@net_retry_count = @@local.net_retry_count
1691
170SELECT @@local.net_retry_count = @@session.net_retry_count;
171@@local.net_retry_count = @@session.net_retry_count
1721
173'#---------------------FN_DYNVARS_111_11----------------------#'
174SET net_retry_count = 1;
175SELECT @@net_retry_count;
176@@net_retry_count
1771
178SELECT local.net_retry_count;
179ERROR 42S02: Unknown table 'local' in field list
180SELECT session.net_retry_count;
181ERROR 42S02: Unknown table 'session' in field list
182SELECT net_retry_count = @@session.net_retry_count;
183ERROR 42S22: Unknown column 'net_retry_count' in 'field list'
184SET @@global.net_retry_count = @start_global_value;
185SELECT @@global.net_retry_count;
186@@global.net_retry_count
18710
188SET @@session.net_retry_count = @start_session_value;
189SELECT @@session.net_retry_count;
190@@session.net_retry_count
19110
192