Debian Codegraph @

mysql-test/suite/sys_vars/r/net_retry_count_basic_64.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 SET @@global.net_retry_count = 18446744073709551615;
51 SELECT @@global.net_retry_count;
52 @@global.net_retry_count
53 18446744073709551615
54 '#--------------------FN_DYNVARS_111_04-------------------------#'
55 SET @@session.net_retry_count = 1;
56 SELECT @@session.net_retry_count;
57 @@session.net_retry_count
58 1
59 SET @@session.net_retry_count = 2;
60 SELECT @@session.net_retry_count;
61 @@session.net_retry_count
62 2
63 SET @@session.net_retry_count = 65535;
64 SELECT @@session.net_retry_count;
65 @@session.net_retry_count
66 65535
67 SET @@session.net_retry_count = 4294967295;
68 SELECT @@session.net_retry_count;
69 @@session.net_retry_count
70 4294967295
71 SET @@session.net_retry_count = 4294967294;
72 SELECT @@session.net_retry_count;
73 @@session.net_retry_count
74 4294967294
75 SET @@session.net_retry_count = 18446744073709551615;
76 SELECT @@session.net_retry_count;
77 @@session.net_retry_count
78 18446744073709551615
79 '#------------------FN_DYNVARS_111_05-----------------------#'
80 SET @@global.net_retry_count = 0;
81 Warnings:
82 Warning 1292 Truncated incorrect net_retry_count value: '0'
83 SELECT @@global.net_retry_count;
84 @@global.net_retry_count
85 1
86 SET @@global.net_retry_count = -1024;
87 Warnings:
88 Warning 1292 Truncated incorrect net_retry_count value: '-1024'
89 SELECT @@global.net_retry_count;
90 @@global.net_retry_count
91 1
92 SET @@global.net_retry_count = 65530.34;
93 ERROR 42000: Incorrect argument type to variable 'net_retry_count'
94 SELECT @@global.net_retry_count;
95 @@global.net_retry_count
96 1
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
101 1
102 SET @@global.net_retry_count = 18446744073709551616;
103 ERROR 42000: Incorrect argument type to variable 'net_retry_count'
104 SELECT @@global.net_retry_count;
105 @@global.net_retry_count
106 1
107 SET @@session.net_retry_count = 0;
108 Warnings:
109 Warning 1292 Truncated incorrect net_retry_count value: '0'
110 SELECT @@session.net_retry_count;
111 @@session.net_retry_count
112 1
113 SET @@session.net_retry_count = -2;
114 Warnings:
115 Warning 1292 Truncated incorrect net_retry_count value: '-2'
116 SELECT @@session.net_retry_count;
117 @@session.net_retry_count
118 1
119 SET @@session.net_retry_count = 65530.34;
120 ERROR 42000: Incorrect argument type to variable 'net_retry_count'
121 SET @@session.net_retry_count = test;
122 ERROR 42000: Incorrect argument type to variable 'net_retry_count'
123 SELECT @@session.net_retry_count;
124 @@session.net_retry_count
125 1
126 SET @@session.net_retry_count = 18446744073709551616;
127 ERROR 42000: Incorrect argument type to variable 'net_retry_count'
128 SELECT @@session.net_retry_count;
129 @@session.net_retry_count
130 1
131 '#------------------FN_DYNVARS_111_06-----------------------#'
132 SELECT @@global.net_retry_count = VARIABLE_VALUE
133 FROM performance_schema.global_variables
134 WHERE VARIABLE_NAME='net_retry_count';
135 @@global.net_retry_count = VARIABLE_VALUE
136 1
137 '#------------------FN_DYNVARS_111_07-----------------------#'
138 SELECT @@session.net_retry_count = VARIABLE_VALUE
139 FROM performance_schema.session_variables
140 WHERE VARIABLE_NAME='net_retry_count';
141 @@session.net_retry_count = VARIABLE_VALUE
142 1
143 '#------------------FN_DYNVARS_111_08-----------------------#'
144 SET @@global.net_retry_count = TRUE;
145 SELECT @@global.net_retry_count;
146 @@global.net_retry_count
147 1
148 SET @@global.net_retry_count = FALSE;
149 Warnings:
150 Warning 1292 Truncated incorrect net_retry_count value: '0'
151 SELECT @@global.net_retry_count;
152 @@global.net_retry_count
153 1
154 '#---------------------FN_DYNVARS_111_09----------------------#'
155 SET @@global.net_retry_count = 10;
156 SELECT @@net_retry_count = @@global.net_retry_count;
157 @@net_retry_count = @@global.net_retry_count
158 0
159 '#---------------------FN_DYNVARS_111_10----------------------#'
160 SET @@net_retry_count = 100;
161 SELECT @@net_retry_count = @@local.net_retry_count;
162 @@net_retry_count = @@local.net_retry_count
163 1
164 SELECT @@local.net_retry_count = @@session.net_retry_count;
165 @@local.net_retry_count = @@session.net_retry_count
166 1
167 '#---------------------FN_DYNVARS_111_11----------------------#'
168 SET net_retry_count = 1;
169 SELECT @@net_retry_count;
170 @@net_retry_count
171 1
172 SELECT local.net_retry_count;
173 ERROR 42S02: Unknown table 'local' in field list
174 SELECT session.net_retry_count;
175 ERROR 42S02: Unknown table 'session' in field list
176 SELECT net_retry_count = @@session.net_retry_count;
177 ERROR 42S22: Unknown column 'net_retry_count' in 'field list'
178 SET @@global.net_retry_count = @start_global_value;
179 SELECT @@global.net_retry_count;
180 @@global.net_retry_count
181 10
182 SET @@session.net_retry_count = @start_session_value;
183 SELECT @@session.net_retry_count;
184 @@session.net_retry_count
185 10