Bug #49410 Com_call_function status variable is missing
Submitted: 3 Dec 2009 18:37
Reporter: Oli Sennhauser Email Updates:
Status: Verified Impact on me:
None 
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.