MySQL Bugs: #2303: mutiple IN parameters of type VARCHAR not allowed

Bug #2303	mutiple IN parameters of type VARCHAR not allowed
Submitted:	7 Jan 2004 3:52	Modified:	7 Jan 2004 6:54
Reporter:	Peter neville	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server	Severity:	S2 (Serious)
Version:	5.0.0.alpha	OS:	Windows (windows xp)
Assigned to:	Per-Erik Martin	CPU Architecture:	Any

Description:
Error message generated when trying to create a stored procedure with multiple input parameters of VARCHAR. One VARCHAR is okay, more than one INT is okay, but more than one VARCHAR generates an error and cannot compile.

How to repeat:
create procedure test(
IN param1 VARCHAR,
IN param2 VARCHAR,
IN param3 VARCHAR,
OUT param4 VARCHAR)

BEGIN

END
;

Sorry, but the bug system is not the appropriate forum for asking
support questions. Your problem is not the result of a bug.
For a list of more appropriate places to ask for help using MySQL
products, please visit http://www.mysql.com/support/

Thank you for your interest in MySQL.

Additional info:

The syntax is VARCHAR(length), with the length bit mandatory.

This works:

create procedure test (
 IN param1 VARCHAR(4),
 IN param2 VARCHAR(8),
 IN param3 VARCHAR(16),
 OUT param4 VARCHAR(32))
BEGIN
END;