Debian Codegraph @

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

raw
1 --disable_warnings
2 DROP TABLE IF EXISTS t1,t2;
3 DROP FUNCTION IF EXISTS sf1;
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 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
8 DELIMITER //;
9 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT
10 BEGIN
11 DECLARE ret INT DEFAULT 0;
12 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
13 RETURN ret;
14 END//
15 DELIMITER ;//
16 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
17 SELECT * FROM t2 ORDER BY c1;
18 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
19 SELECT * FROM t2 ORDER BY c1;
20 DELETE FROM t2 WHERE c1 = sf1(1);
21 SELECT * FROM t2 ORDER BY c1;
22 DROP FUNCTION sf1;
23 DROP TABLE t1,t2;
24 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
25 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
26 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
27 DELIMITER //;
28 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT CONTAINS SQL
29 BEGIN
30 DECLARE ret INT DEFAULT 0;
31 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
32 RETURN ret;
33 END//
34 DELIMITER ;//
35 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
36 SELECT * FROM t2 ORDER BY c1;
37 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
38 SELECT * FROM t2 ORDER BY c1;
39 DELETE FROM t2 WHERE c1 = sf1(1);
40 SELECT * FROM t2 ORDER BY c1;
41 DROP FUNCTION sf1;
42 DROP TABLE t1,t2;
43 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
44 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
45 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
46 DELIMITER //;
47 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT NO SQL
48 BEGIN
49 DECLARE ret INT DEFAULT 0;
50 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
51 RETURN ret;
52 END//
53 DELIMITER ;//
54 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
55 SELECT * FROM t2 ORDER BY c1;
56 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
57 SELECT * FROM t2 ORDER BY c1;
58 DELETE FROM t2 WHERE c1 = sf1(1);
59 SELECT * FROM t2 ORDER BY c1;
60 DROP FUNCTION sf1;
61 DROP TABLE t1,t2;
62 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
63 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
64 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
65 DELIMITER //;
66 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT READS SQL DATA
67 BEGIN
68 DECLARE ret INT DEFAULT 0;
69 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
70 RETURN ret;
71 END//
72 DELIMITER ;//
73 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
74 SELECT * FROM t2 ORDER BY c1;
75 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
76 SELECT * FROM t2 ORDER BY c1;
77 DELETE FROM t2 WHERE c1 = sf1(1);
78 SELECT * FROM t2 ORDER BY c1;
79 DROP FUNCTION sf1;
80 DROP TABLE t1,t2;
81 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
82 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
83 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
84 DELIMITER //;
85 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT MODIFIES SQL DATA
86 BEGIN
87 DECLARE ret INT DEFAULT 0;
88 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
89 RETURN ret;
90 END//
91 DELIMITER ;//
92 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
93 SELECT * FROM t2 ORDER BY c1;
94 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
95 SELECT * FROM t2 ORDER BY c1;
96 DELETE FROM t2 WHERE c1 = sf1(1);
97 SELECT * FROM t2 ORDER BY c1;
98 DROP FUNCTION sf1;
99 DROP TABLE t1,t2;
100 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
101 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
102 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
103 DELIMITER //;
104 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT COMMENT 'comment'
105 BEGIN
106 DECLARE ret INT DEFAULT 0;
107 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
108 RETURN ret;
109 END//
110 DELIMITER ;//
111 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
112 SELECT * FROM t2 ORDER BY c1;
113 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
114 SELECT * FROM t2 ORDER BY c1;
115 DELETE FROM t2 WHERE c1 = sf1(1);
116 SELECT * FROM t2 ORDER BY c1;
117 DROP FUNCTION sf1;
118 DROP TABLE t1,t2;
119 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
120 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
121 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
122 DELIMITER //;
123 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT CONTAINS SQL COMMENT 'comment'
124 BEGIN
125 DECLARE ret INT DEFAULT 0;
126 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
127 RETURN ret;
128 END//
129 DELIMITER ;//
130 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
131 SELECT * FROM t2 ORDER BY c1;
132 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
133 SELECT * FROM t2 ORDER BY c1;
134 DELETE FROM t2 WHERE c1 = sf1(1);
135 SELECT * FROM t2 ORDER BY c1;
136 DROP FUNCTION sf1;
137 DROP TABLE t1,t2;
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 TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
141 DELIMITER //;
142 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT NO SQL COMMENT 'comment'
143 BEGIN
144 DECLARE ret INT DEFAULT 0;
145 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
146 RETURN ret;
147 END//
148 DELIMITER ;//
149 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
150 SELECT * FROM t2 ORDER BY c1;
151 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
152 SELECT * FROM t2 ORDER BY c1;
153 DELETE FROM t2 WHERE c1 = sf1(1);
154 SELECT * FROM t2 ORDER BY c1;
155 DROP FUNCTION sf1;
156 DROP TABLE t1,t2;
157 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
158 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
159 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
160 DELIMITER //;
161 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT READS SQL DATA COMMENT 'comment'
162 BEGIN
163 DECLARE ret INT DEFAULT 0;
164 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
165 RETURN ret;
166 END//
167 DELIMITER ;//
168 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
169 SELECT * FROM t2 ORDER BY c1;
170 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
171 SELECT * FROM t2 ORDER BY c1;
172 DELETE FROM t2 WHERE c1 = sf1(1);
173 SELECT * FROM t2 ORDER BY c1;
174 DROP FUNCTION sf1;
175 DROP TABLE t1,t2;
176 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
177 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
178 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
179 DELIMITER //;
180 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT MODIFIES SQL DATA COMMENT 'comment'
181 BEGIN
182 DECLARE ret INT DEFAULT 0;
183 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
184 RETURN ret;
185 END//
186 DELIMITER ;//
187 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
188 SELECT * FROM t2 ORDER BY c1;
189 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
190 SELECT * FROM t2 ORDER BY c1;
191 DELETE FROM t2 WHERE c1 = sf1(1);
192 SELECT * FROM t2 ORDER BY c1;
193 DROP FUNCTION sf1;
194 DROP TABLE t1,t2;
195 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
196 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
197 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
198 DELIMITER //;
199 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL
200 BEGIN
201 DECLARE ret INT DEFAULT 0;
202 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
203 RETURN ret;
204 END//
205 DELIMITER ;//
206 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
207 SELECT * FROM t2 ORDER BY c1;
208 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
209 SELECT * FROM t2 ORDER BY c1;
210 DELETE FROM t2 WHERE c1 = sf1(1);
211 SELECT * FROM t2 ORDER BY c1;
212 DROP FUNCTION sf1;
213 DROP TABLE t1,t2;
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 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
217 DELIMITER //;
218 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL CONTAINS SQL
219 BEGIN
220 DECLARE ret INT DEFAULT 0;
221 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
222 RETURN ret;
223 END//
224 DELIMITER ;//
225 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
226 SELECT * FROM t2 ORDER BY c1;
227 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
228 SELECT * FROM t2 ORDER BY c1;
229 DELETE FROM t2 WHERE c1 = sf1(1);
230 SELECT * FROM t2 ORDER BY c1;
231 DROP FUNCTION sf1;
232 DROP TABLE t1,t2;
233 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
234 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
235 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
236 DELIMITER //;
237 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL NO SQL
238 BEGIN
239 DECLARE ret INT DEFAULT 0;
240 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
241 RETURN ret;
242 END//
243 DELIMITER ;//
244 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
245 SELECT * FROM t2 ORDER BY c1;
246 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
247 SELECT * FROM t2 ORDER BY c1;
248 DELETE FROM t2 WHERE c1 = sf1(1);
249 SELECT * FROM t2 ORDER BY c1;
250 DROP FUNCTION sf1;
251 DROP TABLE t1,t2;
252 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
253 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
254 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
255 DELIMITER //;
256 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL READS SQL DATA
257 BEGIN
258 DECLARE ret INT DEFAULT 0;
259 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
260 RETURN ret;
261 END//
262 DELIMITER ;//
263 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
264 SELECT * FROM t2 ORDER BY c1;
265 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
266 SELECT * FROM t2 ORDER BY c1;
267 DELETE FROM t2 WHERE c1 = sf1(1);
268 SELECT * FROM t2 ORDER BY c1;
269 DROP FUNCTION sf1;
270 DROP TABLE t1,t2;
271 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
272 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
273 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
274 DELIMITER //;
275 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL MODIFIES SQL DATA
276 BEGIN
277 DECLARE ret INT DEFAULT 0;
278 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
279 RETURN ret;
280 END//
281 DELIMITER ;//
282 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
283 SELECT * FROM t2 ORDER BY c1;
284 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
285 SELECT * FROM t2 ORDER BY c1;
286 DELETE FROM t2 WHERE c1 = sf1(1);
287 SELECT * FROM t2 ORDER BY c1;
288 DROP FUNCTION sf1;
289 DROP TABLE t1,t2;
290 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
291 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
292 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
293 DELIMITER //;
294 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL COMMENT 'comment'
295 BEGIN
296 DECLARE ret INT DEFAULT 0;
297 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
298 RETURN ret;
299 END//
300 DELIMITER ;//
301 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
302 SELECT * FROM t2 ORDER BY c1;
303 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
304 SELECT * FROM t2 ORDER BY c1;
305 DELETE FROM t2 WHERE c1 = sf1(1);
306 SELECT * FROM t2 ORDER BY c1;
307 DROP FUNCTION sf1;
308 DROP TABLE t1,t2;
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 TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
312 DELIMITER //;
313 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL CONTAINS SQL COMMENT 'comment'
314 BEGIN
315 DECLARE ret INT DEFAULT 0;
316 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
317 RETURN ret;
318 END//
319 DELIMITER ;//
320 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
321 SELECT * FROM t2 ORDER BY c1;
322 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
323 SELECT * FROM t2 ORDER BY c1;
324 DELETE FROM t2 WHERE c1 = sf1(1);
325 SELECT * FROM t2 ORDER BY c1;
326 DROP FUNCTION sf1;
327 DROP TABLE t1,t2;
328 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
329 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
330 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
331 DELIMITER //;
332 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL NO SQL COMMENT 'comment'
333 BEGIN
334 DECLARE ret INT DEFAULT 0;
335 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
336 RETURN ret;
337 END//
338 DELIMITER ;//
339 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
340 SELECT * FROM t2 ORDER BY c1;
341 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
342 SELECT * FROM t2 ORDER BY c1;
343 DELETE FROM t2 WHERE c1 = sf1(1);
344 SELECT * FROM t2 ORDER BY c1;
345 DROP FUNCTION sf1;
346 DROP TABLE t1,t2;
347 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
348 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
349 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
350 DELIMITER //;
351 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL READS SQL DATA COMMENT 'comment'
352 BEGIN
353 DECLARE ret INT DEFAULT 0;
354 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
355 RETURN ret;
356 END//
357 DELIMITER ;//
358 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
359 SELECT * FROM t2 ORDER BY c1;
360 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
361 SELECT * FROM t2 ORDER BY c1;
362 DELETE FROM t2 WHERE c1 = sf1(1);
363 SELECT * FROM t2 ORDER BY c1;
364 DROP FUNCTION sf1;
365 DROP TABLE t1,t2;
366 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
367 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
368 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
369 DELIMITER //;
370 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL MODIFIES SQL DATA COMMENT 'comment'
371 BEGIN
372 DECLARE ret INT DEFAULT 0;
373 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
374 RETURN ret;
375 END//
376 DELIMITER ;//
377 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
378 SELECT * FROM t2 ORDER BY c1;
379 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
380 SELECT * FROM t2 ORDER BY c1;
381 DELETE FROM t2 WHERE c1 = sf1(1);
382 SELECT * FROM t2 ORDER BY c1;
383 DROP FUNCTION sf1;
384 DROP TABLE t1,t2;
385 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
386 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
387 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
388 DELIMITER //;
389 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT NOT DETERMINISTIC
390 BEGIN
391 DECLARE ret INT DEFAULT 0;
392 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
393 RETURN ret;
394 END//
395 DELIMITER ;//
396 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
397 SELECT * FROM t2 ORDER BY c1;
398 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
399 SELECT * FROM t2 ORDER BY c1;
400 DELETE FROM t2 WHERE c1 = sf1(1);
401 SELECT * FROM t2 ORDER BY c1;
402 DROP FUNCTION sf1;
403 DROP TABLE t1,t2;
404 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
405 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
406 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
407 DELIMITER //;
408 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT NOT DETERMINISTIC CONTAINS SQL
409 BEGIN
410 DECLARE ret INT DEFAULT 0;
411 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
412 RETURN ret;
413 END//
414 DELIMITER ;//
415 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
416 SELECT * FROM t2 ORDER BY c1;
417 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
418 SELECT * FROM t2 ORDER BY c1;
419 DELETE FROM t2 WHERE c1 = sf1(1);
420 SELECT * FROM t2 ORDER BY c1;
421 DROP FUNCTION sf1;
422 DROP TABLE t1,t2;
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 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
426 DELIMITER //;
427 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT NOT DETERMINISTIC NO SQL
428 BEGIN
429 DECLARE ret INT DEFAULT 0;
430 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
431 RETURN ret;
432 END//
433 DELIMITER ;//
434 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
435 SELECT * FROM t2 ORDER BY c1;
436 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
437 SELECT * FROM t2 ORDER BY c1;
438 DELETE FROM t2 WHERE c1 = sf1(1);
439 SELECT * FROM t2 ORDER BY c1;
440 DROP FUNCTION sf1;
441 DROP TABLE t1,t2;
442 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
443 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
444 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
445 DELIMITER //;
446 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT NOT DETERMINISTIC READS SQL DATA
447 BEGIN
448 DECLARE ret INT DEFAULT 0;
449 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
450 RETURN ret;
451 END//
452 DELIMITER ;//
453 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
454 SELECT * FROM t2 ORDER BY c1;
455 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
456 SELECT * FROM t2 ORDER BY c1;
457 DELETE FROM t2 WHERE c1 = sf1(1);
458 SELECT * FROM t2 ORDER BY c1;
459 DROP FUNCTION sf1;
460 DROP TABLE t1,t2;
461 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
462 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
463 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
464 DELIMITER //;
465 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT NOT DETERMINISTIC MODIFIES SQL DATA
466 BEGIN
467 DECLARE ret INT DEFAULT 0;
468 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
469 RETURN ret;
470 END//
471 DELIMITER ;//
472 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
473 SELECT * FROM t2 ORDER BY c1;
474 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
475 SELECT * FROM t2 ORDER BY c1;
476 DELETE FROM t2 WHERE c1 = sf1(1);
477 SELECT * FROM t2 ORDER BY c1;
478 DROP FUNCTION sf1;
479 DROP TABLE t1,t2;
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 TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
483 DELIMITER //;
484 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT NOT DETERMINISTIC COMMENT 'comment'
485 BEGIN
486 DECLARE ret INT DEFAULT 0;
487 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
488 RETURN ret;
489 END//
490 DELIMITER ;//
491 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
492 SELECT * FROM t2 ORDER BY c1;
493 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
494 SELECT * FROM t2 ORDER BY c1;
495 DELETE FROM t2 WHERE c1 = sf1(1);
496 SELECT * FROM t2 ORDER BY c1;
497 DROP FUNCTION sf1;
498 DROP TABLE t1,t2;
499 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
500 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
501 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
502 DELIMITER //;
503 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT NOT DETERMINISTIC CONTAINS SQL COMMENT 'comment'
504 BEGIN
505 DECLARE ret INT DEFAULT 0;
506 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
507 RETURN ret;
508 END//
509 DELIMITER ;//
510 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
511 SELECT * FROM t2 ORDER BY c1;
512 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
513 SELECT * FROM t2 ORDER BY c1;
514 DELETE FROM t2 WHERE c1 = sf1(1);
515 SELECT * FROM t2 ORDER BY c1;
516 DROP FUNCTION sf1;
517 DROP TABLE t1,t2;
518 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
519 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
520 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
521 DELIMITER //;
522 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT NOT DETERMINISTIC NO SQL COMMENT 'comment'
523 BEGIN
524 DECLARE ret INT DEFAULT 0;
525 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
526 RETURN ret;
527 END//
528 DELIMITER ;//
529 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
530 SELECT * FROM t2 ORDER BY c1;
531 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
532 SELECT * FROM t2 ORDER BY c1;
533 DELETE FROM t2 WHERE c1 = sf1(1);
534 SELECT * FROM t2 ORDER BY c1;
535 DROP FUNCTION sf1;
536 DROP TABLE t1,t2;
537 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
538 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
539 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
540 DELIMITER //;
541 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT NOT DETERMINISTIC READS SQL DATA COMMENT 'comment'
542 BEGIN
543 DECLARE ret INT DEFAULT 0;
544 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
545 RETURN ret;
546 END//
547 DELIMITER ;//
548 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
549 SELECT * FROM t2 ORDER BY c1;
550 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
551 SELECT * FROM t2 ORDER BY c1;
552 DELETE FROM t2 WHERE c1 = sf1(1);
553 SELECT * FROM t2 ORDER BY c1;
554 DROP FUNCTION sf1;
555 DROP TABLE t1,t2;
556 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
557 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
558 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
559 DELIMITER //;
560 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT NOT DETERMINISTIC MODIFIES SQL DATA COMMENT 'comment'
561 BEGIN
562 DECLARE ret INT DEFAULT 0;
563 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
564 RETURN ret;
565 END//
566 DELIMITER ;//
567 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
568 SELECT * FROM t2 ORDER BY c1;
569 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
570 SELECT * FROM t2 ORDER BY c1;
571 DELETE FROM t2 WHERE c1 = sf1(1);
572 SELECT * FROM t2 ORDER BY c1;
573 DROP FUNCTION sf1;
574 DROP TABLE t1,t2;
575 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
576 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
577 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
578 DELIMITER //;
579 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL NOT DETERMINISTIC
580 BEGIN
581 DECLARE ret INT DEFAULT 0;
582 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
583 RETURN ret;
584 END//
585 DELIMITER ;//
586 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
587 SELECT * FROM t2 ORDER BY c1;
588 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
589 SELECT * FROM t2 ORDER BY c1;
590 DELETE FROM t2 WHERE c1 = sf1(1);
591 SELECT * FROM t2 ORDER BY c1;
592 DROP FUNCTION sf1;
593 DROP TABLE t1,t2;
594 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
595 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
596 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
597 DELIMITER //;
598 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL NOT DETERMINISTIC CONTAINS SQL
599 BEGIN
600 DECLARE ret INT DEFAULT 0;
601 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
602 RETURN ret;
603 END//
604 DELIMITER ;//
605 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
606 SELECT * FROM t2 ORDER BY c1;
607 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
608 SELECT * FROM t2 ORDER BY c1;
609 DELETE FROM t2 WHERE c1 = sf1(1);
610 SELECT * FROM t2 ORDER BY c1;
611 DROP FUNCTION sf1;
612 DROP TABLE t1,t2;
613 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
614 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
615 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
616 DELIMITER //;
617 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL NOT DETERMINISTIC NO SQL
618 BEGIN
619 DECLARE ret INT DEFAULT 0;
620 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
621 RETURN ret;
622 END//
623 DELIMITER ;//
624 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
625 SELECT * FROM t2 ORDER BY c1;
626 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
627 SELECT * FROM t2 ORDER BY c1;
628 DELETE FROM t2 WHERE c1 = sf1(1);
629 SELECT * FROM t2 ORDER BY c1;
630 DROP FUNCTION sf1;
631 DROP TABLE t1,t2;
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 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
635 DELIMITER //;
636 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL NOT DETERMINISTIC READS SQL DATA
637 BEGIN
638 DECLARE ret INT DEFAULT 0;
639 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
640 RETURN ret;
641 END//
642 DELIMITER ;//
643 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
644 SELECT * FROM t2 ORDER BY c1;
645 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
646 SELECT * FROM t2 ORDER BY c1;
647 DELETE FROM t2 WHERE c1 = sf1(1);
648 SELECT * FROM t2 ORDER BY c1;
649 DROP FUNCTION sf1;
650 DROP TABLE t1,t2;
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 TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
654 DELIMITER //;
655 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL NOT DETERMINISTIC MODIFIES SQL DATA
656 BEGIN
657 DECLARE ret INT DEFAULT 0;
658 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
659 RETURN ret;
660 END//
661 DELIMITER ;//
662 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
663 SELECT * FROM t2 ORDER BY c1;
664 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
665 SELECT * FROM t2 ORDER BY c1;
666 DELETE FROM t2 WHERE c1 = sf1(1);
667 SELECT * FROM t2 ORDER BY c1;
668 DROP FUNCTION sf1;
669 DROP TABLE t1,t2;
670 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
671 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
672 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
673 DELIMITER //;
674 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL NOT DETERMINISTIC COMMENT 'comment'
675 BEGIN
676 DECLARE ret INT DEFAULT 0;
677 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
678 RETURN ret;
679 END//
680 DELIMITER ;//
681 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
682 SELECT * FROM t2 ORDER BY c1;
683 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
684 SELECT * FROM t2 ORDER BY c1;
685 DELETE FROM t2 WHERE c1 = sf1(1);
686 SELECT * FROM t2 ORDER BY c1;
687 DROP FUNCTION sf1;
688 DROP TABLE t1,t2;
689 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
690 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
691 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
692 DELIMITER //;
693 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL NOT DETERMINISTIC CONTAINS SQL COMMENT 'comment'
694 BEGIN
695 DECLARE ret INT DEFAULT 0;
696 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
697 RETURN ret;
698 END//
699 DELIMITER ;//
700 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
701 SELECT * FROM t2 ORDER BY c1;
702 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
703 SELECT * FROM t2 ORDER BY c1;
704 DELETE FROM t2 WHERE c1 = sf1(1);
705 SELECT * FROM t2 ORDER BY c1;
706 DROP FUNCTION sf1;
707 DROP TABLE t1,t2;
708 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
709 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
710 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
711 DELIMITER //;
712 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL NOT DETERMINISTIC NO SQL COMMENT 'comment'
713 BEGIN
714 DECLARE ret INT DEFAULT 0;
715 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
716 RETURN ret;
717 END//
718 DELIMITER ;//
719 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
720 SELECT * FROM t2 ORDER BY c1;
721 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
722 SELECT * FROM t2 ORDER BY c1;
723 DELETE FROM t2 WHERE c1 = sf1(1);
724 SELECT * FROM t2 ORDER BY c1;
725 DROP FUNCTION sf1;
726 DROP TABLE t1,t2;
727 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
728 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
729 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
730 DELIMITER //;
731 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL NOT DETERMINISTIC READS SQL DATA COMMENT 'comment'
732 BEGIN
733 DECLARE ret INT DEFAULT 0;
734 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
735 RETURN ret;
736 END//
737 DELIMITER ;//
738 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
739 SELECT * FROM t2 ORDER BY c1;
740 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
741 SELECT * FROM t2 ORDER BY c1;
742 DELETE FROM t2 WHERE c1 = sf1(1);
743 SELECT * FROM t2 ORDER BY c1;
744 DROP FUNCTION sf1;
745 DROP TABLE t1,t2;
746 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
747 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
748 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
749 DELIMITER //;
750 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL NOT DETERMINISTIC MODIFIES SQL DATA COMMENT 'comment'
751 BEGIN
752 DECLARE ret INT DEFAULT 0;
753 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
754 RETURN ret;
755 END//
756 DELIMITER ;//
757 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
758 SELECT * FROM t2 ORDER BY c1;
759 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
760 SELECT * FROM t2 ORDER BY c1;
761 DELETE FROM t2 WHERE c1 = sf1(1);
762 SELECT * FROM t2 ORDER BY c1;
763 DROP FUNCTION sf1;
764 DROP TABLE t1,t2;
765 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
766 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
767 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
768 DELIMITER //;
769 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT DETERMINISTIC
770 BEGIN
771 DECLARE ret INT DEFAULT 0;
772 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
773 RETURN ret;
774 END//
775 DELIMITER ;//
776 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
777 SELECT * FROM t2 ORDER BY c1;
778 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
779 SELECT * FROM t2 ORDER BY c1;
780 DELETE FROM t2 WHERE c1 = sf1(1);
781 SELECT * FROM t2 ORDER BY c1;
782 DROP FUNCTION sf1;
783 DROP TABLE t1,t2;
784 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
785 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
786 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
787 DELIMITER //;
788 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT DETERMINISTIC CONTAINS SQL
789 BEGIN
790 DECLARE ret INT DEFAULT 0;
791 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
792 RETURN ret;
793 END//
794 DELIMITER ;//
795 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
796 SELECT * FROM t2 ORDER BY c1;
797 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
798 SELECT * FROM t2 ORDER BY c1;
799 DELETE FROM t2 WHERE c1 = sf1(1);
800 SELECT * FROM t2 ORDER BY c1;
801 DROP FUNCTION sf1;
802 DROP TABLE t1,t2;
803 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
804 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
805 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
806 DELIMITER //;
807 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT DETERMINISTIC NO SQL
808 BEGIN
809 DECLARE ret INT DEFAULT 0;
810 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
811 RETURN ret;
812 END//
813 DELIMITER ;//
814 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
815 SELECT * FROM t2 ORDER BY c1;
816 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
817 SELECT * FROM t2 ORDER BY c1;
818 DELETE FROM t2 WHERE c1 = sf1(1);
819 SELECT * FROM t2 ORDER BY c1;
820 DROP FUNCTION sf1;
821 DROP TABLE t1,t2;
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 TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
825 DELIMITER //;
826 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT DETERMINISTIC READS SQL DATA
827 BEGIN
828 DECLARE ret INT DEFAULT 0;
829 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
830 RETURN ret;
831 END//
832 DELIMITER ;//
833 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
834 SELECT * FROM t2 ORDER BY c1;
835 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
836 SELECT * FROM t2 ORDER BY c1;
837 DELETE FROM t2 WHERE c1 = sf1(1);
838 SELECT * FROM t2 ORDER BY c1;
839 DROP FUNCTION sf1;
840 DROP TABLE t1,t2;
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 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
844 DELIMITER //;
845 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT DETERMINISTIC MODIFIES SQL DATA
846 BEGIN
847 DECLARE ret INT DEFAULT 0;
848 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
849 RETURN ret;
850 END//
851 DELIMITER ;//
852 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
853 SELECT * FROM t2 ORDER BY c1;
854 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
855 SELECT * FROM t2 ORDER BY c1;
856 DELETE FROM t2 WHERE c1 = sf1(1);
857 SELECT * FROM t2 ORDER BY c1;
858 DROP FUNCTION sf1;
859 DROP TABLE t1,t2;
860 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
861 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
862 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
863 DELIMITER //;
864 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT DETERMINISTIC COMMENT 'comment'
865 BEGIN
866 DECLARE ret INT DEFAULT 0;
867 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
868 RETURN ret;
869 END//
870 DELIMITER ;//
871 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
872 SELECT * FROM t2 ORDER BY c1;
873 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
874 SELECT * FROM t2 ORDER BY c1;
875 DELETE FROM t2 WHERE c1 = sf1(1);
876 SELECT * FROM t2 ORDER BY c1;
877 DROP FUNCTION sf1;
878 DROP TABLE t1,t2;
879 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
880 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
881 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
882 DELIMITER //;
883 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT DETERMINISTIC CONTAINS SQL COMMENT 'comment'
884 BEGIN
885 DECLARE ret INT DEFAULT 0;
886 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
887 RETURN ret;
888 END//
889 DELIMITER ;//
890 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
891 SELECT * FROM t2 ORDER BY c1;
892 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
893 SELECT * FROM t2 ORDER BY c1;
894 DELETE FROM t2 WHERE c1 = sf1(1);
895 SELECT * FROM t2 ORDER BY c1;
896 DROP FUNCTION sf1;
897 DROP TABLE t1,t2;
898 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
899 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
900 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
901 DELIMITER //;
902 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT DETERMINISTIC NO SQL COMMENT 'comment'
903 BEGIN
904 DECLARE ret INT DEFAULT 0;
905 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
906 RETURN ret;
907 END//
908 DELIMITER ;//
909 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
910 SELECT * FROM t2 ORDER BY c1;
911 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
912 SELECT * FROM t2 ORDER BY c1;
913 DELETE FROM t2 WHERE c1 = sf1(1);
914 SELECT * FROM t2 ORDER BY c1;
915 DROP FUNCTION sf1;
916 DROP TABLE t1,t2;
917 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
918 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
919 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
920 DELIMITER //;
921 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT DETERMINISTIC READS SQL DATA COMMENT 'comment'
922 BEGIN
923 DECLARE ret INT DEFAULT 0;
924 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
925 RETURN ret;
926 END//
927 DELIMITER ;//
928 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
929 SELECT * FROM t2 ORDER BY c1;
930 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
931 SELECT * FROM t2 ORDER BY c1;
932 DELETE FROM t2 WHERE c1 = sf1(1);
933 SELECT * FROM t2 ORDER BY c1;
934 DROP FUNCTION sf1;
935 DROP TABLE t1,t2;
936 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
937 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
938 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
939 DELIMITER //;
940 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT DETERMINISTIC MODIFIES SQL DATA COMMENT 'comment'
941 BEGIN
942 DECLARE ret INT DEFAULT 0;
943 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
944 RETURN ret;
945 END//
946 DELIMITER ;//
947 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
948 SELECT * FROM t2 ORDER BY c1;
949 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
950 SELECT * FROM t2 ORDER BY c1;
951 DELETE FROM t2 WHERE c1 = sf1(1);
952 SELECT * FROM t2 ORDER BY c1;
953 DROP FUNCTION sf1;
954 DROP TABLE t1,t2;
955 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
956 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
957 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
958 DELIMITER //;
959 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL DETERMINISTIC
960 BEGIN
961 DECLARE ret INT DEFAULT 0;
962 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
963 RETURN ret;
964 END//
965 DELIMITER ;//
966 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
967 SELECT * FROM t2 ORDER BY c1;
968 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
969 SELECT * FROM t2 ORDER BY c1;
970 DELETE FROM t2 WHERE c1 = sf1(1);
971 SELECT * FROM t2 ORDER BY c1;
972 DROP FUNCTION sf1;
973 DROP TABLE t1,t2;
974 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
975 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
976 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
977 DELIMITER //;
978 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL DETERMINISTIC CONTAINS SQL
979 BEGIN
980 DECLARE ret INT DEFAULT 0;
981 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
982 RETURN ret;
983 END//
984 DELIMITER ;//
985 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
986 SELECT * FROM t2 ORDER BY c1;
987 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
988 SELECT * FROM t2 ORDER BY c1;
989 DELETE FROM t2 WHERE c1 = sf1(1);
990 SELECT * FROM t2 ORDER BY c1;
991 DROP FUNCTION sf1;
992 DROP TABLE t1,t2;
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 TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
996 DELIMITER //;
997 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL DETERMINISTIC NO SQL
998 BEGIN
999 DECLARE ret INT DEFAULT 0;
1000 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
1001 RETURN ret;
1002 END//
1003 DELIMITER ;//
1004 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
1005 SELECT * FROM t2 ORDER BY c1;
1006 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
1007 SELECT * FROM t2 ORDER BY c1;
1008 DELETE FROM t2 WHERE c1 = sf1(1);
1009 SELECT * FROM t2 ORDER BY c1;
1010 DROP FUNCTION sf1;
1011 DROP TABLE t1,t2;
1012 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1013 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1014 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1015 DELIMITER //;
1016 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL DETERMINISTIC READS SQL DATA
1017 BEGIN
1018 DECLARE ret INT DEFAULT 0;
1019 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
1020 RETURN ret;
1021 END//
1022 DELIMITER ;//
1023 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
1024 SELECT * FROM t2 ORDER BY c1;
1025 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
1026 SELECT * FROM t2 ORDER BY c1;
1027 DELETE FROM t2 WHERE c1 = sf1(1);
1028 SELECT * FROM t2 ORDER BY c1;
1029 DROP FUNCTION sf1;
1030 DROP TABLE t1,t2;
1031 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1032 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1033 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1034 DELIMITER //;
1035 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL DETERMINISTIC MODIFIES SQL DATA
1036 BEGIN
1037 DECLARE ret INT DEFAULT 0;
1038 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
1039 RETURN ret;
1040 END//
1041 DELIMITER ;//
1042 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
1043 SELECT * FROM t2 ORDER BY c1;
1044 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
1045 SELECT * FROM t2 ORDER BY c1;
1046 DELETE FROM t2 WHERE c1 = sf1(1);
1047 SELECT * FROM t2 ORDER BY c1;
1048 DROP FUNCTION sf1;
1049 DROP TABLE t1,t2;
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 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1053 DELIMITER //;
1054 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL DETERMINISTIC COMMENT 'comment'
1055 BEGIN
1056 DECLARE ret INT DEFAULT 0;
1057 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
1058 RETURN ret;
1059 END//
1060 DELIMITER ;//
1061 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
1062 SELECT * FROM t2 ORDER BY c1;
1063 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
1064 SELECT * FROM t2 ORDER BY c1;
1065 DELETE FROM t2 WHERE c1 = sf1(1);
1066 SELECT * FROM t2 ORDER BY c1;
1067 DROP FUNCTION sf1;
1068 DROP TABLE t1,t2;
1069 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1070 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1071 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1072 DELIMITER //;
1073 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL DETERMINISTIC CONTAINS SQL COMMENT 'comment'
1074 BEGIN
1075 DECLARE ret INT DEFAULT 0;
1076 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
1077 RETURN ret;
1078 END//
1079 DELIMITER ;//
1080 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
1081 SELECT * FROM t2 ORDER BY c1;
1082 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
1083 SELECT * FROM t2 ORDER BY c1;
1084 DELETE FROM t2 WHERE c1 = sf1(1);
1085 SELECT * FROM t2 ORDER BY c1;
1086 DROP FUNCTION sf1;
1087 DROP TABLE t1,t2;
1088 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1089 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1090 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1091 DELIMITER //;
1092 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL DETERMINISTIC NO SQL COMMENT 'comment'
1093 BEGIN
1094 DECLARE ret INT DEFAULT 0;
1095 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
1096 RETURN ret;
1097 END//
1098 DELIMITER ;//
1099 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
1100 SELECT * FROM t2 ORDER BY c1;
1101 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
1102 SELECT * FROM t2 ORDER BY c1;
1103 DELETE FROM t2 WHERE c1 = sf1(1);
1104 SELECT * FROM t2 ORDER BY c1;
1105 DROP FUNCTION sf1;
1106 DROP TABLE t1,t2;
1107 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1108 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1109 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1110 DELIMITER //;
1111 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL DETERMINISTIC READS SQL DATA COMMENT 'comment'
1112 BEGIN
1113 DECLARE ret INT DEFAULT 0;
1114 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
1115 RETURN ret;
1116 END//
1117 DELIMITER ;//
1118 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
1119 SELECT * FROM t2 ORDER BY c1;
1120 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
1121 SELECT * FROM t2 ORDER BY c1;
1122 DELETE FROM t2 WHERE c1 = sf1(1);
1123 SELECT * FROM t2 ORDER BY c1;
1124 DROP FUNCTION sf1;
1125 DROP TABLE t1,t2;
1126 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1127 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1128 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1129 DELIMITER //;
1130 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL DETERMINISTIC MODIFIES SQL DATA COMMENT 'comment'
1131 BEGIN
1132 DECLARE ret INT DEFAULT 0;
1133 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
1134 RETURN ret;
1135 END//
1136 DELIMITER ;//
1137 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
1138 SELECT * FROM t2 ORDER BY c1;
1139 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
1140 SELECT * FROM t2 ORDER BY c1;
1141 DELETE FROM t2 WHERE c1 = sf1(1);
1142 SELECT * FROM t2 ORDER BY c1;
1143 DROP FUNCTION sf1;
1144 DROP TABLE t1,t2;
1145 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1146 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1147 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1148 DELIMITER //;
1149 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT SQL SECURITY INVOKER
1150 BEGIN
1151 DECLARE ret INT DEFAULT 0;
1152 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
1153 RETURN ret;
1154 END//
1155 DELIMITER ;//
1156 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
1157 SELECT * FROM t2 ORDER BY c1;
1158 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
1159 SELECT * FROM t2 ORDER BY c1;
1160 DELETE FROM t2 WHERE c1 = sf1(1);
1161 SELECT * FROM t2 ORDER BY c1;
1162 DROP FUNCTION sf1;
1163 DROP TABLE t1,t2;
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 TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1167 DELIMITER //;
1168 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT CONTAINS SQL SQL SECURITY INVOKER
1169 BEGIN
1170 DECLARE ret INT DEFAULT 0;
1171 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
1172 RETURN ret;
1173 END//
1174 DELIMITER ;//
1175 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
1176 SELECT * FROM t2 ORDER BY c1;
1177 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
1178 SELECT * FROM t2 ORDER BY c1;
1179 DELETE FROM t2 WHERE c1 = sf1(1);
1180 SELECT * FROM t2 ORDER BY c1;
1181 DROP FUNCTION sf1;
1182 DROP TABLE t1,t2;
1183 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1184 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1185 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1186 DELIMITER //;
1187 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT NO SQL SQL SECURITY INVOKER
1188 BEGIN
1189 DECLARE ret INT DEFAULT 0;
1190 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
1191 RETURN ret;
1192 END//
1193 DELIMITER ;//
1194 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
1195 SELECT * FROM t2 ORDER BY c1;
1196 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
1197 SELECT * FROM t2 ORDER BY c1;
1198 DELETE FROM t2 WHERE c1 = sf1(1);
1199 SELECT * FROM t2 ORDER BY c1;
1200 DROP FUNCTION sf1;
1201 DROP TABLE t1,t2;
1202 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1203 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1204 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1205 DELIMITER //;
1206 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT READS SQL DATA SQL SECURITY INVOKER
1207 BEGIN
1208 DECLARE ret INT DEFAULT 0;
1209 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
1210 RETURN ret;
1211 END//
1212 DELIMITER ;//
1213 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
1214 SELECT * FROM t2 ORDER BY c1;
1215 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
1216 SELECT * FROM t2 ORDER BY c1;
1217 DELETE FROM t2 WHERE c1 = sf1(1);
1218 SELECT * FROM t2 ORDER BY c1;
1219 DROP FUNCTION sf1;
1220 DROP TABLE t1,t2;
1221 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1222 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1223 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1224 DELIMITER //;
1225 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT MODIFIES SQL DATA SQL SECURITY INVOKER
1226 BEGIN
1227 DECLARE ret INT DEFAULT 0;
1228 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
1229 RETURN ret;
1230 END//
1231 DELIMITER ;//
1232 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
1233 SELECT * FROM t2 ORDER BY c1;
1234 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
1235 SELECT * FROM t2 ORDER BY c1;
1236 DELETE FROM t2 WHERE c1 = sf1(1);
1237 SELECT * FROM t2 ORDER BY c1;
1238 DROP FUNCTION sf1;
1239 DROP TABLE t1,t2;
1240 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1241 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1242 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1243 DELIMITER //;
1244 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT SQL SECURITY INVOKER COMMENT 'comment'
1245 BEGIN
1246 DECLARE ret INT DEFAULT 0;
1247 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
1248 RETURN ret;
1249 END//
1250 DELIMITER ;//
1251 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
1252 SELECT * FROM t2 ORDER BY c1;
1253 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
1254 SELECT * FROM t2 ORDER BY c1;
1255 DELETE FROM t2 WHERE c1 = sf1(1);
1256 SELECT * FROM t2 ORDER BY c1;
1257 DROP FUNCTION sf1;
1258 DROP TABLE t1,t2;
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 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1262 DELIMITER //;
1263 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT CONTAINS SQL SQL SECURITY INVOKER COMMENT 'comment'
1264 BEGIN
1265 DECLARE ret INT DEFAULT 0;
1266 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
1267 RETURN ret;
1268 END//
1269 DELIMITER ;//
1270 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
1271 SELECT * FROM t2 ORDER BY c1;
1272 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
1273 SELECT * FROM t2 ORDER BY c1;
1274 DELETE FROM t2 WHERE c1 = sf1(1);
1275 SELECT * FROM t2 ORDER BY c1;
1276 DROP FUNCTION sf1;
1277 DROP TABLE t1,t2;
1278 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1279 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1280 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1281 DELIMITER //;
1282 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT NO SQL SQL SECURITY INVOKER COMMENT 'comment'
1283 BEGIN
1284 DECLARE ret INT DEFAULT 0;
1285 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
1286 RETURN ret;
1287 END//
1288 DELIMITER ;//
1289 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
1290 SELECT * FROM t2 ORDER BY c1;
1291 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
1292 SELECT * FROM t2 ORDER BY c1;
1293 DELETE FROM t2 WHERE c1 = sf1(1);
1294 SELECT * FROM t2 ORDER BY c1;
1295 DROP FUNCTION sf1;
1296 DROP TABLE t1,t2;
1297 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1298 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1299 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1300 DELIMITER //;
1301 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT READS SQL DATA SQL SECURITY INVOKER COMMENT 'comment'
1302 BEGIN
1303 DECLARE ret INT DEFAULT 0;
1304 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
1305 RETURN ret;
1306 END//
1307 DELIMITER ;//
1308 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
1309 SELECT * FROM t2 ORDER BY c1;
1310 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
1311 SELECT * FROM t2 ORDER BY c1;
1312 DELETE FROM t2 WHERE c1 = sf1(1);
1313 SELECT * FROM t2 ORDER BY c1;
1314 DROP FUNCTION sf1;
1315 DROP TABLE t1,t2;
1316 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1317 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1318 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1319 DELIMITER //;
1320 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT MODIFIES SQL DATA SQL SECURITY INVOKER COMMENT 'comment'
1321 BEGIN
1322 DECLARE ret INT DEFAULT 0;
1323 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
1324 RETURN ret;
1325 END//
1326 DELIMITER ;//
1327 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
1328 SELECT * FROM t2 ORDER BY c1;
1329 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
1330 SELECT * FROM t2 ORDER BY c1;
1331 DELETE FROM t2 WHERE c1 = sf1(1);
1332 SELECT * FROM t2 ORDER BY c1;
1333 DROP FUNCTION sf1;
1334 DROP TABLE t1,t2;
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 TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1338 DELIMITER //;
1339 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL SQL SECURITY INVOKER
1340 BEGIN
1341 DECLARE ret INT DEFAULT 0;
1342 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
1343 RETURN ret;
1344 END//
1345 DELIMITER ;//
1346 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
1347 SELECT * FROM t2 ORDER BY c1;
1348 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
1349 SELECT * FROM t2 ORDER BY c1;
1350 DELETE FROM t2 WHERE c1 = sf1(1);
1351 SELECT * FROM t2 ORDER BY c1;
1352 DROP FUNCTION sf1;
1353 DROP TABLE t1,t2;
1354 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1355 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1356 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1357 DELIMITER //;
1358 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL CONTAINS SQL SQL SECURITY INVOKER
1359 BEGIN
1360 DECLARE ret INT DEFAULT 0;
1361 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
1362 RETURN ret;
1363 END//
1364 DELIMITER ;//
1365 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
1366 SELECT * FROM t2 ORDER BY c1;
1367 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
1368 SELECT * FROM t2 ORDER BY c1;
1369 DELETE FROM t2 WHERE c1 = sf1(1);
1370 SELECT * FROM t2 ORDER BY c1;
1371 DROP FUNCTION sf1;
1372 DROP TABLE t1,t2;
1373 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1374 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1375 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1376 DELIMITER //;
1377 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL NO SQL SQL SECURITY INVOKER
1378 BEGIN
1379 DECLARE ret INT DEFAULT 0;
1380 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
1381 RETURN ret;
1382 END//
1383 DELIMITER ;//
1384 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
1385 SELECT * FROM t2 ORDER BY c1;
1386 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
1387 SELECT * FROM t2 ORDER BY c1;
1388 DELETE FROM t2 WHERE c1 = sf1(1);
1389 SELECT * FROM t2 ORDER BY c1;
1390 DROP FUNCTION sf1;
1391 DROP TABLE t1,t2;
1392 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1393 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1394 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1395 DELIMITER //;
1396 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL READS SQL DATA SQL SECURITY INVOKER
1397 BEGIN
1398 DECLARE ret INT DEFAULT 0;
1399 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
1400 RETURN ret;
1401 END//
1402 DELIMITER ;//
1403 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
1404 SELECT * FROM t2 ORDER BY c1;
1405 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
1406 SELECT * FROM t2 ORDER BY c1;
1407 DELETE FROM t2 WHERE c1 = sf1(1);
1408 SELECT * FROM t2 ORDER BY c1;
1409 DROP FUNCTION sf1;
1410 DROP TABLE t1,t2;
1411 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1412 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1413 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1414 DELIMITER //;
1415 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL MODIFIES SQL DATA SQL SECURITY INVOKER
1416 BEGIN
1417 DECLARE ret INT DEFAULT 0;
1418 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
1419 RETURN ret;
1420 END//
1421 DELIMITER ;//
1422 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
1423 SELECT * FROM t2 ORDER BY c1;
1424 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
1425 SELECT * FROM t2 ORDER BY c1;
1426 DELETE FROM t2 WHERE c1 = sf1(1);
1427 SELECT * FROM t2 ORDER BY c1;
1428 DROP FUNCTION sf1;
1429 DROP TABLE t1,t2;
1430 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1431 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1432 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1433 DELIMITER //;
1434 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL SQL SECURITY INVOKER COMMENT 'comment'
1435 BEGIN
1436 DECLARE ret INT DEFAULT 0;
1437 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
1438 RETURN ret;
1439 END//
1440 DELIMITER ;//
1441 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
1442 SELECT * FROM t2 ORDER BY c1;
1443 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
1444 SELECT * FROM t2 ORDER BY c1;
1445 DELETE FROM t2 WHERE c1 = sf1(1);
1446 SELECT * FROM t2 ORDER BY c1;
1447 DROP FUNCTION sf1;
1448 DROP TABLE t1,t2;
1449 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1450 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1451 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1452 DELIMITER //;
1453 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL CONTAINS SQL SQL SECURITY INVOKER COMMENT 'comment'
1454 BEGIN
1455 DECLARE ret INT DEFAULT 0;
1456 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
1457 RETURN ret;
1458 END//
1459 DELIMITER ;//
1460 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
1461 SELECT * FROM t2 ORDER BY c1;
1462 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
1463 SELECT * FROM t2 ORDER BY c1;
1464 DELETE FROM t2 WHERE c1 = sf1(1);
1465 SELECT * FROM t2 ORDER BY c1;
1466 DROP FUNCTION sf1;
1467 DROP TABLE t1,t2;
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 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1471 DELIMITER //;
1472 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL NO SQL SQL SECURITY INVOKER COMMENT 'comment'
1473 BEGIN
1474 DECLARE ret INT DEFAULT 0;
1475 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
1476 RETURN ret;
1477 END//
1478 DELIMITER ;//
1479 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
1480 SELECT * FROM t2 ORDER BY c1;
1481 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
1482 SELECT * FROM t2 ORDER BY c1;
1483 DELETE FROM t2 WHERE c1 = sf1(1);
1484 SELECT * FROM t2 ORDER BY c1;
1485 DROP FUNCTION sf1;
1486 DROP TABLE t1,t2;
1487 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1488 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1489 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1490 DELIMITER //;
1491 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL READS SQL DATA SQL SECURITY INVOKER COMMENT 'comment'
1492 BEGIN
1493 DECLARE ret INT DEFAULT 0;
1494 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
1495 RETURN ret;
1496 END//
1497 DELIMITER ;//
1498 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
1499 SELECT * FROM t2 ORDER BY c1;
1500 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
1501 SELECT * FROM t2 ORDER BY c1;
1502 DELETE FROM t2 WHERE c1 = sf1(1);
1503 SELECT * FROM t2 ORDER BY c1;
1504 DROP FUNCTION sf1;
1505 DROP TABLE t1,t2;
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 TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1509 DELIMITER //;
1510 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL MODIFIES SQL DATA SQL SECURITY INVOKER COMMENT 'comment'
1511 BEGIN
1512 DECLARE ret INT DEFAULT 0;
1513 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
1514 RETURN ret;
1515 END//
1516 DELIMITER ;//
1517 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
1518 SELECT * FROM t2 ORDER BY c1;
1519 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
1520 SELECT * FROM t2 ORDER BY c1;
1521 DELETE FROM t2 WHERE c1 = sf1(1);
1522 SELECT * FROM t2 ORDER BY c1;
1523 DROP FUNCTION sf1;
1524 DROP TABLE t1,t2;
1525 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1526 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1527 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1528 DELIMITER //;
1529 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT NOT DETERMINISTIC SQL SECURITY INVOKER
1530 BEGIN
1531 DECLARE ret INT DEFAULT 0;
1532 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
1533 RETURN ret;
1534 END//
1535 DELIMITER ;//
1536 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
1537 SELECT * FROM t2 ORDER BY c1;
1538 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
1539 SELECT * FROM t2 ORDER BY c1;
1540 DELETE FROM t2 WHERE c1 = sf1(1);
1541 SELECT * FROM t2 ORDER BY c1;
1542 DROP FUNCTION sf1;
1543 DROP TABLE t1,t2;
1544 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1545 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1546 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1547 DELIMITER //;
1548 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT NOT DETERMINISTIC CONTAINS SQL SQL SECURITY INVOKER
1549 BEGIN
1550 DECLARE ret INT DEFAULT 0;
1551 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
1552 RETURN ret;
1553 END//
1554 DELIMITER ;//
1555 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
1556 SELECT * FROM t2 ORDER BY c1;
1557 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
1558 SELECT * FROM t2 ORDER BY c1;
1559 DELETE FROM t2 WHERE c1 = sf1(1);
1560 SELECT * FROM t2 ORDER BY c1;
1561 DROP FUNCTION sf1;
1562 DROP TABLE t1,t2;
1563 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1564 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1565 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1566 DELIMITER //;
1567 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT NOT DETERMINISTIC NO SQL SQL SECURITY INVOKER
1568 BEGIN
1569 DECLARE ret INT DEFAULT 0;
1570 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
1571 RETURN ret;
1572 END//
1573 DELIMITER ;//
1574 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
1575 SELECT * FROM t2 ORDER BY c1;
1576 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
1577 SELECT * FROM t2 ORDER BY c1;
1578 DELETE FROM t2 WHERE c1 = sf1(1);
1579 SELECT * FROM t2 ORDER BY c1;
1580 DROP FUNCTION sf1;
1581 DROP TABLE t1,t2;
1582 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1583 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1584 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1585 DELIMITER //;
1586 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT NOT DETERMINISTIC READS SQL DATA SQL SECURITY INVOKER
1587 BEGIN
1588 DECLARE ret INT DEFAULT 0;
1589 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
1590 RETURN ret;
1591 END//
1592 DELIMITER ;//
1593 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
1594 SELECT * FROM t2 ORDER BY c1;
1595 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
1596 SELECT * FROM t2 ORDER BY c1;
1597 DELETE FROM t2 WHERE c1 = sf1(1);
1598 SELECT * FROM t2 ORDER BY c1;
1599 DROP FUNCTION sf1;
1600 DROP TABLE t1,t2;
1601 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1602 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1603 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1604 DELIMITER //;
1605 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT NOT DETERMINISTIC MODIFIES SQL DATA SQL SECURITY INVOKER
1606 BEGIN
1607 DECLARE ret INT DEFAULT 0;
1608 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
1609 RETURN ret;
1610 END//
1611 DELIMITER ;//
1612 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
1613 SELECT * FROM t2 ORDER BY c1;
1614 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
1615 SELECT * FROM t2 ORDER BY c1;
1616 DELETE FROM t2 WHERE c1 = sf1(1);
1617 SELECT * FROM t2 ORDER BY c1;
1618 DROP FUNCTION sf1;
1619 DROP TABLE t1,t2;
1620 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1621 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1622 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1623 DELIMITER //;
1624 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT NOT DETERMINISTIC SQL SECURITY INVOKER COMMENT 'comment'
1625 BEGIN
1626 DECLARE ret INT DEFAULT 0;
1627 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
1628 RETURN ret;
1629 END//
1630 DELIMITER ;//
1631 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
1632 SELECT * FROM t2 ORDER BY c1;
1633 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
1634 SELECT * FROM t2 ORDER BY c1;
1635 DELETE FROM t2 WHERE c1 = sf1(1);
1636 SELECT * FROM t2 ORDER BY c1;
1637 DROP FUNCTION sf1;
1638 DROP TABLE t1,t2;
1639 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1640 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1641 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1642 DELIMITER //;
1643 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT NOT DETERMINISTIC CONTAINS SQL SQL SECURITY INVOKER COMMENT 'comment'
1644 BEGIN
1645 DECLARE ret INT DEFAULT 0;
1646 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
1647 RETURN ret;
1648 END//
1649 DELIMITER ;//
1650 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
1651 SELECT * FROM t2 ORDER BY c1;
1652 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
1653 SELECT * FROM t2 ORDER BY c1;
1654 DELETE FROM t2 WHERE c1 = sf1(1);
1655 SELECT * FROM t2 ORDER BY c1;
1656 DROP FUNCTION sf1;
1657 DROP TABLE t1,t2;
1658 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1659 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1660 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1661 DELIMITER //;
1662 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT NOT DETERMINISTIC NO SQL SQL SECURITY INVOKER COMMENT 'comment'
1663 BEGIN
1664 DECLARE ret INT DEFAULT 0;
1665 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
1666 RETURN ret;
1667 END//
1668 DELIMITER ;//
1669 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
1670 SELECT * FROM t2 ORDER BY c1;
1671 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
1672 SELECT * FROM t2 ORDER BY c1;
1673 DELETE FROM t2 WHERE c1 = sf1(1);
1674 SELECT * FROM t2 ORDER BY c1;
1675 DROP FUNCTION sf1;
1676 DROP TABLE t1,t2;
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 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1680 DELIMITER //;
1681 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT NOT DETERMINISTIC READS SQL DATA SQL SECURITY INVOKER COMMENT 'comment'
1682 BEGIN
1683 DECLARE ret INT DEFAULT 0;
1684 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
1685 RETURN ret;
1686 END//
1687 DELIMITER ;//
1688 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
1689 SELECT * FROM t2 ORDER BY c1;
1690 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
1691 SELECT * FROM t2 ORDER BY c1;
1692 DELETE FROM t2 WHERE c1 = sf1(1);
1693 SELECT * FROM t2 ORDER BY c1;
1694 DROP FUNCTION sf1;
1695 DROP TABLE t1,t2;
1696 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1697 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1698 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1699 DELIMITER //;
1700 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT NOT DETERMINISTIC MODIFIES SQL DATA SQL SECURITY INVOKER COMMENT 'comment'
1701 BEGIN
1702 DECLARE ret INT DEFAULT 0;
1703 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
1704 RETURN ret;
1705 END//
1706 DELIMITER ;//
1707 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
1708 SELECT * FROM t2 ORDER BY c1;
1709 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
1710 SELECT * FROM t2 ORDER BY c1;
1711 DELETE FROM t2 WHERE c1 = sf1(1);
1712 SELECT * FROM t2 ORDER BY c1;
1713 DROP FUNCTION sf1;
1714 DROP TABLE t1,t2;
1715 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1716 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1717 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1718 DELIMITER //;
1719 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL NOT DETERMINISTIC SQL SECURITY INVOKER
1720 BEGIN
1721 DECLARE ret INT DEFAULT 0;
1722 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
1723 RETURN ret;
1724 END//
1725 DELIMITER ;//
1726 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
1727 SELECT * FROM t2 ORDER BY c1;
1728 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
1729 SELECT * FROM t2 ORDER BY c1;
1730 DELETE FROM t2 WHERE c1 = sf1(1);
1731 SELECT * FROM t2 ORDER BY c1;
1732 DROP FUNCTION sf1;
1733 DROP TABLE t1,t2;
1734 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1735 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1736 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1737 DELIMITER //;
1738 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL NOT DETERMINISTIC CONTAINS SQL SQL SECURITY INVOKER
1739 BEGIN
1740 DECLARE ret INT DEFAULT 0;
1741 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
1742 RETURN ret;
1743 END//
1744 DELIMITER ;//
1745 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
1746 SELECT * FROM t2 ORDER BY c1;
1747 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
1748 SELECT * FROM t2 ORDER BY c1;
1749 DELETE FROM t2 WHERE c1 = sf1(1);
1750 SELECT * FROM t2 ORDER BY c1;
1751 DROP FUNCTION sf1;
1752 DROP TABLE t1,t2;
1753 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1754 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1755 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1756 DELIMITER //;
1757 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL NOT DETERMINISTIC NO SQL SQL SECURITY INVOKER
1758 BEGIN
1759 DECLARE ret INT DEFAULT 0;
1760 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
1761 RETURN ret;
1762 END//
1763 DELIMITER ;//
1764 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
1765 SELECT * FROM t2 ORDER BY c1;
1766 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
1767 SELECT * FROM t2 ORDER BY c1;
1768 DELETE FROM t2 WHERE c1 = sf1(1);
1769 SELECT * FROM t2 ORDER BY c1;
1770 DROP FUNCTION sf1;
1771 DROP TABLE t1,t2;
1772 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1773 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1774 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1775 DELIMITER //;
1776 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL NOT DETERMINISTIC READS SQL DATA SQL SECURITY INVOKER
1777 BEGIN
1778 DECLARE ret INT DEFAULT 0;
1779 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
1780 RETURN ret;
1781 END//
1782 DELIMITER ;//
1783 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
1784 SELECT * FROM t2 ORDER BY c1;
1785 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
1786 SELECT * FROM t2 ORDER BY c1;
1787 DELETE FROM t2 WHERE c1 = sf1(1);
1788 SELECT * FROM t2 ORDER BY c1;
1789 DROP FUNCTION sf1;
1790 DROP TABLE t1,t2;
1791 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1792 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1793 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1794 DELIMITER //;
1795 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL NOT DETERMINISTIC MODIFIES SQL DATA SQL SECURITY INVOKER
1796 BEGIN
1797 DECLARE ret INT DEFAULT 0;
1798 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
1799 RETURN ret;
1800 END//
1801 DELIMITER ;//
1802 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
1803 SELECT * FROM t2 ORDER BY c1;
1804 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
1805 SELECT * FROM t2 ORDER BY c1;
1806 DELETE FROM t2 WHERE c1 = sf1(1);
1807 SELECT * FROM t2 ORDER BY c1;
1808 DROP FUNCTION sf1;
1809 DROP TABLE t1,t2;
1810 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1811 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1812 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1813 DELIMITER //;
1814 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL NOT DETERMINISTIC SQL SECURITY INVOKER COMMENT 'comment'
1815 BEGIN
1816 DECLARE ret INT DEFAULT 0;
1817 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
1818 RETURN ret;
1819 END//
1820 DELIMITER ;//
1821 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
1822 SELECT * FROM t2 ORDER BY c1;
1823 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
1824 SELECT * FROM t2 ORDER BY c1;
1825 DELETE FROM t2 WHERE c1 = sf1(1);
1826 SELECT * FROM t2 ORDER BY c1;
1827 DROP FUNCTION sf1;
1828 DROP TABLE t1,t2;
1829 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1830 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1831 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1832 DELIMITER //;
1833 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL NOT DETERMINISTIC CONTAINS SQL SQL SECURITY INVOKER COMMENT 'comment'
1834 BEGIN
1835 DECLARE ret INT DEFAULT 0;
1836 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
1837 RETURN ret;
1838 END//
1839 DELIMITER ;//
1840 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
1841 SELECT * FROM t2 ORDER BY c1;
1842 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
1843 SELECT * FROM t2 ORDER BY c1;
1844 DELETE FROM t2 WHERE c1 = sf1(1);
1845 SELECT * FROM t2 ORDER BY c1;
1846 DROP FUNCTION sf1;
1847 DROP TABLE t1,t2;
1848 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1849 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1850 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1851 DELIMITER //;
1852 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL NOT DETERMINISTIC NO SQL SQL SECURITY INVOKER COMMENT 'comment'
1853 BEGIN
1854 DECLARE ret INT DEFAULT 0;
1855 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
1856 RETURN ret;
1857 END//
1858 DELIMITER ;//
1859 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
1860 SELECT * FROM t2 ORDER BY c1;
1861 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
1862 SELECT * FROM t2 ORDER BY c1;
1863 DELETE FROM t2 WHERE c1 = sf1(1);
1864 SELECT * FROM t2 ORDER BY c1;
1865 DROP FUNCTION sf1;
1866 DROP TABLE t1,t2;
1867 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1868 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1869 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1870 DELIMITER //;
1871 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL NOT DETERMINISTIC READS SQL DATA SQL SECURITY INVOKER COMMENT 'comment'
1872 BEGIN
1873 DECLARE ret INT DEFAULT 0;
1874 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
1875 RETURN ret;
1876 END//
1877 DELIMITER ;//
1878 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
1879 SELECT * FROM t2 ORDER BY c1;
1880 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
1881 SELECT * FROM t2 ORDER BY c1;
1882 DELETE FROM t2 WHERE c1 = sf1(1);
1883 SELECT * FROM t2 ORDER BY c1;
1884 DROP FUNCTION sf1;
1885 DROP TABLE t1,t2;
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 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1889 DELIMITER //;
1890 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL NOT DETERMINISTIC MODIFIES SQL DATA SQL SECURITY INVOKER COMMENT 'comment'
1891 BEGIN
1892 DECLARE ret INT DEFAULT 0;
1893 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
1894 RETURN ret;
1895 END//
1896 DELIMITER ;//
1897 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
1898 SELECT * FROM t2 ORDER BY c1;
1899 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
1900 SELECT * FROM t2 ORDER BY c1;
1901 DELETE FROM t2 WHERE c1 = sf1(1);
1902 SELECT * FROM t2 ORDER BY c1;
1903 DROP FUNCTION sf1;
1904 DROP TABLE t1,t2;
1905 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1906 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1907 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1908 DELIMITER //;
1909 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT DETERMINISTIC SQL SECURITY INVOKER
1910 BEGIN
1911 DECLARE ret INT DEFAULT 0;
1912 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
1913 RETURN ret;
1914 END//
1915 DELIMITER ;//
1916 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
1917 SELECT * FROM t2 ORDER BY c1;
1918 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
1919 SELECT * FROM t2 ORDER BY c1;
1920 DELETE FROM t2 WHERE c1 = sf1(1);
1921 SELECT * FROM t2 ORDER BY c1;
1922 DROP FUNCTION sf1;
1923 DROP TABLE t1,t2;
1924 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1925 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1926 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1927 DELIMITER //;
1928 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT DETERMINISTIC CONTAINS SQL SQL SECURITY INVOKER
1929 BEGIN
1930 DECLARE ret INT DEFAULT 0;
1931 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
1932 RETURN ret;
1933 END//
1934 DELIMITER ;//
1935 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
1936 SELECT * FROM t2 ORDER BY c1;
1937 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
1938 SELECT * FROM t2 ORDER BY c1;
1939 DELETE FROM t2 WHERE c1 = sf1(1);
1940 SELECT * FROM t2 ORDER BY c1;
1941 DROP FUNCTION sf1;
1942 DROP TABLE t1,t2;
1943 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1944 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1945 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1946 DELIMITER //;
1947 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT DETERMINISTIC NO SQL SQL SECURITY INVOKER
1948 BEGIN
1949 DECLARE ret INT DEFAULT 0;
1950 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
1951 RETURN ret;
1952 END//
1953 DELIMITER ;//
1954 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
1955 SELECT * FROM t2 ORDER BY c1;
1956 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
1957 SELECT * FROM t2 ORDER BY c1;
1958 DELETE FROM t2 WHERE c1 = sf1(1);
1959 SELECT * FROM t2 ORDER BY c1;
1960 DROP FUNCTION sf1;
1961 DROP TABLE t1,t2;
1962 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1963 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1964 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1965 DELIMITER //;
1966 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT DETERMINISTIC READS SQL DATA SQL SECURITY INVOKER
1967 BEGIN
1968 DECLARE ret INT DEFAULT 0;
1969 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
1970 RETURN ret;
1971 END//
1972 DELIMITER ;//
1973 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
1974 SELECT * FROM t2 ORDER BY c1;
1975 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
1976 SELECT * FROM t2 ORDER BY c1;
1977 DELETE FROM t2 WHERE c1 = sf1(1);
1978 SELECT * FROM t2 ORDER BY c1;
1979 DROP FUNCTION sf1;
1980 DROP TABLE t1,t2;
1981 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1982 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1983 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1984 DELIMITER //;
1985 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT DETERMINISTIC MODIFIES SQL DATA SQL SECURITY INVOKER
1986 BEGIN
1987 DECLARE ret INT DEFAULT 0;
1988 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
1989 RETURN ret;
1990 END//
1991 DELIMITER ;//
1992 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
1993 SELECT * FROM t2 ORDER BY c1;
1994 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
1995 SELECT * FROM t2 ORDER BY c1;
1996 DELETE FROM t2 WHERE c1 = sf1(1);
1997 SELECT * FROM t2 ORDER BY c1;
1998 DROP FUNCTION sf1;
1999 DROP TABLE t1,t2;
2000 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2001 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
2002 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2003 DELIMITER //;
2004 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT DETERMINISTIC SQL SECURITY INVOKER COMMENT 'comment'
2005 BEGIN
2006 DECLARE ret INT DEFAULT 0;
2007 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
2008 RETURN ret;
2009 END//
2010 DELIMITER ;//
2011 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
2012 SELECT * FROM t2 ORDER BY c1;
2013 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
2014 SELECT * FROM t2 ORDER BY c1;
2015 DELETE FROM t2 WHERE c1 = sf1(1);
2016 SELECT * FROM t2 ORDER BY c1;
2017 DROP FUNCTION sf1;
2018 DROP TABLE t1,t2;
2019 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2020 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
2021 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2022 DELIMITER //;
2023 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT DETERMINISTIC CONTAINS SQL SQL SECURITY INVOKER COMMENT 'comment'
2024 BEGIN
2025 DECLARE ret INT DEFAULT 0;
2026 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
2027 RETURN ret;
2028 END//
2029 DELIMITER ;//
2030 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
2031 SELECT * FROM t2 ORDER BY c1;
2032 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
2033 SELECT * FROM t2 ORDER BY c1;
2034 DELETE FROM t2 WHERE c1 = sf1(1);
2035 SELECT * FROM t2 ORDER BY c1;
2036 DROP FUNCTION sf1;
2037 DROP TABLE t1,t2;
2038 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2039 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
2040 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2041 DELIMITER //;
2042 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT DETERMINISTIC NO SQL SQL SECURITY INVOKER COMMENT 'comment'
2043 BEGIN
2044 DECLARE ret INT DEFAULT 0;
2045 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
2046 RETURN ret;
2047 END//
2048 DELIMITER ;//
2049 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
2050 SELECT * FROM t2 ORDER BY c1;
2051 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
2052 SELECT * FROM t2 ORDER BY c1;
2053 DELETE FROM t2 WHERE c1 = sf1(1);
2054 SELECT * FROM t2 ORDER BY c1;
2055 DROP FUNCTION sf1;
2056 DROP TABLE t1,t2;
2057 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2058 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
2059 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2060 DELIMITER //;
2061 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT DETERMINISTIC READS SQL DATA SQL SECURITY INVOKER COMMENT 'comment'
2062 BEGIN
2063 DECLARE ret INT DEFAULT 0;
2064 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
2065 RETURN ret;
2066 END//
2067 DELIMITER ;//
2068 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
2069 SELECT * FROM t2 ORDER BY c1;
2070 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
2071 SELECT * FROM t2 ORDER BY c1;
2072 DELETE FROM t2 WHERE c1 = sf1(1);
2073 SELECT * FROM t2 ORDER BY c1;
2074 DROP FUNCTION sf1;
2075 DROP TABLE t1,t2;
2076 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2077 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
2078 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2079 DELIMITER //;
2080 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT DETERMINISTIC MODIFIES SQL DATA SQL SECURITY INVOKER COMMENT 'comment'
2081 BEGIN
2082 DECLARE ret INT DEFAULT 0;
2083 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
2084 RETURN ret;
2085 END//
2086 DELIMITER ;//
2087 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
2088 SELECT * FROM t2 ORDER BY c1;
2089 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
2090 SELECT * FROM t2 ORDER BY c1;
2091 DELETE FROM t2 WHERE c1 = sf1(1);
2092 SELECT * FROM t2 ORDER BY c1;
2093 DROP FUNCTION sf1;
2094 DROP TABLE t1,t2;
2095 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2096 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
2097 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2098 DELIMITER //;
2099 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL DETERMINISTIC SQL SECURITY INVOKER
2100 BEGIN
2101 DECLARE ret INT DEFAULT 0;
2102 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
2103 RETURN ret;
2104 END//
2105 DELIMITER ;//
2106 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
2107 SELECT * FROM t2 ORDER BY c1;
2108 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
2109 SELECT * FROM t2 ORDER BY c1;
2110 DELETE FROM t2 WHERE c1 = sf1(1);
2111 SELECT * FROM t2 ORDER BY c1;
2112 DROP FUNCTION sf1;
2113 DROP TABLE t1,t2;
2114 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2115 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
2116 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2117 DELIMITER //;
2118 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL DETERMINISTIC CONTAINS SQL SQL SECURITY INVOKER
2119 BEGIN
2120 DECLARE ret INT DEFAULT 0;
2121 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
2122 RETURN ret;
2123 END//
2124 DELIMITER ;//
2125 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
2126 SELECT * FROM t2 ORDER BY c1;
2127 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
2128 SELECT * FROM t2 ORDER BY c1;
2129 DELETE FROM t2 WHERE c1 = sf1(1);
2130 SELECT * FROM t2 ORDER BY c1;
2131 DROP FUNCTION sf1;
2132 DROP TABLE t1,t2;
2133 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2134 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
2135 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2136 DELIMITER //;
2137 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL DETERMINISTIC NO SQL SQL SECURITY INVOKER
2138 BEGIN
2139 DECLARE ret INT DEFAULT 0;
2140 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
2141 RETURN ret;
2142 END//
2143 DELIMITER ;//
2144 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
2145 SELECT * FROM t2 ORDER BY c1;
2146 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
2147 SELECT * FROM t2 ORDER BY c1;
2148 DELETE FROM t2 WHERE c1 = sf1(1);
2149 SELECT * FROM t2 ORDER BY c1;
2150 DROP FUNCTION sf1;
2151 DROP TABLE t1,t2;
2152 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2153 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
2154 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2155 DELIMITER //;
2156 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL DETERMINISTIC READS SQL DATA SQL SECURITY INVOKER
2157 BEGIN
2158 DECLARE ret INT DEFAULT 0;
2159 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
2160 RETURN ret;
2161 END//
2162 DELIMITER ;//
2163 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
2164 SELECT * FROM t2 ORDER BY c1;
2165 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
2166 SELECT * FROM t2 ORDER BY c1;
2167 DELETE FROM t2 WHERE c1 = sf1(1);
2168 SELECT * FROM t2 ORDER BY c1;
2169 DROP FUNCTION sf1;
2170 DROP TABLE t1,t2;
2171 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2172 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
2173 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2174 DELIMITER //;
2175 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL DETERMINISTIC MODIFIES SQL DATA SQL SECURITY INVOKER
2176 BEGIN
2177 DECLARE ret INT DEFAULT 0;
2178 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
2179 RETURN ret;
2180 END//
2181 DELIMITER ;//
2182 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
2183 SELECT * FROM t2 ORDER BY c1;
2184 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
2185 SELECT * FROM t2 ORDER BY c1;
2186 DELETE FROM t2 WHERE c1 = sf1(1);
2187 SELECT * FROM t2 ORDER BY c1;
2188 DROP FUNCTION sf1;
2189 DROP TABLE t1,t2;
2190 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2191 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
2192 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2193 DELIMITER //;
2194 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL DETERMINISTIC SQL SECURITY INVOKER COMMENT 'comment'
2195 BEGIN
2196 DECLARE ret INT DEFAULT 0;
2197 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
2198 RETURN ret;
2199 END//
2200 DELIMITER ;//
2201 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
2202 SELECT * FROM t2 ORDER BY c1;
2203 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
2204 SELECT * FROM t2 ORDER BY c1;
2205 DELETE FROM t2 WHERE c1 = sf1(1);
2206 SELECT * FROM t2 ORDER BY c1;
2207 DROP FUNCTION sf1;
2208 DROP TABLE t1,t2;
2209 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2210 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
2211 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2212 DELIMITER //;
2213 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL DETERMINISTIC CONTAINS SQL SQL SECURITY INVOKER COMMENT 'comment'
2214 BEGIN
2215 DECLARE ret INT DEFAULT 0;
2216 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
2217 RETURN ret;
2218 END//
2219 DELIMITER ;//
2220 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
2221 SELECT * FROM t2 ORDER BY c1;
2222 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
2223 SELECT * FROM t2 ORDER BY c1;
2224 DELETE FROM t2 WHERE c1 = sf1(1);
2225 SELECT * FROM t2 ORDER BY c1;
2226 DROP FUNCTION sf1;
2227 DROP TABLE t1,t2;
2228 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2229 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
2230 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2231 DELIMITER //;
2232 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL DETERMINISTIC NO SQL SQL SECURITY INVOKER COMMENT 'comment'
2233 BEGIN
2234 DECLARE ret INT DEFAULT 0;
2235 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
2236 RETURN ret;
2237 END//
2238 DELIMITER ;//
2239 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
2240 SELECT * FROM t2 ORDER BY c1;
2241 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
2242 SELECT * FROM t2 ORDER BY c1;
2243 DELETE FROM t2 WHERE c1 = sf1(1);
2244 SELECT * FROM t2 ORDER BY c1;
2245 DROP FUNCTION sf1;
2246 DROP TABLE t1,t2;
2247 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2248 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
2249 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2250 DELIMITER //;
2251 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL DETERMINISTIC READS SQL DATA SQL SECURITY INVOKER COMMENT 'comment'
2252 BEGIN
2253 DECLARE ret INT DEFAULT 0;
2254 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
2255 RETURN ret;
2256 END//
2257 DELIMITER ;//
2258 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
2259 SELECT * FROM t2 ORDER BY c1;
2260 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
2261 SELECT * FROM t2 ORDER BY c1;
2262 DELETE FROM t2 WHERE c1 = sf1(1);
2263 SELECT * FROM t2 ORDER BY c1;
2264 DROP FUNCTION sf1;
2265 DROP TABLE t1,t2;
2266 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2267 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
2268 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2269 DELIMITER //;
2270 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL DETERMINISTIC MODIFIES SQL DATA SQL SECURITY INVOKER COMMENT 'comment'
2271 BEGIN
2272 DECLARE ret INT DEFAULT 0;
2273 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
2274 RETURN ret;
2275 END//
2276 DELIMITER ;//
2277 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
2278 SELECT * FROM t2 ORDER BY c1;
2279 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
2280 SELECT * FROM t2 ORDER BY c1;
2281 DELETE FROM t2 WHERE c1 = sf1(1);
2282 SELECT * FROM t2 ORDER BY c1;
2283 DROP FUNCTION sf1;
2284 DROP TABLE t1,t2;
2285 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2286 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
2287 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2288 DELIMITER //;
2289 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT SQL SECURITY DEFINER
2290 BEGIN
2291 DECLARE ret INT DEFAULT 0;
2292 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
2293 RETURN ret;
2294 END//
2295 DELIMITER ;//
2296 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
2297 SELECT * FROM t2 ORDER BY c1;
2298 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
2299 SELECT * FROM t2 ORDER BY c1;
2300 DELETE FROM t2 WHERE c1 = sf1(1);
2301 SELECT * FROM t2 ORDER BY c1;
2302 DROP FUNCTION sf1;
2303 DROP TABLE t1,t2;
2304 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2305 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
2306 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2307 DELIMITER //;
2308 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT CONTAINS SQL SQL SECURITY DEFINER
2309 BEGIN
2310 DECLARE ret INT DEFAULT 0;
2311 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
2312 RETURN ret;
2313 END//
2314 DELIMITER ;//
2315 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
2316 SELECT * FROM t2 ORDER BY c1;
2317 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
2318 SELECT * FROM t2 ORDER BY c1;
2319 DELETE FROM t2 WHERE c1 = sf1(1);
2320 SELECT * FROM t2 ORDER BY c1;
2321 DROP FUNCTION sf1;
2322 DROP TABLE t1,t2;
2323 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2324 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
2325 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2326 DELIMITER //;
2327 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT NO SQL SQL SECURITY DEFINER
2328 BEGIN
2329 DECLARE ret INT DEFAULT 0;
2330 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
2331 RETURN ret;
2332 END//
2333 DELIMITER ;//
2334 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
2335 SELECT * FROM t2 ORDER BY c1;
2336 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
2337 SELECT * FROM t2 ORDER BY c1;
2338 DELETE FROM t2 WHERE c1 = sf1(1);
2339 SELECT * FROM t2 ORDER BY c1;
2340 DROP FUNCTION sf1;
2341 DROP TABLE t1,t2;
2342 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2343 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
2344 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2345 DELIMITER //;
2346 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT READS SQL DATA SQL SECURITY DEFINER
2347 BEGIN
2348 DECLARE ret INT DEFAULT 0;
2349 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
2350 RETURN ret;
2351 END//
2352 DELIMITER ;//
2353 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
2354 SELECT * FROM t2 ORDER BY c1;
2355 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
2356 SELECT * FROM t2 ORDER BY c1;
2357 DELETE FROM t2 WHERE c1 = sf1(1);
2358 SELECT * FROM t2 ORDER BY c1;
2359 DROP FUNCTION sf1;
2360 DROP TABLE t1,t2;
2361 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2362 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
2363 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2364 DELIMITER //;
2365 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT MODIFIES SQL DATA SQL SECURITY DEFINER
2366 BEGIN
2367 DECLARE ret INT DEFAULT 0;
2368 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
2369 RETURN ret;
2370 END//
2371 DELIMITER ;//
2372 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
2373 SELECT * FROM t2 ORDER BY c1;
2374 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
2375 SELECT * FROM t2 ORDER BY c1;
2376 DELETE FROM t2 WHERE c1 = sf1(1);
2377 SELECT * FROM t2 ORDER BY c1;
2378 DROP FUNCTION sf1;
2379 DROP TABLE t1,t2;
2380 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2381 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
2382 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2383 DELIMITER //;
2384 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT SQL SECURITY DEFINER COMMENT 'comment'
2385 BEGIN
2386 DECLARE ret INT DEFAULT 0;
2387 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
2388 RETURN ret;
2389 END//
2390 DELIMITER ;//
2391 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
2392 SELECT * FROM t2 ORDER BY c1;
2393 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
2394 SELECT * FROM t2 ORDER BY c1;
2395 DELETE FROM t2 WHERE c1 = sf1(1);
2396 SELECT * FROM t2 ORDER BY c1;
2397 DROP FUNCTION sf1;
2398 DROP TABLE t1,t2;
2399 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2400 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
2401 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2402 DELIMITER //;
2403 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT CONTAINS SQL SQL SECURITY DEFINER COMMENT 'comment'
2404 BEGIN
2405 DECLARE ret INT DEFAULT 0;
2406 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
2407 RETURN ret;
2408 END//
2409 DELIMITER ;//
2410 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
2411 SELECT * FROM t2 ORDER BY c1;
2412 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
2413 SELECT * FROM t2 ORDER BY c1;
2414 DELETE FROM t2 WHERE c1 = sf1(1);
2415 SELECT * FROM t2 ORDER BY c1;
2416 DROP FUNCTION sf1;
2417 DROP TABLE t1,t2;
2418 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2419 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
2420 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2421 DELIMITER //;
2422 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT NO SQL SQL SECURITY DEFINER COMMENT 'comment'
2423 BEGIN
2424 DECLARE ret INT DEFAULT 0;
2425 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
2426 RETURN ret;
2427 END//
2428 DELIMITER ;//
2429 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
2430 SELECT * FROM t2 ORDER BY c1;
2431 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
2432 SELECT * FROM t2 ORDER BY c1;
2433 DELETE FROM t2 WHERE c1 = sf1(1);
2434 SELECT * FROM t2 ORDER BY c1;
2435 DROP FUNCTION sf1;
2436 DROP TABLE t1,t2;
2437 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2438 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
2439 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2440 DELIMITER //;
2441 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT READS SQL DATA SQL SECURITY DEFINER COMMENT 'comment'
2442 BEGIN
2443 DECLARE ret INT DEFAULT 0;
2444 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
2445 RETURN ret;
2446 END//
2447 DELIMITER ;//
2448 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
2449 SELECT * FROM t2 ORDER BY c1;
2450 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
2451 SELECT * FROM t2 ORDER BY c1;
2452 DELETE FROM t2 WHERE c1 = sf1(1);
2453 SELECT * FROM t2 ORDER BY c1;
2454 DROP FUNCTION sf1;
2455 DROP TABLE t1,t2;
2456 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2457 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
2458 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2459 DELIMITER //;
2460 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT MODIFIES SQL DATA SQL SECURITY DEFINER COMMENT 'comment'
2461 BEGIN
2462 DECLARE ret INT DEFAULT 0;
2463 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
2464 RETURN ret;
2465 END//
2466 DELIMITER ;//
2467 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
2468 SELECT * FROM t2 ORDER BY c1;
2469 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
2470 SELECT * FROM t2 ORDER BY c1;
2471 DELETE FROM t2 WHERE c1 = sf1(1);
2472 SELECT * FROM t2 ORDER BY c1;
2473 DROP FUNCTION sf1;
2474 DROP TABLE t1,t2;
2475 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2476 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
2477 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2478 DELIMITER //;
2479 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL SQL SECURITY DEFINER
2480 BEGIN
2481 DECLARE ret INT DEFAULT 0;
2482 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
2483 RETURN ret;
2484 END//
2485 DELIMITER ;//
2486 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
2487 SELECT * FROM t2 ORDER BY c1;
2488 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
2489 SELECT * FROM t2 ORDER BY c1;
2490 DELETE FROM t2 WHERE c1 = sf1(1);
2491 SELECT * FROM t2 ORDER BY c1;
2492 DROP FUNCTION sf1;
2493 DROP TABLE t1,t2;
2494 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2495 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
2496 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2497 DELIMITER //;
2498 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL CONTAINS SQL SQL SECURITY DEFINER
2499 BEGIN
2500 DECLARE ret INT DEFAULT 0;
2501 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
2502 RETURN ret;
2503 END//
2504 DELIMITER ;//
2505 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
2506 SELECT * FROM t2 ORDER BY c1;
2507 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
2508 SELECT * FROM t2 ORDER BY c1;
2509 DELETE FROM t2 WHERE c1 = sf1(1);
2510 SELECT * FROM t2 ORDER BY c1;
2511 DROP FUNCTION sf1;
2512 DROP TABLE t1,t2;
2513 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2514 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
2515 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2516 DELIMITER //;
2517 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL NO SQL SQL SECURITY DEFINER
2518 BEGIN
2519 DECLARE ret INT DEFAULT 0;
2520 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
2521 RETURN ret;
2522 END//
2523 DELIMITER ;//
2524 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
2525 SELECT * FROM t2 ORDER BY c1;
2526 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
2527 SELECT * FROM t2 ORDER BY c1;
2528 DELETE FROM t2 WHERE c1 = sf1(1);
2529 SELECT * FROM t2 ORDER BY c1;
2530 DROP FUNCTION sf1;
2531 DROP TABLE t1,t2;
2532 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2533 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
2534 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2535 DELIMITER //;
2536 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL READS SQL DATA SQL SECURITY DEFINER
2537 BEGIN
2538 DECLARE ret INT DEFAULT 0;
2539 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
2540 RETURN ret;
2541 END//
2542 DELIMITER ;//
2543 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
2544 SELECT * FROM t2 ORDER BY c1;
2545 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
2546 SELECT * FROM t2 ORDER BY c1;
2547 DELETE FROM t2 WHERE c1 = sf1(1);
2548 SELECT * FROM t2 ORDER BY c1;
2549 DROP FUNCTION sf1;
2550 DROP TABLE t1,t2;
2551 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2552 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
2553 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2554 DELIMITER //;
2555 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL MODIFIES SQL DATA SQL SECURITY DEFINER
2556 BEGIN
2557 DECLARE ret INT DEFAULT 0;
2558 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
2559 RETURN ret;
2560 END//
2561 DELIMITER ;//
2562 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
2563 SELECT * FROM t2 ORDER BY c1;
2564 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
2565 SELECT * FROM t2 ORDER BY c1;
2566 DELETE FROM t2 WHERE c1 = sf1(1);
2567 SELECT * FROM t2 ORDER BY c1;
2568 DROP FUNCTION sf1;
2569 DROP TABLE t1,t2;
2570 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2571 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
2572 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2573 DELIMITER //;
2574 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL SQL SECURITY DEFINER COMMENT 'comment'
2575 BEGIN
2576 DECLARE ret INT DEFAULT 0;
2577 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
2578 RETURN ret;
2579 END//
2580 DELIMITER ;//
2581 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
2582 SELECT * FROM t2 ORDER BY c1;
2583 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
2584 SELECT * FROM t2 ORDER BY c1;
2585 DELETE FROM t2 WHERE c1 = sf1(1);
2586 SELECT * FROM t2 ORDER BY c1;
2587 DROP FUNCTION sf1;
2588 DROP TABLE t1,t2;
2589 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2590 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
2591 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2592 DELIMITER //;
2593 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL CONTAINS SQL SQL SECURITY DEFINER COMMENT 'comment'
2594 BEGIN
2595 DECLARE ret INT DEFAULT 0;
2596 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
2597 RETURN ret;
2598 END//
2599 DELIMITER ;//
2600 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
2601 SELECT * FROM t2 ORDER BY c1;
2602 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
2603 SELECT * FROM t2 ORDER BY c1;
2604 DELETE FROM t2 WHERE c1 = sf1(1);
2605 SELECT * FROM t2 ORDER BY c1;
2606 DROP FUNCTION sf1;
2607 DROP TABLE t1,t2;
2608 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2609 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
2610 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2611 DELIMITER //;
2612 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL NO SQL SQL SECURITY DEFINER COMMENT 'comment'
2613 BEGIN
2614 DECLARE ret INT DEFAULT 0;
2615 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
2616 RETURN ret;
2617 END//
2618 DELIMITER ;//
2619 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
2620 SELECT * FROM t2 ORDER BY c1;
2621 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
2622 SELECT * FROM t2 ORDER BY c1;
2623 DELETE FROM t2 WHERE c1 = sf1(1);
2624 SELECT * FROM t2 ORDER BY c1;
2625 DROP FUNCTION sf1;
2626 DROP TABLE t1,t2;
2627 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2628 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
2629 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2630 DELIMITER //;
2631 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL READS SQL DATA SQL SECURITY DEFINER COMMENT 'comment'
2632 BEGIN
2633 DECLARE ret INT DEFAULT 0;
2634 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
2635 RETURN ret;
2636 END//
2637 DELIMITER ;//
2638 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
2639 SELECT * FROM t2 ORDER BY c1;
2640 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
2641 SELECT * FROM t2 ORDER BY c1;
2642 DELETE FROM t2 WHERE c1 = sf1(1);
2643 SELECT * FROM t2 ORDER BY c1;
2644 DROP FUNCTION sf1;
2645 DROP TABLE t1,t2;
2646 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2647 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
2648 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2649 DELIMITER //;
2650 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL MODIFIES SQL DATA SQL SECURITY DEFINER COMMENT 'comment'
2651 BEGIN
2652 DECLARE ret INT DEFAULT 0;
2653 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
2654 RETURN ret;
2655 END//
2656 DELIMITER ;//
2657 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
2658 SELECT * FROM t2 ORDER BY c1;
2659 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
2660 SELECT * FROM t2 ORDER BY c1;
2661 DELETE FROM t2 WHERE c1 = sf1(1);
2662 SELECT * FROM t2 ORDER BY c1;
2663 DROP FUNCTION sf1;
2664 DROP TABLE t1,t2;
2665 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2666 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
2667 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2668 DELIMITER //;
2669 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT NOT DETERMINISTIC SQL SECURITY DEFINER
2670 BEGIN
2671 DECLARE ret INT DEFAULT 0;
2672 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
2673 RETURN ret;
2674 END//
2675 DELIMITER ;//
2676 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
2677 SELECT * FROM t2 ORDER BY c1;
2678 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
2679 SELECT * FROM t2 ORDER BY c1;
2680 DELETE FROM t2 WHERE c1 = sf1(1);
2681 SELECT * FROM t2 ORDER BY c1;
2682 DROP FUNCTION sf1;
2683 DROP TABLE t1,t2;
2684 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2685 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
2686 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2687 DELIMITER //;
2688 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT NOT DETERMINISTIC CONTAINS SQL SQL SECURITY DEFINER
2689 BEGIN
2690 DECLARE ret INT DEFAULT 0;
2691 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
2692 RETURN ret;
2693 END//
2694 DELIMITER ;//
2695 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
2696 SELECT * FROM t2 ORDER BY c1;
2697 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
2698 SELECT * FROM t2 ORDER BY c1;
2699 DELETE FROM t2 WHERE c1 = sf1(1);
2700 SELECT * FROM t2 ORDER BY c1;
2701 DROP FUNCTION sf1;
2702 DROP TABLE t1,t2;
2703 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2704 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
2705 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2706 DELIMITER //;
2707 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT NOT DETERMINISTIC NO SQL SQL SECURITY DEFINER
2708 BEGIN
2709 DECLARE ret INT DEFAULT 0;
2710 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
2711 RETURN ret;
2712 END//
2713 DELIMITER ;//
2714 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
2715 SELECT * FROM t2 ORDER BY c1;
2716 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
2717 SELECT * FROM t2 ORDER BY c1;
2718 DELETE FROM t2 WHERE c1 = sf1(1);
2719 SELECT * FROM t2 ORDER BY c1;
2720 DROP FUNCTION sf1;
2721 DROP TABLE t1,t2;
2722 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2723 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
2724 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2725 DELIMITER //;
2726 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT NOT DETERMINISTIC READS SQL DATA SQL SECURITY DEFINER
2727 BEGIN
2728 DECLARE ret INT DEFAULT 0;
2729 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
2730 RETURN ret;
2731 END//
2732 DELIMITER ;//
2733 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
2734 SELECT * FROM t2 ORDER BY c1;
2735 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
2736 SELECT * FROM t2 ORDER BY c1;
2737 DELETE FROM t2 WHERE c1 = sf1(1);
2738 SELECT * FROM t2 ORDER BY c1;
2739 DROP FUNCTION sf1;
2740 DROP TABLE t1,t2;
2741 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2742 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
2743 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2744 DELIMITER //;
2745 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT NOT DETERMINISTIC MODIFIES SQL DATA SQL SECURITY DEFINER
2746 BEGIN
2747 DECLARE ret INT DEFAULT 0;
2748 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
2749 RETURN ret;
2750 END//
2751 DELIMITER ;//
2752 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
2753 SELECT * FROM t2 ORDER BY c1;
2754 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
2755 SELECT * FROM t2 ORDER BY c1;
2756 DELETE FROM t2 WHERE c1 = sf1(1);
2757 SELECT * FROM t2 ORDER BY c1;
2758 DROP FUNCTION sf1;
2759 DROP TABLE t1,t2;
2760 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2761 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
2762 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2763 DELIMITER //;
2764 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT NOT DETERMINISTIC SQL SECURITY DEFINER COMMENT 'comment'
2765 BEGIN
2766 DECLARE ret INT DEFAULT 0;
2767 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
2768 RETURN ret;
2769 END//
2770 DELIMITER ;//
2771 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
2772 SELECT * FROM t2 ORDER BY c1;
2773 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
2774 SELECT * FROM t2 ORDER BY c1;
2775 DELETE FROM t2 WHERE c1 = sf1(1);
2776 SELECT * FROM t2 ORDER BY c1;
2777 DROP FUNCTION sf1;
2778 DROP TABLE t1,t2;
2779 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2780 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
2781 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2782 DELIMITER //;
2783 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT NOT DETERMINISTIC CONTAINS SQL SQL SECURITY DEFINER COMMENT 'comment'
2784 BEGIN
2785 DECLARE ret INT DEFAULT 0;
2786 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
2787 RETURN ret;
2788 END//
2789 DELIMITER ;//
2790 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
2791 SELECT * FROM t2 ORDER BY c1;
2792 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
2793 SELECT * FROM t2 ORDER BY c1;
2794 DELETE FROM t2 WHERE c1 = sf1(1);
2795 SELECT * FROM t2 ORDER BY c1;
2796 DROP FUNCTION sf1;
2797 DROP TABLE t1,t2;
2798 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2799 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
2800 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2801 DELIMITER //;
2802 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT NOT DETERMINISTIC NO SQL SQL SECURITY DEFINER COMMENT 'comment'
2803 BEGIN
2804 DECLARE ret INT DEFAULT 0;
2805 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
2806 RETURN ret;
2807 END//
2808 DELIMITER ;//
2809 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
2810 SELECT * FROM t2 ORDER BY c1;
2811 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
2812 SELECT * FROM t2 ORDER BY c1;
2813 DELETE FROM t2 WHERE c1 = sf1(1);
2814 SELECT * FROM t2 ORDER BY c1;
2815 DROP FUNCTION sf1;
2816 DROP TABLE t1,t2;
2817 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2818 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
2819 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2820 DELIMITER //;
2821 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT NOT DETERMINISTIC READS SQL DATA SQL SECURITY DEFINER COMMENT 'comment'
2822 BEGIN
2823 DECLARE ret INT DEFAULT 0;
2824 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
2825 RETURN ret;
2826 END//
2827 DELIMITER ;//
2828 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
2829 SELECT * FROM t2 ORDER BY c1;
2830 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
2831 SELECT * FROM t2 ORDER BY c1;
2832 DELETE FROM t2 WHERE c1 = sf1(1);
2833 SELECT * FROM t2 ORDER BY c1;
2834 DROP FUNCTION sf1;
2835 DROP TABLE t1,t2;
2836 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2837 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
2838 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2839 DELIMITER //;
2840 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT NOT DETERMINISTIC MODIFIES SQL DATA SQL SECURITY DEFINER COMMENT 'comment'
2841 BEGIN
2842 DECLARE ret INT DEFAULT 0;
2843 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
2844 RETURN ret;
2845 END//
2846 DELIMITER ;//
2847 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
2848 SELECT * FROM t2 ORDER BY c1;
2849 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
2850 SELECT * FROM t2 ORDER BY c1;
2851 DELETE FROM t2 WHERE c1 = sf1(1);
2852 SELECT * FROM t2 ORDER BY c1;
2853 DROP FUNCTION sf1;
2854 DROP TABLE t1,t2;
2855 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2856 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
2857 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2858 DELIMITER //;
2859 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL NOT DETERMINISTIC SQL SECURITY DEFINER
2860 BEGIN
2861 DECLARE ret INT DEFAULT 0;
2862 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
2863 RETURN ret;
2864 END//
2865 DELIMITER ;//
2866 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
2867 SELECT * FROM t2 ORDER BY c1;
2868 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
2869 SELECT * FROM t2 ORDER BY c1;
2870 DELETE FROM t2 WHERE c1 = sf1(1);
2871 SELECT * FROM t2 ORDER BY c1;
2872 DROP FUNCTION sf1;
2873 DROP TABLE t1,t2;
2874 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2875 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
2876 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2877 DELIMITER //;
2878 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL NOT DETERMINISTIC CONTAINS SQL SQL SECURITY DEFINER
2879 BEGIN
2880 DECLARE ret INT DEFAULT 0;
2881 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
2882 RETURN ret;
2883 END//
2884 DELIMITER ;//
2885 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
2886 SELECT * FROM t2 ORDER BY c1;
2887 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
2888 SELECT * FROM t2 ORDER BY c1;
2889 DELETE FROM t2 WHERE c1 = sf1(1);
2890 SELECT * FROM t2 ORDER BY c1;
2891 DROP FUNCTION sf1;
2892 DROP TABLE t1,t2;
2893 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2894 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
2895 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2896 DELIMITER //;
2897 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL NOT DETERMINISTIC NO SQL SQL SECURITY DEFINER
2898 BEGIN
2899 DECLARE ret INT DEFAULT 0;
2900 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
2901 RETURN ret;
2902 END//
2903 DELIMITER ;//
2904 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
2905 SELECT * FROM t2 ORDER BY c1;
2906 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
2907 SELECT * FROM t2 ORDER BY c1;
2908 DELETE FROM t2 WHERE c1 = sf1(1);
2909 SELECT * FROM t2 ORDER BY c1;
2910 DROP FUNCTION sf1;
2911 DROP TABLE t1,t2;
2912 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2913 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
2914 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2915 DELIMITER //;
2916 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL NOT DETERMINISTIC READS SQL DATA SQL SECURITY DEFINER
2917 BEGIN
2918 DECLARE ret INT DEFAULT 0;
2919 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
2920 RETURN ret;
2921 END//
2922 DELIMITER ;//
2923 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
2924 SELECT * FROM t2 ORDER BY c1;
2925 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
2926 SELECT * FROM t2 ORDER BY c1;
2927 DELETE FROM t2 WHERE c1 = sf1(1);
2928 SELECT * FROM t2 ORDER BY c1;
2929 DROP FUNCTION sf1;
2930 DROP TABLE t1,t2;
2931 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2932 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
2933 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2934 DELIMITER //;
2935 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL NOT DETERMINISTIC MODIFIES SQL DATA SQL SECURITY DEFINER
2936 BEGIN
2937 DECLARE ret INT DEFAULT 0;
2938 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
2939 RETURN ret;
2940 END//
2941 DELIMITER ;//
2942 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
2943 SELECT * FROM t2 ORDER BY c1;
2944 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
2945 SELECT * FROM t2 ORDER BY c1;
2946 DELETE FROM t2 WHERE c1 = sf1(1);
2947 SELECT * FROM t2 ORDER BY c1;
2948 DROP FUNCTION sf1;
2949 DROP TABLE t1,t2;
2950 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2951 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
2952 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2953 DELIMITER //;
2954 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL NOT DETERMINISTIC SQL SECURITY DEFINER COMMENT 'comment'
2955 BEGIN
2956 DECLARE ret INT DEFAULT 0;
2957 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
2958 RETURN ret;
2959 END//
2960 DELIMITER ;//
2961 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
2962 SELECT * FROM t2 ORDER BY c1;
2963 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
2964 SELECT * FROM t2 ORDER BY c1;
2965 DELETE FROM t2 WHERE c1 = sf1(1);
2966 SELECT * FROM t2 ORDER BY c1;
2967 DROP FUNCTION sf1;
2968 DROP TABLE t1,t2;
2969 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2970 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
2971 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2972 DELIMITER //;
2973 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL NOT DETERMINISTIC CONTAINS SQL SQL SECURITY DEFINER COMMENT 'comment'
2974 BEGIN
2975 DECLARE ret INT DEFAULT 0;
2976 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
2977 RETURN ret;
2978 END//
2979 DELIMITER ;//
2980 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
2981 SELECT * FROM t2 ORDER BY c1;
2982 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
2983 SELECT * FROM t2 ORDER BY c1;
2984 DELETE FROM t2 WHERE c1 = sf1(1);
2985 SELECT * FROM t2 ORDER BY c1;
2986 DROP FUNCTION sf1;
2987 DROP TABLE t1,t2;
2988 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2989 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
2990 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2991 DELIMITER //;
2992 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL NOT DETERMINISTIC NO SQL SQL SECURITY DEFINER COMMENT 'comment'
2993 BEGIN
2994 DECLARE ret INT DEFAULT 0;
2995 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
2996 RETURN ret;
2997 END//
2998 DELIMITER ;//
2999 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
3000 SELECT * FROM t2 ORDER BY c1;
3001 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
3002 SELECT * FROM t2 ORDER BY c1;
3003 DELETE FROM t2 WHERE c1 = sf1(1);
3004 SELECT * FROM t2 ORDER BY c1;
3005 DROP FUNCTION sf1;
3006 DROP TABLE t1,t2;
3007 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3008 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
3009 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3010 DELIMITER //;
3011 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL NOT DETERMINISTIC READS SQL DATA SQL SECURITY DEFINER COMMENT 'comment'
3012 BEGIN
3013 DECLARE ret INT DEFAULT 0;
3014 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
3015 RETURN ret;
3016 END//
3017 DELIMITER ;//
3018 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
3019 SELECT * FROM t2 ORDER BY c1;
3020 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
3021 SELECT * FROM t2 ORDER BY c1;
3022 DELETE FROM t2 WHERE c1 = sf1(1);
3023 SELECT * FROM t2 ORDER BY c1;
3024 DROP FUNCTION sf1;
3025 DROP TABLE t1,t2;
3026 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3027 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
3028 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3029 DELIMITER //;
3030 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL NOT DETERMINISTIC MODIFIES SQL DATA SQL SECURITY DEFINER COMMENT 'comment'
3031 BEGIN
3032 DECLARE ret INT DEFAULT 0;
3033 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
3034 RETURN ret;
3035 END//
3036 DELIMITER ;//
3037 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
3038 SELECT * FROM t2 ORDER BY c1;
3039 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
3040 SELECT * FROM t2 ORDER BY c1;
3041 DELETE FROM t2 WHERE c1 = sf1(1);
3042 SELECT * FROM t2 ORDER BY c1;
3043 DROP FUNCTION sf1;
3044 DROP TABLE t1,t2;
3045 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3046 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
3047 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3048 DELIMITER //;
3049 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT DETERMINISTIC SQL SECURITY DEFINER
3050 BEGIN
3051 DECLARE ret INT DEFAULT 0;
3052 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
3053 RETURN ret;
3054 END//
3055 DELIMITER ;//
3056 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
3057 SELECT * FROM t2 ORDER BY c1;
3058 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
3059 SELECT * FROM t2 ORDER BY c1;
3060 DELETE FROM t2 WHERE c1 = sf1(1);
3061 SELECT * FROM t2 ORDER BY c1;
3062 DROP FUNCTION sf1;
3063 DROP TABLE t1,t2;
3064 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3065 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
3066 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3067 DELIMITER //;
3068 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT DETERMINISTIC CONTAINS SQL SQL SECURITY DEFINER
3069 BEGIN
3070 DECLARE ret INT DEFAULT 0;
3071 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
3072 RETURN ret;
3073 END//
3074 DELIMITER ;//
3075 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
3076 SELECT * FROM t2 ORDER BY c1;
3077 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
3078 SELECT * FROM t2 ORDER BY c1;
3079 DELETE FROM t2 WHERE c1 = sf1(1);
3080 SELECT * FROM t2 ORDER BY c1;
3081 DROP FUNCTION sf1;
3082 DROP TABLE t1,t2;
3083 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3084 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
3085 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3086 DELIMITER //;
3087 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT DETERMINISTIC NO SQL SQL SECURITY DEFINER
3088 BEGIN
3089 DECLARE ret INT DEFAULT 0;
3090 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
3091 RETURN ret;
3092 END//
3093 DELIMITER ;//
3094 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
3095 SELECT * FROM t2 ORDER BY c1;
3096 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
3097 SELECT * FROM t2 ORDER BY c1;
3098 DELETE FROM t2 WHERE c1 = sf1(1);
3099 SELECT * FROM t2 ORDER BY c1;
3100 DROP FUNCTION sf1;
3101 DROP TABLE t1,t2;
3102 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3103 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
3104 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3105 DELIMITER //;
3106 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT DETERMINISTIC READS SQL DATA SQL SECURITY DEFINER
3107 BEGIN
3108 DECLARE ret INT DEFAULT 0;
3109 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
3110 RETURN ret;
3111 END//
3112 DELIMITER ;//
3113 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
3114 SELECT * FROM t2 ORDER BY c1;
3115 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
3116 SELECT * FROM t2 ORDER BY c1;
3117 DELETE FROM t2 WHERE c1 = sf1(1);
3118 SELECT * FROM t2 ORDER BY c1;
3119 DROP FUNCTION sf1;
3120 DROP TABLE t1,t2;
3121 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3122 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
3123 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3124 DELIMITER //;
3125 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT DETERMINISTIC MODIFIES SQL DATA SQL SECURITY DEFINER
3126 BEGIN
3127 DECLARE ret INT DEFAULT 0;
3128 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
3129 RETURN ret;
3130 END//
3131 DELIMITER ;//
3132 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
3133 SELECT * FROM t2 ORDER BY c1;
3134 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
3135 SELECT * FROM t2 ORDER BY c1;
3136 DELETE FROM t2 WHERE c1 = sf1(1);
3137 SELECT * FROM t2 ORDER BY c1;
3138 DROP FUNCTION sf1;
3139 DROP TABLE t1,t2;
3140 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3141 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
3142 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3143 DELIMITER //;
3144 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT DETERMINISTIC SQL SECURITY DEFINER COMMENT 'comment'
3145 BEGIN
3146 DECLARE ret INT DEFAULT 0;
3147 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
3148 RETURN ret;
3149 END//
3150 DELIMITER ;//
3151 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
3152 SELECT * FROM t2 ORDER BY c1;
3153 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
3154 SELECT * FROM t2 ORDER BY c1;
3155 DELETE FROM t2 WHERE c1 = sf1(1);
3156 SELECT * FROM t2 ORDER BY c1;
3157 DROP FUNCTION sf1;
3158 DROP TABLE t1,t2;
3159 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3160 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
3161 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3162 DELIMITER //;
3163 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT DETERMINISTIC CONTAINS SQL SQL SECURITY DEFINER COMMENT 'comment'
3164 BEGIN
3165 DECLARE ret INT DEFAULT 0;
3166 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
3167 RETURN ret;
3168 END//
3169 DELIMITER ;//
3170 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
3171 SELECT * FROM t2 ORDER BY c1;
3172 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
3173 SELECT * FROM t2 ORDER BY c1;
3174 DELETE FROM t2 WHERE c1 = sf1(1);
3175 SELECT * FROM t2 ORDER BY c1;
3176 DROP FUNCTION sf1;
3177 DROP TABLE t1,t2;
3178 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3179 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
3180 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3181 DELIMITER //;
3182 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT DETERMINISTIC NO SQL SQL SECURITY DEFINER COMMENT 'comment'
3183 BEGIN
3184 DECLARE ret INT DEFAULT 0;
3185 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
3186 RETURN ret;
3187 END//
3188 DELIMITER ;//
3189 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
3190 SELECT * FROM t2 ORDER BY c1;
3191 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
3192 SELECT * FROM t2 ORDER BY c1;
3193 DELETE FROM t2 WHERE c1 = sf1(1);
3194 SELECT * FROM t2 ORDER BY c1;
3195 DROP FUNCTION sf1;
3196 DROP TABLE t1,t2;
3197 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3198 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
3199 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3200 DELIMITER //;
3201 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT DETERMINISTIC READS SQL DATA SQL SECURITY DEFINER COMMENT 'comment'
3202 BEGIN
3203 DECLARE ret INT DEFAULT 0;
3204 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
3205 RETURN ret;
3206 END//
3207 DELIMITER ;//
3208 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
3209 SELECT * FROM t2 ORDER BY c1;
3210 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
3211 SELECT * FROM t2 ORDER BY c1;
3212 DELETE FROM t2 WHERE c1 = sf1(1);
3213 SELECT * FROM t2 ORDER BY c1;
3214 DROP FUNCTION sf1;
3215 DROP TABLE t1,t2;
3216 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3217 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
3218 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3219 DELIMITER //;
3220 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT DETERMINISTIC MODIFIES SQL DATA SQL SECURITY DEFINER COMMENT 'comment'
3221 BEGIN
3222 DECLARE ret INT DEFAULT 0;
3223 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
3224 RETURN ret;
3225 END//
3226 DELIMITER ;//
3227 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
3228 SELECT * FROM t2 ORDER BY c1;
3229 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
3230 SELECT * FROM t2 ORDER BY c1;
3231 DELETE FROM t2 WHERE c1 = sf1(1);
3232 SELECT * FROM t2 ORDER BY c1;
3233 DROP FUNCTION sf1;
3234 DROP TABLE t1,t2;
3235 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3236 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
3237 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3238 DELIMITER //;
3239 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL DETERMINISTIC SQL SECURITY DEFINER
3240 BEGIN
3241 DECLARE ret INT DEFAULT 0;
3242 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
3243 RETURN ret;
3244 END//
3245 DELIMITER ;//
3246 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
3247 SELECT * FROM t2 ORDER BY c1;
3248 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
3249 SELECT * FROM t2 ORDER BY c1;
3250 DELETE FROM t2 WHERE c1 = sf1(1);
3251 SELECT * FROM t2 ORDER BY c1;
3252 DROP FUNCTION sf1;
3253 DROP TABLE t1,t2;
3254 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3255 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
3256 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3257 DELIMITER //;
3258 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL DETERMINISTIC CONTAINS SQL SQL SECURITY DEFINER
3259 BEGIN
3260 DECLARE ret INT DEFAULT 0;
3261 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
3262 RETURN ret;
3263 END//
3264 DELIMITER ;//
3265 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
3266 SELECT * FROM t2 ORDER BY c1;
3267 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
3268 SELECT * FROM t2 ORDER BY c1;
3269 DELETE FROM t2 WHERE c1 = sf1(1);
3270 SELECT * FROM t2 ORDER BY c1;
3271 DROP FUNCTION sf1;
3272 DROP TABLE t1,t2;
3273 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3274 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
3275 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3276 DELIMITER //;
3277 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL DETERMINISTIC NO SQL SQL SECURITY DEFINER
3278 BEGIN
3279 DECLARE ret INT DEFAULT 0;
3280 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
3281 RETURN ret;
3282 END//
3283 DELIMITER ;//
3284 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
3285 SELECT * FROM t2 ORDER BY c1;
3286 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
3287 SELECT * FROM t2 ORDER BY c1;
3288 DELETE FROM t2 WHERE c1 = sf1(1);
3289 SELECT * FROM t2 ORDER BY c1;
3290 DROP FUNCTION sf1;
3291 DROP TABLE t1,t2;
3292 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3293 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
3294 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3295 DELIMITER //;
3296 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL DETERMINISTIC READS SQL DATA SQL SECURITY DEFINER
3297 BEGIN
3298 DECLARE ret INT DEFAULT 0;
3299 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
3300 RETURN ret;
3301 END//
3302 DELIMITER ;//
3303 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
3304 SELECT * FROM t2 ORDER BY c1;
3305 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
3306 SELECT * FROM t2 ORDER BY c1;
3307 DELETE FROM t2 WHERE c1 = sf1(1);
3308 SELECT * FROM t2 ORDER BY c1;
3309 DROP FUNCTION sf1;
3310 DROP TABLE t1,t2;
3311 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3312 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
3313 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3314 DELIMITER //;
3315 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL DETERMINISTIC MODIFIES SQL DATA SQL SECURITY DEFINER
3316 BEGIN
3317 DECLARE ret INT DEFAULT 0;
3318 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
3319 RETURN ret;
3320 END//
3321 DELIMITER ;//
3322 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
3323 SELECT * FROM t2 ORDER BY c1;
3324 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
3325 SELECT * FROM t2 ORDER BY c1;
3326 DELETE FROM t2 WHERE c1 = sf1(1);
3327 SELECT * FROM t2 ORDER BY c1;
3328 DROP FUNCTION sf1;
3329 DROP TABLE t1,t2;
3330 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3331 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
3332 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3333 DELIMITER //;
3334 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL DETERMINISTIC SQL SECURITY DEFINER COMMENT 'comment'
3335 BEGIN
3336 DECLARE ret INT DEFAULT 0;
3337 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
3338 RETURN ret;
3339 END//
3340 DELIMITER ;//
3341 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
3342 SELECT * FROM t2 ORDER BY c1;
3343 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
3344 SELECT * FROM t2 ORDER BY c1;
3345 DELETE FROM t2 WHERE c1 = sf1(1);
3346 SELECT * FROM t2 ORDER BY c1;
3347 DROP FUNCTION sf1;
3348 DROP TABLE t1,t2;
3349 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3350 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
3351 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3352 DELIMITER //;
3353 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL DETERMINISTIC CONTAINS SQL SQL SECURITY DEFINER COMMENT 'comment'
3354 BEGIN
3355 DECLARE ret INT DEFAULT 0;
3356 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
3357 RETURN ret;
3358 END//
3359 DELIMITER ;//
3360 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
3361 SELECT * FROM t2 ORDER BY c1;
3362 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
3363 SELECT * FROM t2 ORDER BY c1;
3364 DELETE FROM t2 WHERE c1 = sf1(1);
3365 SELECT * FROM t2 ORDER BY c1;
3366 DROP FUNCTION sf1;
3367 DROP TABLE t1,t2;
3368 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3369 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
3370 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3371 DELIMITER //;
3372 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL DETERMINISTIC NO SQL SQL SECURITY DEFINER COMMENT 'comment'
3373 BEGIN
3374 DECLARE ret INT DEFAULT 0;
3375 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
3376 RETURN ret;
3377 END//
3378 DELIMITER ;//
3379 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
3380 SELECT * FROM t2 ORDER BY c1;
3381 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
3382 SELECT * FROM t2 ORDER BY c1;
3383 DELETE FROM t2 WHERE c1 = sf1(1);
3384 SELECT * FROM t2 ORDER BY c1;
3385 DROP FUNCTION sf1;
3386 DROP TABLE t1,t2;
3387 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3388 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
3389 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3390 DELIMITER //;
3391 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL DETERMINISTIC READS SQL DATA SQL SECURITY DEFINER COMMENT 'comment'
3392 BEGIN
3393 DECLARE ret INT DEFAULT 0;
3394 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
3395 RETURN ret;
3396 END//
3397 DELIMITER ;//
3398 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
3399 SELECT * FROM t2 ORDER BY c1;
3400 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
3401 SELECT * FROM t2 ORDER BY c1;
3402 DELETE FROM t2 WHERE c1 = sf1(1);
3403 SELECT * FROM t2 ORDER BY c1;
3404 DROP FUNCTION sf1;
3405 DROP TABLE t1,t2;
3406 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3407 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
3408 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3409 DELIMITER //;
3410 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL DETERMINISTIC MODIFIES SQL DATA SQL SECURITY DEFINER COMMENT 'comment'
3411 BEGIN
3412 DECLARE ret INT DEFAULT 0;
3413 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
3414 RETURN ret;
3415 END//
3416 DELIMITER ;//
3417 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
3418 SELECT * FROM t2 ORDER BY c1;
3419 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
3420 SELECT * FROM t2 ORDER BY c1;
3421 DELETE FROM t2 WHERE c1 = sf1(1);
3422 SELECT * FROM t2 ORDER BY c1;
3423 DROP FUNCTION sf1;
3424 DROP TABLE t1,t2;
3425