Bug #49410 Com_call_function status variable is missing

• Submitted: 3 Dec 2009 18:37
• Reporter: Oli Sennhauser
• Status: Verified
• Category: MySQL Server: Information schema
• Severity: S4 (Feature request)
• Version: 5.1.40
• OS: Any
• Assigned to: Geir Høydalsvik
• CPU Architecture: Any
• Tags: Com_call_function, STATUS, variable

[3 Dec 2009 18:37] Oli Sennhauser

Description:
For stored procedures we have:

+----------------------+-------+
| Variable_name        | Value |
+----------------------+-------+
| Com_alter_procedure  | 0     |
| Com_call_procedure   | 1     |
| Com_create_procedure | 1     |
| Com_drop_procedure   | 1     |
+----------------------+-------+

For stored functions we have only:

+---------------------+-------+
| Variable_name       | Value |
+---------------------+-------+
| Com_alter_function  | 0     |
| Com_create_function | 1     |
| Com_drop_function   | 1     |
+---------------------+-------+

The call of functions is counted in the Com_select field. Which does not really help much to see how many times a stored function was called.

How to repeat:
Create a function, call the function.

Suggested fix:
Com_call_function should be counted separately from Com_select.