Bug #67996 INFORMATION_SCHEMA.ROUTINES view missing param_list column

• Submitted: 31 Dec 2012 9:00
• Modified: 31 Dec 2012 9:16
• Reporter: Shlomi Noach (OCA)
• Status: Not a Bug
• Category: MySQL Server: Information schema
• Severity: S3 (Non-critical)
• Version: >= 5.0
• OS: Any
• CPU Architecture: Any
• Tags: information_schema, metadata, routines

[31 Dec 2012 9:00] Shlomi Noach

Description:
The INFORMATION_SCHEMA.ROUTINES view is missing the parameters list. This data does appear in mysql.proc table, and this makes the ROUTINES view incomplete and inconsistent.

How to repeat:
DESC INFORMATION_SCHEMA.ROUTINES;

no "parameters to routine" column.

Suggested fix:
Add PARAM_LIST column to INFORMATION_SCHEMA.ROUTINES

[31 Dec 2012 9:06] MySQL Verification Team

Isn't the PARAMETERS table fulfilling the need?

http://dev.mysql.com/doc/refman/5.5/en/parameters-table.html

[31 Dec 2012 9:14] Shlomi Noach

Erm... Yes.
I can assume this can not be fixed for 5.1.
Face/palm - just noticed it exists.

[31 Dec 2012 9:16] MySQL Verification Team

So "Not a Bug".  Correct assumption regarding not fixing 5.1 :)