Bug #6338 SHOW CREATE FUNCTION incorrect error message

• Submitted: 30 Oct 2004 16:59
• Modified: 7 Jan 2005 18:43
• Reporter: Paul DuBois
• Status: Closed
• Category: MySQL Server
• Severity: S3 (Non-critical)
• Version: 5.0.2
• Assigned to: Jim Winstead
• CPU Architecture: Any

[30 Oct 2004 16:59] Paul DuBois

Description:
mysql> show create procedure x;
ERROR 1305 (42000): PROCEDURE x does not exist
mysql> show create function x;
ERROR 1305 (42000): PROCEDURE x does not exist

It'd be better if the second statement produced
FUNCTION x does not exist. :-)

How to repeat:
See above.

[4 Jan 2005 1:50] Jim Winstead

The macro used to figure out whether to put PROCEDURE or FUNCTION in the error message 
simply lacked a test for being called during a 'SHOW CREATE FUNCTION' statement.

[7 Jan 2005 18:43] Paul DuBois

No documentation changes required.