Debian Codegraph @

mysql-test/suite/compat/oracle/r/information_schema_parameters.result

raw
1 #
2 # MDEV-15416 Crash when reading I_S.PARAMETERS
3 #
4 # Create in sql_mode=ORACLE, display in sql_mode=ORACLE and sql_mode=DEFAULT
5 SET sql_mode=ORACLE;
6 CREATE PROCEDURE p1(a0 t1.a%TYPE,
7 a1 test.t1.a%TYPE,
8 b0 t1%ROWTYPE,
9 b1 test.t1%ROWTYPE,
10 d ROW(a INT,b DOUBLE))
11 AS
12 BEGIN
13 NULL;
14 END;
15 $$
16 SET sql_mode=ORACLE;
17 SELECT *, '--------' FROM INFORMATION_SCHEMA.PARAMETERS WHERE SPECIFIC_NAME='p1';
18 SPECIFIC_CATALOG def
19 SPECIFIC_SCHEMA test
20 SPECIFIC_NAME p1
21 ORDINAL_POSITION 1
22 PARAMETER_MODE IN
23 PARAMETER_NAME a0
24 DATA_TYPE TYPE OF
25 CHARACTER_MAXIMUM_LENGTH NULL
26 CHARACTER_OCTET_LENGTH NULL
27 NUMERIC_PRECISION NULL
28 NUMERIC_SCALE NULL
29 DATETIME_PRECISION NULL
30 CHARACTER_SET_NAME NULL
31 COLLATION_NAME NULL
32 DTD_IDENTIFIER "t1"."a"%TYPE
33 ROUTINE_TYPE PROCEDURE
34 -------- --------
35 SPECIFIC_CATALOG def
36 SPECIFIC_SCHEMA test
37 SPECIFIC_NAME p1
38 ORDINAL_POSITION 2
39 PARAMETER_MODE IN
40 PARAMETER_NAME a1
41 DATA_TYPE TYPE OF
42 CHARACTER_MAXIMUM_LENGTH NULL
43 CHARACTER_OCTET_LENGTH NULL
44 NUMERIC_PRECISION NULL
45 NUMERIC_SCALE NULL
46 DATETIME_PRECISION NULL
47 CHARACTER_SET_NAME NULL
48 COLLATION_NAME NULL
49 DTD_IDENTIFIER "test"."t1"."a"%TYPE
50 ROUTINE_TYPE PROCEDURE
51 -------- --------
52 SPECIFIC_CATALOG def
53 SPECIFIC_SCHEMA test
54 SPECIFIC_NAME p1
55 ORDINAL_POSITION 3
56 PARAMETER_MODE IN
57 PARAMETER_NAME b0
58 DATA_TYPE ROW TYPE OF
59 CHARACTER_MAXIMUM_LENGTH NULL
60 CHARACTER_OCTET_LENGTH NULL
61 NUMERIC_PRECISION NULL
62 NUMERIC_SCALE NULL
63 DATETIME_PRECISION NULL
64 CHARACTER_SET_NAME NULL
65 COLLATION_NAME NULL
66 DTD_IDENTIFIER "t1"%ROWTYPE
67 ROUTINE_TYPE PROCEDURE
68 -------- --------
69 SPECIFIC_CATALOG def
70 SPECIFIC_SCHEMA test
71 SPECIFIC_NAME p1
72 ORDINAL_POSITION 4
73 PARAMETER_MODE IN
74 PARAMETER_NAME b1
75 DATA_TYPE ROW TYPE OF
76 CHARACTER_MAXIMUM_LENGTH NULL
77 CHARACTER_OCTET_LENGTH NULL
78 NUMERIC_PRECISION NULL
79 NUMERIC_SCALE NULL
80 DATETIME_PRECISION NULL
81 CHARACTER_SET_NAME NULL
82 COLLATION_NAME NULL
83 DTD_IDENTIFIER "test"."t1"%ROWTYPE
84 ROUTINE_TYPE PROCEDURE
85 -------- --------
86 SPECIFIC_CATALOG def
87 SPECIFIC_SCHEMA test
88 SPECIFIC_NAME p1
89 ORDINAL_POSITION 5
90 PARAMETER_MODE IN
91 PARAMETER_NAME d
92 DATA_TYPE ROW
93 CHARACTER_MAXIMUM_LENGTH NULL
94 CHARACTER_OCTET_LENGTH NULL
95 NUMERIC_PRECISION NULL
96 NUMERIC_SCALE NULL
97 DATETIME_PRECISION NULL
98 CHARACTER_SET_NAME NULL
99 COLLATION_NAME NULL
100 DTD_IDENTIFIER ROW
101 ROUTINE_TYPE PROCEDURE
102 -------- --------
103 SET sql_mode=DEFAULT;
104 SELECT *, '--------' FROM INFORMATION_SCHEMA.PARAMETERS WHERE SPECIFIC_NAME='p1';
105 SPECIFIC_CATALOG def
106 SPECIFIC_SCHEMA test
107 SPECIFIC_NAME p1
108 ORDINAL_POSITION 1
109 PARAMETER_MODE IN
110 PARAMETER_NAME a0
111 DATA_TYPE TYPE OF
112 CHARACTER_MAXIMUM_LENGTH NULL
113 CHARACTER_OCTET_LENGTH NULL
114 NUMERIC_PRECISION NULL
115 NUMERIC_SCALE NULL
116 DATETIME_PRECISION NULL
117 CHARACTER_SET_NAME NULL
118 COLLATION_NAME NULL
119 DTD_IDENTIFIER "t1"."a"%TYPE
120 ROUTINE_TYPE PROCEDURE
121 -------- --------
122 SPECIFIC_CATALOG def
123 SPECIFIC_SCHEMA test
124 SPECIFIC_NAME p1
125 ORDINAL_POSITION 2
126 PARAMETER_MODE IN
127 PARAMETER_NAME a1
128 DATA_TYPE TYPE OF
129 CHARACTER_MAXIMUM_LENGTH NULL
130 CHARACTER_OCTET_LENGTH NULL
131 NUMERIC_PRECISION NULL
132 NUMERIC_SCALE NULL
133 DATETIME_PRECISION NULL
134 CHARACTER_SET_NAME NULL
135 COLLATION_NAME NULL
136 DTD_IDENTIFIER "test"."t1"."a"%TYPE
137 ROUTINE_TYPE PROCEDURE
138 -------- --------
139 SPECIFIC_CATALOG def
140 SPECIFIC_SCHEMA test
141 SPECIFIC_NAME p1
142 ORDINAL_POSITION 3
143 PARAMETER_MODE IN
144 PARAMETER_NAME b0
145 DATA_TYPE ROW TYPE OF
146 CHARACTER_MAXIMUM_LENGTH NULL
147 CHARACTER_OCTET_LENGTH NULL
148 NUMERIC_PRECISION NULL
149 NUMERIC_SCALE NULL
150 DATETIME_PRECISION NULL
151 CHARACTER_SET_NAME NULL
152 COLLATION_NAME NULL
153 DTD_IDENTIFIER "t1"%ROWTYPE
154 ROUTINE_TYPE PROCEDURE
155 -------- --------
156 SPECIFIC_CATALOG def
157 SPECIFIC_SCHEMA test
158 SPECIFIC_NAME p1
159 ORDINAL_POSITION 4
160 PARAMETER_MODE IN
161 PARAMETER_NAME b1
162 DATA_TYPE ROW TYPE OF
163 CHARACTER_MAXIMUM_LENGTH NULL
164 CHARACTER_OCTET_LENGTH NULL
165 NUMERIC_PRECISION NULL
166 NUMERIC_SCALE NULL
167 DATETIME_PRECISION NULL
168 CHARACTER_SET_NAME NULL
169 COLLATION_NAME NULL
170 DTD_IDENTIFIER "test"."t1"%ROWTYPE
171 ROUTINE_TYPE PROCEDURE
172 -------- --------
173 SPECIFIC_CATALOG def
174 SPECIFIC_SCHEMA test
175 SPECIFIC_NAME p1
176 ORDINAL_POSITION 5
177 PARAMETER_MODE IN
178 PARAMETER_NAME d
179 DATA_TYPE ROW
180 CHARACTER_MAXIMUM_LENGTH NULL
181 CHARACTER_OCTET_LENGTH NULL
182 NUMERIC_PRECISION NULL
183 NUMERIC_SCALE NULL
184 DATETIME_PRECISION NULL
185 CHARACTER_SET_NAME NULL
186 COLLATION_NAME NULL
187 DTD_IDENTIFIER ROW
188 ROUTINE_TYPE PROCEDURE
189 -------- --------
190 DROP PROCEDURE p1;
191 SET sql_mode=ORACLE;
192 CREATE FUNCTION f1(a0 t1.a%TYPE,
193 a1 test.t1.a%TYPE,
194 b0 t1%ROWTYPE,
195 b1 test.t1%ROWTYPE,
196 d ROW(a INT,b DOUBLE))
197 RETURN INT
198 AS
199 BEGIN
200 RETURN 0;
201 END;
202 $$
203 SET sql_mode=ORACLE;
204 SELECT *, '--------' FROM INFORMATION_SCHEMA.PARAMETERS WHERE SPECIFIC_NAME='f1';
205 SPECIFIC_CATALOG def
206 SPECIFIC_SCHEMA test
207 SPECIFIC_NAME f1
208 ORDINAL_POSITION 0
209 PARAMETER_MODE NULL
210 PARAMETER_NAME NULL
211 DATA_TYPE int
212 CHARACTER_MAXIMUM_LENGTH NULL
213 CHARACTER_OCTET_LENGTH NULL
214 NUMERIC_PRECISION 10
215 NUMERIC_SCALE 0
216 DATETIME_PRECISION NULL
217 CHARACTER_SET_NAME NULL
218 COLLATION_NAME NULL
219 DTD_IDENTIFIER int(11)
220 ROUTINE_TYPE FUNCTION
221 -------- --------
222 SPECIFIC_CATALOG def
223 SPECIFIC_SCHEMA test
224 SPECIFIC_NAME f1
225 ORDINAL_POSITION 1
226 PARAMETER_MODE IN
227 PARAMETER_NAME a0
228 DATA_TYPE TYPE OF
229 CHARACTER_MAXIMUM_LENGTH NULL
230 CHARACTER_OCTET_LENGTH NULL
231 NUMERIC_PRECISION NULL
232 NUMERIC_SCALE NULL
233 DATETIME_PRECISION NULL
234 CHARACTER_SET_NAME NULL
235 COLLATION_NAME NULL
236 DTD_IDENTIFIER "t1"."a"%TYPE
237 ROUTINE_TYPE FUNCTION
238 -------- --------
239 SPECIFIC_CATALOG def
240 SPECIFIC_SCHEMA test
241 SPECIFIC_NAME f1
242 ORDINAL_POSITION 2
243 PARAMETER_MODE IN
244 PARAMETER_NAME a1
245 DATA_TYPE TYPE OF
246 CHARACTER_MAXIMUM_LENGTH NULL
247 CHARACTER_OCTET_LENGTH NULL
248 NUMERIC_PRECISION NULL
249 NUMERIC_SCALE NULL
250 DATETIME_PRECISION NULL
251 CHARACTER_SET_NAME NULL
252 COLLATION_NAME NULL
253 DTD_IDENTIFIER "test"."t1"."a"%TYPE
254 ROUTINE_TYPE FUNCTION
255 -------- --------
256 SPECIFIC_CATALOG def
257 SPECIFIC_SCHEMA test
258 SPECIFIC_NAME f1
259 ORDINAL_POSITION 3
260 PARAMETER_MODE IN
261 PARAMETER_NAME b0
262 DATA_TYPE ROW TYPE OF
263 CHARACTER_MAXIMUM_LENGTH NULL
264 CHARACTER_OCTET_LENGTH NULL
265 NUMERIC_PRECISION NULL
266 NUMERIC_SCALE NULL
267 DATETIME_PRECISION NULL
268 CHARACTER_SET_NAME NULL
269 COLLATION_NAME NULL
270 DTD_IDENTIFIER "t1"%ROWTYPE
271 ROUTINE_TYPE FUNCTION
272 -------- --------
273 SPECIFIC_CATALOG def
274 SPECIFIC_SCHEMA test
275 SPECIFIC_NAME f1
276 ORDINAL_POSITION 4
277 PARAMETER_MODE IN
278 PARAMETER_NAME b1
279 DATA_TYPE ROW TYPE OF
280 CHARACTER_MAXIMUM_LENGTH NULL
281 CHARACTER_OCTET_LENGTH NULL
282 NUMERIC_PRECISION NULL
283 NUMERIC_SCALE NULL
284 DATETIME_PRECISION NULL
285 CHARACTER_SET_NAME NULL
286 COLLATION_NAME NULL
287 DTD_IDENTIFIER "test"."t1"%ROWTYPE
288 ROUTINE_TYPE FUNCTION
289 -------- --------
290 SPECIFIC_CATALOG def
291 SPECIFIC_SCHEMA test
292 SPECIFIC_NAME f1
293 ORDINAL_POSITION 5
294 PARAMETER_MODE IN
295 PARAMETER_NAME d
296 DATA_TYPE ROW
297 CHARACTER_MAXIMUM_LENGTH NULL
298 CHARACTER_OCTET_LENGTH NULL
299 NUMERIC_PRECISION NULL
300 NUMERIC_SCALE NULL
301 DATETIME_PRECISION NULL
302 CHARACTER_SET_NAME NULL
303 COLLATION_NAME NULL
304 DTD_IDENTIFIER ROW
305 ROUTINE_TYPE FUNCTION
306 -------- --------
307 SET sql_mode=DEFAULT;
308 SELECT *, '--------' FROM INFORMATION_SCHEMA.PARAMETERS WHERE SPECIFIC_NAME='f1';
309 SPECIFIC_CATALOG def
310 SPECIFIC_SCHEMA test
311 SPECIFIC_NAME f1
312 ORDINAL_POSITION 0
313 PARAMETER_MODE NULL
314 PARAMETER_NAME NULL
315 DATA_TYPE int
316 CHARACTER_MAXIMUM_LENGTH NULL
317 CHARACTER_OCTET_LENGTH NULL
318 NUMERIC_PRECISION 10
319 NUMERIC_SCALE 0
320 DATETIME_PRECISION NULL
321 CHARACTER_SET_NAME NULL
322 COLLATION_NAME NULL
323 DTD_IDENTIFIER int(11)
324 ROUTINE_TYPE FUNCTION
325 -------- --------
326 SPECIFIC_CATALOG def
327 SPECIFIC_SCHEMA test
328 SPECIFIC_NAME f1
329 ORDINAL_POSITION 1
330 PARAMETER_MODE IN
331 PARAMETER_NAME a0
332 DATA_TYPE TYPE OF
333 CHARACTER_MAXIMUM_LENGTH NULL
334 CHARACTER_OCTET_LENGTH NULL
335 NUMERIC_PRECISION NULL
336 NUMERIC_SCALE NULL
337 DATETIME_PRECISION NULL
338 CHARACTER_SET_NAME NULL
339 COLLATION_NAME NULL
340 DTD_IDENTIFIER "t1"."a"%TYPE
341 ROUTINE_TYPE FUNCTION
342 -------- --------
343 SPECIFIC_CATALOG def
344 SPECIFIC_SCHEMA test
345 SPECIFIC_NAME f1
346 ORDINAL_POSITION 2
347 PARAMETER_MODE IN
348 PARAMETER_NAME a1
349 DATA_TYPE TYPE OF
350 CHARACTER_MAXIMUM_LENGTH NULL
351 CHARACTER_OCTET_LENGTH NULL
352 NUMERIC_PRECISION NULL
353 NUMERIC_SCALE NULL
354 DATETIME_PRECISION NULL
355 CHARACTER_SET_NAME NULL
356 COLLATION_NAME NULL
357 DTD_IDENTIFIER "test"."t1"."a"%TYPE
358 ROUTINE_TYPE FUNCTION
359 -------- --------
360 SPECIFIC_CATALOG def
361 SPECIFIC_SCHEMA test
362 SPECIFIC_NAME f1
363 ORDINAL_POSITION 3
364 PARAMETER_MODE IN
365 PARAMETER_NAME b0
366 DATA_TYPE ROW TYPE OF
367 CHARACTER_MAXIMUM_LENGTH NULL
368 CHARACTER_OCTET_LENGTH NULL
369 NUMERIC_PRECISION NULL
370 NUMERIC_SCALE NULL
371 DATETIME_PRECISION NULL
372 CHARACTER_SET_NAME NULL
373 COLLATION_NAME NULL
374 DTD_IDENTIFIER "t1"%ROWTYPE
375 ROUTINE_TYPE FUNCTION
376 -------- --------
377 SPECIFIC_CATALOG def
378 SPECIFIC_SCHEMA test
379 SPECIFIC_NAME f1
380 ORDINAL_POSITION 4
381 PARAMETER_MODE IN
382 PARAMETER_NAME b1
383 DATA_TYPE ROW TYPE OF
384 CHARACTER_MAXIMUM_LENGTH NULL
385 CHARACTER_OCTET_LENGTH NULL
386 NUMERIC_PRECISION NULL
387 NUMERIC_SCALE NULL
388 DATETIME_PRECISION NULL
389 CHARACTER_SET_NAME NULL
390 COLLATION_NAME NULL
391 DTD_IDENTIFIER "test"."t1"%ROWTYPE
392 ROUTINE_TYPE FUNCTION
393 -------- --------
394 SPECIFIC_CATALOG def
395 SPECIFIC_SCHEMA test
396 SPECIFIC_NAME f1
397 ORDINAL_POSITION 5
398 PARAMETER_MODE IN
399 PARAMETER_NAME d
400 DATA_TYPE ROW
401 CHARACTER_MAXIMUM_LENGTH NULL
402 CHARACTER_OCTET_LENGTH NULL
403 NUMERIC_PRECISION NULL
404 NUMERIC_SCALE NULL
405 DATETIME_PRECISION NULL
406 CHARACTER_SET_NAME NULL
407 COLLATION_NAME NULL
408 DTD_IDENTIFIER ROW
409 ROUTINE_TYPE FUNCTION
410 -------- --------
411 DROP FUNCTION f1;
412 # Create in sql_mode=DEFAULT, display in sql_mode=DEFAULT and sql_mode=ORACLE
413 SET sql_mode=DEFAULT;
414 CREATE PROCEDURE p1(a0 TYPE OF t1.a,
415 a1 TYPE OF test.t1.a,
416 b0 ROW TYPE OF t1,
417 b1 ROW TYPE OF test.t1,
418 d ROW(a INT,b DOUBLE))
419 BEGIN
420 END;
421 $$
422 SET sql_mode=DEFAULT;
423 SELECT *, '--------' FROM INFORMATION_SCHEMA.PARAMETERS WHERE SPECIFIC_NAME='p1';
424 SPECIFIC_CATALOG def
425 SPECIFIC_SCHEMA test
426 SPECIFIC_NAME p1
427 ORDINAL_POSITION 1
428 PARAMETER_MODE IN
429 PARAMETER_NAME a0
430 DATA_TYPE TYPE OF
431 CHARACTER_MAXIMUM_LENGTH NULL
432 CHARACTER_OCTET_LENGTH NULL
433 NUMERIC_PRECISION NULL
434 NUMERIC_SCALE NULL
435 DATETIME_PRECISION NULL
436 CHARACTER_SET_NAME NULL
437 COLLATION_NAME NULL
438 DTD_IDENTIFIER TYPE OF `t1`.`a`
439 ROUTINE_TYPE PROCEDURE
440 -------- --------
441 SPECIFIC_CATALOG def
442 SPECIFIC_SCHEMA test
443 SPECIFIC_NAME p1
444 ORDINAL_POSITION 2
445 PARAMETER_MODE IN
446 PARAMETER_NAME a1
447 DATA_TYPE TYPE OF
448 CHARACTER_MAXIMUM_LENGTH NULL
449 CHARACTER_OCTET_LENGTH NULL
450 NUMERIC_PRECISION NULL
451 NUMERIC_SCALE NULL
452 DATETIME_PRECISION NULL
453 CHARACTER_SET_NAME NULL
454 COLLATION_NAME NULL
455 DTD_IDENTIFIER TYPE OF `test`.`t1`.`a`
456 ROUTINE_TYPE PROCEDURE
457 -------- --------
458 SPECIFIC_CATALOG def
459 SPECIFIC_SCHEMA test
460 SPECIFIC_NAME p1
461 ORDINAL_POSITION 3
462 PARAMETER_MODE IN
463 PARAMETER_NAME b0
464 DATA_TYPE ROW TYPE OF
465 CHARACTER_MAXIMUM_LENGTH NULL
466 CHARACTER_OCTET_LENGTH NULL
467 NUMERIC_PRECISION NULL
468 NUMERIC_SCALE NULL
469 DATETIME_PRECISION NULL
470 CHARACTER_SET_NAME NULL
471 COLLATION_NAME NULL
472 DTD_IDENTIFIER ROW TYPE OF `t1`
473 ROUTINE_TYPE PROCEDURE
474 -------- --------
475 SPECIFIC_CATALOG def
476 SPECIFIC_SCHEMA test
477 SPECIFIC_NAME p1
478 ORDINAL_POSITION 4
479 PARAMETER_MODE IN
480 PARAMETER_NAME b1
481 DATA_TYPE ROW TYPE OF
482 CHARACTER_MAXIMUM_LENGTH NULL
483 CHARACTER_OCTET_LENGTH NULL
484 NUMERIC_PRECISION NULL
485 NUMERIC_SCALE NULL
486 DATETIME_PRECISION NULL
487 CHARACTER_SET_NAME NULL
488 COLLATION_NAME NULL
489 DTD_IDENTIFIER ROW TYPE OF `test`.`t1`
490 ROUTINE_TYPE PROCEDURE
491 -------- --------
492 SPECIFIC_CATALOG def
493 SPECIFIC_SCHEMA test
494 SPECIFIC_NAME p1
495 ORDINAL_POSITION 5
496 PARAMETER_MODE IN
497 PARAMETER_NAME d
498 DATA_TYPE ROW
499 CHARACTER_MAXIMUM_LENGTH NULL
500 CHARACTER_OCTET_LENGTH NULL
501 NUMERIC_PRECISION NULL
502 NUMERIC_SCALE NULL
503 DATETIME_PRECISION NULL
504 CHARACTER_SET_NAME NULL
505 COLLATION_NAME NULL
506 DTD_IDENTIFIER ROW
507 ROUTINE_TYPE PROCEDURE
508 -------- --------
509 SET sql_mode=ORACLE;
510 SELECT *, '--------' FROM INFORMATION_SCHEMA.PARAMETERS WHERE SPECIFIC_NAME='p1';
511 SPECIFIC_CATALOG def
512 SPECIFIC_SCHEMA test
513 SPECIFIC_NAME p1
514 ORDINAL_POSITION 1
515 PARAMETER_MODE IN
516 PARAMETER_NAME a0
517 DATA_TYPE TYPE OF
518 CHARACTER_MAXIMUM_LENGTH NULL
519 CHARACTER_OCTET_LENGTH NULL
520 NUMERIC_PRECISION NULL
521 NUMERIC_SCALE NULL
522 DATETIME_PRECISION NULL
523 CHARACTER_SET_NAME NULL
524 COLLATION_NAME NULL
525 DTD_IDENTIFIER TYPE OF `t1`.`a`
526 ROUTINE_TYPE PROCEDURE
527 -------- --------
528 SPECIFIC_CATALOG def
529 SPECIFIC_SCHEMA test
530 SPECIFIC_NAME p1
531 ORDINAL_POSITION 2
532 PARAMETER_MODE IN
533 PARAMETER_NAME a1
534 DATA_TYPE TYPE OF
535 CHARACTER_MAXIMUM_LENGTH NULL
536 CHARACTER_OCTET_LENGTH NULL
537 NUMERIC_PRECISION NULL
538 NUMERIC_SCALE NULL
539 DATETIME_PRECISION NULL
540 CHARACTER_SET_NAME NULL
541 COLLATION_NAME NULL
542 DTD_IDENTIFIER TYPE OF `test`.`t1`.`a`
543 ROUTINE_TYPE PROCEDURE
544 -------- --------
545 SPECIFIC_CATALOG def
546 SPECIFIC_SCHEMA test
547 SPECIFIC_NAME p1
548 ORDINAL_POSITION 3
549 PARAMETER_MODE IN
550 PARAMETER_NAME b0
551 DATA_TYPE ROW TYPE OF
552 CHARACTER_MAXIMUM_LENGTH NULL
553 CHARACTER_OCTET_LENGTH NULL
554 NUMERIC_PRECISION NULL
555 NUMERIC_SCALE NULL
556 DATETIME_PRECISION NULL
557 CHARACTER_SET_NAME NULL
558 COLLATION_NAME NULL
559 DTD_IDENTIFIER ROW TYPE OF `t1`
560 ROUTINE_TYPE PROCEDURE
561 -------- --------
562 SPECIFIC_CATALOG def
563 SPECIFIC_SCHEMA test
564 SPECIFIC_NAME p1
565 ORDINAL_POSITION 4
566 PARAMETER_MODE IN
567 PARAMETER_NAME b1
568 DATA_TYPE ROW TYPE OF
569 CHARACTER_MAXIMUM_LENGTH NULL
570 CHARACTER_OCTET_LENGTH NULL
571 NUMERIC_PRECISION NULL
572 NUMERIC_SCALE NULL
573 DATETIME_PRECISION NULL
574 CHARACTER_SET_NAME NULL
575 COLLATION_NAME NULL
576 DTD_IDENTIFIER ROW TYPE OF `test`.`t1`
577 ROUTINE_TYPE PROCEDURE
578 -------- --------
579 SPECIFIC_CATALOG def
580 SPECIFIC_SCHEMA test
581 SPECIFIC_NAME p1
582 ORDINAL_POSITION 5
583 PARAMETER_MODE IN
584 PARAMETER_NAME d
585 DATA_TYPE ROW
586 CHARACTER_MAXIMUM_LENGTH NULL
587 CHARACTER_OCTET_LENGTH NULL
588 NUMERIC_PRECISION NULL
589 NUMERIC_SCALE NULL
590 DATETIME_PRECISION NULL
591 CHARACTER_SET_NAME NULL
592 COLLATION_NAME NULL
593 DTD_IDENTIFIER ROW
594 ROUTINE_TYPE PROCEDURE
595 -------- --------
596 DROP PROCEDURE p1;
597 SET sql_mode=DEFAULT;
598 CREATE FUNCTION f1(a0 TYPE OF t1.a,
599 a1 TYPE OF test.t1.a,
600 b0 ROW TYPE OF t1,
601 b1 ROW TYPE OF test.t1,
602 d ROW(a INT,b DOUBLE))
603 RETURNS INT
604 BEGIN
605 RETURN 0;
606 END;
607 $$
608 SET sql_mode=DEFAULT;
609 SELECT *, '--------' FROM INFORMATION_SCHEMA.PARAMETERS WHERE SPECIFIC_NAME='f1';
610 SPECIFIC_CATALOG def
611 SPECIFIC_SCHEMA test
612 SPECIFIC_NAME f1
613 ORDINAL_POSITION 0
614 PARAMETER_MODE NULL
615 PARAMETER_NAME NULL
616 DATA_TYPE int
617 CHARACTER_MAXIMUM_LENGTH NULL
618 CHARACTER_OCTET_LENGTH NULL
619 NUMERIC_PRECISION 10
620 NUMERIC_SCALE 0
621 DATETIME_PRECISION NULL
622 CHARACTER_SET_NAME NULL
623 COLLATION_NAME NULL
624 DTD_IDENTIFIER int(11)
625 ROUTINE_TYPE FUNCTION
626 -------- --------
627 SPECIFIC_CATALOG def
628 SPECIFIC_SCHEMA test
629 SPECIFIC_NAME f1
630 ORDINAL_POSITION 1
631 PARAMETER_MODE IN
632 PARAMETER_NAME a0
633 DATA_TYPE TYPE OF
634 CHARACTER_MAXIMUM_LENGTH NULL
635 CHARACTER_OCTET_LENGTH NULL
636 NUMERIC_PRECISION NULL
637 NUMERIC_SCALE NULL
638 DATETIME_PRECISION NULL
639 CHARACTER_SET_NAME NULL
640 COLLATION_NAME NULL
641 DTD_IDENTIFIER TYPE OF `t1`.`a`
642 ROUTINE_TYPE FUNCTION
643 -------- --------
644 SPECIFIC_CATALOG def
645 SPECIFIC_SCHEMA test
646 SPECIFIC_NAME f1
647 ORDINAL_POSITION 2
648 PARAMETER_MODE IN
649 PARAMETER_NAME a1
650 DATA_TYPE TYPE OF
651 CHARACTER_MAXIMUM_LENGTH NULL
652 CHARACTER_OCTET_LENGTH NULL
653 NUMERIC_PRECISION NULL
654 NUMERIC_SCALE NULL
655 DATETIME_PRECISION NULL
656 CHARACTER_SET_NAME NULL
657 COLLATION_NAME NULL
658 DTD_IDENTIFIER TYPE OF `test`.`t1`.`a`
659 ROUTINE_TYPE FUNCTION
660 -------- --------
661 SPECIFIC_CATALOG def
662 SPECIFIC_SCHEMA test
663 SPECIFIC_NAME f1
664 ORDINAL_POSITION 3
665 PARAMETER_MODE IN
666 PARAMETER_NAME b0
667 DATA_TYPE ROW TYPE OF
668 CHARACTER_MAXIMUM_LENGTH NULL
669 CHARACTER_OCTET_LENGTH NULL
670 NUMERIC_PRECISION NULL
671 NUMERIC_SCALE NULL
672 DATETIME_PRECISION NULL
673 CHARACTER_SET_NAME NULL
674 COLLATION_NAME NULL
675 DTD_IDENTIFIER ROW TYPE OF `t1`
676 ROUTINE_TYPE FUNCTION
677 -------- --------
678 SPECIFIC_CATALOG def
679 SPECIFIC_SCHEMA test
680 SPECIFIC_NAME f1
681 ORDINAL_POSITION 4
682 PARAMETER_MODE IN
683 PARAMETER_NAME b1
684 DATA_TYPE ROW TYPE OF
685 CHARACTER_MAXIMUM_LENGTH NULL
686 CHARACTER_OCTET_LENGTH NULL
687 NUMERIC_PRECISION NULL
688 NUMERIC_SCALE NULL
689 DATETIME_PRECISION NULL
690 CHARACTER_SET_NAME NULL
691 COLLATION_NAME NULL
692 DTD_IDENTIFIER ROW TYPE OF `test`.`t1`
693 ROUTINE_TYPE FUNCTION
694 -------- --------
695 SPECIFIC_CATALOG def
696 SPECIFIC_SCHEMA test
697 SPECIFIC_NAME f1
698 ORDINAL_POSITION 5
699 PARAMETER_MODE IN
700 PARAMETER_NAME d
701 DATA_TYPE ROW
702 CHARACTER_MAXIMUM_LENGTH NULL
703 CHARACTER_OCTET_LENGTH NULL
704 NUMERIC_PRECISION NULL
705 NUMERIC_SCALE NULL
706 DATETIME_PRECISION NULL
707 CHARACTER_SET_NAME NULL
708 COLLATION_NAME NULL
709 DTD_IDENTIFIER ROW
710 ROUTINE_TYPE FUNCTION
711 -------- --------
712 SET sql_mode=ORACLE;
713 SELECT *, '--------' FROM INFORMATION_SCHEMA.PARAMETERS WHERE SPECIFIC_NAME='f1';
714 SPECIFIC_CATALOG def
715 SPECIFIC_SCHEMA test
716 SPECIFIC_NAME f1
717 ORDINAL_POSITION 0
718 PARAMETER_MODE NULL
719 PARAMETER_NAME NULL
720 DATA_TYPE int
721 CHARACTER_MAXIMUM_LENGTH NULL
722 CHARACTER_OCTET_LENGTH NULL
723 NUMERIC_PRECISION 10
724 NUMERIC_SCALE 0
725 DATETIME_PRECISION NULL
726 CHARACTER_SET_NAME NULL
727 COLLATION_NAME NULL
728 DTD_IDENTIFIER int(11)
729 ROUTINE_TYPE FUNCTION
730 -------- --------
731 SPECIFIC_CATALOG def
732 SPECIFIC_SCHEMA test
733 SPECIFIC_NAME f1
734 ORDINAL_POSITION 1
735 PARAMETER_MODE IN
736 PARAMETER_NAME a0
737 DATA_TYPE TYPE OF
738 CHARACTER_MAXIMUM_LENGTH NULL
739 CHARACTER_OCTET_LENGTH NULL
740 NUMERIC_PRECISION NULL
741 NUMERIC_SCALE NULL
742 DATETIME_PRECISION NULL
743 CHARACTER_SET_NAME NULL
744 COLLATION_NAME NULL
745 DTD_IDENTIFIER TYPE OF `t1`.`a`
746 ROUTINE_TYPE FUNCTION
747 -------- --------
748 SPECIFIC_CATALOG def
749 SPECIFIC_SCHEMA test
750 SPECIFIC_NAME f1
751 ORDINAL_POSITION 2
752 PARAMETER_MODE IN
753 PARAMETER_NAME a1
754 DATA_TYPE TYPE OF
755 CHARACTER_MAXIMUM_LENGTH NULL
756 CHARACTER_OCTET_LENGTH NULL
757 NUMERIC_PRECISION NULL
758 NUMERIC_SCALE NULL
759 DATETIME_PRECISION NULL
760 CHARACTER_SET_NAME NULL
761 COLLATION_NAME NULL
762 DTD_IDENTIFIER TYPE OF `test`.`t1`.`a`
763 ROUTINE_TYPE FUNCTION
764 -------- --------
765 SPECIFIC_CATALOG def
766 SPECIFIC_SCHEMA test
767 SPECIFIC_NAME f1
768 ORDINAL_POSITION 3
769 PARAMETER_MODE IN
770 PARAMETER_NAME b0
771 DATA_TYPE ROW TYPE OF
772 CHARACTER_MAXIMUM_LENGTH NULL
773 CHARACTER_OCTET_LENGTH NULL
774 NUMERIC_PRECISION NULL
775 NUMERIC_SCALE NULL
776 DATETIME_PRECISION NULL
777 CHARACTER_SET_NAME NULL
778 COLLATION_NAME NULL
779 DTD_IDENTIFIER ROW TYPE OF `t1`
780 ROUTINE_TYPE FUNCTION
781 -------- --------
782 SPECIFIC_CATALOG def
783 SPECIFIC_SCHEMA test
784 SPECIFIC_NAME f1
785 ORDINAL_POSITION 4
786 PARAMETER_MODE IN
787 PARAMETER_NAME b1
788 DATA_TYPE ROW TYPE OF
789 CHARACTER_MAXIMUM_LENGTH NULL
790 CHARACTER_OCTET_LENGTH NULL
791 NUMERIC_PRECISION NULL
792 NUMERIC_SCALE NULL
793 DATETIME_PRECISION NULL
794 CHARACTER_SET_NAME NULL
795 COLLATION_NAME NULL
796 DTD_IDENTIFIER ROW TYPE OF `test`.`t1`
797 ROUTINE_TYPE FUNCTION
798 -------- --------
799 SPECIFIC_CATALOG def
800 SPECIFIC_SCHEMA test
801 SPECIFIC_NAME f1
802 ORDINAL_POSITION 5
803 PARAMETER_MODE IN
804 PARAMETER_NAME d
805 DATA_TYPE ROW
806 CHARACTER_MAXIMUM_LENGTH NULL
807 CHARACTER_OCTET_LENGTH NULL
808 NUMERIC_PRECISION NULL
809 NUMERIC_SCALE NULL
810 DATETIME_PRECISION NULL
811 CHARACTER_SET_NAME NULL
812 COLLATION_NAME NULL
813 DTD_IDENTIFIER ROW
814 ROUTINE_TYPE FUNCTION
815 -------- --------
816 DROP FUNCTION f1;
817 #
818 # MDEV 18092 Query with the table I_S.PARAMETERS stop working
819 # after a package is created
820 #
821 SET sql_mode=ORACLE;
822 CREATE DATABASE db1_mdev18092;
823 USE db1_mdev18092;
824 CREATE PROCEDURE p1(a INT)
825 AS BEGIN
826 NULL;
827 END;
828 $$
829 CREATE OR REPLACE PACKAGE employee_tools AS
830 FUNCTION getSalary(eid INT) RETURN DECIMAL(10,2);
831 PROCEDURE raiseSalary(eid INT, amount DECIMAL(10,2));
832 PROCEDURE raiseSalaryStd(eid INT);
833 PROCEDURE hire(ename TEXT, esalary DECIMAL(10,2));
834 END;
835 $$
836 SELECT *, '---------------' FROM INFORMATION_SCHEMA.PARAMETERS WHERE SPECIFIC_SCHEMA='db1_mdev18092';
837 SPECIFIC_CATALOG def
838 SPECIFIC_SCHEMA db1_mdev18092
839 SPECIFIC_NAME p1
840 ORDINAL_POSITION 1
841 PARAMETER_MODE IN
842 PARAMETER_NAME a
843 DATA_TYPE int
844 CHARACTER_MAXIMUM_LENGTH NULL
845 CHARACTER_OCTET_LENGTH NULL
846 NUMERIC_PRECISION 10
847 NUMERIC_SCALE 0
848 DATETIME_PRECISION NULL
849 CHARACTER_SET_NAME NULL
850 COLLATION_NAME NULL
851 DTD_IDENTIFIER int(11)
852 ROUTINE_TYPE PROCEDURE
853 --------------- ---------------
854 DROP DATABASE db1_mdev18092;