Debian Codegraph @

mysql-test/suite/sys_vars/r/net_retry_count_basic.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 = 4294967296;
85 Warnings:
86 Warning 1292 Truncated incorrect net_retry_count value: '4294967296'
87 SELECT @@global.net_retry_count;
88 @@global.net_retry_count
89 4294967295
90 SET @@global.net_retry_count = 429496729500;
91 Warnings:
92 Warning 1292 Truncated incorrect net_retry_count value: '429496729500'
93 SELECT @@global.net_retry_count;
94 @@global.net_retry_count
95 4294967295
96 SET @@global.net_retry_count = 65530.34;
97 ERROR 42000: Incorrect argument type to variable 'net_retry_count'
98 SELECT @@global.net_retry_count;
99 @@global.net_retry_count
100 4294967295
101 SET @@global.net_retry_count = test;
102 ERROR 42000: Incorrect argument type to variable 'net_retry_count'
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 = 6555015425;
121 Warnings:
122 Warning 1292 Truncated incorrect net_retry_count value: '6555015425'
123 SELECT @@session.net_retry_count;
124 @@session.net_retry_count
125 4294967295
126 SET @@session.net_retry_count = 4294967296;
127 Warnings:
128 Warning 1292 Truncated incorrect net_retry_count value: '4294967296'
129 SELECT @@session.net_retry_count;
130 @@session.net_retry_count
131 4294967295
132 SET @@session.net_retry_count = test;
133 ERROR 42000: Incorrect argument type to variable 'net_retry_count'
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 INFORMATION_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 INFORMATION_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 SELECT
180 SELECT session.net_retry_count;
181 ERROR 42S02: Unknown table 'session' in SELECT
182 SELECT net_retry_count = @@session.net_retry_count;
183 ERROR 42S22: Unknown column 'net_retry_count' in 'SELECT'
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