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

Request: Variable number of arguments in Stored Routines

    Details

    • Type: Task
    • Status: Open
    • Priority: Minor
    • Resolution: Unresolved
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      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.

        Gliffy Diagrams

          Attachments

            Activity

            Hide
            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.

            Show
            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.
            Hide
            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.

            Show
            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.
            Hide
            f_razzoli Federico Razzoli added a comment -

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

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

              People

              • Assignee:
                Unassigned
                Reporter:
                f_razzoli Federico Razzoli
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated: