Details
-
Type:
Technical task
-
Status: Closed (View Workflow)
-
Priority:
Blocker
-
Resolution: Fixed
-
Affects Version/s: None
-
Fix Version/s: 10.8.1
-
Component/s: Parser, Stored routines
-
Labels:None
Description
When running with the default sql_mode, MariaDB does not support qualifiers in stored function parameters. Qualifiers are only supported in stored procedure parameters.
When running with sql_mode=ORACLE, MariaDB should support IN, OUT, INOUT parameter qualifiers in CREATE FUNCTION, for Oracle compatibility.
Attachments
Issue Links
- causes
-
MDEV-27331 FUNCTION declaration fails with ERROR 1064 (error in SQL) when using oracle sql_mode and OUT parameter
-
- Closed
-
- is duplicated by
-
MDEV-15715 sql_mode = Oracle with MariaDB 10.3.4 and Store procedure
-
- Closed
-
-
MDEV-17762 PL/SQL FUNCTION arguments with IN/OUT declaration fails
-
- Closed
-
- is part of
-
MDEV-27373 Q1 2022 release merge
-
- Closed
-
- relates to
-
MDEV-27574 MDEV-10654 (IN, OUT, INOUT parameters) documentation items
-
- Open
-