PL/SQL parser - Phase 2 (MDEV-10764)

[MDEV-10586] sql_mode=ORACLE: Predefined exceptions (part 2) Created: 2016-08-18  Updated: 2018-02-14

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

Type: Technical task Priority: Major
Reporter: Alexander Barkov Assignee: Unassigned
Resolution: Unresolved Votes: 3
Labels: Compatibility

Issue Links:
Relates
relates to MDEV-10839 sql_mode=ORACLE: Predefined exception... Closed

 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

Generated at Thu Feb 08 07:43:21 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.