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

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

        Issue Links

          blocks

          New Feature - A new feature of the product, which has yet to be developed. MDEV-34323 Oracle compatibility project 3

          • Major - Major loss of function.
          • Open
          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

          Task - A task that needs to be done. MDEV-34648 Support Composite Variable, Associative Arrays, in Procedure Parameter out

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-36179 Assertion `0' failed in virtual bool Type_handler_row::Item_save_in_value(THD*, Item*, st_value*) const

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

          Activity

            Ascending order - Click to sort in descending order
            View 6 older comments
            ManoharKB Manohar KB added a comment - - edited

            Thank you.

            I have added test cases to and pushed the changes.
            1. mysql-test/suite/compat/oracle/t/func_inout.test
            2. mysql-test/suite/compat/oracle/r/func_inout.result

            As the ticket description says, this fix only supports when sql_mode='ORACLE';

            ManoharKB Manohar KB added a comment - - edited Thank you. I have added test cases to and pushed the changes. 1. mysql-test/suite/compat/oracle/t/func_inout.test 2. mysql-test/suite/compat/oracle/r/func_inout.result As the ticket description says, this fix only supports when sql_mode='ORACLE';
            serg Sergei Golubchik added a comment -

            pushed into preview-10.8-MDEV-10654-inout branch

            serg Sergei Golubchik added a comment - pushed into preview-10.8- MDEV-10654 -inout branch
            danblack Daniel Black added a comment - - edited

            Preview notice: https://mariadb.org/?p=24584&preview=1&_ppp=08ff268aca

            ManoharKB anything to add/change? If you want to credit an employer please let net me know.

            danblack Daniel Black added a comment - - edited Preview notice: https://mariadb.org/?p=24584&preview=1&_ppp=08ff268aca ManoharKB anything to add/change? If you want to credit an employer please let net me know.
            Roel Roel Van de Paar added a comment - - edited

            Both myself and ramesh tested this feature and no major issues were observed. Please note this comment however (this could be made clear in the manual).

            OK to push and with thanks to the implementer for the two high quality MTR testcases.

            Roel Roel Van de Paar added a comment - - edited Both myself and ramesh tested this feature and no major issues were observed. Please note this comment however (this could be made clear in the manual). OK to push and with thanks to the implementer for the two high quality MTR testcases.
            Roel Roel Van de Paar added a comment -

            Logged MDEV-27574 MDEV-10654 (IN, OUT, INOUT parameters) documentation items

            Roel Roel Van de Paar added a comment - Logged MDEV-27574 MDEV-10654 (IN, OUT, INOUT parameters) documentation items

            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.