Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.3(EOL), 10.4(EOL), 10.5, 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL)
Description
MariaDB supports only 2-part qualified names in the package function call syntax:
SET sql_mode=ORACLE; |
DELIMITER $$
|
CREATE OR REPLACE PACKAGE pkg1 AS |
FUNCTION f1 RETURN TEXT; |
END; |
$$
|
CREATE PACKAGE BODY pkg1 |
AS
|
FUNCTION f1 RETURN TEXT IS |
BEGIN |
RETURN 'Here'; |
END; |
END; |
$$
|
DELIMITER ;
|
SELECT pkg1.f1(); |
+-----------+
|
| pkg1.f1() |
|
+-----------+
|
| Here |
|
+-----------+
|
So far so good.
But fully qualified (i.e. including database name) calls do not work:
SELECT test.pkg1.f1(); |
ERROR 1064 (42000): You have an error in your SQL syntax ... near '()' at line 1
|
This should be fixed. This problem is a blocker for MDEV-19328.
Attachments
Issue Links
- relates to
-
MDEV-19328 sql_mode=ORACLE: Package function in VIEW
- Closed
-
MDEV-28267 ASAN heap-use-after-free in Item_sp::func_name_cstring
- Closed