Bug #81008 Calling stored procedure through GUI does not generate correct SQL
Submitted: 8 Apr 2016 9:25 Modified: 11 Apr 2016 6:17
Reporter: Carl Partridge Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench Severity:S2 (Serious)
Version:6.3.6 build 511 CE OS:MacOS
Assigned to: CPU Architecture:Any

[8 Apr 2016 9:25] Carl Partridge
Description:
The MySQL Workbench GUI to call a stored procedure with user-entered parameters is fundamentally broken.

The application presents a window for the user to enter the procedure's parameters, however the SQL that is subsequently generated contains none of the entered parameters.

How to repeat:
1. Create a stored procedure, for testing purposes, that has at least one IN parameter

2. Within the GUI, move the mouse over the name of the Stored Procedure and click the 'execute' icon.  (it looks like a small lightning bolt)

3. A window appears to request user input for the parameter(s) to be passed to the stored procedure - type the name of a parameter into the text box.

4. A new SQL query is generated and executed - however, the query does not contain any of the parameters that were typed into the text box; instead just default values.

Suggested fix:
The parameters entered into the GUI text boxes need to be correctly passed through to form part of the generated SQL.
[11 Apr 2016 6:17] MySQL Verification Team
Hello Carl,

Thank you for the bug report.
This is most likely duplicate of Bug #80564.

Thanks,
Umesh