multiple current_timestamp

Hi all,

Why can there be only one timestamp field with current_timestamp in default or on update?

I've been wondered about this for a long time. A table often has a field
`date_added`, with the current timestamp only as default, and a field
`date_changed` with a changing timestamp upon updating. Basically it is
irritating me, since now I have to either solve this in code or use a trigger. Also because I do not understand why this limitation is necessary.

Is this something that is subjected to change in MySQL 6? I haven't seen any plans for it.

Best regards,
Arnold

-- 
MySQL Internals Mailing List
For list archives: 
http://lists.mysql.com/internals
To unsubscribe:    
http://lists.mysql.com/internals?unsub=lists@pantek.com