| Bug #30252 | Com_create_function is not incremented. | ||
|---|---|---|---|
| Submitted: | 6 Aug 2007 9:56 | Modified: | 1 Feb 2008 18:31 |
| Reporter: | mantani shigeki | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server: Stored Routines | Severity: | S3 (Non-critical) |
| Version: | 5.0.44, 5.1, 5.2 | OS: | Linux (RHEL ES update4) |
| Assigned to: | CPU Architecture: | Any | |
[6 Aug 2007 10:15]
Sveta Smirnova
Thank you for the report. Verified as described.
[14 Dec 2007 23:28]
Bugs System
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.
[18 Dec 2007 22:55]
Bugs System
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
[19 Dec 2007 0:23]
Bugs System
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.
[19 Dec 2007 0:28]
Sergei Golubchik
queued in 5.1-runtime
[19 Dec 2007 13:08]
Sergei Golubchik
queued in 6.0-runtime
[25 Jan 2008 12:35]
Bugs System
Pushed into 5.1.24-rc
[25 Jan 2008 12:39]
Bugs System
Pushed into 6.0.5-alpha
[1 Feb 2008 18:31]
Paul DuBois
Noted in 5.1.24, 6.0.5 changelogs. The Com_create_function status variable was not incremented properly.
[6 Mar 2008 9:01]
Jon Stephens
Also documented fix for 5.1.23-ndb-6.2.14.
[30 Mar 2008 18:55]
Jon Stephens
Also documented fix for 5.1.23-ndb-6.3.11.
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)