1
SET @start_global_value = @@global.net_retry_count;
2
SELECT @start_global_value;
5
SET @start_session_value = @@session.net_retry_count;
6
SELECT @start_session_value;
9
'#--------------------FN_DYNVARS_111_01-------------------------#'
10
SET @@global.net_retry_count = 100;
11
SET @@global.net_retry_count = DEFAULT;
12
SELECT @@global.net_retry_count;
13
@@global.net_retry_count
15
SET @@session.net_retry_count = 200;
16
SET @@session.net_retry_count = DEFAULT;
17
SELECT @@session.net_retry_count;
18
@@session.net_retry_count
20
'#--------------------FN_DYNVARS_111_02-------------------------#'
21
SET @@global.net_retry_count = DEFAULT;
22
SELECT @@global.net_retry_count = 10;
23
@@global.net_retry_count = 10
25
SET @@session.net_retry_count = DEFAULT;
26
SELECT @@session.net_retry_count = 10;
27
@@session.net_retry_count = 10
29
'#--------------------FN_DYNVARS_111_03-------------------------#'
30
SET @@global.net_retry_count = 1;
31
SELECT @@global.net_retry_count;
32
@@global.net_retry_count
34
SET @@global.net_retry_count = 2;
35
SELECT @@global.net_retry_count;
36
@@global.net_retry_count
38
SET @@global.net_retry_count = 4294967295;
39
SELECT @@global.net_retry_count;
40
@@global.net_retry_count
42
SET @@global.net_retry_count = 4294967294;
43
SELECT @@global.net_retry_count;
44
@@global.net_retry_count
46
SET @@global.net_retry_count = 65536;
47
SELECT @@global.net_retry_count;
48
@@global.net_retry_count
50
'#--------------------FN_DYNVARS_111_04-------------------------#'
51
SET @@session.net_retry_count = 1;
52
SELECT @@session.net_retry_count;
53
@@session.net_retry_count
55
SET @@session.net_retry_count = 2;
56
SELECT @@session.net_retry_count;
57
@@session.net_retry_count
59
SET @@session.net_retry_count = 65535;
60
SELECT @@session.net_retry_count;
61
@@session.net_retry_count
63
SET @@session.net_retry_count = 4294967295;
64
SELECT @@session.net_retry_count;
65
@@session.net_retry_count
67
SET @@session.net_retry_count = 4294967294;
68
SELECT @@session.net_retry_count;
69
@@session.net_retry_count
71
'#------------------FN_DYNVARS_111_05-----------------------#'
72
SET @@global.net_retry_count = 0;
74
Warning 1292 Truncated incorrect net_retry_count value: '0'
75
SELECT @@global.net_retry_count;
76
@@global.net_retry_count
78
SET @@global.net_retry_count = -1024;
80
Warning 1292 Truncated incorrect net_retry_count value: '0'
81
SELECT @@global.net_retry_count;
82
@@global.net_retry_count
84
SET @@global.net_retry_count = 4294967296;
85
SELECT @@global.net_retry_count;
86
@@global.net_retry_count
88
SET @@global.net_retry_count = 429496729500;
89
SELECT @@global.net_retry_count;
90
@@global.net_retry_count
92
SET @@global.net_retry_count = 65530.34.;
93
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
94
SELECT @@global.net_retry_count;
95
@@global.net_retry_count
97
SET @@global.net_retry_count = test;
98
ERROR 42000: Incorrect argument type to variable 'net_retry_count'
99
SELECT @@global.net_retry_count;
100
@@global.net_retry_count
102
SET @@session.net_retry_count = 0;
104
Warning 1292 Truncated incorrect net_retry_count value: '0'
105
SELECT @@session.net_retry_count;
106
@@session.net_retry_count
108
SET @@session.net_retry_count = -2;
110
Warning 1292 Truncated incorrect net_retry_count value: '0'
111
SELECT @@session.net_retry_count;
112
@@session.net_retry_count
114
SET @@session.net_retry_count = 65530.34.;
115
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
116
SET @@session.net_retry_count = 6555015425;
117
SELECT @@session.net_retry_count;
118
@@session.net_retry_count
120
SET @@session.net_retry_count = 4294967296;
121
SELECT @@session.net_retry_count;
122
@@session.net_retry_count
124
'Bug # 34837: Errors are not coming on assigning invalid values to variable';
125
SET @@session.net_retry_count = test;
126
ERROR 42000: Incorrect argument type to variable 'net_retry_count'
127
SELECT @@session.net_retry_count;
128
@@session.net_retry_count
130
'#------------------FN_DYNVARS_111_06-----------------------#'
131
SELECT @@global.net_retry_count = VARIABLE_VALUE
132
FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
133
WHERE VARIABLE_NAME='net_retry_count';
134
@@global.net_retry_count = VARIABLE_VALUE
136
'#------------------FN_DYNVARS_111_07-----------------------#'
137
SELECT @@session.net_retry_count = VARIABLE_VALUE
138
FROM INFORMATION_SCHEMA.SESSION_VARIABLES
139
WHERE VARIABLE_NAME='net_retry_count';
140
@@session.net_retry_count = VARIABLE_VALUE
142
'#------------------FN_DYNVARS_111_08-----------------------#'
143
SET @@global.net_retry_count = TRUE;
144
SELECT @@global.net_retry_count;
145
@@global.net_retry_count
147
SET @@global.net_retry_count = FALSE;
149
Warning 1292 Truncated incorrect net_retry_count value: '0'
150
SELECT @@global.net_retry_count;
151
@@global.net_retry_count
153
'#---------------------FN_DYNVARS_111_09----------------------#'
154
SET @@global.net_retry_count = 10;
155
SELECT @@net_retry_count = @@global.net_retry_count;
156
@@net_retry_count = @@global.net_retry_count
158
'#---------------------FN_DYNVARS_111_10----------------------#'
159
SET @@net_retry_count = 100;
160
SELECT @@net_retry_count = @@local.net_retry_count;
161
@@net_retry_count = @@local.net_retry_count
163
SELECT @@local.net_retry_count = @@session.net_retry_count;
164
@@local.net_retry_count = @@session.net_retry_count
166
'#---------------------FN_DYNVARS_111_11----------------------#'
167
SET net_retry_count = 1;
168
SELECT @@net_retry_count;
171
SELECT local.net_retry_count;
172
ERROR 42S02: Unknown table 'local' in field list
173
SELECT session.net_retry_count;
174
ERROR 42S02: Unknown table 'session' in field list
175
SELECT net_retry_count = @@session.net_retry_count;
176
ERROR 42S22: Unknown column 'net_retry_count' in 'field list'
177
SET @@global.net_retry_count = @start_global_value;
178
SELECT @@global.net_retry_count;
179
@@global.net_retry_count
181
SET @@session.net_retry_count = @start_session_value;
182
SELECT @@session.net_retry_count;
183
@@session.net_retry_count