Bug #5841 Stored Procedure not found
Submitted: 1 Oct 2004 8:56 Modified: 13 Oct 2004 17:30
Reporter: Benjamin Arroyo Email Updates:
Status: Not a Bug Impact on me:
None 
Category:Connector / NET Severity:S2 (Serious)
Version:1.0.0 & MySQL 5.0.0 OS:Windows (Windows 2000 SP4)
Assigned to: Reggie Burnett CPU Architecture:Any

[1 Oct 2004 8:56] Benjamin Arroyo
Description:
Stored procedure didn't found by the connector because MySQL 5.0.0 doesn't save database's name about the procedure. 

This means 'db' field at 'proc' table of 'mysql' system's database is empty. Therefore the connector can't find the stored procedure by it's name and database's name that belongs to.

How to repeat:
Create a stored procedure, verify the empty field 'db' at 'proc' table of 'mysql' database. And call it using the connector.

Suggested fix:
¿Fix the creation method of MySQL database or modify the connector's find stored procedure method (and stored procedures belongs to all databases)?
[13 Oct 2004 17:30] Reggie Burnett
Thank you for taking the time to write to us, but this is not
a bug. Please double-check the documentation available at
http://www.mysql.com/documentation/ and the instructions on
how to report a bug at http://bugs.mysql.com/how-to-report.php

Additional info:

This is not a bug in the connector.  I think there is a problem in 5.0 where it is possible to save an SP without an associated database.  This is likely a bug in the server.