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

    • Technical task
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • None
    • None
    • OTHER

    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

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

              Dates

                Created:
                Updated:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.