Bug #16130 A stored procedure can have the same name has a function.
Submitted: 2 Jan 2006 17:28
Reporter: Hasani Blackwell Email Updates:
Status: Open Impact on me:
Category:MySQL Server Severity:S4 (Feature request)
Version:5.0.18 OS:Windows (Windows 2000 SP4)
Assigned to: CPU Architecture:Any

[2 Jan 2006 17:28] Hasani Blackwell
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:

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