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

• Submitted: 2 Jan 2006 18:28
• Reporter: Hasani Blackwell
• Status: Open
• Category: Server
• Severity: S4 (Feature request)
• Version: 5.0.18
• OS: Microsoft Windows (Windows 2000 SP4)
• Triage: D5 (Feature request)

[2 Jan 2006 18: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.