Debian Codegraph @

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

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