Bug #7222 information_schema: errors in "routines"

• Submitted: 13 Dec 2004 1:44
• Modified: 14 Dec 2004 9:42
• Reporter: Peter Gulutzan
• Status: Closed
• Category: MySQL Server
• Severity: S3 (Non-critical)
• Version: 5.0.3-alpha-debug
• OS: Linux (SUSE 9.2)
• Assigned to: Sergei Glukhov
• CPU Architecture: Any

[13 Dec 2004 1:44] Peter Gulutzan

Description:
This table always shows parameter_style = '' but it should be 
parameter_style = 'SQL'. 
Routine_body should be a minimum of 8 characters long. 
Parameter_style should be a minimum of 8 characters long. 
The sql_data_access column values should be 'CONTAINS SQL' 
not 'CONTAINS_SQL'. 
The DATA_TYPE_DESCRIPTOR value should be NULL for a procedure. 
There should be data type description for a function's return data type, 
the original task description should have mentioned this. 
 

How to repeat:
mysql> select parameter_style,sql_data_access from information_schema.routines; 
+-----------------+-----------------+ 
| parameter_style | sql_data_access | 
+-----------------+-----------------+ 
|                 | CONTAINS_SQL    | 
|                 | CONTAINS_SQL    | 
...

[14 Dec 2004 9:42] Sergei Glukhov

Fixed in 5.0 source tree