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

[5 Sep 2006 15:34] thrash putopunto
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
[13 Sep 2006 9:07] Tonci Grgin
Hi Thrash and thanks for your bug report. Verified as described by reporter.
[13 Sep 2006 14:43] Bugs System
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