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: