Details
-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Minor
-
Resolution: Duplicate
-
Affects Version/s: 10.3.7
-
Fix Version/s: N/A
-
Component/s: Data Definition - Procedure
-
Labels:None
-
Environment:CentOS 7.4
Description
Using %TYPE for a return value from a PL/SQL function fails with MariaDB, but works as expected in Oracle. Like this:
DROP TABLE tab1; |
CREATE TABLE tab1(c1 INTEGER); |
 |
CREATE OR REPLACE FUNCTION f1 |
RETURN tab1.c1%TYPE |
AS
|
BEGIN
|
RETURN 1; |
END; |
/
|
With Oracle this works without errors. With MariaDB I get:
ERROR 1064 (42000) at line 1 in file...
%TYPE declarations works for function and procedure parameters in both Oracle and MariaDB
Attachments
Issue Links
- duplicates
-
MDEV-11210 %TYPE in stored function RETURN data type
-
- Open
-