[#MDEV-20662] sql_mode=oracle does not support custom EXCEPTIONs

Some basic datatypes and functions in oracle compatibility mode do not work (MDEV-19162) [MDEV-20662] sql_mode=oracle does not support custom EXCEPTIONs Created: 2019-09-24 Updated: 2019-09-24
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:

Labels:

Compatibility

Description

Defining custom exception does not work in ORACLE mode

as an example:

CREATE PROCEDURE XYZ() AS

    SOME_NEW_EXCEPTION EXCEPTION;

BEGIN

   IF true THEN

        DO SOMETHING;

   ELSE

         RAISE SOME_NEW_EXCEPTION;

    ELSEIF;

END;

Generated at Thu Feb 08 09:01:12 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.