Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-10764 PL/SQL parser - Phase 2
  3. MDEV-10586

sql_mode=ORACLE: Predefined exceptions (part 2)

    XMLWordPrintable

    Details

    • Type: Technical task
    • Status: Open (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: OTHER
    • Labels:

      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

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              bar Alexander Barkov
              Votes:
              3 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated: