MySQL Bugs: #22024: Stored Procedure mal formation

Bug #22024	Stored Procedure mal formation
Submitted:	5 Sep 2006 15:34	Modified:	19 Sep 2006 1:48
Reporter:	thrash putopunto	Email Updates:
Status:	Closed	Impact on me:	None
Category:	Connector / J	Severity:	S3 (Non-critical)
Version:	mysql-connector-java-5.0.0-beta-bin	OS:	Linux (Gentoo Linux)
Assigned to:		CPU Architecture:	Any
Tags:	stored procedure parenthesis enter

Description:
Sorry, I dont speak english...

----------------------------------------------
CREATE PROCEDURE foo (
)
BEGIN
-- (...)
END

---> Message:   Internal error when parsing callable statement metadata (unknown output from 'SHOW CREATE PROCEDURE')
----------------------------------------------
CREATE PROCEDURE foo ()
BEGIN
-- (...)
END

---> OK!

How to repeat:
Foo.java

String driverStr = "org.gjt.mm.mysql.Driver";
static String url = "jdbc:mysql://localhost/ACCESO_EJB";

Class.forName("org.gjt.mm.mysql.Driver");
Connection con = DriverManager.getConnection(url, "foo", "xxx");

CallableStatement sentencia = con.prepareCall("{call foo_proc()}");
ResultSet rs = sentencia.executeQuery();

--------------------------------------------------

Foo.sql

CREATE PROCEDURE foo (
)
BEGIN
-- (...)
END

Hi Thrash and thanks for your bug report. Verified as described by reporter.

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/11855