1 DROP TABLE IF EXISTS t1,t2;
2 DROP FUNCTION IF EXISTS sf1;
3 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
4 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
5 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
6 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT
8 DECLARE ret INT DEFAULT 0;
9 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
12 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
13 SELECT * FROM t2 ORDER BY c1;
17 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
18 SELECT * FROM t2 ORDER BY c1;
22 DELETE FROM t2 WHERE c1 = sf1(1);
23 SELECT * FROM t2 ORDER BY c1;
28 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
29 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
30 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
31 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT CONTAINS SQL
33 DECLARE ret INT DEFAULT 0;
34 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
37 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
38 SELECT * FROM t2 ORDER BY c1;
42 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
43 SELECT * FROM t2 ORDER BY c1;
47 DELETE FROM t2 WHERE c1 = sf1(1);
48 SELECT * FROM t2 ORDER BY c1;
53 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
54 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
55 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
56 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT NO SQL
58 DECLARE ret INT DEFAULT 0;
59 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
62 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
63 SELECT * FROM t2 ORDER BY c1;
67 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
68 SELECT * FROM t2 ORDER BY c1;
72 DELETE FROM t2 WHERE c1 = sf1(1);
73 SELECT * FROM t2 ORDER BY c1;
78 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
79 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
80 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
81 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT READS SQL DATA
83 DECLARE ret INT DEFAULT 0;
84 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
87 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
88 SELECT * FROM t2 ORDER BY c1;
92 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
93 SELECT * FROM t2 ORDER BY c1;
97 DELETE FROM t2 WHERE c1 = sf1(1);
98 SELECT * FROM t2 ORDER BY c1;
103 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
104 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
105 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
106 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT MODIFIES SQL DATA
108 DECLARE ret INT DEFAULT 0;
109 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
112 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
113 SELECT * FROM t2 ORDER BY c1;
117 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
118 SELECT * FROM t2 ORDER BY c1;
122 DELETE FROM t2 WHERE c1 = sf1(1);
123 SELECT * FROM t2 ORDER BY c1;
128 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
129 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
130 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
131 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT COMMENT 'comment'
133 DECLARE ret INT DEFAULT 0;
134 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
137 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
138 SELECT * FROM t2 ORDER BY c1;
142 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
143 SELECT * FROM t2 ORDER BY c1;
147 DELETE FROM t2 WHERE c1 = sf1(1);
148 SELECT * FROM t2 ORDER BY c1;
153 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
154 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
155 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
156 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT CONTAINS SQL COMMENT 'comment'
158 DECLARE ret INT DEFAULT 0;
159 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
162 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
163 SELECT * FROM t2 ORDER BY c1;
167 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
168 SELECT * FROM t2 ORDER BY c1;
172 DELETE FROM t2 WHERE c1 = sf1(1);
173 SELECT * FROM t2 ORDER BY c1;
178 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
179 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
180 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
181 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT NO SQL COMMENT 'comment'
183 DECLARE ret INT DEFAULT 0;
184 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
187 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
188 SELECT * FROM t2 ORDER BY c1;
192 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
193 SELECT * FROM t2 ORDER BY c1;
197 DELETE FROM t2 WHERE c1 = sf1(1);
198 SELECT * FROM t2 ORDER BY c1;
203 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
204 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
205 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
206 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT READS SQL DATA COMMENT 'comment'
208 DECLARE ret INT DEFAULT 0;
209 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
212 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
213 SELECT * FROM t2 ORDER BY c1;
217 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
218 SELECT * FROM t2 ORDER BY c1;
222 DELETE FROM t2 WHERE c1 = sf1(1);
223 SELECT * FROM t2 ORDER BY c1;
228 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
229 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
230 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
231 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT MODIFIES SQL DATA COMMENT 'comment'
233 DECLARE ret INT DEFAULT 0;
234 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
237 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
238 SELECT * FROM t2 ORDER BY c1;
242 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
243 SELECT * FROM t2 ORDER BY c1;
247 DELETE FROM t2 WHERE c1 = sf1(1);
248 SELECT * FROM t2 ORDER BY c1;
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 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL
258 DECLARE ret INT DEFAULT 0;
259 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
262 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
263 SELECT * FROM t2 ORDER BY c1;
267 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
268 SELECT * FROM t2 ORDER BY c1;
272 DELETE FROM t2 WHERE c1 = sf1(1);
273 SELECT * FROM t2 ORDER BY c1;
278 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
279 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
280 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
281 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL CONTAINS SQL
283 DECLARE ret INT DEFAULT 0;
284 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
287 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
288 SELECT * FROM t2 ORDER BY c1;
292 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
293 SELECT * FROM t2 ORDER BY c1;
297 DELETE FROM t2 WHERE c1 = sf1(1);
298 SELECT * FROM t2 ORDER BY c1;
303 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
304 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
305 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
306 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL NO SQL
308 DECLARE ret INT DEFAULT 0;
309 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
312 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
313 SELECT * FROM t2 ORDER BY c1;
317 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
318 SELECT * FROM t2 ORDER BY c1;
322 DELETE FROM t2 WHERE c1 = sf1(1);
323 SELECT * FROM t2 ORDER BY c1;
328 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
329 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
330 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
331 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL READS SQL DATA
333 DECLARE ret INT DEFAULT 0;
334 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
337 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
338 SELECT * FROM t2 ORDER BY c1;
342 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
343 SELECT * FROM t2 ORDER BY c1;
347 DELETE FROM t2 WHERE c1 = sf1(1);
348 SELECT * FROM t2 ORDER BY c1;
353 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
354 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
355 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
356 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL MODIFIES SQL DATA
358 DECLARE ret INT DEFAULT 0;
359 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
362 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
363 SELECT * FROM t2 ORDER BY c1;
367 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
368 SELECT * FROM t2 ORDER BY c1;
372 DELETE FROM t2 WHERE c1 = sf1(1);
373 SELECT * FROM t2 ORDER BY c1;
378 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
379 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
380 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
381 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL COMMENT 'comment'
383 DECLARE ret INT DEFAULT 0;
384 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
387 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
388 SELECT * FROM t2 ORDER BY c1;
392 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
393 SELECT * FROM t2 ORDER BY c1;
397 DELETE FROM t2 WHERE c1 = sf1(1);
398 SELECT * FROM t2 ORDER BY c1;
403 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
404 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
405 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
406 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL CONTAINS SQL COMMENT 'comment'
408 DECLARE ret INT DEFAULT 0;
409 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
412 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
413 SELECT * FROM t2 ORDER BY c1;
417 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
418 SELECT * FROM t2 ORDER BY c1;
422 DELETE FROM t2 WHERE c1 = sf1(1);
423 SELECT * FROM t2 ORDER BY c1;
428 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
429 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
430 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
431 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL NO SQL COMMENT 'comment'
433 DECLARE ret INT DEFAULT 0;
434 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
437 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
438 SELECT * FROM t2 ORDER BY c1;
442 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
443 SELECT * FROM t2 ORDER BY c1;
447 DELETE FROM t2 WHERE c1 = sf1(1);
448 SELECT * FROM t2 ORDER BY c1;
453 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
454 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
455 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
456 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL READS SQL DATA COMMENT 'comment'
458 DECLARE ret INT DEFAULT 0;
459 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
462 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
463 SELECT * FROM t2 ORDER BY c1;
467 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
468 SELECT * FROM t2 ORDER BY c1;
472 DELETE FROM t2 WHERE c1 = sf1(1);
473 SELECT * FROM t2 ORDER BY c1;
478 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
479 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
480 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
481 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL MODIFIES SQL DATA COMMENT 'comment'
483 DECLARE ret INT DEFAULT 0;
484 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
487 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
488 SELECT * FROM t2 ORDER BY c1;
492 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
493 SELECT * FROM t2 ORDER BY c1;
497 DELETE FROM t2 WHERE c1 = sf1(1);
498 SELECT * FROM t2 ORDER BY c1;
503 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
504 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
505 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
506 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT NOT DETERMINISTIC
508 DECLARE ret INT DEFAULT 0;
509 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
512 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
513 SELECT * FROM t2 ORDER BY c1;
517 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
518 SELECT * FROM t2 ORDER BY c1;
522 DELETE FROM t2 WHERE c1 = sf1(1);
523 SELECT * FROM t2 ORDER BY c1;
528 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
529 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
530 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
531 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT NOT DETERMINISTIC CONTAINS SQL
533 DECLARE ret INT DEFAULT 0;
534 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
537 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
538 SELECT * FROM t2 ORDER BY c1;
542 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
543 SELECT * FROM t2 ORDER BY c1;
547 DELETE FROM t2 WHERE c1 = sf1(1);
548 SELECT * FROM t2 ORDER BY c1;
553 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
554 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
555 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
556 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT NOT DETERMINISTIC NO SQL
558 DECLARE ret INT DEFAULT 0;
559 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
562 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
563 SELECT * FROM t2 ORDER BY c1;
567 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
568 SELECT * FROM t2 ORDER BY c1;
572 DELETE FROM t2 WHERE c1 = sf1(1);
573 SELECT * FROM t2 ORDER BY c1;
578 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
579 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
580 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
581 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT NOT DETERMINISTIC READS SQL DATA
583 DECLARE ret INT DEFAULT 0;
584 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
587 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
588 SELECT * FROM t2 ORDER BY c1;
592 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
593 SELECT * FROM t2 ORDER BY c1;
597 DELETE FROM t2 WHERE c1 = sf1(1);
598 SELECT * FROM t2 ORDER BY c1;
603 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
604 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
605 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
606 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT NOT DETERMINISTIC MODIFIES SQL DATA
608 DECLARE ret INT DEFAULT 0;
609 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
612 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
613 SELECT * FROM t2 ORDER BY c1;
617 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
618 SELECT * FROM t2 ORDER BY c1;
622 DELETE FROM t2 WHERE c1 = sf1(1);
623 SELECT * FROM t2 ORDER BY c1;
628 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
629 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
630 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
631 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT NOT DETERMINISTIC COMMENT 'comment'
633 DECLARE ret INT DEFAULT 0;
634 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
637 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
638 SELECT * FROM t2 ORDER BY c1;
642 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
643 SELECT * FROM t2 ORDER BY c1;
647 DELETE FROM t2 WHERE c1 = sf1(1);
648 SELECT * FROM t2 ORDER BY c1;
653 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
654 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
655 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
656 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT NOT DETERMINISTIC CONTAINS SQL COMMENT 'comment'
658 DECLARE ret INT DEFAULT 0;
659 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
662 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
663 SELECT * FROM t2 ORDER BY c1;
667 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
668 SELECT * FROM t2 ORDER BY c1;
672 DELETE FROM t2 WHERE c1 = sf1(1);
673 SELECT * FROM t2 ORDER BY c1;
678 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
679 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
680 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
681 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT NOT DETERMINISTIC NO SQL COMMENT 'comment'
683 DECLARE ret INT DEFAULT 0;
684 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
687 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
688 SELECT * FROM t2 ORDER BY c1;
692 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
693 SELECT * FROM t2 ORDER BY c1;
697 DELETE FROM t2 WHERE c1 = sf1(1);
698 SELECT * FROM t2 ORDER BY c1;
703 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
704 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
705 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
706 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT NOT DETERMINISTIC READS SQL DATA COMMENT 'comment'
708 DECLARE ret INT DEFAULT 0;
709 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
712 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
713 SELECT * FROM t2 ORDER BY c1;
717 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
718 SELECT * FROM t2 ORDER BY c1;
722 DELETE FROM t2 WHERE c1 = sf1(1);
723 SELECT * FROM t2 ORDER BY c1;
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 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT NOT DETERMINISTIC MODIFIES SQL DATA COMMENT 'comment'
733 DECLARE ret INT DEFAULT 0;
734 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
737 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
738 SELECT * FROM t2 ORDER BY c1;
742 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
743 SELECT * FROM t2 ORDER BY c1;
747 DELETE FROM t2 WHERE c1 = sf1(1);
748 SELECT * FROM t2 ORDER BY c1;
753 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
754 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
755 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
756 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL NOT DETERMINISTIC
758 DECLARE ret INT DEFAULT 0;
759 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
762 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
763 SELECT * FROM t2 ORDER BY c1;
767 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
768 SELECT * FROM t2 ORDER BY c1;
772 DELETE FROM t2 WHERE c1 = sf1(1);
773 SELECT * FROM t2 ORDER BY c1;
778 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
779 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
780 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
781 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL NOT DETERMINISTIC CONTAINS SQL
783 DECLARE ret INT DEFAULT 0;
784 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
787 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
788 SELECT * FROM t2 ORDER BY c1;
792 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
793 SELECT * FROM t2 ORDER BY c1;
797 DELETE FROM t2 WHERE c1 = sf1(1);
798 SELECT * FROM t2 ORDER BY c1;
803 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
804 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
805 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
806 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL NOT DETERMINISTIC NO SQL
808 DECLARE ret INT DEFAULT 0;
809 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
812 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
813 SELECT * FROM t2 ORDER BY c1;
817 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
818 SELECT * FROM t2 ORDER BY c1;
822 DELETE FROM t2 WHERE c1 = sf1(1);
823 SELECT * FROM t2 ORDER BY c1;
828 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
829 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
830 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
831 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL NOT DETERMINISTIC READS SQL DATA
833 DECLARE ret INT DEFAULT 0;
834 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
837 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
838 SELECT * FROM t2 ORDER BY c1;
842 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
843 SELECT * FROM t2 ORDER BY c1;
847 DELETE FROM t2 WHERE c1 = sf1(1);
848 SELECT * FROM t2 ORDER BY c1;
853 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
854 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
855 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
856 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL NOT DETERMINISTIC MODIFIES SQL DATA
858 DECLARE ret INT DEFAULT 0;
859 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
862 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
863 SELECT * FROM t2 ORDER BY c1;
867 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
868 SELECT * FROM t2 ORDER BY c1;
872 DELETE FROM t2 WHERE c1 = sf1(1);
873 SELECT * FROM t2 ORDER BY c1;
878 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
879 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
880 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
881 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL NOT DETERMINISTIC COMMENT 'comment'
883 DECLARE ret INT DEFAULT 0;
884 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
887 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
888 SELECT * FROM t2 ORDER BY c1;
892 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
893 SELECT * FROM t2 ORDER BY c1;
897 DELETE FROM t2 WHERE c1 = sf1(1);
898 SELECT * FROM t2 ORDER BY c1;
903 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
904 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
905 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
906 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL NOT DETERMINISTIC CONTAINS SQL COMMENT 'comment'
908 DECLARE ret INT DEFAULT 0;
909 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
912 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
913 SELECT * FROM t2 ORDER BY c1;
917 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
918 SELECT * FROM t2 ORDER BY c1;
922 DELETE FROM t2 WHERE c1 = sf1(1);
923 SELECT * FROM t2 ORDER BY c1;
928 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
929 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
930 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
931 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL NOT DETERMINISTIC NO SQL COMMENT 'comment'
933 DECLARE ret INT DEFAULT 0;
934 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
937 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
938 SELECT * FROM t2 ORDER BY c1;
942 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
943 SELECT * FROM t2 ORDER BY c1;
947 DELETE FROM t2 WHERE c1 = sf1(1);
948 SELECT * FROM t2 ORDER BY c1;
953 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
954 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
955 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
956 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL NOT DETERMINISTIC READS SQL DATA COMMENT 'comment'
958 DECLARE ret INT DEFAULT 0;
959 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
962 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
963 SELECT * FROM t2 ORDER BY c1;
967 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
968 SELECT * FROM t2 ORDER BY c1;
972 DELETE FROM t2 WHERE c1 = sf1(1);
973 SELECT * FROM t2 ORDER BY c1;
978 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
979 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
980 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
981 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL NOT DETERMINISTIC MODIFIES SQL DATA COMMENT 'comment'
983 DECLARE ret INT DEFAULT 0;
984 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
987 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
988 SELECT * FROM t2 ORDER BY c1;
992 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
993 SELECT * FROM t2 ORDER BY c1;
997 DELETE FROM t2 WHERE c1 = sf1(1);
998 SELECT * FROM t2 ORDER BY c1;
1003 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1004 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1005 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1006 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT DETERMINISTIC
1008 DECLARE ret INT DEFAULT 0;
1009 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
1012 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
1013 SELECT * FROM t2 ORDER BY c1;
1017 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
1018 SELECT * FROM t2 ORDER BY c1;
1022 DELETE FROM t2 WHERE c1 = sf1(1);
1023 SELECT * FROM t2 ORDER BY c1;
1028 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1029 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1030 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1031 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT DETERMINISTIC CONTAINS SQL
1033 DECLARE ret INT DEFAULT 0;
1034 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
1037 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
1038 SELECT * FROM t2 ORDER BY c1;
1042 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
1043 SELECT * FROM t2 ORDER BY c1;
1047 DELETE FROM t2 WHERE c1 = sf1(1);
1048 SELECT * FROM t2 ORDER BY c1;
1053 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1054 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1055 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1056 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT DETERMINISTIC NO SQL
1058 DECLARE ret INT DEFAULT 0;
1059 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
1062 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
1063 SELECT * FROM t2 ORDER BY c1;
1067 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
1068 SELECT * FROM t2 ORDER BY c1;
1072 DELETE FROM t2 WHERE c1 = sf1(1);
1073 SELECT * FROM t2 ORDER BY c1;
1078 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1079 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1080 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1081 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT DETERMINISTIC READS SQL DATA
1083 DECLARE ret INT DEFAULT 0;
1084 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
1087 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
1088 SELECT * FROM t2 ORDER BY c1;
1092 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
1093 SELECT * FROM t2 ORDER BY c1;
1097 DELETE FROM t2 WHERE c1 = sf1(1);
1098 SELECT * FROM t2 ORDER BY c1;
1103 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1104 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1105 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1106 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT DETERMINISTIC MODIFIES SQL DATA
1108 DECLARE ret INT DEFAULT 0;
1109 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
1112 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
1113 SELECT * FROM t2 ORDER BY c1;
1117 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
1118 SELECT * FROM t2 ORDER BY c1;
1122 DELETE FROM t2 WHERE c1 = sf1(1);
1123 SELECT * FROM t2 ORDER BY c1;
1128 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1129 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1130 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1131 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT DETERMINISTIC COMMENT 'comment'
1133 DECLARE ret INT DEFAULT 0;
1134 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
1137 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
1138 SELECT * FROM t2 ORDER BY c1;
1142 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
1143 SELECT * FROM t2 ORDER BY c1;
1147 DELETE FROM t2 WHERE c1 = sf1(1);
1148 SELECT * FROM t2 ORDER BY c1;
1153 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1154 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1155 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1156 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT DETERMINISTIC CONTAINS SQL COMMENT 'comment'
1158 DECLARE ret INT DEFAULT 0;
1159 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
1162 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
1163 SELECT * FROM t2 ORDER BY c1;
1167 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
1168 SELECT * FROM t2 ORDER BY c1;
1172 DELETE FROM t2 WHERE c1 = sf1(1);
1173 SELECT * FROM t2 ORDER BY c1;
1178 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1179 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1180 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1181 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT DETERMINISTIC NO SQL COMMENT 'comment'
1183 DECLARE ret INT DEFAULT 0;
1184 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
1187 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
1188 SELECT * FROM t2 ORDER BY c1;
1192 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
1193 SELECT * FROM t2 ORDER BY c1;
1197 DELETE FROM t2 WHERE c1 = sf1(1);
1198 SELECT * FROM t2 ORDER BY c1;
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 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT DETERMINISTIC READS SQL DATA COMMENT 'comment'
1208 DECLARE ret INT DEFAULT 0;
1209 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
1212 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
1213 SELECT * FROM t2 ORDER BY c1;
1217 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
1218 SELECT * FROM t2 ORDER BY c1;
1222 DELETE FROM t2 WHERE c1 = sf1(1);
1223 SELECT * FROM t2 ORDER BY c1;
1228 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1229 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1230 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1231 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT DETERMINISTIC MODIFIES SQL DATA COMMENT 'comment'
1233 DECLARE ret INT DEFAULT 0;
1234 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
1237 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
1238 SELECT * FROM t2 ORDER BY c1;
1242 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
1243 SELECT * FROM t2 ORDER BY c1;
1247 DELETE FROM t2 WHERE c1 = sf1(1);
1248 SELECT * FROM t2 ORDER BY c1;
1253 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1254 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1255 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1256 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL DETERMINISTIC
1258 DECLARE ret INT DEFAULT 0;
1259 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
1262 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
1263 SELECT * FROM t2 ORDER BY c1;
1267 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
1268 SELECT * FROM t2 ORDER BY c1;
1272 DELETE FROM t2 WHERE c1 = sf1(1);
1273 SELECT * FROM t2 ORDER BY c1;
1278 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1279 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1280 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1281 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL DETERMINISTIC CONTAINS SQL
1283 DECLARE ret INT DEFAULT 0;
1284 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
1287 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
1288 SELECT * FROM t2 ORDER BY c1;
1292 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
1293 SELECT * FROM t2 ORDER BY c1;
1297 DELETE FROM t2 WHERE c1 = sf1(1);
1298 SELECT * FROM t2 ORDER BY c1;
1303 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1304 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1305 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1306 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL DETERMINISTIC NO SQL
1308 DECLARE ret INT DEFAULT 0;
1309 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
1312 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
1313 SELECT * FROM t2 ORDER BY c1;
1317 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
1318 SELECT * FROM t2 ORDER BY c1;
1322 DELETE FROM t2 WHERE c1 = sf1(1);
1323 SELECT * FROM t2 ORDER BY c1;
1328 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1329 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1330 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1331 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL DETERMINISTIC READS SQL DATA
1333 DECLARE ret INT DEFAULT 0;
1334 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
1337 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
1338 SELECT * FROM t2 ORDER BY c1;
1342 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
1343 SELECT * FROM t2 ORDER BY c1;
1347 DELETE FROM t2 WHERE c1 = sf1(1);
1348 SELECT * FROM t2 ORDER BY c1;
1353 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1354 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1355 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1356 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL DETERMINISTIC MODIFIES SQL DATA
1358 DECLARE ret INT DEFAULT 0;
1359 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
1362 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
1363 SELECT * FROM t2 ORDER BY c1;
1367 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
1368 SELECT * FROM t2 ORDER BY c1;
1372 DELETE FROM t2 WHERE c1 = sf1(1);
1373 SELECT * FROM t2 ORDER BY c1;
1378 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1379 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1380 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1381 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL DETERMINISTIC COMMENT 'comment'
1383 DECLARE ret INT DEFAULT 0;
1384 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
1387 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
1388 SELECT * FROM t2 ORDER BY c1;
1392 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
1393 SELECT * FROM t2 ORDER BY c1;
1397 DELETE FROM t2 WHERE c1 = sf1(1);
1398 SELECT * FROM t2 ORDER BY c1;
1403 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1404 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1405 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1406 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL DETERMINISTIC CONTAINS SQL COMMENT 'comment'
1408 DECLARE ret INT DEFAULT 0;
1409 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
1412 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
1413 SELECT * FROM t2 ORDER BY c1;
1417 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
1418 SELECT * FROM t2 ORDER BY c1;
1422 DELETE FROM t2 WHERE c1 = sf1(1);
1423 SELECT * FROM t2 ORDER BY c1;
1428 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1429 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1430 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1431 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL DETERMINISTIC NO SQL COMMENT 'comment'
1433 DECLARE ret INT DEFAULT 0;
1434 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
1437 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
1438 SELECT * FROM t2 ORDER BY c1;
1442 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
1443 SELECT * FROM t2 ORDER BY c1;
1447 DELETE FROM t2 WHERE c1 = sf1(1);
1448 SELECT * FROM t2 ORDER BY c1;
1453 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1454 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1455 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1456 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL DETERMINISTIC READS SQL DATA COMMENT 'comment'
1458 DECLARE ret INT DEFAULT 0;
1459 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
1462 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
1463 SELECT * FROM t2 ORDER BY c1;
1467 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
1468 SELECT * FROM t2 ORDER BY c1;
1472 DELETE FROM t2 WHERE c1 = sf1(1);
1473 SELECT * FROM t2 ORDER BY c1;
1478 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1479 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1480 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1481 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL DETERMINISTIC MODIFIES SQL DATA COMMENT 'comment'
1483 DECLARE ret INT DEFAULT 0;
1484 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
1487 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
1488 SELECT * FROM t2 ORDER BY c1;
1492 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
1493 SELECT * FROM t2 ORDER BY c1;
1497 DELETE FROM t2 WHERE c1 = sf1(1);
1498 SELECT * FROM t2 ORDER BY c1;
1503 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1504 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1505 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1506 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT SQL SECURITY INVOKER
1508 DECLARE ret INT DEFAULT 0;
1509 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
1512 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
1513 SELECT * FROM t2 ORDER BY c1;
1517 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
1518 SELECT * FROM t2 ORDER BY c1;
1522 DELETE FROM t2 WHERE c1 = sf1(1);
1523 SELECT * FROM t2 ORDER BY c1;
1528 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1529 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1530 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1531 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT CONTAINS SQL SQL SECURITY INVOKER
1533 DECLARE ret INT DEFAULT 0;
1534 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
1537 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
1538 SELECT * FROM t2 ORDER BY c1;
1542 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
1543 SELECT * FROM t2 ORDER BY c1;
1547 DELETE FROM t2 WHERE c1 = sf1(1);
1548 SELECT * FROM t2 ORDER BY c1;
1553 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1554 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1555 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1556 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT NO SQL SQL SECURITY INVOKER
1558 DECLARE ret INT DEFAULT 0;
1559 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
1562 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
1563 SELECT * FROM t2 ORDER BY c1;
1567 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
1568 SELECT * FROM t2 ORDER BY c1;
1572 DELETE FROM t2 WHERE c1 = sf1(1);
1573 SELECT * FROM t2 ORDER BY c1;
1578 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1579 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1580 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1581 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT READS SQL DATA SQL SECURITY INVOKER
1583 DECLARE ret INT DEFAULT 0;
1584 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
1587 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
1588 SELECT * FROM t2 ORDER BY c1;
1592 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
1593 SELECT * FROM t2 ORDER BY c1;
1597 DELETE FROM t2 WHERE c1 = sf1(1);
1598 SELECT * FROM t2 ORDER BY c1;
1603 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1604 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1605 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1606 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT MODIFIES SQL DATA SQL SECURITY INVOKER
1608 DECLARE ret INT DEFAULT 0;
1609 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
1612 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
1613 SELECT * FROM t2 ORDER BY c1;
1617 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
1618 SELECT * FROM t2 ORDER BY c1;
1622 DELETE FROM t2 WHERE c1 = sf1(1);
1623 SELECT * FROM t2 ORDER BY c1;
1628 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1629 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1630 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1631 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT SQL SECURITY INVOKER COMMENT 'comment'
1633 DECLARE ret INT DEFAULT 0;
1634 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
1637 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
1638 SELECT * FROM t2 ORDER BY c1;
1642 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
1643 SELECT * FROM t2 ORDER BY c1;
1647 DELETE FROM t2 WHERE c1 = sf1(1);
1648 SELECT * FROM t2 ORDER BY c1;
1653 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1654 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1655 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1656 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT CONTAINS SQL SQL SECURITY INVOKER COMMENT 'comment'
1658 DECLARE ret INT DEFAULT 0;
1659 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
1662 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
1663 SELECT * FROM t2 ORDER BY c1;
1667 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
1668 SELECT * FROM t2 ORDER BY c1;
1672 DELETE FROM t2 WHERE c1 = sf1(1);
1673 SELECT * FROM t2 ORDER BY c1;
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 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT NO SQL SQL SECURITY INVOKER COMMENT 'comment'
1683 DECLARE ret INT DEFAULT 0;
1684 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
1687 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
1688 SELECT * FROM t2 ORDER BY c1;
1692 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
1693 SELECT * FROM t2 ORDER BY c1;
1697 DELETE FROM t2 WHERE c1 = sf1(1);
1698 SELECT * FROM t2 ORDER BY c1;
1703 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1704 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1705 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1706 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT READS SQL DATA SQL SECURITY INVOKER COMMENT 'comment'
1708 DECLARE ret INT DEFAULT 0;
1709 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
1712 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
1713 SELECT * FROM t2 ORDER BY c1;
1717 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
1718 SELECT * FROM t2 ORDER BY c1;
1722 DELETE FROM t2 WHERE c1 = sf1(1);
1723 SELECT * FROM t2 ORDER BY c1;
1728 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1729 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1730 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1731 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT MODIFIES SQL DATA SQL SECURITY INVOKER COMMENT 'comment'
1733 DECLARE ret INT DEFAULT 0;
1734 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
1737 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
1738 SELECT * FROM t2 ORDER BY c1;
1742 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
1743 SELECT * FROM t2 ORDER BY c1;
1747 DELETE FROM t2 WHERE c1 = sf1(1);
1748 SELECT * FROM t2 ORDER BY c1;
1753 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1754 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1755 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1756 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL SQL SECURITY INVOKER
1758 DECLARE ret INT DEFAULT 0;
1759 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
1762 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
1763 SELECT * FROM t2 ORDER BY c1;
1767 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
1768 SELECT * FROM t2 ORDER BY c1;
1772 DELETE FROM t2 WHERE c1 = sf1(1);
1773 SELECT * FROM t2 ORDER BY c1;
1778 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1779 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1780 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1781 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL CONTAINS SQL SQL SECURITY INVOKER
1783 DECLARE ret INT DEFAULT 0;
1784 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
1787 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
1788 SELECT * FROM t2 ORDER BY c1;
1792 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
1793 SELECT * FROM t2 ORDER BY c1;
1797 DELETE FROM t2 WHERE c1 = sf1(1);
1798 SELECT * FROM t2 ORDER BY c1;
1803 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1804 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1805 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1806 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL NO SQL SQL SECURITY INVOKER
1808 DECLARE ret INT DEFAULT 0;
1809 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
1812 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
1813 SELECT * FROM t2 ORDER BY c1;
1817 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
1818 SELECT * FROM t2 ORDER BY c1;
1822 DELETE FROM t2 WHERE c1 = sf1(1);
1823 SELECT * FROM t2 ORDER BY c1;
1828 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1829 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1830 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1831 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL READS SQL DATA SQL SECURITY INVOKER
1833 DECLARE ret INT DEFAULT 0;
1834 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
1837 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
1838 SELECT * FROM t2 ORDER BY c1;
1842 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
1843 SELECT * FROM t2 ORDER BY c1;
1847 DELETE FROM t2 WHERE c1 = sf1(1);
1848 SELECT * FROM t2 ORDER BY c1;
1853 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1854 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1855 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1856 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL MODIFIES SQL DATA SQL SECURITY INVOKER
1858 DECLARE ret INT DEFAULT 0;
1859 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
1862 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
1863 SELECT * FROM t2 ORDER BY c1;
1867 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
1868 SELECT * FROM t2 ORDER BY c1;
1872 DELETE FROM t2 WHERE c1 = sf1(1);
1873 SELECT * FROM t2 ORDER BY c1;
1878 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1879 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1880 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1881 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL SQL SECURITY INVOKER COMMENT 'comment'
1883 DECLARE ret INT DEFAULT 0;
1884 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
1887 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
1888 SELECT * FROM t2 ORDER BY c1;
1892 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
1893 SELECT * FROM t2 ORDER BY c1;
1897 DELETE FROM t2 WHERE c1 = sf1(1);
1898 SELECT * FROM t2 ORDER BY c1;
1903 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1904 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1905 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1906 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL CONTAINS SQL SQL SECURITY INVOKER COMMENT 'comment'
1908 DECLARE ret INT DEFAULT 0;
1909 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
1912 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
1913 SELECT * FROM t2 ORDER BY c1;
1917 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
1918 SELECT * FROM t2 ORDER BY c1;
1922 DELETE FROM t2 WHERE c1 = sf1(1);
1923 SELECT * FROM t2 ORDER BY c1;
1928 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1929 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1930 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1931 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL NO SQL SQL SECURITY INVOKER COMMENT 'comment'
1933 DECLARE ret INT DEFAULT 0;
1934 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
1937 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
1938 SELECT * FROM t2 ORDER BY c1;
1942 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
1943 SELECT * FROM t2 ORDER BY c1;
1947 DELETE FROM t2 WHERE c1 = sf1(1);
1948 SELECT * FROM t2 ORDER BY c1;
1953 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1954 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1955 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1956 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL READS SQL DATA SQL SECURITY INVOKER COMMENT 'comment'
1958 DECLARE ret INT DEFAULT 0;
1959 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
1962 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
1963 SELECT * FROM t2 ORDER BY c1;
1967 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
1968 SELECT * FROM t2 ORDER BY c1;
1972 DELETE FROM t2 WHERE c1 = sf1(1);
1973 SELECT * FROM t2 ORDER BY c1;
1978 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1979 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
1980 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
1981 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL MODIFIES SQL DATA SQL SECURITY INVOKER COMMENT 'comment'
1983 DECLARE ret INT DEFAULT 0;
1984 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
1987 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
1988 SELECT * FROM t2 ORDER BY c1;
1992 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
1993 SELECT * FROM t2 ORDER BY c1;
1997 DELETE FROM t2 WHERE c1 = sf1(1);
1998 SELECT * FROM t2 ORDER BY c1;
2003 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2004 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
2005 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2006 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT NOT DETERMINISTIC SQL SECURITY INVOKER
2008 DECLARE ret INT DEFAULT 0;
2009 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
2012 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
2013 SELECT * FROM t2 ORDER BY c1;
2017 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
2018 SELECT * FROM t2 ORDER BY c1;
2022 DELETE FROM t2 WHERE c1 = sf1(1);
2023 SELECT * FROM t2 ORDER BY c1;
2028 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2029 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
2030 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2031 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT NOT DETERMINISTIC CONTAINS SQL SQL SECURITY INVOKER
2033 DECLARE ret INT DEFAULT 0;
2034 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
2037 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
2038 SELECT * FROM t2 ORDER BY c1;
2042 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
2043 SELECT * FROM t2 ORDER BY c1;
2047 DELETE FROM t2 WHERE c1 = sf1(1);
2048 SELECT * FROM t2 ORDER BY c1;
2053 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2054 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
2055 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2056 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT NOT DETERMINISTIC NO SQL SQL SECURITY INVOKER
2058 DECLARE ret INT DEFAULT 0;
2059 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
2062 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
2063 SELECT * FROM t2 ORDER BY c1;
2067 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
2068 SELECT * FROM t2 ORDER BY c1;
2072 DELETE FROM t2 WHERE c1 = sf1(1);
2073 SELECT * FROM t2 ORDER BY c1;
2078 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2079 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
2080 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2081 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT NOT DETERMINISTIC READS SQL DATA SQL SECURITY INVOKER
2083 DECLARE ret INT DEFAULT 0;
2084 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
2087 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
2088 SELECT * FROM t2 ORDER BY c1;
2092 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
2093 SELECT * FROM t2 ORDER BY c1;
2097 DELETE FROM t2 WHERE c1 = sf1(1);
2098 SELECT * FROM t2 ORDER BY c1;
2103 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2104 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
2105 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2106 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT NOT DETERMINISTIC MODIFIES SQL DATA SQL SECURITY INVOKER
2108 DECLARE ret INT DEFAULT 0;
2109 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
2112 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
2113 SELECT * FROM t2 ORDER BY c1;
2117 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
2118 SELECT * FROM t2 ORDER BY c1;
2122 DELETE FROM t2 WHERE c1 = sf1(1);
2123 SELECT * FROM t2 ORDER BY c1;
2128 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2129 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
2130 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2131 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT NOT DETERMINISTIC SQL SECURITY INVOKER COMMENT 'comment'
2133 DECLARE ret INT DEFAULT 0;
2134 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
2137 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
2138 SELECT * FROM t2 ORDER BY c1;
2142 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
2143 SELECT * FROM t2 ORDER BY c1;
2147 DELETE FROM t2 WHERE c1 = sf1(1);
2148 SELECT * FROM t2 ORDER BY c1;
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 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT NOT DETERMINISTIC CONTAINS SQL SQL SECURITY INVOKER COMMENT 'comment'
2158 DECLARE ret INT DEFAULT 0;
2159 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
2162 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
2163 SELECT * FROM t2 ORDER BY c1;
2167 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
2168 SELECT * FROM t2 ORDER BY c1;
2172 DELETE FROM t2 WHERE c1 = sf1(1);
2173 SELECT * FROM t2 ORDER BY c1;
2178 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2179 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
2180 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2181 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT NOT DETERMINISTIC NO SQL SQL SECURITY INVOKER COMMENT 'comment'
2183 DECLARE ret INT DEFAULT 0;
2184 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
2187 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
2188 SELECT * FROM t2 ORDER BY c1;
2192 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
2193 SELECT * FROM t2 ORDER BY c1;
2197 DELETE FROM t2 WHERE c1 = sf1(1);
2198 SELECT * FROM t2 ORDER BY c1;
2203 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2204 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
2205 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2206 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT NOT DETERMINISTIC READS SQL DATA SQL SECURITY INVOKER COMMENT 'comment'
2208 DECLARE ret INT DEFAULT 0;
2209 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
2212 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
2213 SELECT * FROM t2 ORDER BY c1;
2217 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
2218 SELECT * FROM t2 ORDER BY c1;
2222 DELETE FROM t2 WHERE c1 = sf1(1);
2223 SELECT * FROM t2 ORDER BY c1;
2228 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2229 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
2230 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2231 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT NOT DETERMINISTIC MODIFIES SQL DATA SQL SECURITY INVOKER COMMENT 'comment'
2233 DECLARE ret INT DEFAULT 0;
2234 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
2237 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
2238 SELECT * FROM t2 ORDER BY c1;
2242 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
2243 SELECT * FROM t2 ORDER BY c1;
2247 DELETE FROM t2 WHERE c1 = sf1(1);
2248 SELECT * FROM t2 ORDER BY c1;
2253 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2254 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
2255 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2256 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL NOT DETERMINISTIC SQL SECURITY INVOKER
2258 DECLARE ret INT DEFAULT 0;
2259 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
2262 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
2263 SELECT * FROM t2 ORDER BY c1;
2267 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
2268 SELECT * FROM t2 ORDER BY c1;
2272 DELETE FROM t2 WHERE c1 = sf1(1);
2273 SELECT * FROM t2 ORDER BY c1;
2278 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2279 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
2280 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2281 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL NOT DETERMINISTIC CONTAINS SQL SQL SECURITY INVOKER
2283 DECLARE ret INT DEFAULT 0;
2284 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
2287 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
2288 SELECT * FROM t2 ORDER BY c1;
2292 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
2293 SELECT * FROM t2 ORDER BY c1;
2297 DELETE FROM t2 WHERE c1 = sf1(1);
2298 SELECT * FROM t2 ORDER BY c1;
2303 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2304 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
2305 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2306 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL NOT DETERMINISTIC NO SQL SQL SECURITY INVOKER
2308 DECLARE ret INT DEFAULT 0;
2309 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
2312 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
2313 SELECT * FROM t2 ORDER BY c1;
2317 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
2318 SELECT * FROM t2 ORDER BY c1;
2322 DELETE FROM t2 WHERE c1 = sf1(1);
2323 SELECT * FROM t2 ORDER BY c1;
2328 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2329 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
2330 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2331 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL NOT DETERMINISTIC READS SQL DATA SQL SECURITY INVOKER
2333 DECLARE ret INT DEFAULT 0;
2334 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
2337 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
2338 SELECT * FROM t2 ORDER BY c1;
2342 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
2343 SELECT * FROM t2 ORDER BY c1;
2347 DELETE FROM t2 WHERE c1 = sf1(1);
2348 SELECT * FROM t2 ORDER BY c1;
2353 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2354 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
2355 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2356 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL NOT DETERMINISTIC MODIFIES SQL DATA SQL SECURITY INVOKER
2358 DECLARE ret INT DEFAULT 0;
2359 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
2362 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
2363 SELECT * FROM t2 ORDER BY c1;
2367 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
2368 SELECT * FROM t2 ORDER BY c1;
2372 DELETE FROM t2 WHERE c1 = sf1(1);
2373 SELECT * FROM t2 ORDER BY c1;
2378 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2379 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
2380 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2381 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL NOT DETERMINISTIC SQL SECURITY INVOKER COMMENT 'comment'
2383 DECLARE ret INT DEFAULT 0;
2384 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
2387 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
2388 SELECT * FROM t2 ORDER BY c1;
2392 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
2393 SELECT * FROM t2 ORDER BY c1;
2397 DELETE FROM t2 WHERE c1 = sf1(1);
2398 SELECT * FROM t2 ORDER BY c1;
2403 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2404 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
2405 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2406 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL NOT DETERMINISTIC CONTAINS SQL SQL SECURITY INVOKER COMMENT 'comment'
2408 DECLARE ret INT DEFAULT 0;
2409 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
2412 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
2413 SELECT * FROM t2 ORDER BY c1;
2417 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
2418 SELECT * FROM t2 ORDER BY c1;
2422 DELETE FROM t2 WHERE c1 = sf1(1);
2423 SELECT * FROM t2 ORDER BY c1;
2428 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2429 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
2430 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2431 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL NOT DETERMINISTIC NO SQL SQL SECURITY INVOKER COMMENT 'comment'
2433 DECLARE ret INT DEFAULT 0;
2434 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
2437 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
2438 SELECT * FROM t2 ORDER BY c1;
2442 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
2443 SELECT * FROM t2 ORDER BY c1;
2447 DELETE FROM t2 WHERE c1 = sf1(1);
2448 SELECT * FROM t2 ORDER BY c1;
2453 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2454 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
2455 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2456 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL NOT DETERMINISTIC READS SQL DATA SQL SECURITY INVOKER COMMENT 'comment'
2458 DECLARE ret INT DEFAULT 0;
2459 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
2462 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
2463 SELECT * FROM t2 ORDER BY c1;
2467 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
2468 SELECT * FROM t2 ORDER BY c1;
2472 DELETE FROM t2 WHERE c1 = sf1(1);
2473 SELECT * FROM t2 ORDER BY c1;
2478 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2479 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
2480 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2481 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL NOT DETERMINISTIC MODIFIES SQL DATA SQL SECURITY INVOKER COMMENT 'comment'
2483 DECLARE ret INT DEFAULT 0;
2484 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
2487 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
2488 SELECT * FROM t2 ORDER BY c1;
2492 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
2493 SELECT * FROM t2 ORDER BY c1;
2497 DELETE FROM t2 WHERE c1 = sf1(1);
2498 SELECT * FROM t2 ORDER BY c1;
2503 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2504 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
2505 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2506 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT DETERMINISTIC SQL SECURITY INVOKER
2508 DECLARE ret INT DEFAULT 0;
2509 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
2512 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
2513 SELECT * FROM t2 ORDER BY c1;
2517 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
2518 SELECT * FROM t2 ORDER BY c1;
2522 DELETE FROM t2 WHERE c1 = sf1(1);
2523 SELECT * FROM t2 ORDER BY c1;
2528 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2529 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
2530 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2531 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT DETERMINISTIC CONTAINS SQL SQL SECURITY INVOKER
2533 DECLARE ret INT DEFAULT 0;
2534 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
2537 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
2538 SELECT * FROM t2 ORDER BY c1;
2542 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
2543 SELECT * FROM t2 ORDER BY c1;
2547 DELETE FROM t2 WHERE c1 = sf1(1);
2548 SELECT * FROM t2 ORDER BY c1;
2553 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2554 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
2555 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2556 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT DETERMINISTIC NO SQL SQL SECURITY INVOKER
2558 DECLARE ret INT DEFAULT 0;
2559 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
2562 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
2563 SELECT * FROM t2 ORDER BY c1;
2567 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
2568 SELECT * FROM t2 ORDER BY c1;
2572 DELETE FROM t2 WHERE c1 = sf1(1);
2573 SELECT * FROM t2 ORDER BY c1;
2578 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2579 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
2580 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2581 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT DETERMINISTIC READS SQL DATA SQL SECURITY INVOKER
2583 DECLARE ret INT DEFAULT 0;
2584 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
2587 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
2588 SELECT * FROM t2 ORDER BY c1;
2592 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
2593 SELECT * FROM t2 ORDER BY c1;
2597 DELETE FROM t2 WHERE c1 = sf1(1);
2598 SELECT * FROM t2 ORDER BY c1;
2603 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2604 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
2605 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2606 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT DETERMINISTIC MODIFIES SQL DATA SQL SECURITY INVOKER
2608 DECLARE ret INT DEFAULT 0;
2609 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
2612 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
2613 SELECT * FROM t2 ORDER BY c1;
2617 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
2618 SELECT * FROM t2 ORDER BY c1;
2622 DELETE FROM t2 WHERE c1 = sf1(1);
2623 SELECT * FROM t2 ORDER BY c1;
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 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT DETERMINISTIC SQL SECURITY INVOKER COMMENT 'comment'
2633 DECLARE ret INT DEFAULT 0;
2634 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
2637 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
2638 SELECT * FROM t2 ORDER BY c1;
2642 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
2643 SELECT * FROM t2 ORDER BY c1;
2647 DELETE FROM t2 WHERE c1 = sf1(1);
2648 SELECT * FROM t2 ORDER BY c1;
2653 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2654 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
2655 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2656 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT DETERMINISTIC CONTAINS SQL SQL SECURITY INVOKER COMMENT 'comment'
2658 DECLARE ret INT DEFAULT 0;
2659 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
2662 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
2663 SELECT * FROM t2 ORDER BY c1;
2667 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
2668 SELECT * FROM t2 ORDER BY c1;
2672 DELETE FROM t2 WHERE c1 = sf1(1);
2673 SELECT * FROM t2 ORDER BY c1;
2678 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2679 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
2680 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2681 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT DETERMINISTIC NO SQL SQL SECURITY INVOKER COMMENT 'comment'
2683 DECLARE ret INT DEFAULT 0;
2684 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
2687 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
2688 SELECT * FROM t2 ORDER BY c1;
2692 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
2693 SELECT * FROM t2 ORDER BY c1;
2697 DELETE FROM t2 WHERE c1 = sf1(1);
2698 SELECT * FROM t2 ORDER BY c1;
2703 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2704 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
2705 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2706 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT DETERMINISTIC READS SQL DATA SQL SECURITY INVOKER COMMENT 'comment'
2708 DECLARE ret INT DEFAULT 0;
2709 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
2712 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
2713 SELECT * FROM t2 ORDER BY c1;
2717 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
2718 SELECT * FROM t2 ORDER BY c1;
2722 DELETE FROM t2 WHERE c1 = sf1(1);
2723 SELECT * FROM t2 ORDER BY c1;
2728 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2729 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
2730 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2731 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT DETERMINISTIC MODIFIES SQL DATA SQL SECURITY INVOKER COMMENT 'comment'
2733 DECLARE ret INT DEFAULT 0;
2734 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
2737 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
2738 SELECT * FROM t2 ORDER BY c1;
2742 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
2743 SELECT * FROM t2 ORDER BY c1;
2747 DELETE FROM t2 WHERE c1 = sf1(1);
2748 SELECT * FROM t2 ORDER BY c1;
2753 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2754 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
2755 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2756 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL DETERMINISTIC SQL SECURITY INVOKER
2758 DECLARE ret INT DEFAULT 0;
2759 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
2762 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
2763 SELECT * FROM t2 ORDER BY c1;
2767 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
2768 SELECT * FROM t2 ORDER BY c1;
2772 DELETE FROM t2 WHERE c1 = sf1(1);
2773 SELECT * FROM t2 ORDER BY c1;
2778 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2779 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
2780 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2781 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL DETERMINISTIC CONTAINS SQL SQL SECURITY INVOKER
2783 DECLARE ret INT DEFAULT 0;
2784 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
2787 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
2788 SELECT * FROM t2 ORDER BY c1;
2792 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
2793 SELECT * FROM t2 ORDER BY c1;
2797 DELETE FROM t2 WHERE c1 = sf1(1);
2798 SELECT * FROM t2 ORDER BY c1;
2803 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2804 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
2805 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2806 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL DETERMINISTIC NO SQL SQL SECURITY INVOKER
2808 DECLARE ret INT DEFAULT 0;
2809 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
2812 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
2813 SELECT * FROM t2 ORDER BY c1;
2817 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
2818 SELECT * FROM t2 ORDER BY c1;
2822 DELETE FROM t2 WHERE c1 = sf1(1);
2823 SELECT * FROM t2 ORDER BY c1;
2828 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2829 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
2830 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2831 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL DETERMINISTIC READS SQL DATA SQL SECURITY INVOKER
2833 DECLARE ret INT DEFAULT 0;
2834 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
2837 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
2838 SELECT * FROM t2 ORDER BY c1;
2842 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
2843 SELECT * FROM t2 ORDER BY c1;
2847 DELETE FROM t2 WHERE c1 = sf1(1);
2848 SELECT * FROM t2 ORDER BY c1;
2853 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2854 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
2855 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2856 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL DETERMINISTIC MODIFIES SQL DATA SQL SECURITY INVOKER
2858 DECLARE ret INT DEFAULT 0;
2859 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
2862 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
2863 SELECT * FROM t2 ORDER BY c1;
2867 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
2868 SELECT * FROM t2 ORDER BY c1;
2872 DELETE FROM t2 WHERE c1 = sf1(1);
2873 SELECT * FROM t2 ORDER BY c1;
2878 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2879 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
2880 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2881 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL DETERMINISTIC SQL SECURITY INVOKER COMMENT 'comment'
2883 DECLARE ret INT DEFAULT 0;
2884 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
2887 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
2888 SELECT * FROM t2 ORDER BY c1;
2892 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
2893 SELECT * FROM t2 ORDER BY c1;
2897 DELETE FROM t2 WHERE c1 = sf1(1);
2898 SELECT * FROM t2 ORDER BY c1;
2903 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2904 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
2905 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2906 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL DETERMINISTIC CONTAINS SQL SQL SECURITY INVOKER COMMENT 'comment'
2908 DECLARE ret INT DEFAULT 0;
2909 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
2912 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
2913 SELECT * FROM t2 ORDER BY c1;
2917 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
2918 SELECT * FROM t2 ORDER BY c1;
2922 DELETE FROM t2 WHERE c1 = sf1(1);
2923 SELECT * FROM t2 ORDER BY c1;
2928 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2929 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
2930 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2931 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL DETERMINISTIC NO SQL SQL SECURITY INVOKER COMMENT 'comment'
2933 DECLARE ret INT DEFAULT 0;
2934 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
2937 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
2938 SELECT * FROM t2 ORDER BY c1;
2942 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
2943 SELECT * FROM t2 ORDER BY c1;
2947 DELETE FROM t2 WHERE c1 = sf1(1);
2948 SELECT * FROM t2 ORDER BY c1;
2953 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2954 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
2955 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2956 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL DETERMINISTIC READS SQL DATA SQL SECURITY INVOKER COMMENT 'comment'
2958 DECLARE ret INT DEFAULT 0;
2959 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
2962 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
2963 SELECT * FROM t2 ORDER BY c1;
2967 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
2968 SELECT * FROM t2 ORDER BY c1;
2972 DELETE FROM t2 WHERE c1 = sf1(1);
2973 SELECT * FROM t2 ORDER BY c1;
2978 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2979 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
2980 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
2981 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL DETERMINISTIC MODIFIES SQL DATA SQL SECURITY INVOKER COMMENT 'comment'
2983 DECLARE ret INT DEFAULT 0;
2984 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
2987 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
2988 SELECT * FROM t2 ORDER BY c1;
2992 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
2993 SELECT * FROM t2 ORDER BY c1;
2997 DELETE FROM t2 WHERE c1 = sf1(1);
2998 SELECT * FROM t2 ORDER BY c1;
3003 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3004 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
3005 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3006 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT SQL SECURITY DEFINER
3008 DECLARE ret INT DEFAULT 0;
3009 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
3012 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
3013 SELECT * FROM t2 ORDER BY c1;
3017 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
3018 SELECT * FROM t2 ORDER BY c1;
3022 DELETE FROM t2 WHERE c1 = sf1(1);
3023 SELECT * FROM t2 ORDER BY c1;
3028 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3029 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
3030 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3031 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT CONTAINS SQL SQL SECURITY DEFINER
3033 DECLARE ret INT DEFAULT 0;
3034 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
3037 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
3038 SELECT * FROM t2 ORDER BY c1;
3042 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
3043 SELECT * FROM t2 ORDER BY c1;
3047 DELETE FROM t2 WHERE c1 = sf1(1);
3048 SELECT * FROM t2 ORDER BY c1;
3053 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3054 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
3055 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3056 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT NO SQL SQL SECURITY DEFINER
3058 DECLARE ret INT DEFAULT 0;
3059 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
3062 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
3063 SELECT * FROM t2 ORDER BY c1;
3067 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
3068 SELECT * FROM t2 ORDER BY c1;
3072 DELETE FROM t2 WHERE c1 = sf1(1);
3073 SELECT * FROM t2 ORDER BY c1;
3078 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3079 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
3080 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3081 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT READS SQL DATA SQL SECURITY DEFINER
3083 DECLARE ret INT DEFAULT 0;
3084 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
3087 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
3088 SELECT * FROM t2 ORDER BY c1;
3092 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
3093 SELECT * FROM t2 ORDER BY c1;
3097 DELETE FROM t2 WHERE c1 = sf1(1);
3098 SELECT * FROM t2 ORDER BY c1;
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 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT MODIFIES SQL DATA SQL SECURITY DEFINER
3108 DECLARE ret INT DEFAULT 0;
3109 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
3112 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
3113 SELECT * FROM t2 ORDER BY c1;
3117 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
3118 SELECT * FROM t2 ORDER BY c1;
3122 DELETE FROM t2 WHERE c1 = sf1(1);
3123 SELECT * FROM t2 ORDER BY c1;
3128 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3129 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
3130 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3131 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT SQL SECURITY DEFINER COMMENT 'comment'
3133 DECLARE ret INT DEFAULT 0;
3134 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
3137 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
3138 SELECT * FROM t2 ORDER BY c1;
3142 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
3143 SELECT * FROM t2 ORDER BY c1;
3147 DELETE FROM t2 WHERE c1 = sf1(1);
3148 SELECT * FROM t2 ORDER BY c1;
3153 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3154 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
3155 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3156 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT CONTAINS SQL SQL SECURITY DEFINER COMMENT 'comment'
3158 DECLARE ret INT DEFAULT 0;
3159 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
3162 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
3163 SELECT * FROM t2 ORDER BY c1;
3167 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
3168 SELECT * FROM t2 ORDER BY c1;
3172 DELETE FROM t2 WHERE c1 = sf1(1);
3173 SELECT * FROM t2 ORDER BY c1;
3178 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3179 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
3180 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3181 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT NO SQL SQL SECURITY DEFINER COMMENT 'comment'
3183 DECLARE ret INT DEFAULT 0;
3184 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
3187 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
3188 SELECT * FROM t2 ORDER BY c1;
3192 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
3193 SELECT * FROM t2 ORDER BY c1;
3197 DELETE FROM t2 WHERE c1 = sf1(1);
3198 SELECT * FROM t2 ORDER BY c1;
3203 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3204 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
3205 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3206 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT READS SQL DATA SQL SECURITY DEFINER COMMENT 'comment'
3208 DECLARE ret INT DEFAULT 0;
3209 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
3212 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
3213 SELECT * FROM t2 ORDER BY c1;
3217 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
3218 SELECT * FROM t2 ORDER BY c1;
3222 DELETE FROM t2 WHERE c1 = sf1(1);
3223 SELECT * FROM t2 ORDER BY c1;
3228 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3229 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
3230 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3231 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT MODIFIES SQL DATA SQL SECURITY DEFINER COMMENT 'comment'
3233 DECLARE ret INT DEFAULT 0;
3234 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
3237 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
3238 SELECT * FROM t2 ORDER BY c1;
3242 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
3243 SELECT * FROM t2 ORDER BY c1;
3247 DELETE FROM t2 WHERE c1 = sf1(1);
3248 SELECT * FROM t2 ORDER BY c1;
3253 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3254 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
3255 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3256 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL SQL SECURITY DEFINER
3258 DECLARE ret INT DEFAULT 0;
3259 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
3262 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
3263 SELECT * FROM t2 ORDER BY c1;
3267 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
3268 SELECT * FROM t2 ORDER BY c1;
3272 DELETE FROM t2 WHERE c1 = sf1(1);
3273 SELECT * FROM t2 ORDER BY c1;
3278 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3279 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
3280 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3281 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL CONTAINS SQL SQL SECURITY DEFINER
3283 DECLARE ret INT DEFAULT 0;
3284 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
3287 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
3288 SELECT * FROM t2 ORDER BY c1;
3292 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
3293 SELECT * FROM t2 ORDER BY c1;
3297 DELETE FROM t2 WHERE c1 = sf1(1);
3298 SELECT * FROM t2 ORDER BY c1;
3303 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3304 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
3305 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3306 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL NO SQL SQL SECURITY DEFINER
3308 DECLARE ret INT DEFAULT 0;
3309 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
3312 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
3313 SELECT * FROM t2 ORDER BY c1;
3317 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
3318 SELECT * FROM t2 ORDER BY c1;
3322 DELETE FROM t2 WHERE c1 = sf1(1);
3323 SELECT * FROM t2 ORDER BY c1;
3328 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3329 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
3330 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3331 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL READS SQL DATA SQL SECURITY DEFINER
3333 DECLARE ret INT DEFAULT 0;
3334 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
3337 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
3338 SELECT * FROM t2 ORDER BY c1;
3342 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
3343 SELECT * FROM t2 ORDER BY c1;
3347 DELETE FROM t2 WHERE c1 = sf1(1);
3348 SELECT * FROM t2 ORDER BY c1;
3353 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3354 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
3355 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3356 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL MODIFIES SQL DATA SQL SECURITY DEFINER
3358 DECLARE ret INT DEFAULT 0;
3359 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
3362 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
3363 SELECT * FROM t2 ORDER BY c1;
3367 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
3368 SELECT * FROM t2 ORDER BY c1;
3372 DELETE FROM t2 WHERE c1 = sf1(1);
3373 SELECT * FROM t2 ORDER BY c1;
3378 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3379 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
3380 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3381 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL SQL SECURITY DEFINER COMMENT 'comment'
3383 DECLARE ret INT DEFAULT 0;
3384 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
3387 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
3388 SELECT * FROM t2 ORDER BY c1;
3392 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
3393 SELECT * FROM t2 ORDER BY c1;
3397 DELETE FROM t2 WHERE c1 = sf1(1);
3398 SELECT * FROM t2 ORDER BY c1;
3403 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3404 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
3405 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3406 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL CONTAINS SQL SQL SECURITY DEFINER COMMENT 'comment'
3408 DECLARE ret INT DEFAULT 0;
3409 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
3412 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
3413 SELECT * FROM t2 ORDER BY c1;
3417 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
3418 SELECT * FROM t2 ORDER BY c1;
3422 DELETE FROM t2 WHERE c1 = sf1(1);
3423 SELECT * FROM t2 ORDER BY c1;
3428 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3429 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
3430 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3431 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL NO SQL SQL SECURITY DEFINER COMMENT 'comment'
3433 DECLARE ret INT DEFAULT 0;
3434 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
3437 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
3438 SELECT * FROM t2 ORDER BY c1;
3442 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
3443 SELECT * FROM t2 ORDER BY c1;
3447 DELETE FROM t2 WHERE c1 = sf1(1);
3448 SELECT * FROM t2 ORDER BY c1;
3453 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3454 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
3455 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3456 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL READS SQL DATA SQL SECURITY DEFINER COMMENT 'comment'
3458 DECLARE ret INT DEFAULT 0;
3459 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
3462 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
3463 SELECT * FROM t2 ORDER BY c1;
3467 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
3468 SELECT * FROM t2 ORDER BY c1;
3472 DELETE FROM t2 WHERE c1 = sf1(1);
3473 SELECT * FROM t2 ORDER BY c1;
3478 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3479 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
3480 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3481 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL MODIFIES SQL DATA SQL SECURITY DEFINER COMMENT 'comment'
3483 DECLARE ret INT DEFAULT 0;
3484 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
3487 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
3488 SELECT * FROM t2 ORDER BY c1;
3492 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
3493 SELECT * FROM t2 ORDER BY c1;
3497 DELETE FROM t2 WHERE c1 = sf1(1);
3498 SELECT * FROM t2 ORDER BY c1;
3503 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3504 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
3505 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3506 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT NOT DETERMINISTIC SQL SECURITY DEFINER
3508 DECLARE ret INT DEFAULT 0;
3509 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
3512 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
3513 SELECT * FROM t2 ORDER BY c1;
3517 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
3518 SELECT * FROM t2 ORDER BY c1;
3522 DELETE FROM t2 WHERE c1 = sf1(1);
3523 SELECT * FROM t2 ORDER BY c1;
3528 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3529 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
3530 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3531 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT NOT DETERMINISTIC CONTAINS SQL SQL SECURITY DEFINER
3533 DECLARE ret INT DEFAULT 0;
3534 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
3537 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
3538 SELECT * FROM t2 ORDER BY c1;
3542 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
3543 SELECT * FROM t2 ORDER BY c1;
3547 DELETE FROM t2 WHERE c1 = sf1(1);
3548 SELECT * FROM t2 ORDER BY c1;
3553 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3554 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
3555 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3556 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT NOT DETERMINISTIC NO SQL SQL SECURITY DEFINER
3558 DECLARE ret INT DEFAULT 0;
3559 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
3562 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
3563 SELECT * FROM t2 ORDER BY c1;
3567 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
3568 SELECT * FROM t2 ORDER BY c1;
3572 DELETE FROM t2 WHERE c1 = sf1(1);
3573 SELECT * FROM t2 ORDER BY c1;
3578 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3579 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
3580 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3581 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT NOT DETERMINISTIC READS SQL DATA SQL SECURITY DEFINER
3583 DECLARE ret INT DEFAULT 0;
3584 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
3587 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
3588 SELECT * FROM t2 ORDER BY c1;
3592 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
3593 SELECT * FROM t2 ORDER BY c1;
3597 DELETE FROM t2 WHERE c1 = sf1(1);
3598 SELECT * FROM t2 ORDER BY c1;
3603 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3604 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
3605 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3606 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT NOT DETERMINISTIC MODIFIES SQL DATA SQL SECURITY DEFINER
3608 DECLARE ret INT DEFAULT 0;
3609 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
3612 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
3613 SELECT * FROM t2 ORDER BY c1;
3617 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
3618 SELECT * FROM t2 ORDER BY c1;
3622 DELETE FROM t2 WHERE c1 = sf1(1);
3623 SELECT * FROM t2 ORDER BY c1;
3628 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3629 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
3630 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3631 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT NOT DETERMINISTIC SQL SECURITY DEFINER COMMENT 'comment'
3633 DECLARE ret INT DEFAULT 0;
3634 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
3637 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
3638 SELECT * FROM t2 ORDER BY c1;
3642 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
3643 SELECT * FROM t2 ORDER BY c1;
3647 DELETE FROM t2 WHERE c1 = sf1(1);
3648 SELECT * FROM t2 ORDER BY c1;
3653 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3654 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
3655 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3656 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT NOT DETERMINISTIC CONTAINS SQL SQL SECURITY DEFINER COMMENT 'comment'
3658 DECLARE ret INT DEFAULT 0;
3659 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
3662 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
3663 SELECT * FROM t2 ORDER BY c1;
3667 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
3668 SELECT * FROM t2 ORDER BY c1;
3672 DELETE FROM t2 WHERE c1 = sf1(1);
3673 SELECT * FROM t2 ORDER BY c1;
3678 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3679 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
3680 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3681 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT NOT DETERMINISTIC NO SQL SQL SECURITY DEFINER COMMENT 'comment'
3683 DECLARE ret INT DEFAULT 0;
3684 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
3687 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
3688 SELECT * FROM t2 ORDER BY c1;
3692 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
3693 SELECT * FROM t2 ORDER BY c1;
3697 DELETE FROM t2 WHERE c1 = sf1(1);
3698 SELECT * FROM t2 ORDER BY c1;
3703 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3704 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
3705 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3706 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT NOT DETERMINISTIC READS SQL DATA SQL SECURITY DEFINER COMMENT 'comment'
3708 DECLARE ret INT DEFAULT 0;
3709 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
3712 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
3713 SELECT * FROM t2 ORDER BY c1;
3717 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
3718 SELECT * FROM t2 ORDER BY c1;
3722 DELETE FROM t2 WHERE c1 = sf1(1);
3723 SELECT * FROM t2 ORDER BY c1;
3728 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3729 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
3730 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3731 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT NOT DETERMINISTIC MODIFIES SQL DATA SQL SECURITY DEFINER COMMENT 'comment'
3733 DECLARE ret INT DEFAULT 0;
3734 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
3737 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
3738 SELECT * FROM t2 ORDER BY c1;
3742 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
3743 SELECT * FROM t2 ORDER BY c1;
3747 DELETE FROM t2 WHERE c1 = sf1(1);
3748 SELECT * FROM t2 ORDER BY c1;
3753 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3754 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
3755 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3756 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL NOT DETERMINISTIC SQL SECURITY DEFINER
3758 DECLARE ret INT DEFAULT 0;
3759 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
3762 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
3763 SELECT * FROM t2 ORDER BY c1;
3767 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
3768 SELECT * FROM t2 ORDER BY c1;
3772 DELETE FROM t2 WHERE c1 = sf1(1);
3773 SELECT * FROM t2 ORDER BY c1;
3778 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3779 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
3780 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3781 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL NOT DETERMINISTIC CONTAINS SQL SQL SECURITY DEFINER
3783 DECLARE ret INT DEFAULT 0;
3784 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
3787 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
3788 SELECT * FROM t2 ORDER BY c1;
3792 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
3793 SELECT * FROM t2 ORDER BY c1;
3797 DELETE FROM t2 WHERE c1 = sf1(1);
3798 SELECT * FROM t2 ORDER BY c1;
3803 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3804 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
3805 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3806 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL NOT DETERMINISTIC NO SQL SQL SECURITY DEFINER
3808 DECLARE ret INT DEFAULT 0;
3809 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
3812 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
3813 SELECT * FROM t2 ORDER BY c1;
3817 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
3818 SELECT * FROM t2 ORDER BY c1;
3822 DELETE FROM t2 WHERE c1 = sf1(1);
3823 SELECT * FROM t2 ORDER BY c1;
3828 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3829 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
3830 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3831 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL NOT DETERMINISTIC READS SQL DATA SQL SECURITY DEFINER
3833 DECLARE ret INT DEFAULT 0;
3834 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
3837 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
3838 SELECT * FROM t2 ORDER BY c1;
3842 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
3843 SELECT * FROM t2 ORDER BY c1;
3847 DELETE FROM t2 WHERE c1 = sf1(1);
3848 SELECT * FROM t2 ORDER BY c1;
3853 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3854 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
3855 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3856 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL NOT DETERMINISTIC MODIFIES SQL DATA SQL SECURITY DEFINER
3858 DECLARE ret INT DEFAULT 0;
3859 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
3862 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
3863 SELECT * FROM t2 ORDER BY c1;
3867 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
3868 SELECT * FROM t2 ORDER BY c1;
3872 DELETE FROM t2 WHERE c1 = sf1(1);
3873 SELECT * FROM t2 ORDER BY c1;
3878 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3879 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
3880 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3881 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL NOT DETERMINISTIC SQL SECURITY DEFINER COMMENT 'comment'
3883 DECLARE ret INT DEFAULT 0;
3884 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
3887 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
3888 SELECT * FROM t2 ORDER BY c1;
3892 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
3893 SELECT * FROM t2 ORDER BY c1;
3897 DELETE FROM t2 WHERE c1 = sf1(1);
3898 SELECT * FROM t2 ORDER BY c1;
3903 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3904 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
3905 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3906 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL NOT DETERMINISTIC CONTAINS SQL SQL SECURITY DEFINER COMMENT 'comment'
3908 DECLARE ret INT DEFAULT 0;
3909 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
3912 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
3913 SELECT * FROM t2 ORDER BY c1;
3917 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
3918 SELECT * FROM t2 ORDER BY c1;
3922 DELETE FROM t2 WHERE c1 = sf1(1);
3923 SELECT * FROM t2 ORDER BY c1;
3928 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3929 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
3930 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3931 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL NOT DETERMINISTIC NO SQL SQL SECURITY DEFINER COMMENT 'comment'
3933 DECLARE ret INT DEFAULT 0;
3934 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
3937 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
3938 SELECT * FROM t2 ORDER BY c1;
3942 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
3943 SELECT * FROM t2 ORDER BY c1;
3947 DELETE FROM t2 WHERE c1 = sf1(1);
3948 SELECT * FROM t2 ORDER BY c1;
3953 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3954 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
3955 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3956 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL NOT DETERMINISTIC READS SQL DATA SQL SECURITY DEFINER COMMENT 'comment'
3958 DECLARE ret INT DEFAULT 0;
3959 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
3962 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
3963 SELECT * FROM t2 ORDER BY c1;
3967 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
3968 SELECT * FROM t2 ORDER BY c1;
3972 DELETE FROM t2 WHERE c1 = sf1(1);
3973 SELECT * FROM t2 ORDER BY c1;
3978 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3979 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
3980 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3981 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL NOT DETERMINISTIC MODIFIES SQL DATA SQL SECURITY DEFINER COMMENT 'comment'
3983 DECLARE ret INT DEFAULT 0;
3984 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
3987 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
3988 SELECT * FROM t2 ORDER BY c1;
3992 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
3993 SELECT * FROM t2 ORDER BY c1;
3997 DELETE FROM t2 WHERE c1 = sf1(1);
3998 SELECT * FROM t2 ORDER BY c1;
4003 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
4004 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
4005 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
4006 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT DETERMINISTIC SQL SECURITY DEFINER
4008 DECLARE ret INT DEFAULT 0;
4009 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
4012 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
4013 SELECT * FROM t2 ORDER BY c1;
4017 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
4018 SELECT * FROM t2 ORDER BY c1;
4022 DELETE FROM t2 WHERE c1 = sf1(1);
4023 SELECT * FROM t2 ORDER BY c1;
4028 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
4029 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
4030 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
4031 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT DETERMINISTIC CONTAINS SQL SQL SECURITY DEFINER
4033 DECLARE ret INT DEFAULT 0;
4034 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
4037 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
4038 SELECT * FROM t2 ORDER BY c1;
4042 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
4043 SELECT * FROM t2 ORDER BY c1;
4047 DELETE FROM t2 WHERE c1 = sf1(1);
4048 SELECT * FROM t2 ORDER BY c1;
4053 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
4054 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
4055 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
4056 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT DETERMINISTIC NO SQL SQL SECURITY DEFINER
4058 DECLARE ret INT DEFAULT 0;
4059 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
4062 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
4063 SELECT * FROM t2 ORDER BY c1;
4067 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
4068 SELECT * FROM t2 ORDER BY c1;
4072 DELETE FROM t2 WHERE c1 = sf1(1);
4073 SELECT * FROM t2 ORDER BY c1;
4078 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
4079 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
4080 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
4081 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT DETERMINISTIC READS SQL DATA SQL SECURITY DEFINER
4083 DECLARE ret INT DEFAULT 0;
4084 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
4087 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
4088 SELECT * FROM t2 ORDER BY c1;
4092 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
4093 SELECT * FROM t2 ORDER BY c1;
4097 DELETE FROM t2 WHERE c1 = sf1(1);
4098 SELECT * FROM t2 ORDER BY c1;
4103 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
4104 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
4105 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
4106 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT DETERMINISTIC MODIFIES SQL DATA SQL SECURITY DEFINER
4108 DECLARE ret INT DEFAULT 0;
4109 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
4112 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
4113 SELECT * FROM t2 ORDER BY c1;
4117 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
4118 SELECT * FROM t2 ORDER BY c1;
4122 DELETE FROM t2 WHERE c1 = sf1(1);
4123 SELECT * FROM t2 ORDER BY c1;
4128 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
4129 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
4130 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
4131 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT DETERMINISTIC SQL SECURITY DEFINER COMMENT 'comment'
4133 DECLARE ret INT DEFAULT 0;
4134 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
4137 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
4138 SELECT * FROM t2 ORDER BY c1;
4142 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
4143 SELECT * FROM t2 ORDER BY c1;
4147 DELETE FROM t2 WHERE c1 = sf1(1);
4148 SELECT * FROM t2 ORDER BY c1;
4153 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
4154 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
4155 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
4156 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT DETERMINISTIC CONTAINS SQL SQL SECURITY DEFINER COMMENT 'comment'
4158 DECLARE ret INT DEFAULT 0;
4159 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
4162 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
4163 SELECT * FROM t2 ORDER BY c1;
4167 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
4168 SELECT * FROM t2 ORDER BY c1;
4172 DELETE FROM t2 WHERE c1 = sf1(1);
4173 SELECT * FROM t2 ORDER BY c1;
4178 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
4179 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
4180 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
4181 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT DETERMINISTIC NO SQL SQL SECURITY DEFINER COMMENT 'comment'
4183 DECLARE ret INT DEFAULT 0;
4184 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
4187 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
4188 SELECT * FROM t2 ORDER BY c1;
4192 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
4193 SELECT * FROM t2 ORDER BY c1;
4197 DELETE FROM t2 WHERE c1 = sf1(1);
4198 SELECT * FROM t2 ORDER BY c1;
4203 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
4204 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
4205 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
4206 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT DETERMINISTIC READS SQL DATA SQL SECURITY DEFINER COMMENT 'comment'
4208 DECLARE ret INT DEFAULT 0;
4209 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
4212 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
4213 SELECT * FROM t2 ORDER BY c1;
4217 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
4218 SELECT * FROM t2 ORDER BY c1;
4222 DELETE FROM t2 WHERE c1 = sf1(1);
4223 SELECT * FROM t2 ORDER BY c1;
4228 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
4229 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
4230 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
4231 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT DETERMINISTIC MODIFIES SQL DATA SQL SECURITY DEFINER COMMENT 'comment'
4233 DECLARE ret INT DEFAULT 0;
4234 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
4237 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
4238 SELECT * FROM t2 ORDER BY c1;
4242 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
4243 SELECT * FROM t2 ORDER BY c1;
4247 DELETE FROM t2 WHERE c1 = sf1(1);
4248 SELECT * FROM t2 ORDER BY c1;
4253 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
4254 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
4255 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
4256 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL DETERMINISTIC SQL SECURITY DEFINER
4258 DECLARE ret INT DEFAULT 0;
4259 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
4262 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
4263 SELECT * FROM t2 ORDER BY c1;
4267 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
4268 SELECT * FROM t2 ORDER BY c1;
4272 DELETE FROM t2 WHERE c1 = sf1(1);
4273 SELECT * FROM t2 ORDER BY c1;
4278 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
4279 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
4280 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
4281 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL DETERMINISTIC CONTAINS SQL SQL SECURITY DEFINER
4283 DECLARE ret INT DEFAULT 0;
4284 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
4287 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
4288 SELECT * FROM t2 ORDER BY c1;
4292 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
4293 SELECT * FROM t2 ORDER BY c1;
4297 DELETE FROM t2 WHERE c1 = sf1(1);
4298 SELECT * FROM t2 ORDER BY c1;
4303 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
4304 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
4305 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
4306 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL DETERMINISTIC NO SQL SQL SECURITY DEFINER
4308 DECLARE ret INT DEFAULT 0;
4309 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
4312 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
4313 SELECT * FROM t2 ORDER BY c1;
4317 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
4318 SELECT * FROM t2 ORDER BY c1;
4322 DELETE FROM t2 WHERE c1 = sf1(1);
4323 SELECT * FROM t2 ORDER BY c1;
4328 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
4329 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
4330 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
4331 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL DETERMINISTIC READS SQL DATA SQL SECURITY DEFINER
4333 DECLARE ret INT DEFAULT 0;
4334 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
4337 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
4338 SELECT * FROM t2 ORDER BY c1;
4342 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
4343 SELECT * FROM t2 ORDER BY c1;
4347 DELETE FROM t2 WHERE c1 = sf1(1);
4348 SELECT * FROM t2 ORDER BY c1;
4353 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
4354 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
4355 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
4356 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL DETERMINISTIC MODIFIES SQL DATA SQL SECURITY DEFINER
4358 DECLARE ret INT DEFAULT 0;
4359 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
4362 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
4363 SELECT * FROM t2 ORDER BY c1;
4367 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
4368 SELECT * FROM t2 ORDER BY c1;
4372 DELETE FROM t2 WHERE c1 = sf1(1);
4373 SELECT * FROM t2 ORDER BY c1;
4378 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
4379 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
4380 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
4381 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL DETERMINISTIC SQL SECURITY DEFINER COMMENT 'comment'
4383 DECLARE ret INT DEFAULT 0;
4384 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
4387 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
4388 SELECT * FROM t2 ORDER BY c1;
4392 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
4393 SELECT * FROM t2 ORDER BY c1;
4397 DELETE FROM t2 WHERE c1 = sf1(1);
4398 SELECT * FROM t2 ORDER BY c1;
4403 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
4404 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
4405 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
4406 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL DETERMINISTIC CONTAINS SQL SQL SECURITY DEFINER COMMENT 'comment'
4408 DECLARE ret INT DEFAULT 0;
4409 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
4412 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
4413 SELECT * FROM t2 ORDER BY c1;
4417 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
4418 SELECT * FROM t2 ORDER BY c1;
4422 DELETE FROM t2 WHERE c1 = sf1(1);
4423 SELECT * FROM t2 ORDER BY c1;
4428 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
4429 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
4430 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
4431 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL DETERMINISTIC NO SQL SQL SECURITY DEFINER COMMENT 'comment'
4433 DECLARE ret INT DEFAULT 0;
4434 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
4437 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
4438 SELECT * FROM t2 ORDER BY c1;
4442 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
4443 SELECT * FROM t2 ORDER BY c1;
4447 DELETE FROM t2 WHERE c1 = sf1(1);
4448 SELECT * FROM t2 ORDER BY c1;
4453 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
4454 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
4455 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
4456 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL DETERMINISTIC READS SQL DATA SQL SECURITY DEFINER COMMENT 'comment'
4458 DECLARE ret INT DEFAULT 0;
4459 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
4462 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
4463 SELECT * FROM t2 ORDER BY c1;
4467 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
4468 SELECT * FROM t2 ORDER BY c1;
4472 DELETE FROM t2 WHERE c1 = sf1(1);
4473 SELECT * FROM t2 ORDER BY c1;
4478 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
4479 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
4480 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
4481 CREATE FUNCTION sf1 (p1 BIGINT) RETURNS BIGINT LANGUAGE SQL DETERMINISTIC MODIFIES SQL DATA SQL SECURITY DEFINER COMMENT 'comment'
4483 DECLARE ret INT DEFAULT 0;
4484 SELECT c1*2 INTO ret FROM t1 WHERE c1 = p1;
4487 INSERT INTO t2 VALUES(1,sf1(1)), (2,sf1(2));
4488 SELECT * FROM t2 ORDER BY c1;
4492 UPDATE t2 SET c2 = sf1(2) WHERE c1 = 1;
4493 SELECT * FROM t2 ORDER BY c1;
4497 DELETE FROM t2 WHERE c1 = sf1(1);
4498 SELECT * FROM t2 ORDER BY c1;