Description:
The creation time of a procedure/function looks like being changed when user ALTERs a p/f. Reproduced with changing the comment as well as name change. Also it looks strange to have modification and creation time set when a p/f is renamed (either the modification time should be NOW() or (the creation time will be NOW() and modtime will be 0000-00-00)
See examples.
How to repeat:
mysql> create procedure p1()begin end;
Query OK, 0 rows affected (0.00 sec)
mysql> show procedure status like 'p_';
+------+------+-----------+----------------+---------------------+---------------------+---------------+---------+
| Db | Name | Type | Definer | Modified | Created | Security_type | Comment |
+------+------+-----------+----------------+---------------------+---------------------+---------------+---------+
| test | p1 | PROCEDURE | root@localhost | 0000-00-00 00:00:00 | 2004-08-27 13:15:43 | DEFINER | |
+------+------+-----------+----------------+---------------------+---------------------+---------------+---------+
1 row in set (0.01 sec)
mysql> alter procedure p1 comment "foobar";
Query OK, 0 rows affected (0.00 sec)
mysql> show procedure status like 'p_';
+------+------+-----------+----------------+---------------------+---------------------+---------------+---------+
| Db | Name | Type | Definer | Modified | Created | Security_type | Comment |
+------+------+-----------+----------------+---------------------+---------------------+---------------+---------+
| test | p1 | PROCEDURE | root@localhost | 2004-08-27 13:15:54 | 2004-08-27 13:15:54 | DEFINER | foobar |
+------+------+-----------+----------------+---------------------+---------------------+---------------+---------+
1 row in set (0.00 sec)
mysql> alter procedure p1 name p3;
Query OK, 0 rows affected (0.00 sec)
mysql> show procedure status like 'p_';
+------+------+-----------+----------------+---------------------+---------------------+---------------+---------+
| Db | Name | Type | Definer | Modified | Created | Security_type | Comment |
+------+------+-----------+----------------+---------------------+---------------------+---------------+---------+
| test | p3 | PROCEDURE | root@localhost | 2004-08-27 13:16:04 | 2004-08-27 13:16:04 | DEFINER | foobar |
+------+------+-----------+----------------+---------------------+---------------------+---------------+---------+
1 row in set (0.00 sec)
