Bug #15975 Optional parameters support in stored procedures
Submitted: 24 Dec 2005 17:49 Modified: 25 Dec 2005 7:22
Reporter: Roberto Meardi
Status: Verified
Category:Server: SP Severity:S4 (Feature request)
Version:5.0 OS:Microsoft Windows (Windows)
Assigned to: Target Version:
Triage: Triaged: D5 (Feature request)

[24 Dec 2005 17:49] Roberto Meardi 
Description:
I've been using MSSQL for a couple of years. I write almost all the sql statements in
stored procedures, so I can encapsulate data logic, that can be changed later without
recompiling my application.
In MySQL v5.0 you came out with Stored Procedure support, so I downloaded it and began
using it. Currently I'm translating my stored procedures in mssql to mysql. But I've come
with a BIG problem. MySQL stored procedures do not support optional parameters, so, if I
want to change my undelying database system, I'd have to write almost all the data access
layer for my applications.
This is why I'm requesting Optional Parameters support for Stored Procedures...

How to repeat:
Feature request
[25 Dec 2005 7:22] Valeriy Kravchuk 
Thank you for a useful feature request. By optional parameter you mean the one with
default value, I believe... So, that the value for it can be ommited in the SP call.
Oracle's PL/SQL also has this feature. I think it should be implemented as soon as
possible to simplify migration from other RDBMS to MySQL 5.
[3 Sep 9:46] The Assimilator 
Please advise of the status of this bug. Has this been implemented yet? If so, what
version of MySQL is it available in? And if not, why not?
[20 Sep 12:52] Meir Guttman 
I cannot stress enough the importance of such!
Any plans for implementing this???
Meir