Debian Codegraph @

mysql-test/suite/engines/funcs/t/sp_simple1.test

raw
1 --disable_warnings
2 DROP TABLE IF EXISTS t1;
3 DROP PROCEDURE IF EXISTS sp1;
4 --enable_warnings
5 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
6 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
7 DELIMITER //;
8 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT)
9 BEGIN
10 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
11 END//
12 DELIMITER ;//
13 CALL sp1(@a,1);
14 DROP PROCEDURE sp1;
15 DROP TABLE t1;
16 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
17 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
18 DELIMITER //;
19 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) CONTAINS SQL
20 BEGIN
21 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
22 END//
23 DELIMITER ;//
24 CALL sp1(@a,1);
25 DROP PROCEDURE sp1;
26 DROP TABLE t1;
27 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
28 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
29 DELIMITER //;
30 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) NO SQL
31 BEGIN
32 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
33 END//
34 DELIMITER ;//
35 CALL sp1(@a,1);
36 DROP PROCEDURE sp1;
37 DROP TABLE t1;
38 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
39 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
40 DELIMITER //;
41 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) READS SQL DATA
42 BEGIN
43 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
44 END//
45 DELIMITER ;//
46 CALL sp1(@a,1);
47 DROP PROCEDURE sp1;
48 DROP TABLE t1;
49 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
50 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
51 DELIMITER //;
52 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) MODIFIES SQL DATA
53 BEGIN
54 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
55 END//
56 DELIMITER ;//
57 CALL sp1(@a,1);
58 DROP PROCEDURE sp1;
59 DROP TABLE t1;
60 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
61 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
62 DELIMITER //;
63 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) COMMENT 'comment'
64 BEGIN
65 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
66 END//
67 DELIMITER ;//
68 CALL sp1(@a,1);
69 DROP PROCEDURE sp1;
70 DROP TABLE t1;
71 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
72 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
73 DELIMITER //;
74 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) CONTAINS SQL COMMENT 'comment'
75 BEGIN
76 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
77 END//
78 DELIMITER ;//
79 CALL sp1(@a,1);
80 DROP PROCEDURE sp1;
81 DROP TABLE t1;
82 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
83 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
84 DELIMITER //;
85 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) NO SQL COMMENT 'comment'
86 BEGIN
87 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
88 END//
89 DELIMITER ;//
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 DELIMITER //;
96 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) READS SQL DATA COMMENT 'comment'
97 BEGIN
98 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
99 END//
100 DELIMITER ;//
101 CALL sp1(@a,1);
102 DROP PROCEDURE sp1;
103 DROP TABLE t1;
104 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
105 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
106 DELIMITER //;
107 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) MODIFIES SQL DATA COMMENT 'comment'
108 BEGIN
109 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
110 END//
111 DELIMITER ;//
112 CALL sp1(@a,1);
113 DROP PROCEDURE sp1;
114 DROP TABLE t1;
115 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
116 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
117 DELIMITER //;
118 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL
119 BEGIN
120 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
121 END//
122 DELIMITER ;//
123 CALL sp1(@a,1);
124 DROP PROCEDURE sp1;
125 DROP TABLE t1;
126 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
127 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
128 DELIMITER //;
129 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL CONTAINS SQL
130 BEGIN
131 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
132 END//
133 DELIMITER ;//
134 CALL sp1(@a,1);
135 DROP PROCEDURE sp1;
136 DROP TABLE t1;
137 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
138 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
139 DELIMITER //;
140 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL NO SQL
141 BEGIN
142 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
143 END//
144 DELIMITER ;//
145 CALL sp1(@a,1);
146 DROP PROCEDURE sp1;
147 DROP TABLE t1;
148 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
149 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
150 DELIMITER //;
151 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL READS SQL DATA
152 BEGIN
153 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
154 END//
155 DELIMITER ;//
156 CALL sp1(@a,1);
157 DROP PROCEDURE sp1;
158 DROP TABLE t1;
159 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
160 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
161 DELIMITER //;
162 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL MODIFIES SQL DATA
163 BEGIN
164 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
165 END//
166 DELIMITER ;//
167 CALL sp1(@a,1);
168 DROP PROCEDURE sp1;
169 DROP TABLE t1;
170 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
171 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
172 DELIMITER //;
173 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL COMMENT 'comment'
174 BEGIN
175 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
176 END//
177 DELIMITER ;//
178 CALL sp1(@a,1);
179 DROP PROCEDURE sp1;
180 DROP TABLE t1;
181 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
182 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
183 DELIMITER //;
184 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL CONTAINS SQL COMMENT 'comment'
185 BEGIN
186 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
187 END//
188 DELIMITER ;//
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 DELIMITER //;
195 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL NO SQL COMMENT 'comment'
196 BEGIN
197 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
198 END//
199 DELIMITER ;//
200 CALL sp1(@a,1);
201 DROP PROCEDURE sp1;
202 DROP TABLE t1;
203 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
204 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
205 DELIMITER //;
206 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL READS SQL DATA COMMENT 'comment'
207 BEGIN
208 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
209 END//
210 DELIMITER ;//
211 CALL sp1(@a,1);
212 DROP PROCEDURE sp1;
213 DROP TABLE t1;
214 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
215 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
216 DELIMITER //;
217 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL MODIFIES SQL DATA COMMENT 'comment'
218 BEGIN
219 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
220 END//
221 DELIMITER ;//
222 CALL sp1(@a,1);
223 DROP PROCEDURE sp1;
224 DROP TABLE t1;
225 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
226 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
227 DELIMITER //;
228 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) NOT DETERMINISTIC
229 BEGIN
230 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
231 END//
232 DELIMITER ;//
233 CALL sp1(@a,1);
234 DROP PROCEDURE sp1;
235 DROP TABLE t1;
236 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
237 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
238 DELIMITER //;
239 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) NOT DETERMINISTIC CONTAINS SQL
240 BEGIN
241 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
242 END//
243 DELIMITER ;//
244 CALL sp1(@a,1);
245 DROP PROCEDURE sp1;
246 DROP TABLE t1;
247 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
248 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
249 DELIMITER //;
250 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) NOT DETERMINISTIC NO SQL
251 BEGIN
252 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
253 END//
254 DELIMITER ;//
255 CALL sp1(@a,1);
256 DROP PROCEDURE sp1;
257 DROP TABLE t1;
258 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
259 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
260 DELIMITER //;
261 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) NOT DETERMINISTIC READS SQL DATA
262 BEGIN
263 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
264 END//
265 DELIMITER ;//
266 CALL sp1(@a,1);
267 DROP PROCEDURE sp1;
268 DROP TABLE t1;
269 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
270 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
271 DELIMITER //;
272 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) NOT DETERMINISTIC MODIFIES SQL DATA
273 BEGIN
274 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
275 END//
276 DELIMITER ;//
277 CALL sp1(@a,1);
278 DROP PROCEDURE sp1;
279 DROP TABLE t1;
280 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
281 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
282 DELIMITER //;
283 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) NOT DETERMINISTIC COMMENT 'comment'
284 BEGIN
285 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
286 END//
287 DELIMITER ;//
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 DELIMITER //;
294 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) NOT DETERMINISTIC CONTAINS SQL COMMENT 'comment'
295 BEGIN
296 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
297 END//
298 DELIMITER ;//
299 CALL sp1(@a,1);
300 DROP PROCEDURE sp1;
301 DROP TABLE t1;
302 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
303 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
304 DELIMITER //;
305 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) NOT DETERMINISTIC NO SQL COMMENT 'comment'
306 BEGIN
307 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
308 END//
309 DELIMITER ;//
310 CALL sp1(@a,1);
311 DROP PROCEDURE sp1;
312 DROP TABLE t1;
313 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
314 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
315 DELIMITER //;
316 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) NOT DETERMINISTIC READS SQL DATA COMMENT 'comment'
317 BEGIN
318 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
319 END//
320 DELIMITER ;//
321 CALL sp1(@a,1);
322 DROP PROCEDURE sp1;
323 DROP TABLE t1;
324 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
325 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
326 DELIMITER //;
327 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) NOT DETERMINISTIC MODIFIES SQL DATA COMMENT 'comment'
328 BEGIN
329 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
330 END//
331 DELIMITER ;//
332 CALL sp1(@a,1);
333 DROP PROCEDURE sp1;
334 DROP TABLE t1;
335 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
336 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
337 DELIMITER //;
338 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL NOT DETERMINISTIC
339 BEGIN
340 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
341 END//
342 DELIMITER ;//
343 CALL sp1(@a,1);
344 DROP PROCEDURE sp1;
345 DROP TABLE t1;
346 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
347 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
348 DELIMITER //;
349 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL NOT DETERMINISTIC CONTAINS SQL
350 BEGIN
351 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
352 END//
353 DELIMITER ;//
354 CALL sp1(@a,1);
355 DROP PROCEDURE sp1;
356 DROP TABLE t1;
357 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
358 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
359 DELIMITER //;
360 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL NOT DETERMINISTIC NO SQL
361 BEGIN
362 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
363 END//
364 DELIMITER ;//
365 CALL sp1(@a,1);
366 DROP PROCEDURE sp1;
367 DROP TABLE t1;
368 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
369 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
370 DELIMITER //;
371 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL NOT DETERMINISTIC READS SQL DATA
372 BEGIN
373 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
374 END//
375 DELIMITER ;//
376 CALL sp1(@a,1);
377 DROP PROCEDURE sp1;
378 DROP TABLE t1;
379 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
380 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
381 DELIMITER //;
382 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL NOT DETERMINISTIC MODIFIES SQL DATA
383 BEGIN
384 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
385 END//
386 DELIMITER ;//
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 DELIMITER //;
393 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL NOT DETERMINISTIC COMMENT 'comment'
394 BEGIN
395 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
396 END//
397 DELIMITER ;//
398 CALL sp1(@a,1);
399 DROP PROCEDURE sp1;
400 DROP TABLE t1;
401 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
402 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
403 DELIMITER //;
404 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL NOT DETERMINISTIC CONTAINS SQL COMMENT 'comment'
405 BEGIN
406 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
407 END//
408 DELIMITER ;//
409 CALL sp1(@a,1);
410 DROP PROCEDURE sp1;
411 DROP TABLE t1;
412 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
413 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
414 DELIMITER //;
415 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL NOT DETERMINISTIC NO SQL COMMENT 'comment'
416 BEGIN
417 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
418 END//
419 DELIMITER ;//
420 CALL sp1(@a,1);
421 DROP PROCEDURE sp1;
422 DROP TABLE t1;
423 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
424 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
425 DELIMITER //;
426 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL NOT DETERMINISTIC READS SQL DATA COMMENT 'comment'
427 BEGIN
428 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
429 END//
430 DELIMITER ;//
431 CALL sp1(@a,1);
432 DROP PROCEDURE sp1;
433 DROP TABLE t1;
434 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
435 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
436 DELIMITER //;
437 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL NOT DETERMINISTIC MODIFIES SQL DATA COMMENT 'comment'
438 BEGIN
439 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
440 END//
441 DELIMITER ;//
442 CALL sp1(@a,1);
443 DROP PROCEDURE sp1;
444 DROP TABLE t1;
445 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
446 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
447 DELIMITER //;
448 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) DETERMINISTIC
449 BEGIN
450 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
451 END//
452 DELIMITER ;//
453 CALL sp1(@a,1);
454 DROP PROCEDURE sp1;
455 DROP TABLE t1;
456 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
457 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
458 DELIMITER //;
459 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) DETERMINISTIC CONTAINS SQL
460 BEGIN
461 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
462 END//
463 DELIMITER ;//
464 CALL sp1(@a,1);
465 DROP PROCEDURE sp1;
466 DROP TABLE t1;
467 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
468 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
469 DELIMITER //;
470 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) DETERMINISTIC NO SQL
471 BEGIN
472 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
473 END//
474 DELIMITER ;//
475 CALL sp1(@a,1);
476 DROP PROCEDURE sp1;
477 DROP TABLE t1;
478 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
479 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
480 DELIMITER //;
481 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) DETERMINISTIC READS SQL DATA
482 BEGIN
483 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
484 END//
485 DELIMITER ;//
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 DELIMITER //;
492 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) DETERMINISTIC MODIFIES SQL DATA
493 BEGIN
494 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
495 END//
496 DELIMITER ;//
497 CALL sp1(@a,1);
498 DROP PROCEDURE sp1;
499 DROP TABLE t1;
500 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
501 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
502 DELIMITER //;
503 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) DETERMINISTIC COMMENT 'comment'
504 BEGIN
505 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
506 END//
507 DELIMITER ;//
508 CALL sp1(@a,1);
509 DROP PROCEDURE sp1;
510 DROP TABLE t1;
511 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
512 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
513 DELIMITER //;
514 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) DETERMINISTIC CONTAINS SQL COMMENT 'comment'
515 BEGIN
516 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
517 END//
518 DELIMITER ;//
519 CALL sp1(@a,1);
520 DROP PROCEDURE sp1;
521 DROP TABLE t1;
522 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
523 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
524 DELIMITER //;
525 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) DETERMINISTIC NO SQL COMMENT 'comment'
526 BEGIN
527 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
528 END//
529 DELIMITER ;//
530 CALL sp1(@a,1);
531 DROP PROCEDURE sp1;
532 DROP TABLE t1;
533 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
534 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
535 DELIMITER //;
536 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) DETERMINISTIC READS SQL DATA COMMENT 'comment'
537 BEGIN
538 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
539 END//
540 DELIMITER ;//
541 CALL sp1(@a,1);
542 DROP PROCEDURE sp1;
543 DROP TABLE t1;
544 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
545 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
546 DELIMITER //;
547 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) DETERMINISTIC MODIFIES SQL DATA COMMENT 'comment'
548 BEGIN
549 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
550 END//
551 DELIMITER ;//
552 CALL sp1(@a,1);
553 DROP PROCEDURE sp1;
554 DROP TABLE t1;
555 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
556 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
557 DELIMITER //;
558 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL DETERMINISTIC
559 BEGIN
560 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
561 END//
562 DELIMITER ;//
563 CALL sp1(@a,1);
564 DROP PROCEDURE sp1;
565 DROP TABLE t1;
566 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
567 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
568 DELIMITER //;
569 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL DETERMINISTIC CONTAINS SQL
570 BEGIN
571 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
572 END//
573 DELIMITER ;//
574 CALL sp1(@a,1);
575 DROP PROCEDURE sp1;
576 DROP TABLE t1;
577 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
578 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
579 DELIMITER //;
580 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL DETERMINISTIC NO SQL
581 BEGIN
582 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
583 END//
584 DELIMITER ;//
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 DELIMITER //;
591 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL DETERMINISTIC READS SQL DATA
592 BEGIN
593 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
594 END//
595 DELIMITER ;//
596 CALL sp1(@a,1);
597 DROP PROCEDURE sp1;
598 DROP TABLE t1;
599 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
600 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
601 DELIMITER //;
602 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL DETERMINISTIC MODIFIES SQL DATA
603 BEGIN
604 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
605 END//
606 DELIMITER ;//
607 CALL sp1(@a,1);
608 DROP PROCEDURE sp1;
609 DROP TABLE t1;
610 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
611 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
612 DELIMITER //;
613 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL DETERMINISTIC COMMENT 'comment'
614 BEGIN
615 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
616 END//
617 DELIMITER ;//
618 CALL sp1(@a,1);
619 DROP PROCEDURE sp1;
620 DROP TABLE t1;
621 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
622 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
623 DELIMITER //;
624 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL DETERMINISTIC CONTAINS SQL COMMENT 'comment'
625 BEGIN
626 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
627 END//
628 DELIMITER ;//
629 CALL sp1(@a,1);
630 DROP PROCEDURE sp1;
631 DROP TABLE t1;
632 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
633 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
634 DELIMITER //;
635 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL DETERMINISTIC NO SQL COMMENT 'comment'
636 BEGIN
637 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
638 END//
639 DELIMITER ;//
640 CALL sp1(@a,1);
641 DROP PROCEDURE sp1;
642 DROP TABLE t1;
643 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
644 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
645 DELIMITER //;
646 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL DETERMINISTIC READS SQL DATA COMMENT 'comment'
647 BEGIN
648 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
649 END//
650 DELIMITER ;//
651 CALL sp1(@a,1);
652 DROP PROCEDURE sp1;
653 DROP TABLE t1;
654 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
655 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
656 DELIMITER //;
657 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL DETERMINISTIC MODIFIES SQL DATA COMMENT 'comment'
658 BEGIN
659 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
660 END//
661 DELIMITER ;//
662 CALL sp1(@a,1);
663 DROP PROCEDURE sp1;
664 DROP TABLE t1;
665 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
666 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
667 DELIMITER //;
668 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) SQL SECURITY INVOKER
669 BEGIN
670 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
671 END//
672 DELIMITER ;//
673 CALL sp1(@a,1);
674 DROP PROCEDURE sp1;
675 DROP TABLE t1;
676 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
677 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
678 DELIMITER //;
679 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) CONTAINS SQL SQL SECURITY INVOKER
680 BEGIN
681 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
682 END//
683 DELIMITER ;//
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 DELIMITER //;
690 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) NO SQL SQL SECURITY INVOKER
691 BEGIN
692 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
693 END//
694 DELIMITER ;//
695 CALL sp1(@a,1);
696 DROP PROCEDURE sp1;
697 DROP TABLE t1;
698 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
699 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
700 DELIMITER //;
701 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) READS SQL DATA SQL SECURITY INVOKER
702 BEGIN
703 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
704 END//
705 DELIMITER ;//
706 CALL sp1(@a,1);
707 DROP PROCEDURE sp1;
708 DROP TABLE t1;
709 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
710 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
711 DELIMITER //;
712 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) MODIFIES SQL DATA SQL SECURITY INVOKER
713 BEGIN
714 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
715 END//
716 DELIMITER ;//
717 CALL sp1(@a,1);
718 DROP PROCEDURE sp1;
719 DROP TABLE t1;
720 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
721 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
722 DELIMITER //;
723 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) SQL SECURITY INVOKER COMMENT 'comment'
724 BEGIN
725 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
726 END//
727 DELIMITER ;//
728 CALL sp1(@a,1);
729 DROP PROCEDURE sp1;
730 DROP TABLE t1;
731 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
732 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
733 DELIMITER //;
734 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) CONTAINS SQL SQL SECURITY INVOKER COMMENT 'comment'
735 BEGIN
736 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
737 END//
738 DELIMITER ;//
739 CALL sp1(@a,1);
740 DROP PROCEDURE sp1;
741 DROP TABLE t1;
742 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
743 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
744 DELIMITER //;
745 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) NO SQL SQL SECURITY INVOKER COMMENT 'comment'
746 BEGIN
747 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
748 END//
749 DELIMITER ;//
750 CALL sp1(@a,1);
751 DROP PROCEDURE sp1;
752 DROP TABLE t1;
753 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
754 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
755 DELIMITER //;
756 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) READS SQL DATA SQL SECURITY INVOKER COMMENT 'comment'
757 BEGIN
758 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
759 END//
760 DELIMITER ;//
761 CALL sp1(@a,1);
762 DROP PROCEDURE sp1;
763 DROP TABLE t1;
764 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
765 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
766 DELIMITER //;
767 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) MODIFIES SQL DATA SQL SECURITY INVOKER COMMENT 'comment'
768 BEGIN
769 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
770 END//
771 DELIMITER ;//
772 CALL sp1(@a,1);
773 DROP PROCEDURE sp1;
774 DROP TABLE t1;
775 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
776 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
777 DELIMITER //;
778 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL SQL SECURITY INVOKER
779 BEGIN
780 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
781 END//
782 DELIMITER ;//
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 DELIMITER //;
789 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL CONTAINS SQL SQL SECURITY INVOKER
790 BEGIN
791 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
792 END//
793 DELIMITER ;//
794 CALL sp1(@a,1);
795 DROP PROCEDURE sp1;
796 DROP TABLE t1;
797 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
798 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
799 DELIMITER //;
800 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL NO SQL SQL SECURITY INVOKER
801 BEGIN
802 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
803 END//
804 DELIMITER ;//
805 CALL sp1(@a,1);
806 DROP PROCEDURE sp1;
807 DROP TABLE t1;
808 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
809 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
810 DELIMITER //;
811 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL READS SQL DATA SQL SECURITY INVOKER
812 BEGIN
813 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
814 END//
815 DELIMITER ;//
816 CALL sp1(@a,1);
817 DROP PROCEDURE sp1;
818 DROP TABLE t1;
819 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
820 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
821 DELIMITER //;
822 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL MODIFIES SQL DATA SQL SECURITY INVOKER
823 BEGIN
824 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
825 END//
826 DELIMITER ;//
827 CALL sp1(@a,1);
828 DROP PROCEDURE sp1;
829 DROP TABLE t1;
830 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
831 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
832 DELIMITER //;
833 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL SQL SECURITY INVOKER COMMENT 'comment'
834 BEGIN
835 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
836 END//
837 DELIMITER ;//
838 CALL sp1(@a,1);
839 DROP PROCEDURE sp1;
840 DROP TABLE t1;
841 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
842 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
843 DELIMITER //;
844 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL CONTAINS SQL SQL SECURITY INVOKER COMMENT 'comment'
845 BEGIN
846 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
847 END//
848 DELIMITER ;//
849 CALL sp1(@a,1);
850 DROP PROCEDURE sp1;
851 DROP TABLE t1;
852 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
853 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
854 DELIMITER //;
855 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL NO SQL SQL SECURITY INVOKER COMMENT 'comment'
856 BEGIN
857 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
858 END//
859 DELIMITER ;//
860 CALL sp1(@a,1);
861 DROP PROCEDURE sp1;
862 DROP TABLE t1;
863 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
864 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
865 DELIMITER //;
866 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL READS SQL DATA SQL SECURITY INVOKER COMMENT 'comment'
867 BEGIN
868 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
869 END//
870 DELIMITER ;//
871 CALL sp1(@a,1);
872 DROP PROCEDURE sp1;
873 DROP TABLE t1;
874 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
875 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
876 DELIMITER //;
877 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL MODIFIES SQL DATA SQL SECURITY INVOKER COMMENT 'comment'
878 BEGIN
879 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
880 END//
881 DELIMITER ;//
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 DELIMITER //;
888 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) NOT DETERMINISTIC SQL SECURITY INVOKER
889 BEGIN
890 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
891 END//
892 DELIMITER ;//
893 CALL sp1(@a,1);
894 DROP PROCEDURE sp1;
895 DROP TABLE t1;
896 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
897 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
898 DELIMITER //;
899 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) NOT DETERMINISTIC CONTAINS SQL SQL SECURITY INVOKER
900 BEGIN
901 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
902 END//
903 DELIMITER ;//
904 CALL sp1(@a,1);
905 DROP PROCEDURE sp1;
906 DROP TABLE t1;
907 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
908 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
909 DELIMITER //;
910 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) NOT DETERMINISTIC NO SQL SQL SECURITY INVOKER
911 BEGIN
912 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
913 END//
914 DELIMITER ;//
915 CALL sp1(@a,1);
916 DROP PROCEDURE sp1;
917 DROP TABLE t1;
918 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
919 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
920 DELIMITER //;
921 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) NOT DETERMINISTIC READS SQL DATA SQL SECURITY INVOKER
922 BEGIN
923 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
924 END//
925 DELIMITER ;//
926 CALL sp1(@a,1);
927 DROP PROCEDURE sp1;
928 DROP TABLE t1;
929 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
930 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
931 DELIMITER //;
932 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) NOT DETERMINISTIC MODIFIES SQL DATA SQL SECURITY INVOKER
933 BEGIN
934 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
935 END//
936 DELIMITER ;//
937 CALL sp1(@a,1);
938 DROP PROCEDURE sp1;
939 DROP TABLE t1;
940 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
941 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
942 DELIMITER //;
943 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) NOT DETERMINISTIC SQL SECURITY INVOKER COMMENT 'comment'
944 BEGIN
945 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
946 END//
947 DELIMITER ;//
948 CALL sp1(@a,1);
949 DROP PROCEDURE sp1;
950 DROP TABLE t1;
951 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
952 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
953 DELIMITER //;
954 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) NOT DETERMINISTIC CONTAINS SQL SQL SECURITY INVOKER COMMENT 'comment'
955 BEGIN
956 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
957 END//
958 DELIMITER ;//
959 CALL sp1(@a,1);
960 DROP PROCEDURE sp1;
961 DROP TABLE t1;
962 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
963 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
964 DELIMITER //;
965 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) NOT DETERMINISTIC NO SQL SQL SECURITY INVOKER COMMENT 'comment'
966 BEGIN
967 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
968 END//
969 DELIMITER ;//
970 CALL sp1(@a,1);
971 DROP PROCEDURE sp1;
972 DROP TABLE t1;
973 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
974 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
975 DELIMITER //;
976 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) NOT DETERMINISTIC READS SQL DATA SQL SECURITY INVOKER COMMENT 'comment'
977 BEGIN
978 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
979 END//
980 DELIMITER ;//
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 DELIMITER //;
987 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) NOT DETERMINISTIC MODIFIES SQL DATA SQL SECURITY INVOKER COMMENT 'comment'
988 BEGIN
989 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
990 END//
991 DELIMITER ;//
992 CALL sp1(@a,1);
993 DROP PROCEDURE sp1;
994 DROP TABLE t1;
995 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
996 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
997 DELIMITER //;
998 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL NOT DETERMINISTIC SQL SECURITY INVOKER
999 BEGIN
1000 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1001 END//
1002 DELIMITER ;//
1003 CALL sp1(@a,1);
1004 DROP PROCEDURE sp1;
1005 DROP TABLE t1;
1006 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1007 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1008 DELIMITER //;
1009 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL NOT DETERMINISTIC CONTAINS SQL SQL SECURITY INVOKER
1010 BEGIN
1011 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1012 END//
1013 DELIMITER ;//
1014 CALL sp1(@a,1);
1015 DROP PROCEDURE sp1;
1016 DROP TABLE t1;
1017 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1018 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1019 DELIMITER //;
1020 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL NOT DETERMINISTIC NO SQL SQL SECURITY INVOKER
1021 BEGIN
1022 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1023 END//
1024 DELIMITER ;//
1025 CALL sp1(@a,1);
1026 DROP PROCEDURE sp1;
1027 DROP TABLE t1;
1028 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1029 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1030 DELIMITER //;
1031 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL NOT DETERMINISTIC READS SQL DATA SQL SECURITY INVOKER
1032 BEGIN
1033 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1034 END//
1035 DELIMITER ;//
1036 CALL sp1(@a,1);
1037 DROP PROCEDURE sp1;
1038 DROP TABLE t1;
1039 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1040 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1041 DELIMITER //;
1042 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL NOT DETERMINISTIC MODIFIES SQL DATA SQL SECURITY INVOKER
1043 BEGIN
1044 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1045 END//
1046 DELIMITER ;//
1047 CALL sp1(@a,1);
1048 DROP PROCEDURE sp1;
1049 DROP TABLE t1;
1050 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1051 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1052 DELIMITER //;
1053 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL NOT DETERMINISTIC SQL SECURITY INVOKER COMMENT 'comment'
1054 BEGIN
1055 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1056 END//
1057 DELIMITER ;//
1058 CALL sp1(@a,1);
1059 DROP PROCEDURE sp1;
1060 DROP TABLE t1;
1061 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1062 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1063 DELIMITER //;
1064 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL NOT DETERMINISTIC CONTAINS SQL SQL SECURITY INVOKER COMMENT 'comment'
1065 BEGIN
1066 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1067 END//
1068 DELIMITER ;//
1069 CALL sp1(@a,1);
1070 DROP PROCEDURE sp1;
1071 DROP TABLE t1;
1072 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1073 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1074 DELIMITER //;
1075 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL NOT DETERMINISTIC NO SQL SQL SECURITY INVOKER COMMENT 'comment'
1076 BEGIN
1077 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1078 END//
1079 DELIMITER ;//
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 DELIMITER //;
1086 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL NOT DETERMINISTIC READS SQL DATA SQL SECURITY INVOKER COMMENT 'comment'
1087 BEGIN
1088 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1089 END//
1090 DELIMITER ;//
1091 CALL sp1(@a,1);
1092 DROP PROCEDURE sp1;
1093 DROP TABLE t1;
1094 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1095 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1096 DELIMITER //;
1097 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL NOT DETERMINISTIC MODIFIES SQL DATA SQL SECURITY INVOKER COMMENT 'comment'
1098 BEGIN
1099 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1100 END//
1101 DELIMITER ;//
1102 CALL sp1(@a,1);
1103 DROP PROCEDURE sp1;
1104 DROP TABLE t1;
1105 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1106 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1107 DELIMITER //;
1108 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) DETERMINISTIC SQL SECURITY INVOKER
1109 BEGIN
1110 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1111 END//
1112 DELIMITER ;//
1113 CALL sp1(@a,1);
1114 DROP PROCEDURE sp1;
1115 DROP TABLE t1;
1116 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1117 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1118 DELIMITER //;
1119 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) DETERMINISTIC CONTAINS SQL SQL SECURITY INVOKER
1120 BEGIN
1121 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1122 END//
1123 DELIMITER ;//
1124 CALL sp1(@a,1);
1125 DROP PROCEDURE sp1;
1126 DROP TABLE t1;
1127 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1128 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1129 DELIMITER //;
1130 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) DETERMINISTIC NO SQL SQL SECURITY INVOKER
1131 BEGIN
1132 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1133 END//
1134 DELIMITER ;//
1135 CALL sp1(@a,1);
1136 DROP PROCEDURE sp1;
1137 DROP TABLE t1;
1138 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1139 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1140 DELIMITER //;
1141 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) DETERMINISTIC READS SQL DATA SQL SECURITY INVOKER
1142 BEGIN
1143 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1144 END//
1145 DELIMITER ;//
1146 CALL sp1(@a,1);
1147 DROP PROCEDURE sp1;
1148 DROP TABLE t1;
1149 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1150 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1151 DELIMITER //;
1152 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) DETERMINISTIC MODIFIES SQL DATA SQL SECURITY INVOKER
1153 BEGIN
1154 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1155 END//
1156 DELIMITER ;//
1157 CALL sp1(@a,1);
1158 DROP PROCEDURE sp1;
1159 DROP TABLE t1;
1160 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1161 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1162 DELIMITER //;
1163 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) DETERMINISTIC SQL SECURITY INVOKER COMMENT 'comment'
1164 BEGIN
1165 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1166 END//
1167 DELIMITER ;//
1168 CALL sp1(@a,1);
1169 DROP PROCEDURE sp1;
1170 DROP TABLE t1;
1171 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1172 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1173 DELIMITER //;
1174 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) DETERMINISTIC CONTAINS SQL SQL SECURITY INVOKER COMMENT 'comment'
1175 BEGIN
1176 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1177 END//
1178 DELIMITER ;//
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 DELIMITER //;
1185 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) DETERMINISTIC NO SQL SQL SECURITY INVOKER COMMENT 'comment'
1186 BEGIN
1187 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1188 END//
1189 DELIMITER ;//
1190 CALL sp1(@a,1);
1191 DROP PROCEDURE sp1;
1192 DROP TABLE t1;
1193 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1194 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1195 DELIMITER //;
1196 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) DETERMINISTIC READS SQL DATA SQL SECURITY INVOKER COMMENT 'comment'
1197 BEGIN
1198 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1199 END//
1200 DELIMITER ;//
1201 CALL sp1(@a,1);
1202 DROP PROCEDURE sp1;
1203 DROP TABLE t1;
1204 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1205 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1206 DELIMITER //;
1207 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) DETERMINISTIC MODIFIES SQL DATA SQL SECURITY INVOKER COMMENT 'comment'
1208 BEGIN
1209 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1210 END//
1211 DELIMITER ;//
1212 CALL sp1(@a,1);
1213 DROP PROCEDURE sp1;
1214 DROP TABLE t1;
1215 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1216 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1217 DELIMITER //;
1218 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL DETERMINISTIC SQL SECURITY INVOKER
1219 BEGIN
1220 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1221 END//
1222 DELIMITER ;//
1223 CALL sp1(@a,1);
1224 DROP PROCEDURE sp1;
1225 DROP TABLE t1;
1226 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1227 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1228 DELIMITER //;
1229 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL DETERMINISTIC CONTAINS SQL SQL SECURITY INVOKER
1230 BEGIN
1231 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1232 END//
1233 DELIMITER ;//
1234 CALL sp1(@a,1);
1235 DROP PROCEDURE sp1;
1236 DROP TABLE t1;
1237 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1238 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1239 DELIMITER //;
1240 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL DETERMINISTIC NO SQL SQL SECURITY INVOKER
1241 BEGIN
1242 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1243 END//
1244 DELIMITER ;//
1245 CALL sp1(@a,1);
1246 DROP PROCEDURE sp1;
1247 DROP TABLE t1;
1248 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1249 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1250 DELIMITER //;
1251 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL DETERMINISTIC READS SQL DATA SQL SECURITY INVOKER
1252 BEGIN
1253 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1254 END//
1255 DELIMITER ;//
1256 CALL sp1(@a,1);
1257 DROP PROCEDURE sp1;
1258 DROP TABLE t1;
1259 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1260 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1261 DELIMITER //;
1262 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL DETERMINISTIC MODIFIES SQL DATA SQL SECURITY INVOKER
1263 BEGIN
1264 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1265 END//
1266 DELIMITER ;//
1267 CALL sp1(@a,1);
1268 DROP PROCEDURE sp1;
1269 DROP TABLE t1;
1270 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1271 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1272 DELIMITER //;
1273 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL DETERMINISTIC SQL SECURITY INVOKER COMMENT 'comment'
1274 BEGIN
1275 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1276 END//
1277 DELIMITER ;//
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 DELIMITER //;
1284 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL DETERMINISTIC CONTAINS SQL SQL SECURITY INVOKER COMMENT 'comment'
1285 BEGIN
1286 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1287 END//
1288 DELIMITER ;//
1289 CALL sp1(@a,1);
1290 DROP PROCEDURE sp1;
1291 DROP TABLE t1;
1292 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1293 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1294 DELIMITER //;
1295 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL DETERMINISTIC NO SQL SQL SECURITY INVOKER COMMENT 'comment'
1296 BEGIN
1297 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1298 END//
1299 DELIMITER ;//
1300 CALL sp1(@a,1);
1301 DROP PROCEDURE sp1;
1302 DROP TABLE t1;
1303 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1304 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1305 DELIMITER //;
1306 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL DETERMINISTIC READS SQL DATA SQL SECURITY INVOKER COMMENT 'comment'
1307 BEGIN
1308 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1309 END//
1310 DELIMITER ;//
1311 CALL sp1(@a,1);
1312 DROP PROCEDURE sp1;
1313 DROP TABLE t1;
1314 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1315 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1316 DELIMITER //;
1317 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL DETERMINISTIC MODIFIES SQL DATA SQL SECURITY INVOKER COMMENT 'comment'
1318 BEGIN
1319 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1320 END//
1321 DELIMITER ;//
1322 CALL sp1(@a,1);
1323 DROP PROCEDURE sp1;
1324 DROP TABLE t1;
1325 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1326 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1327 DELIMITER //;
1328 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) SQL SECURITY DEFINER
1329 BEGIN
1330 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1331 END//
1332 DELIMITER ;//
1333 CALL sp1(@a,1);
1334 DROP PROCEDURE sp1;
1335 DROP TABLE t1;
1336 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1337 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1338 DELIMITER //;
1339 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) CONTAINS SQL SQL SECURITY DEFINER
1340 BEGIN
1341 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1342 END//
1343 DELIMITER ;//
1344 CALL sp1(@a,1);
1345 DROP PROCEDURE sp1;
1346 DROP TABLE t1;
1347 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1348 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1349 DELIMITER //;
1350 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) NO SQL SQL SECURITY DEFINER
1351 BEGIN
1352 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1353 END//
1354 DELIMITER ;//
1355 CALL sp1(@a,1);
1356 DROP PROCEDURE sp1;
1357 DROP TABLE t1;
1358 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1359 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1360 DELIMITER //;
1361 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) READS SQL DATA SQL SECURITY DEFINER
1362 BEGIN
1363 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1364 END//
1365 DELIMITER ;//
1366 CALL sp1(@a,1);
1367 DROP PROCEDURE sp1;
1368 DROP TABLE t1;
1369 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1370 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1371 DELIMITER //;
1372 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) MODIFIES SQL DATA SQL SECURITY DEFINER
1373 BEGIN
1374 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1375 END//
1376 DELIMITER ;//
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 DELIMITER //;
1383 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) SQL SECURITY DEFINER COMMENT 'comment'
1384 BEGIN
1385 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1386 END//
1387 DELIMITER ;//
1388 CALL sp1(@a,1);
1389 DROP PROCEDURE sp1;
1390 DROP TABLE t1;
1391 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1392 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1393 DELIMITER //;
1394 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) CONTAINS SQL SQL SECURITY DEFINER COMMENT 'comment'
1395 BEGIN
1396 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1397 END//
1398 DELIMITER ;//
1399 CALL sp1(@a,1);
1400 DROP PROCEDURE sp1;
1401 DROP TABLE t1;
1402 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1403 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1404 DELIMITER //;
1405 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) NO SQL SQL SECURITY DEFINER COMMENT 'comment'
1406 BEGIN
1407 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1408 END//
1409 DELIMITER ;//
1410 CALL sp1(@a,1);
1411 DROP PROCEDURE sp1;
1412 DROP TABLE t1;
1413 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1414 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1415 DELIMITER //;
1416 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) READS SQL DATA SQL SECURITY DEFINER COMMENT 'comment'
1417 BEGIN
1418 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1419 END//
1420 DELIMITER ;//
1421 CALL sp1(@a,1);
1422 DROP PROCEDURE sp1;
1423 DROP TABLE t1;
1424 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1425 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1426 DELIMITER //;
1427 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) MODIFIES SQL DATA SQL SECURITY DEFINER COMMENT 'comment'
1428 BEGIN
1429 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1430 END//
1431 DELIMITER ;//
1432 CALL sp1(@a,1);
1433 DROP PROCEDURE sp1;
1434 DROP TABLE t1;
1435 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1436 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1437 DELIMITER //;
1438 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL SQL SECURITY DEFINER
1439 BEGIN
1440 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1441 END//
1442 DELIMITER ;//
1443 CALL sp1(@a,1);
1444 DROP PROCEDURE sp1;
1445 DROP TABLE t1;
1446 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1447 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1448 DELIMITER //;
1449 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL CONTAINS SQL SQL SECURITY DEFINER
1450 BEGIN
1451 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1452 END//
1453 DELIMITER ;//
1454 CALL sp1(@a,1);
1455 DROP PROCEDURE sp1;
1456 DROP TABLE t1;
1457 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1458 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1459 DELIMITER //;
1460 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL NO SQL SQL SECURITY DEFINER
1461 BEGIN
1462 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1463 END//
1464 DELIMITER ;//
1465 CALL sp1(@a,1);
1466 DROP PROCEDURE sp1;
1467 DROP TABLE t1;
1468 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1469 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1470 DELIMITER //;
1471 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL READS SQL DATA SQL SECURITY DEFINER
1472 BEGIN
1473 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1474 END//
1475 DELIMITER ;//
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 DELIMITER //;
1482 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL MODIFIES SQL DATA SQL SECURITY DEFINER
1483 BEGIN
1484 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1485 END//
1486 DELIMITER ;//
1487 CALL sp1(@a,1);
1488 DROP PROCEDURE sp1;
1489 DROP TABLE t1;
1490 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1491 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1492 DELIMITER //;
1493 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL SQL SECURITY DEFINER COMMENT 'comment'
1494 BEGIN
1495 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1496 END//
1497 DELIMITER ;//
1498 CALL sp1(@a,1);
1499 DROP PROCEDURE sp1;
1500 DROP TABLE t1;
1501 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1502 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1503 DELIMITER //;
1504 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL CONTAINS SQL SQL SECURITY DEFINER COMMENT 'comment'
1505 BEGIN
1506 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1507 END//
1508 DELIMITER ;//
1509 CALL sp1(@a,1);
1510 DROP PROCEDURE sp1;
1511 DROP TABLE t1;
1512 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1513 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1514 DELIMITER //;
1515 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL NO SQL SQL SECURITY DEFINER COMMENT 'comment'
1516 BEGIN
1517 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1518 END//
1519 DELIMITER ;//
1520 CALL sp1(@a,1);
1521 DROP PROCEDURE sp1;
1522 DROP TABLE t1;
1523 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1524 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1525 DELIMITER //;
1526 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL READS SQL DATA SQL SECURITY DEFINER COMMENT 'comment'
1527 BEGIN
1528 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1529 END//
1530 DELIMITER ;//
1531 CALL sp1(@a,1);
1532 DROP PROCEDURE sp1;
1533 DROP TABLE t1;
1534 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1535 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1536 DELIMITER //;
1537 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL MODIFIES SQL DATA SQL SECURITY DEFINER COMMENT 'comment'
1538 BEGIN
1539 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1540 END//
1541 DELIMITER ;//
1542 CALL sp1(@a,1);
1543 DROP PROCEDURE sp1;
1544 DROP TABLE t1;
1545 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1546 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1547 DELIMITER //;
1548 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) NOT DETERMINISTIC SQL SECURITY DEFINER
1549 BEGIN
1550 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1551 END//
1552 DELIMITER ;//
1553 CALL sp1(@a,1);
1554 DROP PROCEDURE sp1;
1555 DROP TABLE t1;
1556 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1557 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1558 DELIMITER //;
1559 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) NOT DETERMINISTIC CONTAINS SQL SQL SECURITY DEFINER
1560 BEGIN
1561 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1562 END//
1563 DELIMITER ;//
1564 CALL sp1(@a,1);
1565 DROP PROCEDURE sp1;
1566 DROP TABLE t1;
1567 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1568 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1569 DELIMITER //;
1570 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) NOT DETERMINISTIC NO SQL SQL SECURITY DEFINER
1571 BEGIN
1572 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1573 END//
1574 DELIMITER ;//
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 DELIMITER //;
1581 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) NOT DETERMINISTIC READS SQL DATA SQL SECURITY DEFINER
1582 BEGIN
1583 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1584 END//
1585 DELIMITER ;//
1586 CALL sp1(@a,1);
1587 DROP PROCEDURE sp1;
1588 DROP TABLE t1;
1589 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1590 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1591 DELIMITER //;
1592 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) NOT DETERMINISTIC MODIFIES SQL DATA SQL SECURITY DEFINER
1593 BEGIN
1594 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1595 END//
1596 DELIMITER ;//
1597 CALL sp1(@a,1);
1598 DROP PROCEDURE sp1;
1599 DROP TABLE t1;
1600 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1601 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1602 DELIMITER //;
1603 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) NOT DETERMINISTIC SQL SECURITY DEFINER COMMENT 'comment'
1604 BEGIN
1605 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1606 END//
1607 DELIMITER ;//
1608 CALL sp1(@a,1);
1609 DROP PROCEDURE sp1;
1610 DROP TABLE t1;
1611 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1612 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1613 DELIMITER //;
1614 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) NOT DETERMINISTIC CONTAINS SQL SQL SECURITY DEFINER COMMENT 'comment'
1615 BEGIN
1616 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1617 END//
1618 DELIMITER ;//
1619 CALL sp1(@a,1);
1620 DROP PROCEDURE sp1;
1621 DROP TABLE t1;
1622 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1623 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1624 DELIMITER //;
1625 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) NOT DETERMINISTIC NO SQL SQL SECURITY DEFINER COMMENT 'comment'
1626 BEGIN
1627 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1628 END//
1629 DELIMITER ;//
1630 CALL sp1(@a,1);
1631 DROP PROCEDURE sp1;
1632 DROP TABLE t1;
1633 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1634 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1635 DELIMITER //;
1636 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) NOT DETERMINISTIC READS SQL DATA SQL SECURITY DEFINER COMMENT 'comment'
1637 BEGIN
1638 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1639 END//
1640 DELIMITER ;//
1641 CALL sp1(@a,1);
1642 DROP PROCEDURE sp1;
1643 DROP TABLE t1;
1644 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1645 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1646 DELIMITER //;
1647 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) NOT DETERMINISTIC MODIFIES SQL DATA SQL SECURITY DEFINER COMMENT 'comment'
1648 BEGIN
1649 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1650 END//
1651 DELIMITER ;//
1652 CALL sp1(@a,1);
1653 DROP PROCEDURE sp1;
1654 DROP TABLE t1;
1655 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1656 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1657 DELIMITER //;
1658 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL NOT DETERMINISTIC SQL SECURITY DEFINER
1659 BEGIN
1660 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1661 END//
1662 DELIMITER ;//
1663 CALL sp1(@a,1);
1664 DROP PROCEDURE sp1;
1665 DROP TABLE t1;
1666 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1667 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1668 DELIMITER //;
1669 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL NOT DETERMINISTIC CONTAINS SQL SQL SECURITY DEFINER
1670 BEGIN
1671 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1672 END//
1673 DELIMITER ;//
1674 CALL sp1(@a,1);
1675 DROP PROCEDURE sp1;
1676 DROP TABLE t1;
1677 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1678 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1679 DELIMITER //;
1680 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL NOT DETERMINISTIC NO SQL SQL SECURITY DEFINER
1681 BEGIN
1682 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1683 END//
1684 DELIMITER ;//
1685 CALL sp1(@a,1);
1686 DROP PROCEDURE sp1;
1687 DROP TABLE t1;
1688 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1689 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1690 DELIMITER //;
1691 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL NOT DETERMINISTIC READS SQL DATA SQL SECURITY DEFINER
1692 BEGIN
1693 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1694 END//
1695 DELIMITER ;//
1696 CALL sp1(@a,1);
1697 DROP PROCEDURE sp1;
1698 DROP TABLE t1;
1699 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1700 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1701 DELIMITER //;
1702 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL NOT DETERMINISTIC MODIFIES SQL DATA SQL SECURITY DEFINER
1703 BEGIN
1704 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1705 END//
1706 DELIMITER ;//
1707 CALL sp1(@a,1);
1708 DROP PROCEDURE sp1;
1709 DROP TABLE t1;
1710 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1711 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1712 DELIMITER //;
1713 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL NOT DETERMINISTIC SQL SECURITY DEFINER COMMENT 'comment'
1714 BEGIN
1715 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1716 END//
1717 DELIMITER ;//
1718 CALL sp1(@a,1);
1719 DROP PROCEDURE sp1;
1720 DROP TABLE t1;
1721 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1722 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1723 DELIMITER //;
1724 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL NOT DETERMINISTIC CONTAINS SQL SQL SECURITY DEFINER COMMENT 'comment'
1725 BEGIN
1726 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1727 END//
1728 DELIMITER ;//
1729 CALL sp1(@a,1);
1730 DROP PROCEDURE sp1;
1731 DROP TABLE t1;
1732 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1733 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1734 DELIMITER //;
1735 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL NOT DETERMINISTIC NO SQL SQL SECURITY DEFINER COMMENT 'comment'
1736 BEGIN
1737 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1738 END//
1739 DELIMITER ;//
1740 CALL sp1(@a,1);
1741 DROP PROCEDURE sp1;
1742 DROP TABLE t1;
1743 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1744 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1745 DELIMITER //;
1746 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL NOT DETERMINISTIC READS SQL DATA SQL SECURITY DEFINER COMMENT 'comment'
1747 BEGIN
1748 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1749 END//
1750 DELIMITER ;//
1751 CALL sp1(@a,1);
1752 DROP PROCEDURE sp1;
1753 DROP TABLE t1;
1754 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1755 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1756 DELIMITER //;
1757 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL NOT DETERMINISTIC MODIFIES SQL DATA SQL SECURITY DEFINER COMMENT 'comment'
1758 BEGIN
1759 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1760 END//
1761 DELIMITER ;//
1762 CALL sp1(@a,1);
1763 DROP PROCEDURE sp1;
1764 DROP TABLE t1;
1765 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1766 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1767 DELIMITER //;
1768 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) DETERMINISTIC SQL SECURITY DEFINER
1769 BEGIN
1770 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1771 END//
1772 DELIMITER ;//
1773 CALL sp1(@a,1);
1774 DROP PROCEDURE sp1;
1775 DROP TABLE t1;
1776 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1777 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1778 DELIMITER //;
1779 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) DETERMINISTIC CONTAINS SQL SQL SECURITY DEFINER
1780 BEGIN
1781 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1782 END//
1783 DELIMITER ;//
1784 CALL sp1(@a,1);
1785 DROP PROCEDURE sp1;
1786 DROP TABLE t1;
1787 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1788 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1789 DELIMITER //;
1790 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) DETERMINISTIC NO SQL SQL SECURITY DEFINER
1791 BEGIN
1792 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1793 END//
1794 DELIMITER ;//
1795 CALL sp1(@a,1);
1796 DROP PROCEDURE sp1;
1797 DROP TABLE t1;
1798 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1799 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1800 DELIMITER //;
1801 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) DETERMINISTIC READS SQL DATA SQL SECURITY DEFINER
1802 BEGIN
1803 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1804 END//
1805 DELIMITER ;//
1806 CALL sp1(@a,1);
1807 DROP PROCEDURE sp1;
1808 DROP TABLE t1;
1809 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1810 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1811 DELIMITER //;
1812 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) DETERMINISTIC MODIFIES SQL DATA SQL SECURITY DEFINER
1813 BEGIN
1814 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1815 END//
1816 DELIMITER ;//
1817 CALL sp1(@a,1);
1818 DROP PROCEDURE sp1;
1819 DROP TABLE t1;
1820 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1821 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1822 DELIMITER //;
1823 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) DETERMINISTIC SQL SECURITY DEFINER COMMENT 'comment'
1824 BEGIN
1825 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1826 END//
1827 DELIMITER ;//
1828 CALL sp1(@a,1);
1829 DROP PROCEDURE sp1;
1830 DROP TABLE t1;
1831 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1832 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1833 DELIMITER //;
1834 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) DETERMINISTIC CONTAINS SQL SQL SECURITY DEFINER COMMENT 'comment'
1835 BEGIN
1836 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1837 END//
1838 DELIMITER ;//
1839 CALL sp1(@a,1);
1840 DROP PROCEDURE sp1;
1841 DROP TABLE t1;
1842 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1843 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1844 DELIMITER //;
1845 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) DETERMINISTIC NO SQL SQL SECURITY DEFINER COMMENT 'comment'
1846 BEGIN
1847 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1848 END//
1849 DELIMITER ;//
1850 CALL sp1(@a,1);
1851 DROP PROCEDURE sp1;
1852 DROP TABLE t1;
1853 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1854 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1855 DELIMITER //;
1856 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) DETERMINISTIC READS SQL DATA SQL SECURITY DEFINER COMMENT 'comment'
1857 BEGIN
1858 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1859 END//
1860 DELIMITER ;//
1861 CALL sp1(@a,1);
1862 DROP PROCEDURE sp1;
1863 DROP TABLE t1;
1864 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1865 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1866 DELIMITER //;
1867 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) DETERMINISTIC MODIFIES SQL DATA SQL SECURITY DEFINER COMMENT 'comment'
1868 BEGIN
1869 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1870 END//
1871 DELIMITER ;//
1872 CALL sp1(@a,1);
1873 DROP PROCEDURE sp1;
1874 DROP TABLE t1;
1875 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1876 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1877 DELIMITER //;
1878 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL DETERMINISTIC SQL SECURITY DEFINER
1879 BEGIN
1880 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1881 END//
1882 DELIMITER ;//
1883 CALL sp1(@a,1);
1884 DROP PROCEDURE sp1;
1885 DROP TABLE t1;
1886 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1887 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1888 DELIMITER //;
1889 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL DETERMINISTIC CONTAINS SQL SQL SECURITY DEFINER
1890 BEGIN
1891 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1892 END//
1893 DELIMITER ;//
1894 CALL sp1(@a,1);
1895 DROP PROCEDURE sp1;
1896 DROP TABLE t1;
1897 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1898 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1899 DELIMITER //;
1900 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL DETERMINISTIC NO SQL SQL SECURITY DEFINER
1901 BEGIN
1902 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1903 END//
1904 DELIMITER ;//
1905 CALL sp1(@a,1);
1906 DROP PROCEDURE sp1;
1907 DROP TABLE t1;
1908 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1909 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1910 DELIMITER //;
1911 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL DETERMINISTIC READS SQL DATA SQL SECURITY DEFINER
1912 BEGIN
1913 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1914 END//
1915 DELIMITER ;//
1916 CALL sp1(@a,1);
1917 DROP PROCEDURE sp1;
1918 DROP TABLE t1;
1919 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1920 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1921 DELIMITER //;
1922 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL DETERMINISTIC MODIFIES SQL DATA SQL SECURITY DEFINER
1923 BEGIN
1924 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1925 END//
1926 DELIMITER ;//
1927 CALL sp1(@a,1);
1928 DROP PROCEDURE sp1;
1929 DROP TABLE t1;
1930 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1931 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1932 DELIMITER //;
1933 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL DETERMINISTIC SQL SECURITY DEFINER COMMENT 'comment'
1934 BEGIN
1935 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1936 END//
1937 DELIMITER ;//
1938 CALL sp1(@a,1);
1939 DROP PROCEDURE sp1;
1940 DROP TABLE t1;
1941 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1942 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1943 DELIMITER //;
1944 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL DETERMINISTIC CONTAINS SQL SQL SECURITY DEFINER COMMENT 'comment'
1945 BEGIN
1946 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1947 END//
1948 DELIMITER ;//
1949 CALL sp1(@a,1);
1950 DROP PROCEDURE sp1;
1951 DROP TABLE t1;
1952 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1953 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1954 DELIMITER //;
1955 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL DETERMINISTIC NO SQL SQL SECURITY DEFINER COMMENT 'comment'
1956 BEGIN
1957 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1958 END//
1959 DELIMITER ;//
1960 CALL sp1(@a,1);
1961 DROP PROCEDURE sp1;
1962 DROP TABLE t1;
1963 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1964 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1965 DELIMITER //;
1966 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL DETERMINISTIC READS SQL DATA SQL SECURITY DEFINER COMMENT 'comment'
1967 BEGIN
1968 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1969 END//
1970 DELIMITER ;//
1971 CALL sp1(@a,1);
1972 DROP PROCEDURE sp1;
1973 DROP TABLE t1;
1974 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1975 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1976 DELIMITER //;
1977 CREATE PROCEDURE sp1 (OUT p1 BIGINT, IN p2 BIGINT) LANGUAGE SQL DETERMINISTIC MODIFIES SQL DATA SQL SECURITY DEFINER COMMENT 'comment'
1978 BEGIN
1979 SELECT COUNT(*) INTO p1 FROM t1 WHERE c1 = p2;
1980 END//
1981 DELIMITER ;//
1982 CALL sp1(@a,1);
1983 DROP PROCEDURE sp1;
1984 DROP TABLE t1;
1985