MySQL Bugs: #17148: Stored Procedure arguments listed in wrong order

Bug #17148	Stored Procedure arguments listed in wrong order
Submitted:	6 Feb 2006 6:44	Modified:	4 Dec 2006 11:47
Reporter:	Dave Brown	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Query Browser	Severity:	S3 (Non-critical)
Version:	1.1.19	OS:	Windows (Windows XP)
Assigned to:	Mike Lischke	CPU Architecture:	Any
Tags:	Generic

Description:
Clicking the expand-caret for a Stored Procedure (or Function) in the Schemata lists the function argument names in *alphabetical* order, instead of the actual declared order in the function.  This is very annoying and confusing.

How to repeat:
Create any stored procedure or function and give it some arguments. Then expand the caret for it in the right-hand Schemata tab.

Suggested fix:
List the arguments in the order they should be passed to the stored proc!

verified the order is indeed alphabetical on QB 1.1.19/W2kSP4

How to repeat:

1. First create a procedure.

DELIMITER $$

DROP PROCEDURE IF EXISTS `test`.`bug17148` $$
CREATE PROCEDURE `bug17148`(IN c BIGINT, IN a BIGINT, OUT g BIGINT)
BEGIN
	SET g=1;
END $$

DELIMITER ;

2.  in  query browser, expand the arrow on the procedure name (see screenshot snipping.

As a workaround, you can select "Edit procedure" and view the correct code in the main workspace, but it can be annoying.

order is wrong. should be c, a, g instead of a, c, g

Attachment: screenshot.jpg (image/jpeg, text), 1.81 KiB.

Thank you for your bug report. This issue has been committed to our source repository of that product and will be incorporated into the next release.

If necessary, you can access the source repository and build the latest available version, including the bug fix. More information about accessing the source trees is available at

    http://dev.mysql.com/doc/en/installing-source.html