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

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.042 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.