Bug #16130 A stored procedure can have the same name has a function.

• Submitted: 2 Jan 2006 17:28
• Reporter: Hasani Blackwell
• Status: Open
• Category: MySQL Server
• Severity: S4 (Feature request)
• Version: 5.0.18
• OS: Windows (Windows 2000 SP4)
• CPU Architecture: Any

[2 Jan 2006 17:28] Hasani Blackwell

Description:
A mysql procedure can have the same name as a mysql function because the primary keys of the mysql.proc table are `db`, `name`, and `type`. I'm just questioning why is `type` included as a primary key? I can see this being unecessary because functions are always executed using the 'SELECT' statement and procedures are always executing using the 'CALL' statement but I feel that name sharing shouldn't be allowed.

How to repeat:
N/A

Suggested fix:
Drop `type` as a primary key.