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
            bar Alexander Barkov created issue -
            alvinr Alvin Richards (Inactive) made changes -
            Field Original Value New Value
            Labels Compatibility
            alvinr Alvin Richards (Inactive) made changes -
            Labels Compatibility
            alvinr Alvin Richards (Inactive) made changes -
            Parent Issue MDEV-10142 [ MDEV-10142 ] MDEV-10764 [ MDEV-10764 ]
            bar Alexander Barkov made changes -
            Fix Version/s 10.3 [ 22126 ]
            Fix Version/s 10.2 [ 14601 ]
            serg Sergei Golubchik made changes -
            Fix Version/s 10.3 [ 22126 ]
            bar Alexander Barkov made changes -
            alice Alice Sherepa made changes -
            ralf.gebhardt Ralf Gebhardt made changes -
            Assignee Alexander Barkov [ bar ]
            danblack Daniel Black made changes -
            Assignee Oleksandr Byelkin [ sanja ]
            bar Alexander Barkov made changes -
            Assignee Oleksandr Byelkin [ sanja ] Alexander Barkov [ bar ]
            ManoharKB Manohar KB made changes -
            Attachment TestCase.xlsx [ 60331 ]
            Attachment TestCase_MariaDB.zip [ 60332 ]
            Attachment TestCases_Oracle.zip [ 60333 ]
            ManoharKB Manohar KB made changes -
            Attachment TestCase_MariaDB.zip [ 60332 ]
            ManoharKB Manohar KB made changes -
            Attachment TestCases_Oracle.zip [ 60333 ]
            ManoharKB Manohar KB made changes -
            Attachment TestCase.xlsx [ 60331 ]
            ManoharKB Manohar KB made changes -
            Attachment TestCase.xlsx [ 60334 ]
            Attachment TestCase_MariaDB.zip [ 60335 ]
            Attachment TestCases_Oracle.zip [ 60336 ]
            bar Alexander Barkov made changes -
            Fix Version/s 10.8 [ 26121 ]
            bar Alexander Barkov made changes -
            Priority Major [ 3 ] Critical [ 2 ]
            serg Sergei Golubchik made changes -
            Fix Version/s 10.8.0 [ 26800 ]
            Fix Version/s 10.8 [ 26121 ]
            Resolution Fixed [ 1 ]
            Status Open [ 1 ] Closed [ 6 ]
            serg Sergei Golubchik made changes -
            Resolution Fixed [ 1 ]
            Status Closed [ 6 ] Stalled [ 10000 ]
            serg Sergei Golubchik made changes -
            Fix Version/s 10.8 [ 26121 ]
            Fix Version/s 10.8.0 [ 26800 ]
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 76780 ] MariaDB v4 [ 143486 ]
            serg Sergei Golubchik made changes -
            Status Stalled [ 10000 ] In Testing [ 10301 ]
            serg Sergei Golubchik made changes -
            Assignee Alexander Barkov [ bar ] Elena Stepanova [ elenst ]
            elenst Elena Stepanova made changes -
            Assignee Elena Stepanova [ elenst ] Roel Van de Paar [ roel ]
            Roel Roel Van de Paar made changes -
            ralf.gebhardt Ralf Gebhardt made changes -
            serg Sergei Golubchik made changes -
            Roel Roel Van de Paar made changes -
            Assignee Roel Van de Paar [ roel ] Sergei Golubchik [ serg ]
            Status In Testing [ 10301 ] Stalled [ 10000 ]
            Roel Roel Van de Paar made changes -
            serg Sergei Golubchik made changes -
            Assignee Sergei Golubchik [ serg ] Alexander Barkov [ bar ]
            serg Sergei Golubchik made changes -
            Priority Critical [ 2 ] Blocker [ 1 ]
            bar Alexander Barkov made changes -
            issue.field.resolutiondate 2022-01-24 16:42:47.0 2022-01-24 16:42:47.661
            bar Alexander Barkov made changes -
            Component/s Stored routines [ 13905 ]
            Fix Version/s 10.8.1 [ 26815 ]
            Fix Version/s 10.8 [ 26121 ]
            Resolution Fixed [ 1 ]
            Status Stalled [ 10000 ] Closed [ 6 ]
            ralf.gebhardt Ralf Gebhardt made changes -
            Labels Preview_10.8
            bar Alexander Barkov made changes -
            bar Alexander Barkov made changes -
            kokseng Wong Kok Seng made changes -
            bar Alexander Barkov made changes -

            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.