Bug #402 DEFAULTs should allow current user,timestamp..etc.
Submitted: 8 May 2003 11:12 Modified: 27 Aug 2003 13:21
Reporter: Peter Deacon Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S4 (Feature request)
Version:4.1 OS:Windows (win32)
Assigned to: CPU Architecture:Any

[8 May 2003 11:12] Peter Deacon 
Description:
Most of our use of DEFAULTS involve setting a default user or current time...etc. (Such as CURRENT_TIMESTAMP)  As I understand it you can only provide static values as defaults.

I'd love to see this restriction go away too :)

How to repeat:
[2 Jun 2003 9:31] Peter Gulutzan 
MySQL AB's general plan is to allow all SQL-standard features, and that 
includes support for: DEFAULT CURRENT_DATE, DEFAULT CURRENT_TIME, DEFAULT 
CURRENT_USER (or similar wording). 
 
This is on the "to do" list so it's possible to say: your request will be 
granted. However, it is not possible to state when.
[27 Aug 2003 13:21] Peter Zaitsev 
Closed as being already in intenrnal ToDo list