Debian Codegraph @

mysql-test/suite/sys_vars/r/net_retry_count_basic_32.result

raw
1 SET @start_global_value = @@global.net_retry_count;
2 SELECT @start_global_value;
3 @start_global_value
4 10
5 SET @start_session_value = @@session.net_retry_count;
6 SELECT @start_session_value;
7 @start_session_value
8 10
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
14 10
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
19 10
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
24 1
25 SET @@session.net_retry_count = DEFAULT;
26 SELECT @@session.net_retry_count = 10;
27 @@session.net_retry_count = 10
28 1
29 '#--------------------FN_DYNVARS_111_03-------------------------#'
30 SET @@global.net_retry_count = 1;
31 SELECT @@global.net_retry_count;
32 @@global.net_retry_count
33 1
34 SET @@global.net_retry_count = 2;
35 SELECT @@global.net_retry_count;
36 @@global.net_retry_count
37 2
38 SET @@global.net_retry_count = 4294967295;
39 SELECT @@global.net_retry_count;
40 @@global.net_retry_count
41 4294967295
42 SET @@global.net_retry_count = 4294967294;
43 SELECT @@global.net_retry_count;
44 @@global.net_retry_count
45 4294967294
46 SET @@global.net_retry_count = 65536;
47 SELECT @@global.net_retry_count;
48 @@global.net_retry_count
49 65536
50 '#--------------------FN_DYNVARS_111_04-------------------------#'
51 SET @@session.net_retry_count = 1;
52 SELECT @@session.net_retry_count;
53 @@session.net_retry_count
54 1
55 SET @@session.net_retry_count = 2;
56 SELECT @@session.net_retry_count;
57 @@session.net_retry_count
58 2
59 SET @@session.net_retry_count = 65535;
60 SELECT @@session.net_retry_count;
61 @@session.net_retry_count
62 65535
63 SET @@session.net_retry_count = 4294967295;
64 SELECT @@session.net_retry_count;
65 @@session.net_retry_count
66 4294967295
67 SET @@session.net_retry_count = 4294967294;
68 SELECT @@session.net_retry_count;
69 @@session.net_retry_count
70 4294967294
71 '#------------------FN_DYNVARS_111_05-----------------------#'
72 SET @@global.net_retry_count = 0;
73 Warnings:
74 Warning 1292 Truncated incorrect net_retry_count value: '0'
75 SELECT @@global.net_retry_count;
76 @@global.net_retry_count
77 1
78 SET @@global.net_retry_count = -1024;
79 Warnings:
80 Warning 1292 Truncated incorrect net_retry_count value: '-1024'
81 SELECT @@global.net_retry_count;
82 @@global.net_retry_count
83 1
84 SET @@global.net_retry_count = 65530.34;
85 ERROR 42000: Incorrect argument type to variable 'net_retry_count'
86 SELECT @@global.net_retry_count;
87 @@global.net_retry_count
88 1
89 SET @@global.net_retry_count = test;
90 ERROR 42000: Incorrect argument type to variable 'net_retry_count'
91 SELECT @@global.net_retry_count;
92 @@global.net_retry_count
93 1
94 SET @@global.net_retry_count = 4294967296;
95 Warnings:
96 Warning 1292 Truncated incorrect net_retry_count value: '4294967296'
97 SELECT @@global.net_retry_count;
98 @@global.net_retry_count
99 4294967295
100 SET @@global.net_retry_count = 42949672950;
101 Warnings:
102 Warning 1292 Truncated incorrect net_retry_count value: '42949672950'
103 SELECT @@global.net_retry_count;
104 @@global.net_retry_count
105 4294967295
106 SET @@session.net_retry_count = 0;
107 Warnings:
108 Warning 1292 Truncated incorrect net_retry_count value: '0'
109 SELECT @@session.net_retry_count;
110 @@session.net_retry_count
111 1
112 SET @@session.net_retry_count = -2;
113 Warnings:
114 Warning 1292 Truncated incorrect net_retry_count value: '-2'
115 SELECT @@session.net_retry_count;
116 @@session.net_retry_count
117 1
118 SET @@session.net_retry_count = 65530.34;
119 ERROR 42000: Incorrect argument type to variable 'net_retry_count'
120 SET @@session.net_retry_count = test;
121 ERROR 42000: Incorrect argument type to variable 'net_retry_count'
122 SELECT @@session.net_retry_count;
123 @@session.net_retry_count
124 1
125 SET @@session.net_retry_count = 4294967296;
126 Warnings:
127 Warning 1292 Truncated incorrect net_retry_count value: '4294967296'
128 SELECT @@session.net_retry_count;
129 @@session.net_retry_count
130 4294967295
131 SET @@session.net_retry_count = 42949672950;
132 Warnings:
133 Warning 1292 Truncated incorrect net_retry_count value: '42949672950'
134 SELECT @@session.net_retry_count;
135 @@session.net_retry_count
136 4294967295
137 '#------------------FN_DYNVARS_111_06-----------------------#'
138 SELECT @@global.net_retry_count = VARIABLE_VALUE
139 FROM performance_schema.global_variables
140 WHERE VARIABLE_NAME='net_retry_count';
141 @@global.net_retry_count = VARIABLE_VALUE
142 1
143 '#------------------FN_DYNVARS_111_07-----------------------#'
144 SELECT @@session.net_retry_count = VARIABLE_VALUE
145 FROM performance_schema.session_variables
146 WHERE VARIABLE_NAME='net_retry_count';
147 @@session.net_retry_count = VARIABLE_VALUE
148 1
149 '#------------------FN_DYNVARS_111_08-----------------------#'
150 SET @@global.net_retry_count = TRUE;
151 SELECT @@global.net_retry_count;
152 @@global.net_retry_count
153 1
154 SET @@global.net_retry_count = FALSE;
155 Warnings:
156 Warning 1292 Truncated incorrect net_retry_count value: '0'
157 SELECT @@global.net_retry_count;
158 @@global.net_retry_count
159 1
160 '#---------------------FN_DYNVARS_111_09----------------------#'
161 SET @@global.net_retry_count = 10;
162 SELECT @@net_retry_count = @@global.net_retry_count;
163 @@net_retry_count = @@global.net_retry_count
164 0
165 '#---------------------FN_DYNVARS_111_10----------------------#'
166 SET @@net_retry_count = 100;
167 SELECT @@net_retry_count = @@local.net_retry_count;
168 @@net_retry_count = @@local.net_retry_count
169 1
170 SELECT @@local.net_retry_count = @@session.net_retry_count;
171 @@local.net_retry_count = @@session.net_retry_count
172 1
173 '#---------------------FN_DYNVARS_111_11----------------------#'
174 SET net_retry_count = 1;
175 SELECT @@net_retry_count;
176 @@net_retry_count
177 1
178 SELECT local.net_retry_count;
179 ERROR 42S02: Unknown table 'local' in field list
180 SELECT session.net_retry_count;
181 ERROR 42S02: Unknown table 'session' in field list
182 SELECT net_retry_count = @@session.net_retry_count;
183 ERROR 42S22: Unknown column 'net_retry_count' in 'field list'
184 SET @@global.net_retry_count = @start_global_value;
185 SELECT @@global.net_retry_count;
186 @@global.net_retry_count
187 10
188 SET @@session.net_retry_count = @start_session_value;
189 SELECT @@session.net_retry_count;
190 @@session.net_retry_count
191 10