[MDEV-524] Request: Variable number of arguments in Stored Routines Created: 2012-09-11  Updated: 2019-03-08

Status: Open
Project: MariaDB Server
Component/s: None
Fix Version/s: None

Type: Task Priority: Minor
Reporter: Federico Razzoli Assignee: Unassigned
Resolution: Unresolved Votes: 3
Labels: None

Issue Links:
Relates
relates to MDEV-10862 Stored procedures: default values for... Open

 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.



 Comments   
Comment by Rusty Bailey [ 2015-04-29 ]

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.

Comment by Sergei Golubchik [ 2015-04-29 ]

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.

Comment by Federico Razzoli [ 2015-04-29 ]

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

Generated at Thu Feb 08 06:29:23 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.