Debian Codegraph @

mysql-test/suite/engines/funcs/r/sp_simple1.result

raw
1 DROP TABLE IF EXISTS t1;
2 DROP PROCEDURE IF EXISTS sp1;
3 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
4 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
5 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT)
6 BEGIN
7 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
8 END//
9 CALL sp1(@a,1);
10 DROP PROCEDURE sp1;
11 DROP TABLE t1;
12 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
13 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
14 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) CONTAINS SQL
15 BEGIN
16 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
17 END//
18 CALL sp1(@a,1);
19 DROP PROCEDURE sp1;
20 DROP TABLE t1;
21 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
22 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
23 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) NO SQL
24 BEGIN
25 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
26 END//
27 CALL sp1(@a,1);
28 DROP PROCEDURE sp1;
29 DROP TABLE t1;
30 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
31 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
32 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) READS SQL DATA
33 BEGIN
34 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
35 END//
36 CALL sp1(@a,1);
37 DROP PROCEDURE sp1;
38 DROP TABLE t1;
39 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
40 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
41 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) MODIFIES SQL DATA
42 BEGIN
43 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
44 END//
45 CALL sp1(@a,1);
46 DROP PROCEDURE sp1;
47 DROP TABLE t1;
48 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
49 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
50 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) COMMENT 'comment'
51 BEGIN
52 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
53 END//
54 CALL sp1(@a,1);
55 DROP PROCEDURE sp1;
56 DROP TABLE t1;
57 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
58 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
59 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) CONTAINS SQL COMMENT 'comment'
60 BEGIN
61 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
62 END//
63 CALL sp1(@a,1);
64 DROP PROCEDURE sp1;
65 DROP TABLE t1;
66 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
67 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
68 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) NO SQL COMMENT 'comment'
69 BEGIN
70 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
71 END//
72 CALL sp1(@a,1);
73 DROP PROCEDURE sp1;
74 DROP TABLE t1;
75 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
76 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
77 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) READS SQL DATA COMMENT 'comment'
78 BEGIN
79 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
80 END//
81 CALL sp1(@a,1);
82 DROP PROCEDURE sp1;
83 DROP TABLE t1;
84 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
85 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
86 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) MODIFIES SQL DATA COMMENT 'comment'
87 BEGIN
88 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
89 END//
90 CALL sp1(@a,1);
91 DROP PROCEDURE sp1;
92 DROP TABLE t1;
93 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
94 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
95 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL
96 BEGIN
97 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
98 END//
99 CALL sp1(@a,1);
100 DROP PROCEDURE sp1;
101 DROP TABLE t1;
102 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
103 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
104 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL CONTAINS SQL
105 BEGIN
106 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
107 END//
108 CALL sp1(@a,1);
109 DROP PROCEDURE sp1;
110 DROP TABLE t1;
111 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
112 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
113 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL NO SQL
114 BEGIN
115 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
116 END//
117 CALL sp1(@a,1);
118 DROP PROCEDURE sp1;
119 DROP TABLE t1;
120 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
121 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
122 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL READS SQL DATA
123 BEGIN
124 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
125 END//
126 CALL sp1(@a,1);
127 DROP PROCEDURE sp1;
128 DROP TABLE t1;
129 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
130 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
131 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL MODIFIES SQL DATA
132 BEGIN
133 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
134 END//
135 CALL sp1(@a,1);
136 DROP PROCEDURE sp1;
137 DROP TABLE t1;
138 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
139 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
140 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL COMMENT 'comment'
141 BEGIN
142 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
143 END//
144 CALL sp1(@a,1);
145 DROP PROCEDURE sp1;
146 DROP TABLE t1;
147 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
148 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
149 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL CONTAINS SQL COMMENT 'comment'
150 BEGIN
151 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
152 END//
153 CALL sp1(@a,1);
154 DROP PROCEDURE sp1;
155 DROP TABLE t1;
156 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
157 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
158 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL NO SQL COMMENT 'comment'
159 BEGIN
160 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
161 END//
162 CALL sp1(@a,1);
163 DROP PROCEDURE sp1;
164 DROP TABLE t1;
165 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
166 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
167 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL READS SQL DATA COMMENT 'comment'
168 BEGIN
169 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
170 END//
171 CALL sp1(@a,1);
172 DROP PROCEDURE sp1;
173 DROP TABLE t1;
174 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
175 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
176 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL MODIFIES SQL DATA COMMENT 'comment'
177 BEGIN
178 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
179 END//
180 CALL sp1(@a,1);
181 DROP PROCEDURE sp1;
182 DROP TABLE t1;
183 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
184 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
185 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) NOT DETERMINISTIC
186 BEGIN
187 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
188 END//
189 CALL sp1(@a,1);
190 DROP PROCEDURE sp1;
191 DROP TABLE t1;
192 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
193 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
194 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) NOT DETERMINISTIC CONTAINS SQL
195 BEGIN
196 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
197 END//
198 CALL sp1(@a,1);
199 DROP PROCEDURE sp1;
200 DROP TABLE t1;
201 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
202 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
203 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) NOT DETERMINISTIC NO SQL
204 BEGIN
205 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
206 END//
207 CALL sp1(@a,1);
208 DROP PROCEDURE sp1;
209 DROP TABLE t1;
210 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
211 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
212 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) NOT DETERMINISTIC READS SQL DATA
213 BEGIN
214 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
215 END//
216 CALL sp1(@a,1);
217 DROP PROCEDURE sp1;
218 DROP TABLE t1;
219 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
220 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
221 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) NOT DETERMINISTIC MODIFIES SQL DATA
222 BEGIN
223 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
224 END//
225 CALL sp1(@a,1);
226 DROP PROCEDURE sp1;
227 DROP TABLE t1;
228 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
229 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
230 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) NOT DETERMINISTIC COMMENT 'comment'
231 BEGIN
232 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
233 END//
234 CALL sp1(@a,1);
235 DROP PROCEDURE sp1;
236 DROP TABLE t1;
237 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
238 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
239 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) NOT DETERMINISTIC CONTAINS SQL COMMENT 'comment'
240 BEGIN
241 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
242 END//
243 CALL sp1(@a,1);
244 DROP PROCEDURE sp1;
245 DROP TABLE t1;
246 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
247 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
248 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) NOT DETERMINISTIC NO SQL COMMENT 'comment'
249 BEGIN
250 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
251 END//
252 CALL sp1(@a,1);
253 DROP PROCEDURE sp1;
254 DROP TABLE t1;
255 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
256 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
257 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) NOT DETERMINISTIC READS SQL DATA COMMENT 'comment'
258 BEGIN
259 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
260 END//
261 CALL sp1(@a,1);
262 DROP PROCEDURE sp1;
263 DROP TABLE t1;
264 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
265 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
266 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) NOT DETERMINISTIC MODIFIES SQL DATA COMMENT 'comment'
267 BEGIN
268 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
269 END//
270 CALL sp1(@a,1);
271 DROP PROCEDURE sp1;
272 DROP TABLE t1;
273 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
274 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
275 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL NOT DETERMINISTIC
276 BEGIN
277 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
278 END//
279 CALL sp1(@a,1);
280 DROP PROCEDURE sp1;
281 DROP TABLE t1;
282 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
283 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
284 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL NOT DETERMINISTIC CONTAINS SQL
285 BEGIN
286 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
287 END//
288 CALL sp1(@a,1);
289 DROP PROCEDURE sp1;
290 DROP TABLE t1;
291 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
292 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
293 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL NOT DETERMINISTIC NO SQL
294 BEGIN
295 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
296 END//
297 CALL sp1(@a,1);
298 DROP PROCEDURE sp1;
299 DROP TABLE t1;
300 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
301 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
302 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL NOT DETERMINISTIC READS SQL DATA
303 BEGIN
304 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
305 END//
306 CALL sp1(@a,1);
307 DROP PROCEDURE sp1;
308 DROP TABLE t1;
309 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
310 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
311 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL NOT DETERMINISTIC MODIFIES SQL DATA
312 BEGIN
313 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
314 END//
315 CALL sp1(@a,1);
316 DROP PROCEDURE sp1;
317 DROP TABLE t1;
318 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
319 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
320 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL NOT DETERMINISTIC COMMENT 'comment'
321 BEGIN
322 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
323 END//
324 CALL sp1(@a,1);
325 DROP PROCEDURE sp1;
326 DROP TABLE t1;
327 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
328 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
329 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL NOT DETERMINISTIC CONTAINS SQL COMMENT 'comment'
330 BEGIN
331 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
332 END//
333 CALL sp1(@a,1);
334 DROP PROCEDURE sp1;
335 DROP TABLE t1;
336 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
337 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
338 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL NOT DETERMINISTIC NO SQL COMMENT 'comment'
339 BEGIN
340 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
341 END//
342 CALL sp1(@a,1);
343 DROP PROCEDURE sp1;
344 DROP TABLE t1;
345 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
346 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
347 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL NOT DETERMINISTIC READS SQL DATA COMMENT 'comment'
348 BEGIN
349 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
350 END//
351 CALL sp1(@a,1);
352 DROP PROCEDURE sp1;
353 DROP TABLE t1;
354 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
355 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
356 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL NOT DETERMINISTIC MODIFIES SQL DATA COMMENT 'comment'
357 BEGIN
358 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
359 END//
360 CALL sp1(@a,1);
361 DROP PROCEDURE sp1;
362 DROP TABLE t1;
363 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
364 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
365 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) DETERMINISTIC
366 BEGIN
367 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
368 END//
369 CALL sp1(@a,1);
370 DROP PROCEDURE sp1;
371 DROP TABLE t1;
372 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
373 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
374 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) DETERMINISTIC CONTAINS SQL
375 BEGIN
376 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
377 END//
378 CALL sp1(@a,1);
379 DROP PROCEDURE sp1;
380 DROP TABLE t1;
381 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
382 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
383 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) DETERMINISTIC NO SQL
384 BEGIN
385 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
386 END//
387 CALL sp1(@a,1);
388 DROP PROCEDURE sp1;
389 DROP TABLE t1;
390 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
391 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
392 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) DETERMINISTIC READS SQL DATA
393 BEGIN
394 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
395 END//
396 CALL sp1(@a,1);
397 DROP PROCEDURE sp1;
398 DROP TABLE t1;
399 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
400 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
401 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) DETERMINISTIC MODIFIES SQL DATA
402 BEGIN
403 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
404 END//
405 CALL sp1(@a,1);
406 DROP PROCEDURE sp1;
407 DROP TABLE t1;
408 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
409 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
410 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) DETERMINISTIC COMMENT 'comment'
411 BEGIN
412 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
413 END//
414 CALL sp1(@a,1);
415 DROP PROCEDURE sp1;
416 DROP TABLE t1;
417 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
418 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
419 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) DETERMINISTIC CONTAINS SQL COMMENT 'comment'
420 BEGIN
421 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
422 END//
423 CALL sp1(@a,1);
424 DROP PROCEDURE sp1;
425 DROP TABLE t1;
426 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
427 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
428 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) DETERMINISTIC NO SQL COMMENT 'comment'
429 BEGIN
430 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
431 END//
432 CALL sp1(@a,1);
433 DROP PROCEDURE sp1;
434 DROP TABLE t1;
435 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
436 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
437 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) DETERMINISTIC READS SQL DATA COMMENT 'comment'
438 BEGIN
439 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
440 END//
441 CALL sp1(@a,1);
442 DROP PROCEDURE sp1;
443 DROP TABLE t1;
444 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
445 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
446 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) DETERMINISTIC MODIFIES SQL DATA COMMENT 'comment'
447 BEGIN
448 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
449 END//
450 CALL sp1(@a,1);
451 DROP PROCEDURE sp1;
452 DROP TABLE t1;
453 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
454 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
455 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL DETERMINISTIC
456 BEGIN
457 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
458 END//
459 CALL sp1(@a,1);
460 DROP PROCEDURE sp1;
461 DROP TABLE t1;
462 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
463 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
464 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL DETERMINISTIC CONTAINS SQL
465 BEGIN
466 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
467 END//
468 CALL sp1(@a,1);
469 DROP PROCEDURE sp1;
470 DROP TABLE t1;
471 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
472 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
473 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL DETERMINISTIC NO SQL
474 BEGIN
475 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
476 END//
477 CALL sp1(@a,1);
478 DROP PROCEDURE sp1;
479 DROP TABLE t1;
480 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
481 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
482 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL DETERMINISTIC READS SQL DATA
483 BEGIN
484 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
485 END//
486 CALL sp1(@a,1);
487 DROP PROCEDURE sp1;
488 DROP TABLE t1;
489 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
490 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
491 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL DETERMINISTIC MODIFIES SQL DATA
492 BEGIN
493 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
494 END//
495 CALL sp1(@a,1);
496 DROP PROCEDURE sp1;
497 DROP TABLE t1;
498 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
499 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
500 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL DETERMINISTIC COMMENT 'comment'
501 BEGIN
502 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
503 END//
504 CALL sp1(@a,1);
505 DROP PROCEDURE sp1;
506 DROP TABLE t1;
507 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
508 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
509 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL DETERMINISTIC CONTAINS SQL COMMENT 'comment'
510 BEGIN
511 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
512 END//
513 CALL sp1(@a,1);
514 DROP PROCEDURE sp1;
515 DROP TABLE t1;
516 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
517 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
518 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL DETERMINISTIC NO SQL COMMENT 'comment'
519 BEGIN
520 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
521 END//
522 CALL sp1(@a,1);
523 DROP PROCEDURE sp1;
524 DROP TABLE t1;
525 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
526 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
527 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL DETERMINISTIC READS SQL DATA COMMENT 'comment'
528 BEGIN
529 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
530 END//
531 CALL sp1(@a,1);
532 DROP PROCEDURE sp1;
533 DROP TABLE t1;
534 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
535 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
536 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL DETERMINISTIC MODIFIES SQL DATA COMMENT 'comment'
537 BEGIN
538 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
539 END//
540 CALL sp1(@a,1);
541 DROP PROCEDURE sp1;
542 DROP TABLE t1;
543 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
544 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
545 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) SQL SECURITY INVOKER
546 BEGIN
547 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
548 END//
549 CALL sp1(@a,1);
550 DROP PROCEDURE sp1;
551 DROP TABLE t1;
552 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
553 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
554 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) CONTAINS SQL SQL SECURITY INVOKER
555 BEGIN
556 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
557 END//
558 CALL sp1(@a,1);
559 DROP PROCEDURE sp1;
560 DROP TABLE t1;
561 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
562 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
563 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) NO SQL SQL SECURITY INVOKER
564 BEGIN
565 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
566 END//
567 CALL sp1(@a,1);
568 DROP PROCEDURE sp1;
569 DROP TABLE t1;
570 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
571 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
572 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) READS SQL DATA SQL SECURITY INVOKER
573 BEGIN
574 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
575 END//
576 CALL sp1(@a,1);
577 DROP PROCEDURE sp1;
578 DROP TABLE t1;
579 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
580 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
581 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) MODIFIES SQL DATA SQL SECURITY INVOKER
582 BEGIN
583 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
584 END//
585 CALL sp1(@a,1);
586 DROP PROCEDURE sp1;
587 DROP TABLE t1;
588 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
589 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
590 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) SQL SECURITY INVOKER COMMENT 'comment'
591 BEGIN
592 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
593 END//
594 CALL sp1(@a,1);
595 DROP PROCEDURE sp1;
596 DROP TABLE t1;
597 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
598 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
599 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) CONTAINS SQL SQL SECURITY INVOKER COMMENT 'comment'
600 BEGIN
601 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
602 END//
603 CALL sp1(@a,1);
604 DROP PROCEDURE sp1;
605 DROP TABLE t1;
606 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
607 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
608 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) NO SQL SQL SECURITY INVOKER COMMENT 'comment'
609 BEGIN
610 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
611 END//
612 CALL sp1(@a,1);
613 DROP PROCEDURE sp1;
614 DROP TABLE t1;
615 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
616 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
617 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) READS SQL DATA SQL SECURITY INVOKER COMMENT 'comment'
618 BEGIN
619 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
620 END//
621 CALL sp1(@a,1);
622 DROP PROCEDURE sp1;
623 DROP TABLE t1;
624 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
625 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
626 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) MODIFIES SQL DATA SQL SECURITY INVOKER COMMENT 'comment'
627 BEGIN
628 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
629 END//
630 CALL sp1(@a,1);
631 DROP PROCEDURE sp1;
632 DROP TABLE t1;
633 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
634 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
635 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL SQL SECURITY INVOKER
636 BEGIN
637 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
638 END//
639 CALL sp1(@a,1);
640 DROP PROCEDURE sp1;
641 DROP TABLE t1;
642 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
643 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
644 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL CONTAINS SQL SQL SECURITY INVOKER
645 BEGIN
646 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
647 END//
648 CALL sp1(@a,1);
649 DROP PROCEDURE sp1;
650 DROP TABLE t1;
651 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
652 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
653 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL NO SQL SQL SECURITY INVOKER
654 BEGIN
655 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
656 END//
657 CALL sp1(@a,1);
658 DROP PROCEDURE sp1;
659 DROP TABLE t1;
660 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
661 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
662 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL READS SQL DATA SQL SECURITY INVOKER
663 BEGIN
664 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
665 END//
666 CALL sp1(@a,1);
667 DROP PROCEDURE sp1;
668 DROP TABLE t1;
669 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
670 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
671 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL MODIFIES SQL DATA SQL SECURITY INVOKER
672 BEGIN
673 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
674 END//
675 CALL sp1(@a,1);
676 DROP PROCEDURE sp1;
677 DROP TABLE t1;
678 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
679 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
680 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL SQL SECURITY INVOKER COMMENT 'comment'
681 BEGIN
682 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
683 END//
684 CALL sp1(@a,1);
685 DROP PROCEDURE sp1;
686 DROP TABLE t1;
687 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
688 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
689 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL CONTAINS SQL SQL SECURITY INVOKER COMMENT 'comment'
690 BEGIN
691 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
692 END//
693 CALL sp1(@a,1);
694 DROP PROCEDURE sp1;
695 DROP TABLE t1;
696 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
697 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
698 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL NO SQL SQL SECURITY INVOKER COMMENT 'comment'
699 BEGIN
700 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
701 END//
702 CALL sp1(@a,1);
703 DROP PROCEDURE sp1;
704 DROP TABLE t1;
705 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
706 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
707 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL READS SQL DATA SQL SECURITY INVOKER COMMENT 'comment'
708 BEGIN
709 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
710 END//
711 CALL sp1(@a,1);
712 DROP PROCEDURE sp1;
713 DROP TABLE t1;
714 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
715 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
716 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL MODIFIES SQL DATA SQL SECURITY INVOKER COMMENT 'comment'
717 BEGIN
718 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
719 END//
720 CALL sp1(@a,1);
721 DROP PROCEDURE sp1;
722 DROP TABLE t1;
723 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
724 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
725 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) NOT DETERMINISTIC SQL SECURITY INVOKER
726 BEGIN
727 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
728 END//
729 CALL sp1(@a,1);
730 DROP PROCEDURE sp1;
731 DROP TABLE t1;
732 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
733 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
734 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) NOT DETERMINISTIC CONTAINS SQL SQL SECURITY INVOKER
735 BEGIN
736 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
737 END//
738 CALL sp1(@a,1);
739 DROP PROCEDURE sp1;
740 DROP TABLE t1;
741 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
742 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
743 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) NOT DETERMINISTIC NO SQL SQL SECURITY INVOKER
744 BEGIN
745 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
746 END//
747 CALL sp1(@a,1);
748 DROP PROCEDURE sp1;
749 DROP TABLE t1;
750 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
751 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
752 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) NOT DETERMINISTIC READS SQL DATA SQL SECURITY INVOKER
753 BEGIN
754 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
755 END//
756 CALL sp1(@a,1);
757 DROP PROCEDURE sp1;
758 DROP TABLE t1;
759 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
760 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
761 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) NOT DETERMINISTIC MODIFIES SQL DATA SQL SECURITY INVOKER
762 BEGIN
763 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
764 END//
765 CALL sp1(@a,1);
766 DROP PROCEDURE sp1;
767 DROP TABLE t1;
768 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
769 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
770 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) NOT DETERMINISTIC SQL SECURITY INVOKER COMMENT 'comment'
771 BEGIN
772 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
773 END//
774 CALL sp1(@a,1);
775 DROP PROCEDURE sp1;
776 DROP TABLE t1;
777 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
778 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
779 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) NOT DETERMINISTIC CONTAINS SQL SQL SECURITY INVOKER COMMENT 'comment'
780 BEGIN
781 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
782 END//
783 CALL sp1(@a,1);
784 DROP PROCEDURE sp1;
785 DROP TABLE t1;
786 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
787 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
788 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) NOT DETERMINISTIC NO SQL SQL SECURITY INVOKER COMMENT 'comment'
789 BEGIN
790 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
791 END//
792 CALL sp1(@a,1);
793 DROP PROCEDURE sp1;
794 DROP TABLE t1;
795 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
796 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
797 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) NOT DETERMINISTIC READS SQL DATA SQL SECURITY INVOKER COMMENT 'comment'
798 BEGIN
799 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
800 END//
801 CALL sp1(@a,1);
802 DROP PROCEDURE sp1;
803 DROP TABLE t1;
804 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
805 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
806 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) NOT DETERMINISTIC MODIFIES SQL DATA SQL SECURITY INVOKER COMMENT 'comment'
807 BEGIN
808 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
809 END//
810 CALL sp1(@a,1);
811 DROP PROCEDURE sp1;
812 DROP TABLE t1;
813 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
814 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
815 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL NOT DETERMINISTIC SQL SECURITY INVOKER
816 BEGIN
817 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
818 END//
819 CALL sp1(@a,1);
820 DROP PROCEDURE sp1;
821 DROP TABLE t1;
822 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
823 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
824 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL NOT DETERMINISTIC CONTAINS SQL SQL SECURITY INVOKER
825 BEGIN
826 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
827 END//
828 CALL sp1(@a,1);
829 DROP PROCEDURE sp1;
830 DROP TABLE t1;
831 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
832 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
833 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL NOT DETERMINISTIC NO SQL SQL SECURITY INVOKER
834 BEGIN
835 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
836 END//
837 CALL sp1(@a,1);
838 DROP PROCEDURE sp1;
839 DROP TABLE t1;
840 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
841 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
842 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL NOT DETERMINISTIC READS SQL DATA SQL SECURITY INVOKER
843 BEGIN
844 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
845 END//
846 CALL sp1(@a,1);
847 DROP PROCEDURE sp1;
848 DROP TABLE t1;
849 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
850 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
851 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL NOT DETERMINISTIC MODIFIES SQL DATA SQL SECURITY INVOKER
852 BEGIN
853 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
854 END//
855 CALL sp1(@a,1);
856 DROP PROCEDURE sp1;
857 DROP TABLE t1;
858 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
859 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
860 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL NOT DETERMINISTIC SQL SECURITY INVOKER COMMENT 'comment'
861 BEGIN
862 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
863 END//
864 CALL sp1(@a,1);
865 DROP PROCEDURE sp1;
866 DROP TABLE t1;
867 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
868 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
869 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL NOT DETERMINISTIC CONTAINS SQL SQL SECURITY INVOKER COMMENT 'comment'
870 BEGIN
871 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
872 END//
873 CALL sp1(@a,1);
874 DROP PROCEDURE sp1;
875 DROP TABLE t1;
876 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
877 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
878 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL NOT DETERMINISTIC NO SQL SQL SECURITY INVOKER COMMENT 'comment'
879 BEGIN
880 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
881 END//
882 CALL sp1(@a,1);
883 DROP PROCEDURE sp1;
884 DROP TABLE t1;
885 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
886 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
887 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL NOT DETERMINISTIC READS SQL DATA SQL SECURITY INVOKER COMMENT 'comment'
888 BEGIN
889 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
890 END//
891 CALL sp1(@a,1);
892 DROP PROCEDURE sp1;
893 DROP TABLE t1;
894 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
895 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
896 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL NOT DETERMINISTIC MODIFIES SQL DATA SQL SECURITY INVOKER COMMENT 'comment'
897 BEGIN
898 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
899 END//
900 CALL sp1(@a,1);
901 DROP PROCEDURE sp1;
902 DROP TABLE t1;
903 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
904 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
905 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) DETERMINISTIC SQL SECURITY INVOKER
906 BEGIN
907 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
908 END//
909 CALL sp1(@a,1);
910 DROP PROCEDURE sp1;
911 DROP TABLE t1;
912 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
913 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
914 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) DETERMINISTIC CONTAINS SQL SQL SECURITY INVOKER
915 BEGIN
916 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
917 END//
918 CALL sp1(@a,1);
919 DROP PROCEDURE sp1;
920 DROP TABLE t1;
921 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
922 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
923 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) DETERMINISTIC NO SQL SQL SECURITY INVOKER
924 BEGIN
925 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
926 END//
927 CALL sp1(@a,1);
928 DROP PROCEDURE sp1;
929 DROP TABLE t1;
930 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
931 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
932 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) DETERMINISTIC READS SQL DATA SQL SECURITY INVOKER
933 BEGIN
934 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
935 END//
936 CALL sp1(@a,1);
937 DROP PROCEDURE sp1;
938 DROP TABLE t1;
939 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
940 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
941 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) DETERMINISTIC MODIFIES SQL DATA SQL SECURITY INVOKER
942 BEGIN
943 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
944 END//
945 CALL sp1(@a,1);
946 DROP PROCEDURE sp1;
947 DROP TABLE t1;
948 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
949 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
950 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) DETERMINISTIC SQL SECURITY INVOKER COMMENT 'comment'
951 BEGIN
952 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
953 END//
954 CALL sp1(@a,1);
955 DROP PROCEDURE sp1;
956 DROP TABLE t1;
957 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
958 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
959 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) DETERMINISTIC CONTAINS SQL SQL SECURITY INVOKER COMMENT 'comment'
960 BEGIN
961 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
962 END//
963 CALL sp1(@a,1);
964 DROP PROCEDURE sp1;
965 DROP TABLE t1;
966 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
967 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
968 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) DETERMINISTIC NO SQL SQL SECURITY INVOKER COMMENT 'comment'
969 BEGIN
970 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
971 END//
972 CALL sp1(@a,1);
973 DROP PROCEDURE sp1;
974 DROP TABLE t1;
975 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
976 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
977 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) DETERMINISTIC READS SQL DATA SQL SECURITY INVOKER COMMENT 'comment'
978 BEGIN
979 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
980 END//
981 CALL sp1(@a,1);
982 DROP PROCEDURE sp1;
983 DROP TABLE t1;
984 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
985 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
986 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) DETERMINISTIC MODIFIES SQL DATA SQL SECURITY INVOKER COMMENT 'comment'
987 BEGIN
988 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
989 END//
990 CALL sp1(@a,1);
991 DROP PROCEDURE sp1;
992 DROP TABLE t1;
993 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
994 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
995 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL DETERMINISTIC SQL SECURITY INVOKER
996 BEGIN
997 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
998 END//
999 CALL sp1(@a,1);
1000 DROP PROCEDURE sp1;
1001 DROP TABLE t1;
1002 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1003 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1004 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL DETERMINISTIC CONTAINS SQL SQL SECURITY INVOKER
1005 BEGIN
1006 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1007 END//
1008 CALL sp1(@a,1);
1009 DROP PROCEDURE sp1;
1010 DROP TABLE t1;
1011 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1012 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1013 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL DETERMINISTIC NO SQL SQL SECURITY INVOKER
1014 BEGIN
1015 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1016 END//
1017 CALL sp1(@a,1);
1018 DROP PROCEDURE sp1;
1019 DROP TABLE t1;
1020 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1021 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1022 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL DETERMINISTIC READS SQL DATA SQL SECURITY INVOKER
1023 BEGIN
1024 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1025 END//
1026 CALL sp1(@a,1);
1027 DROP PROCEDURE sp1;
1028 DROP TABLE t1;
1029 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1030 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1031 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL DETERMINISTIC MODIFIES SQL DATA SQL SECURITY INVOKER
1032 BEGIN
1033 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1034 END//
1035 CALL sp1(@a,1);
1036 DROP PROCEDURE sp1;
1037 DROP TABLE t1;
1038 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1039 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1040 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL DETERMINISTIC SQL SECURITY INVOKER COMMENT 'comment'
1041 BEGIN
1042 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1043 END//
1044 CALL sp1(@a,1);
1045 DROP PROCEDURE sp1;
1046 DROP TABLE t1;
1047 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1048 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1049 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL DETERMINISTIC CONTAINS SQL SQL SECURITY INVOKER COMMENT 'comment'
1050 BEGIN
1051 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1052 END//
1053 CALL sp1(@a,1);
1054 DROP PROCEDURE sp1;
1055 DROP TABLE t1;
1056 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1057 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1058 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL DETERMINISTIC NO SQL SQL SECURITY INVOKER COMMENT 'comment'
1059 BEGIN
1060 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1061 END//
1062 CALL sp1(@a,1);
1063 DROP PROCEDURE sp1;
1064 DROP TABLE t1;
1065 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1066 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1067 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL DETERMINISTIC READS SQL DATA SQL SECURITY INVOKER COMMENT 'comment'
1068 BEGIN
1069 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1070 END//
1071 CALL sp1(@a,1);
1072 DROP PROCEDURE sp1;
1073 DROP TABLE t1;
1074 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1075 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1076 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL DETERMINISTIC MODIFIES SQL DATA SQL SECURITY INVOKER COMMENT 'comment'
1077 BEGIN
1078 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1079 END//
1080 CALL sp1(@a,1);
1081 DROP PROCEDURE sp1;
1082 DROP TABLE t1;
1083 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1084 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1085 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) SQL SECURITY DEFINER
1086 BEGIN
1087 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1088 END//
1089 CALL sp1(@a,1);
1090 DROP PROCEDURE sp1;
1091 DROP TABLE t1;
1092 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1093 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1094 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) CONTAINS SQL SQL SECURITY DEFINER
1095 BEGIN
1096 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1097 END//
1098 CALL sp1(@a,1);
1099 DROP PROCEDURE sp1;
1100 DROP TABLE t1;
1101 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1102 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1103 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) NO SQL SQL SECURITY DEFINER
1104 BEGIN
1105 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1106 END//
1107 CALL sp1(@a,1);
1108 DROP PROCEDURE sp1;
1109 DROP TABLE t1;
1110 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1111 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1112 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) READS SQL DATA SQL SECURITY DEFINER
1113 BEGIN
1114 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1115 END//
1116 CALL sp1(@a,1);
1117 DROP PROCEDURE sp1;
1118 DROP TABLE t1;
1119 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1120 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1121 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) MODIFIES SQL DATA SQL SECURITY DEFINER
1122 BEGIN
1123 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1124 END//
1125 CALL sp1(@a,1);
1126 DROP PROCEDURE sp1;
1127 DROP TABLE t1;
1128 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1129 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1130 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) SQL SECURITY DEFINER COMMENT 'comment'
1131 BEGIN
1132 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1133 END//
1134 CALL sp1(@a,1);
1135 DROP PROCEDURE sp1;
1136 DROP TABLE t1;
1137 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1138 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1139 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) CONTAINS SQL SQL SECURITY DEFINER COMMENT 'comment'
1140 BEGIN
1141 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1142 END//
1143 CALL sp1(@a,1);
1144 DROP PROCEDURE sp1;
1145 DROP TABLE t1;
1146 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1147 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1148 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) NO SQL SQL SECURITY DEFINER COMMENT 'comment'
1149 BEGIN
1150 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1151 END//
1152 CALL sp1(@a,1);
1153 DROP PROCEDURE sp1;
1154 DROP TABLE t1;
1155 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1156 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1157 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) READS SQL DATA SQL SECURITY DEFINER COMMENT 'comment'
1158 BEGIN
1159 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1160 END//
1161 CALL sp1(@a,1);
1162 DROP PROCEDURE sp1;
1163 DROP TABLE t1;
1164 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1165 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1166 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) MODIFIES SQL DATA SQL SECURITY DEFINER COMMENT 'comment'
1167 BEGIN
1168 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1169 END//
1170 CALL sp1(@a,1);
1171 DROP PROCEDURE sp1;
1172 DROP TABLE t1;
1173 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1174 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1175 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL SQL SECURITY DEFINER
1176 BEGIN
1177 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1178 END//
1179 CALL sp1(@a,1);
1180 DROP PROCEDURE sp1;
1181 DROP TABLE t1;
1182 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1183 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1184 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL CONTAINS SQL SQL SECURITY DEFINER
1185 BEGIN
1186 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1187 END//
1188 CALL sp1(@a,1);
1189 DROP PROCEDURE sp1;
1190 DROP TABLE t1;
1191 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1192 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1193 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL NO SQL SQL SECURITY DEFINER
1194 BEGIN
1195 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1196 END//
1197 CALL sp1(@a,1);
1198 DROP PROCEDURE sp1;
1199 DROP TABLE t1;
1200 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1201 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1202 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL READS SQL DATA SQL SECURITY DEFINER
1203 BEGIN
1204 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1205 END//
1206 CALL sp1(@a,1);
1207 DROP PROCEDURE sp1;
1208 DROP TABLE t1;
1209 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1210 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1211 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL MODIFIES SQL DATA SQL SECURITY DEFINER
1212 BEGIN
1213 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1214 END//
1215 CALL sp1(@a,1);
1216 DROP PROCEDURE sp1;
1217 DROP TABLE t1;
1218 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1219 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1220 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL SQL SECURITY DEFINER COMMENT 'comment'
1221 BEGIN
1222 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1223 END//
1224 CALL sp1(@a,1);
1225 DROP PROCEDURE sp1;
1226 DROP TABLE t1;
1227 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1228 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1229 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL CONTAINS SQL SQL SECURITY DEFINER COMMENT 'comment'
1230 BEGIN
1231 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1232 END//
1233 CALL sp1(@a,1);
1234 DROP PROCEDURE sp1;
1235 DROP TABLE t1;
1236 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1237 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1238 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL NO SQL SQL SECURITY DEFINER COMMENT 'comment'
1239 BEGIN
1240 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1241 END//
1242 CALL sp1(@a,1);
1243 DROP PROCEDURE sp1;
1244 DROP TABLE t1;
1245 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1246 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1247 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL READS SQL DATA SQL SECURITY DEFINER COMMENT 'comment'
1248 BEGIN
1249 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1250 END//
1251 CALL sp1(@a,1);
1252 DROP PROCEDURE sp1;
1253 DROP TABLE t1;
1254 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1255 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1256 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL MODIFIES SQL DATA SQL SECURITY DEFINER COMMENT 'comment'
1257 BEGIN
1258 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1259 END//
1260 CALL sp1(@a,1);
1261 DROP PROCEDURE sp1;
1262 DROP TABLE t1;
1263 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1264 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1265 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) NOT DETERMINISTIC SQL SECURITY DEFINER
1266 BEGIN
1267 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1268 END//
1269 CALL sp1(@a,1);
1270 DROP PROCEDURE sp1;
1271 DROP TABLE t1;
1272 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1273 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1274 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) NOT DETERMINISTIC CONTAINS SQL SQL SECURITY DEFINER
1275 BEGIN
1276 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1277 END//
1278 CALL sp1(@a,1);
1279 DROP PROCEDURE sp1;
1280 DROP TABLE t1;
1281 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1282 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1283 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) NOT DETERMINISTIC NO SQL SQL SECURITY DEFINER
1284 BEGIN
1285 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1286 END//
1287 CALL sp1(@a,1);
1288 DROP PROCEDURE sp1;
1289 DROP TABLE t1;
1290 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1291 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1292 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) NOT DETERMINISTIC READS SQL DATA SQL SECURITY DEFINER
1293 BEGIN
1294 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1295 END//
1296 CALL sp1(@a,1);
1297 DROP PROCEDURE sp1;
1298 DROP TABLE t1;
1299 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1300 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1301 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) NOT DETERMINISTIC MODIFIES SQL DATA SQL SECURITY DEFINER
1302 BEGIN
1303 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1304 END//
1305 CALL sp1(@a,1);
1306 DROP PROCEDURE sp1;
1307 DROP TABLE t1;
1308 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1309 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1310 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) NOT DETERMINISTIC SQL SECURITY DEFINER COMMENT 'comment'
1311 BEGIN
1312 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1313 END//
1314 CALL sp1(@a,1);
1315 DROP PROCEDURE sp1;
1316 DROP TABLE t1;
1317 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1318 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1319 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) NOT DETERMINISTIC CONTAINS SQL SQL SECURITY DEFINER COMMENT 'comment'
1320 BEGIN
1321 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1322 END//
1323 CALL sp1(@a,1);
1324 DROP PROCEDURE sp1;
1325 DROP TABLE t1;
1326 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1327 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1328 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) NOT DETERMINISTIC NO SQL SQL SECURITY DEFINER COMMENT 'comment'
1329 BEGIN
1330 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1331 END//
1332 CALL sp1(@a,1);
1333 DROP PROCEDURE sp1;
1334 DROP TABLE t1;
1335 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1336 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1337 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) NOT DETERMINISTIC READS SQL DATA SQL SECURITY DEFINER COMMENT 'comment'
1338 BEGIN
1339 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1340 END//
1341 CALL sp1(@a,1);
1342 DROP PROCEDURE sp1;
1343 DROP TABLE t1;
1344 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1345 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1346 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) NOT DETERMINISTIC MODIFIES SQL DATA SQL SECURITY DEFINER COMMENT 'comment'
1347 BEGIN
1348 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1349 END//
1350 CALL sp1(@a,1);
1351 DROP PROCEDURE sp1;
1352 DROP TABLE t1;
1353 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1354 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1355 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL NOT DETERMINISTIC SQL SECURITY DEFINER
1356 BEGIN
1357 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1358 END//
1359 CALL sp1(@a,1);
1360 DROP PROCEDURE sp1;
1361 DROP TABLE t1;
1362 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1363 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1364 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL NOT DETERMINISTIC CONTAINS SQL SQL SECURITY DEFINER
1365 BEGIN
1366 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1367 END//
1368 CALL sp1(@a,1);
1369 DROP PROCEDURE sp1;
1370 DROP TABLE t1;
1371 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1372 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1373 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL NOT DETERMINISTIC NO SQL SQL SECURITY DEFINER
1374 BEGIN
1375 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1376 END//
1377 CALL sp1(@a,1);
1378 DROP PROCEDURE sp1;
1379 DROP TABLE t1;
1380 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1381 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1382 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL NOT DETERMINISTIC READS SQL DATA SQL SECURITY DEFINER
1383 BEGIN
1384 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1385 END//
1386 CALL sp1(@a,1);
1387 DROP PROCEDURE sp1;
1388 DROP TABLE t1;
1389 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1390 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1391 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL NOT DETERMINISTIC MODIFIES SQL DATA SQL SECURITY DEFINER
1392 BEGIN
1393 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1394 END//
1395 CALL sp1(@a,1);
1396 DROP PROCEDURE sp1;
1397 DROP TABLE t1;
1398 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1399 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1400 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL NOT DETERMINISTIC SQL SECURITY DEFINER COMMENT 'comment'
1401 BEGIN
1402 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1403 END//
1404 CALL sp1(@a,1);
1405 DROP PROCEDURE sp1;
1406 DROP TABLE t1;
1407 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1408 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1409 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL NOT DETERMINISTIC CONTAINS SQL SQL SECURITY DEFINER COMMENT 'comment'
1410 BEGIN
1411 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1412 END//
1413 CALL sp1(@a,1);
1414 DROP PROCEDURE sp1;
1415 DROP TABLE t1;
1416 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1417 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1418 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL NOT DETERMINISTIC NO SQL SQL SECURITY DEFINER COMMENT 'comment'
1419 BEGIN
1420 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1421 END//
1422 CALL sp1(@a,1);
1423 DROP PROCEDURE sp1;
1424 DROP TABLE t1;
1425 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1426 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1427 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL NOT DETERMINISTIC READS SQL DATA SQL SECURITY DEFINER COMMENT 'comment'
1428 BEGIN
1429 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1430 END//
1431 CALL sp1(@a,1);
1432 DROP PROCEDURE sp1;
1433 DROP TABLE t1;
1434 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1435 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1436 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL NOT DETERMINISTIC MODIFIES SQL DATA SQL SECURITY DEFINER COMMENT 'comment'
1437 BEGIN
1438 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1439 END//
1440 CALL sp1(@a,1);
1441 DROP PROCEDURE sp1;
1442 DROP TABLE t1;
1443 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1444 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1445 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) DETERMINISTIC SQL SECURITY DEFINER
1446 BEGIN
1447 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1448 END//
1449 CALL sp1(@a,1);
1450 DROP PROCEDURE sp1;
1451 DROP TABLE t1;
1452 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1453 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1454 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) DETERMINISTIC CONTAINS SQL SQL SECURITY DEFINER
1455 BEGIN
1456 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1457 END//
1458 CALL sp1(@a,1);
1459 DROP PROCEDURE sp1;
1460 DROP TABLE t1;
1461 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1462 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1463 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) DETERMINISTIC NO SQL SQL SECURITY DEFINER
1464 BEGIN
1465 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1466 END//
1467 CALL sp1(@a,1);
1468 DROP PROCEDURE sp1;
1469 DROP TABLE t1;
1470 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1471 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1472 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) DETERMINISTIC READS SQL DATA SQL SECURITY DEFINER
1473 BEGIN
1474 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1475 END//
1476 CALL sp1(@a,1);
1477 DROP PROCEDURE sp1;
1478 DROP TABLE t1;
1479 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1480 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1481 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) DETERMINISTIC MODIFIES SQL DATA SQL SECURITY DEFINER
1482 BEGIN
1483 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1484 END//
1485 CALL sp1(@a,1);
1486 DROP PROCEDURE sp1;
1487 DROP TABLE t1;
1488 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1489 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1490 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) DETERMINISTIC SQL SECURITY DEFINER COMMENT 'comment'
1491 BEGIN
1492 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1493 END//
1494 CALL sp1(@a,1);
1495 DROP PROCEDURE sp1;
1496 DROP TABLE t1;
1497 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1498 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1499 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) DETERMINISTIC CONTAINS SQL SQL SECURITY DEFINER COMMENT 'comment'
1500 BEGIN
1501 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1502 END//
1503 CALL sp1(@a,1);
1504 DROP PROCEDURE sp1;
1505 DROP TABLE t1;
1506 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1507 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1508 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) DETERMINISTIC NO SQL SQL SECURITY DEFINER COMMENT 'comment'
1509 BEGIN
1510 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1511 END//
1512 CALL sp1(@a,1);
1513 DROP PROCEDURE sp1;
1514 DROP TABLE t1;
1515 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1516 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1517 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) DETERMINISTIC READS SQL DATA SQL SECURITY DEFINER COMMENT 'comment'
1518 BEGIN
1519 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1520 END//
1521 CALL sp1(@a,1);
1522 DROP PROCEDURE sp1;
1523 DROP TABLE t1;
1524 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1525 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1526 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) DETERMINISTIC MODIFIES SQL DATA SQL SECURITY DEFINER COMMENT 'comment'
1527 BEGIN
1528 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1529 END//
1530 CALL sp1(@a,1);
1531 DROP PROCEDURE sp1;
1532 DROP TABLE t1;
1533 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1534 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1535 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL DETERMINISTIC SQL SECURITY DEFINER
1536 BEGIN
1537 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1538 END//
1539 CALL sp1(@a,1);
1540 DROP PROCEDURE sp1;
1541 DROP TABLE t1;
1542 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1543 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1544 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL DETERMINISTIC CONTAINS SQL SQL SECURITY DEFINER
1545 BEGIN
1546 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1547 END//
1548 CALL sp1(@a,1);
1549 DROP PROCEDURE sp1;
1550 DROP TABLE t1;
1551 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1552 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1553 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL DETERMINISTIC NO SQL SQL SECURITY DEFINER
1554 BEGIN
1555 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1556 END//
1557 CALL sp1(@a,1);
1558 DROP PROCEDURE sp1;
1559 DROP TABLE t1;
1560 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1561 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1562 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL DETERMINISTIC READS SQL DATA SQL SECURITY DEFINER
1563 BEGIN
1564 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1565 END//
1566 CALL sp1(@a,1);
1567 DROP PROCEDURE sp1;
1568 DROP TABLE t1;
1569 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1570 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1571 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL DETERMINISTIC MODIFIES SQL DATA SQL SECURITY DEFINER
1572 BEGIN
1573 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1574 END//
1575 CALL sp1(@a,1);
1576 DROP PROCEDURE sp1;
1577 DROP TABLE t1;
1578 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1579 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1580 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL DETERMINISTIC SQL SECURITY DEFINER COMMENT 'comment'
1581 BEGIN
1582 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1583 END//
1584 CALL sp1(@a,1);
1585 DROP PROCEDURE sp1;
1586 DROP TABLE t1;
1587 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1588 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1589 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL DETERMINISTIC CONTAINS SQL SQL SECURITY DEFINER COMMENT 'comment'
1590 BEGIN
1591 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1592 END//
1593 CALL sp1(@a,1);
1594 DROP PROCEDURE sp1;
1595 DROP TABLE t1;
1596 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1597 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1598 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL DETERMINISTIC NO SQL SQL SECURITY DEFINER COMMENT 'comment'
1599 BEGIN
1600 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1601 END//
1602 CALL sp1(@a,1);
1603 DROP PROCEDURE sp1;
1604 DROP TABLE t1;
1605 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1606 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1607 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL DETERMINISTIC READS SQL DATA SQL SECURITY DEFINER COMMENT 'comment'
1608 BEGIN
1609 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1610 END//
1611 CALL sp1(@a,1);
1612 DROP PROCEDURE sp1;
1613 DROP TABLE t1;
1614 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1615 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1616 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL DETERMINISTIC MODIFIES SQL DATA SQL SECURITY DEFINER COMMENT 'comment'
1617 BEGIN
1618 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1619 END//
1620 CALL sp1(@a,1);
1621 DROP PROCEDURE sp1;
1622 DROP TABLE t1;