Details
-
Technical task
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
None
-
None
Description
When running in sql_mode=ORACLE, MariaDB should understand predefined exception names.
BEGIN
|
...
|
EXCEPTION
|
WHEN TOO_MANY_ROWS THEN ... |
WHEN NO_DATA_FOUND THEN ... |
WHEN OTHERS THEN NULL; |
END; |
The most widely used predefined exceptions were implement under terms of MDEV-10839 and MDEV-10582.
This tasks is for the remaining less important exceptions:
- ACCESS_INTO_NULL
- CASE_NOT_FOUND
- COLLECTION_IS_NULL
- CURSOR_ALREADY_OPEN
- INVALID_NUMBER
- LOGIN_DENIED
- NOT_LOGGED_ON
- PROGRAM_ERROR
- ROWTYPE_MISMATCH
- SELF_IS_NULL
- STORAGE_ERROR
- SUBSCRIPT_BEYOND_COUNT
- SUBSCRIPT_OUTSIDE_LIMIT
- SYS_INVALID_ROWID
- TIMEOUT_ON_RESOURCE
- VALUE_ERROR
- ZERO_DIVIDE
Attachments
Issue Links
- relates to
-
MDEV-10839
sql_mode=ORACLE: Predefined exceptions: TOO_MANY_ROWS, NO_DATA_FOUND, DUP_VAL_ON_INDEX
-
- Closed
-