Bug #5462 SHOW CREATE PROCEDURE doesn't work in Query Browser
Submitted: 8 Sep 2004 9:59 Modified: 8 Sep 2004 10:54
Reporter: Roger Wallace Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Query Browser Severity:S3 (Non-critical)
Version:1.0.5 alpha OS:
Assigned to: CPU Architecture:Any

[8 Sep 2004 9:59] Roger Wallace 
Description:
The MySQL Query Browser returns the following error for the MySQL extension SHOW CREATE PROCEDURE:
   
   PROCEDURE xxx does not exist!
   
The same error occurs for the JDBC GUI client QuantumDB, with the additional error details:

   SQL State: 42000
   Error Code: 1304

How to repeat:
1 If necessary create a simple stored procedure and install it using the command line client

2 Check the the SHOW CREATE PROCEDURE statement works on the command line client
   > SHOW CREATE PROCEDURE xxx

3 Launch the MySQL Query Browser and, using the "Query Browser" view, run the same SHOW CREATE PROCEDURE statement as before.
[8 Sep 2004 10:54] MySQL Verification Team 
Hi,

Thank you for the report! SHOE CREATE PROCEDURE works fine for me on version 1.0.7
[8 Sep 2004 12:32] Roger Wallace 
Downloaded version 1.0.7 and it works for me now. The problem still remains on JDBC base gui client though. Is there a connection option that can be set to enable this through JDBC? 

Thanks,
Roger