Debian Codegraph @

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

raw
1 SET @start_global_value = @@global.lock_wait_timeout;
2 SELECT @start_global_value;
3 @start_global_value
4 31536000
5 SET @start_session_value = @@session.lock_wait_timeout;
6 SELECT @start_session_value;
7 @start_session_value
8 31536000
9 '#--------------------FN_DYNVARS_002_01-------------------------#'
10 SET @@global.lock_wait_timeout = 100;
11 SET @@global.lock_wait_timeout = DEFAULT;
12 SELECT @@global.lock_wait_timeout;
13 @@global.lock_wait_timeout
14 31536000
15 SET @@session.lock_wait_timeout = 200;
16 SET @@session.lock_wait_timeout = DEFAULT;
17 SELECT @@session.lock_wait_timeout;
18 @@session.lock_wait_timeout
19 31536000
20 '#--------------------FN_DYNVARS_002_02-------------------------#'
21 SET @@global.lock_wait_timeout = @start_global_value;
22 SELECT @@global.lock_wait_timeout = 31536000;
23 @@global.lock_wait_timeout = 31536000
24 1
25 SET @@session.lock_wait_timeout = @start_session_value;
26 SELECT @@session.lock_wait_timeout = 31536000;
27 @@session.lock_wait_timeout = 31536000
28 1
29 '#--------------------FN_DYNVARS_002_03-------------------------#'
30 SET @@global.lock_wait_timeout = 1;
31 SELECT @@global.lock_wait_timeout;
32 @@global.lock_wait_timeout
33 1
34 SET @@global.lock_wait_timeout = 60020;
35 SELECT @@global.lock_wait_timeout;
36 @@global.lock_wait_timeout
37 60020
38 SET @@global.lock_wait_timeout = 65535;
39 SELECT @@global.lock_wait_timeout;
40 @@global.lock_wait_timeout
41 65535
42 SET @@global.lock_wait_timeout = 31536000;
43 SELECT @@global.lock_wait_timeout;
44 @@global.lock_wait_timeout
45 31536000
46 '#--------------------FN_DYNVARS_002_04-------------------------#'
47 SET @@session.lock_wait_timeout = 1;
48 SELECT @@session.lock_wait_timeout;
49 @@session.lock_wait_timeout
50 1
51 SET @@session.lock_wait_timeout = 50050;
52 SELECT @@session.lock_wait_timeout;
53 @@session.lock_wait_timeout
54 50050
55 SET @@session.lock_wait_timeout = 65535;
56 SELECT @@session.lock_wait_timeout;
57 @@session.lock_wait_timeout
58 65535
59 SET @@session.lock_wait_timeout = 31536000;
60 SELECT @@session.lock_wait_timeout;
61 @@session.lock_wait_timeout
62 31536000
63 '#------------------FN_DYNVARS_002_05-----------------------#'
64 SET @@global.lock_wait_timeout = 0;
65 Warnings:
66 Warning 1292 Truncated incorrect lock_wait_timeout value: '0'
67 SELECT @@global.lock_wait_timeout;
68 @@global.lock_wait_timeout
69 1
70 SET @@global.lock_wait_timeout = -1024;
71 Warnings:
72 Warning 1292 Truncated incorrect lock_wait_timeout value: '-1024'
73 SELECT @@global.lock_wait_timeout;
74 @@global.lock_wait_timeout
75 1
76 SET @@global.lock_wait_timeout = 31536001;
77 Warnings:
78 Warning 1292 Truncated incorrect lock_wait_timeout value: '31536001'
79 SELECT @@global.lock_wait_timeout;
80 @@global.lock_wait_timeout
81 31536000
82 SET @@global.lock_wait_timeout = 3153600112;
83 Warnings:
84 Warning 1292 Truncated incorrect lock_wait_timeout value: '3153600112'
85 SELECT @@global.lock_wait_timeout;
86 @@global.lock_wait_timeout
87 31536000
88 SET @@global.lock_wait_timeout = 65532.01;
89 ERROR 42000: Incorrect argument type to variable 'lock_wait_timeout'
90 SELECT @@global.lock_wait_timeout;
91 @@global.lock_wait_timeout
92 31536000
93 SET @@global.lock_wait_timeout = ON;
94 ERROR 42000: Incorrect argument type to variable 'lock_wait_timeout'
95 SELECT @@global.lock_wait_timeout;
96 @@global.lock_wait_timeout
97 31536000
98 SET @@global.lock_wait_timeout = OFF;
99 ERROR 42000: Incorrect argument type to variable 'lock_wait_timeout'
100 SELECT @@global.lock_wait_timeout;
101 @@global.lock_wait_timeout
102 31536000
103 SET @@global.lock_wait_timeout = test;
104 ERROR 42000: Incorrect argument type to variable 'lock_wait_timeout'
105 SELECT @@global.lock_wait_timeout;
106 @@global.lock_wait_timeout
107 31536000
108 SET @@global.lock_wait_timeout = " ";
109 ERROR 42000: Incorrect argument type to variable 'lock_wait_timeout'
110 SELECT @@global.lock_wait_timeout;
111 @@global.lock_wait_timeout
112 31536000
113 SET @@global.lock_wait_timeout = ' ';
114 ERROR 42000: Incorrect argument type to variable 'lock_wait_timeout'
115 SELECT @@global.lock_wait_timeout;
116 @@global.lock_wait_timeout
117 31536000
118 SET @@session.lock_wait_timeout = 0;
119 Warnings:
120 Warning 1292 Truncated incorrect lock_wait_timeout value: '0'
121 SELECT @@session.lock_wait_timeout;
122 @@session.lock_wait_timeout
123 1
124 SET @@session.lock_wait_timeout = -2;
125 Warnings:
126 Warning 1292 Truncated incorrect lock_wait_timeout value: '-2'
127 SELECT @@session.lock_wait_timeout;
128 @@session.lock_wait_timeout
129 1
130 SET @@session.lock_wait_timeout = 3176990909;
131 Warnings:
132 Warning 1292 Truncated incorrect lock_wait_timeout value: '3176990909'
133 SELECT @@session.lock_wait_timeout;
134 @@session.lock_wait_timeout
135 31536000
136 SET @@session.lock_wait_timeout = 31536001;
137 Warnings:
138 Warning 1292 Truncated incorrect lock_wait_timeout value: '31536001'
139 SELECT @@session.lock_wait_timeout;
140 @@session.lock_wait_timeout
141 31536000
142 SET @@session.lock_wait_timeout = -1024;
143 Warnings:
144 Warning 1292 Truncated incorrect lock_wait_timeout value: '-1024'
145 SELECT @@session.lock_wait_timeout;
146 @@session.lock_wait_timeout
147 1
148 SET @@session.lock_wait_timeout = 65532.01;
149 ERROR 42000: Incorrect argument type to variable 'lock_wait_timeout'
150 SELECT @@session.lock_wait_timeout;
151 @@session.lock_wait_timeout
152 1
153 SET @@session.lock_wait_timeout = ON;
154 ERROR 42000: Incorrect argument type to variable 'lock_wait_timeout'
155 SELECT @@session.lock_wait_timeout;
156 @@session.lock_wait_timeout
157 1
158 SET @@session.lock_wait_timeout = OFF;
159 ERROR 42000: Incorrect argument type to variable 'lock_wait_timeout'
160 SELECT @@session.lock_wait_timeout;
161 @@session.lock_wait_timeout
162 1
163 SET @@session.lock_wait_timeout = test;
164 ERROR 42000: Incorrect argument type to variable 'lock_wait_timeout'
165 SELECT @@session.lock_wait_timeout;
166 @@session.lock_wait_timeout
167 1
168 SET @@session.lock_wait_timeout = ' ';
169 ERROR 42000: Incorrect argument type to variable 'lock_wait_timeout'
170 SELECT @@session.lock_wait_timeout;
171 @@session.lock_wait_timeout
172 1
173 '#------------------FN_DYNVARS_002_06-----------------------#'
174 SELECT @@global.lock_wait_timeout = VARIABLE_VALUE
175 FROM performance_schema.global_variables
176 WHERE VARIABLE_NAME='lock_wait_timeout';
177 @@global.lock_wait_timeout = VARIABLE_VALUE
178 1
179 '#------------------FN_DYNVARS_002_07-----------------------#'
180 SELECT @@session.lock_wait_timeout = VARIABLE_VALUE
181 FROM performance_schema.session_variables
182 WHERE VARIABLE_NAME='lock_wait_timeout';
183 @@session.lock_wait_timeout = VARIABLE_VALUE
184 1
185 '#------------------FN_DYNVARS_002_08-----------------------#'
186 SET @@global.lock_wait_timeout = TRUE;
187 SELECT @@global.lock_wait_timeout;
188 @@global.lock_wait_timeout
189 1
190 SET @@global.lock_wait_timeout = FALSE;
191 Warnings:
192 Warning 1292 Truncated incorrect lock_wait_timeout value: '0'
193 SELECT @@global.lock_wait_timeout;
194 @@global.lock_wait_timeout
195 1
196 '#---------------------FN_DYNVARS_001_09----------------------#'
197 SET @@global.lock_wait_timeout = 10;
198 SET @@session.lock_wait_timeout = 11;
199 SELECT @@lock_wait_timeout = @@global.lock_wait_timeout;
200 @@lock_wait_timeout = @@global.lock_wait_timeout
201 0
202 '#---------------------FN_DYNVARS_001_10----------------------#'
203 SET @@lock_wait_timeout = 100;
204 SELECT @@lock_wait_timeout = @@local.lock_wait_timeout;
205 @@lock_wait_timeout = @@local.lock_wait_timeout
206 1
207 SELECT @@local.lock_wait_timeout = @@session.lock_wait_timeout;
208 @@local.lock_wait_timeout = @@session.lock_wait_timeout
209 1
210 '#---------------------FN_DYNVARS_001_11----------------------#'
211 SET lock_wait_timeout = 1;
212 SELECT @@lock_wait_timeout;
213 @@lock_wait_timeout
214 1
215 SELECT local.lock_wait_timeout;
216 ERROR 42S02: Unknown table 'local' in field list
217 SELECT session.lock_wait_timeout;
218 ERROR 42S02: Unknown table 'session' in field list
219 SELECT lock_wait_timeout = @@session.lock_wait_timeout;
220 ERROR 42S22: Unknown column 'lock_wait_timeout' in 'field list'
221 SET @@global.lock_wait_timeout = @start_global_value;
222 SELECT @@global.lock_wait_timeout;
223 @@global.lock_wait_timeout
224 31536000
225 SET @@session.lock_wait_timeout = @start_session_value;
226 SELECT @@session.lock_wait_timeout;
227 @@session.lock_wait_timeout
228 31536000