Some basic datatypes and functions in oracle compatibility mode do not work (MDEV-19162)

[MDEV-20037] FUNCTION returning a TYPE fails Created: 2019-07-10  Updated: 2024-01-12

Status: Open
Project: MariaDB Server
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Technical task Priority: Major
Reporter: Faisal Saeed (Inactive) Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: Compatibility


 Description   

A function that returns a TYPE fails to create.

RETURN VARCHAR AS
 
        TYPE KITCHEN_DETAIL IS RECORD (
 
            STATION_CD varchar(3),
 
            TELEX1 varchar(40),
 
            TELEX2 varchar(40),
 
            TELEX3 varchar(40)
 
        );

Oracle Doc: https://docs.oracle.com/cd/B28359_01/appdev.111/b28370/record_definition.htm#LNPLS01338
Generated at Thu Feb 08 08:56:15 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.