Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-524

Request: Variable number of arguments in Stored Routines

Details

    • Task
    • Status: Open (View Workflow)
    • Minor
    • Resolution: Unresolved
    • None
    • None
    • None

    Description

      Some Stored Routines would be more powerful/usable if we are able to declare a variable number of arguments. Two special functions may return the number of passed args, and the value of a given arg.
      As an alternative, you could implement optional parameters with a DEFAULT value, but this is less powerful.
      I think that this is only relevant for IN parameters, not OUT/INOUT.

      Attachments

        Issue Links

          relates to

          New Feature - A new feature of the product, which has yet to be developed. MDEV-10862 Stored procedures: default values for parameters (optional parameters)

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

          Activity

            Ascending order - Click to sort in descending order
            rustybailey Rusty Bailey added a comment -

            I notice that this was scheduled for 10.1, but 10.1.4 beta just released (https://blog.mariadb.org/mariadb-10-1-4-now-available/). Is this still planned soon? This is something that our team at work could really use.

            rustybailey Rusty Bailey added a comment - I notice that this was scheduled for 10.1, but 10.1.4 beta just released ( https://blog.mariadb.org/mariadb-10-1-4-now-available/ ). Is this still planned soon? This is something that our team at work could really use.
            serg Sergei Golubchik added a comment -

            No, sorry, this feature will not make it into 10.1.

            It was not really scheduled for 10.1, being Minor and Unassigned it was an optional nice-to-have feature in case someone has free time to pick it up. But nobody did.

            We're now considering it for 10.2, but there's no guarantee that it will be there.

            serg Sergei Golubchik added a comment - No, sorry, this feature will not make it into 10.1. It was not really scheduled for 10.1, being Minor and Unassigned it was an optional nice-to-have feature in case someone has free time to pick it up. But nobody did. We're now considering it for 10.2, but there's no guarantee that it will be there.
            f_razzoli Federico Razzoli added a comment -

            This would help in developing re-usable procedures, including open source libraries.

            f_razzoli Federico Razzoli added a comment - This would help in developing re-usable procedures, including open source libraries.

            People

              Unassigned Unassigned
              f_razzoli Federico Razzoli
              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.