Debian Codegraph @

mysql-test/suite/compat/oracle/t/information_schema_parameters.test

raw
1
2 --echo #
3 --echo # MDEV-15416 Crash when reading I_S.PARAMETERS
4 --echo #
5
6 --echo # Create in sql_mode=ORACLE, display in sql_mode=ORACLE and sql_mode=DEFAULT
7
8 SET sql_mode=ORACLE;
9 DELIMITER $$;
10 CREATE PROCEDURE p1(a0 t1.a%TYPE,
11 a1 test.t1.a%TYPE,
12 b0 t1%ROWTYPE,
13 b1 test.t1%ROWTYPE,
14 d ROW(a INT,b DOUBLE))
15 AS
16 BEGIN
17 NULL;
18 END;
19 $$
20 DELIMITER ;$$
21 --vertical_results
22 SET sql_mode=ORACLE;
23 SELECT *, '--------' FROM INFORMATION_SCHEMA.PARAMETERS WHERE SPECIFIC_NAME='p1';
24 SET sql_mode=DEFAULT;
25 SELECT *, '--------' FROM INFORMATION_SCHEMA.PARAMETERS WHERE SPECIFIC_NAME='p1';
26 --horizontal_results
27 DROP PROCEDURE p1;
28
29
30 SET sql_mode=ORACLE;
31 DELIMITER $$;
32 CREATE FUNCTION f1(a0 t1.a%TYPE,
33 a1 test.t1.a%TYPE,
34 b0 t1%ROWTYPE,
35 b1 test.t1%ROWTYPE,
36 d ROW(a INT,b DOUBLE))
37 RETURN INT
38 AS
39 BEGIN
40 RETURN 0;
41 END;
42 $$
43 DELIMITER ;$$
44 --vertical_results
45 SET sql_mode=ORACLE;
46 SELECT *, '--------' FROM INFORMATION_SCHEMA.PARAMETERS WHERE SPECIFIC_NAME='f1';
47 SET sql_mode=DEFAULT;
48 SELECT *, '--------' FROM INFORMATION_SCHEMA.PARAMETERS WHERE SPECIFIC_NAME='f1';
49 --horizontal_results
50 DROP FUNCTION f1;
51
52
53 --echo # Create in sql_mode=DEFAULT, display in sql_mode=DEFAULT and sql_mode=ORACLE
54
55 SET sql_mode=DEFAULT;
56 DELIMITER $$;
57 CREATE PROCEDURE p1(a0 TYPE OF t1.a,
58 a1 TYPE OF test.t1.a,
59 b0 ROW TYPE OF t1,
60 b1 ROW TYPE OF test.t1,
61 d ROW(a INT,b DOUBLE))
62 BEGIN
63 END;
64 $$
65 DELIMITER ;$$
66 --vertical_results
67 SET sql_mode=DEFAULT;
68 SELECT *, '--------' FROM INFORMATION_SCHEMA.PARAMETERS WHERE SPECIFIC_NAME='p1';
69 SET sql_mode=ORACLE;
70 SELECT *, '--------' FROM INFORMATION_SCHEMA.PARAMETERS WHERE SPECIFIC_NAME='p1';
71 --horizontal_results
72 DROP PROCEDURE p1;
73
74
75 SET sql_mode=DEFAULT;
76 DELIMITER $$;
77 CREATE FUNCTION f1(a0 TYPE OF t1.a,
78 a1 TYPE OF test.t1.a,
79 b0 ROW TYPE OF t1,
80 b1 ROW TYPE OF test.t1,
81 d ROW(a INT,b DOUBLE))
82 RETURNS INT
83 BEGIN
84 RETURN 0;
85 END;
86 $$
87 DELIMITER ;$$
88 --vertical_results
89 SET sql_mode=DEFAULT;
90 SELECT *, '--------' FROM INFORMATION_SCHEMA.PARAMETERS WHERE SPECIFIC_NAME='f1';
91 SET sql_mode=ORACLE;
92 SELECT *, '--------' FROM INFORMATION_SCHEMA.PARAMETERS WHERE SPECIFIC_NAME='f1';
93 --horizontal_results
94 DROP FUNCTION f1;
95
96 --echo #
97 --echo # MDEV 18092 Query with the table I_S.PARAMETERS stop working
98 --echo # after a package is created
99 --echo #
100
101 SET sql_mode=ORACLE;
102
103 CREATE DATABASE db1_mdev18092;
104 USE db1_mdev18092;
105
106 DELIMITER $$;
107
108 CREATE PROCEDURE p1(a INT)
109 AS BEGIN
110 NULL;
111 END;
112 $$
113
114 CREATE OR REPLACE PACKAGE employee_tools AS
115 FUNCTION getSalary(eid INT) RETURN DECIMAL(10,2);
116 PROCEDURE raiseSalary(eid INT, amount DECIMAL(10,2));
117 PROCEDURE raiseSalaryStd(eid INT);
118 PROCEDURE hire(ename TEXT, esalary DECIMAL(10,2));
119 END;
120 $$
121 DELIMITER ;$$
122
123 --vertical_results
124 SELECT *, '---------------' FROM INFORMATION_SCHEMA.PARAMETERS WHERE SPECIFIC_SCHEMA='db1_mdev18092';
125 --horizontal_results
126
127 DROP DATABASE db1_mdev18092;