Bug #17809 support for DEFAULT CURRENT_USER
Submitted: 28 Feb 2006 22:24 Modified: 5 Mar 2006 9:30
Reporter: Peter Laursen (Basic Quality Contributor) Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: DML Severity:S4 (Feature request)
Version: OS:Any (any)
Assigned to: CPU Architecture:Any

[28 Feb 2006 22:24] Peter Laursen 
Description:
This request could save people some coding in situations where they want to keep track of who created or who last changed a recored:

Enable fuctionalities with CURRENT_USER as exists with CURRENT_TIMESTAMP.

How to repeat:
alter table `test`.`dummy` change `creator` `creator` varchar (50)  DEFAULT current_user;

Error Code : 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'current_user NOT NULL' at line 1
(0 ms taken)

Suggested fix:
implement support for 

DEFAULT CURRENT_USER

and even for 

DEFAULT CURRENT_USER on update CURRENT_USER
[5 Mar 2006 9:07] Valeriy Kravchuk 
Thank you for a reasonable feature request. This feature will be available as soon as expressions will be allowed in DEFAULT clause.
[5 Mar 2006 9:30] Peter Laursen 
Any idea when that will be ?