Bug #30252 Com_create_function is not incremented.

Description:
When I created the function, the server status 'Com_create_function' was not incremented.

Meanwhile, dropping the function incremented the Com_drop_function.

How to repeat:
Please execute like this.

mysql> show global status like 'Com%function%';
+---------------------+-------+
| Variable_name       | Value |
+---------------------+-------+
| Com_create_function | 0     | 
| Com_drop_function   | 0     | 
+---------------------+-------+
2 rows in set (0.00 sec)

mysql> DELIMITER //
mysql> create function f1 (x INTEGER) returns integer
    -> begin
    ->   declare ret integer;
    ->   set ret = x * 10;
    ->   return ret;
    -> end
    -> //
Query OK, 0 rows affected (0.00 sec)

mysql> DELIMITER ;
mysql> drop function f1;
Query OK, 0 rows affected (0.00 sec)

mysql> show global status like 'Com%function%';
+---------------------+-------+
| Variable_name       | Value |
+---------------------+-------+
| Com_create_function | 0     | 
| Com_drop_function   | 1     | 
+---------------------+-------+
2 rows in set (0.01 sec)

Thank you for the report.

Verified as described.

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/40040

ChangeSet@1.2640, 2007-12-14 18:27:40-05:00, dkatz@damien-katzs-computer.local +3 -0
  Bug #30252	Com_create_function is not incremented.
  
  Added Com_create_spfunction and all other commands previously missing to the global status variables.

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/40166

ChangeSet@1.2647, 2007-12-18 23:59:32+01:00, serg@janus.mylan +2 -0
  followup for bug#30252
  ensure that all SQLCOM_ constants have corresponding Com_ variables

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/40169

ChangeSet@1.2648, 2007-12-19 01:27:15+01:00, serg@janus.mylan +2 -0
  Followup for bug#30252.
  Ensure that all SQLCOM_ constants have corresponding Com_ variables.

queued in 5.1-runtime

queued in 6.0-runtime

Pushed into 5.1.24-rc

Pushed into 6.0.5-alpha

Noted in 5.1.24, 6.0.5 changelogs.

The Com_create_function status variable was not incremented properly.

Also documented fix for 5.1.23-ndb-6.2.14.

Also documented fix for 5.1.23-ndb-6.3.11.