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

IN, OUT, INOUT parameters in CREATE FUNCTION

    XMLWordPrintable

Details

    Description

      When running with the default sql_mode, MariaDB does not support qualifiers in stored function parameters. Qualifiers are only supported in stored procedure parameters.

      When running with sql_mode=ORACLE, MariaDB should support IN, OUT, INOUT parameter qualifiers in CREATE FUNCTION, for Oracle compatibility.

      Attachments

        2. TestCase.xlsx
          15 kB
          Manohar KB

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-27331 FUNCTION declaration fails with ERROR 1064 (error in SQL) when using oracle sql_mode and OUT parameter

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-15715 sql_mode = Oracle with MariaDB 10.3.4 and Store procedure

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-17762 PL/SQL FUNCTION arguments with IN/OUT declaration fails

          • Major - Major loss of function.
          • Closed
          is part of

          Task - A task that needs to be done. MDEV-27373 Q1 2022 release merge

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed
          relates to

          Task - A task that needs to be done. MDEV-27574 MDEV-10654 (IN, OUT, INOUT parameters) documentation items

          • Major - Major loss of function.
          • Open

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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