Details
-
New Feature
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
None
Description
Oracle PL/SQL supports default values for parameters to procedures and functions, which is not supported by SQL/PL in MariaDB. This is a commonly used PL/SQL feature and looks like this, this works fine with Oracle but doesn't compile with MariaDB (excluding SQL_MODE and delimiter, obviously):
SET SQL_MODE=Oracle; |
delimiter //
|
|
CREATE OR REPLACE PROCEDURE p1(a1 INTEGER := 1) |
IS
|
dummy INTEGER; |
BEGIN
|
SELECT a1 INTO dummy FROM dual; |
END; |
//
|
|
CREATE OR REPLACE FUNCTION f1(a1 INTEGER := 1) |
RETURN INTEGER |
IS
|
BEGIN
|
RETURN a1; |
END; |
//
|