Bug #13956 CURRENT_TIME
Submitted: 12 Oct 2005 9:20 Modified: 12 Oct 2005 10:31
Reporter: Melvin Zamora Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server Severity:S1 (Critical)
Version:5 OS:Windows (Windows XP)
Assigned to: CPU Architecture:Any

[12 Oct 2005 9:20] Melvin Zamora 
Description:
CURRENT_TIME Keyword Reports an error if used in DDL.

CREATE TABLE MYTABLE (

     MY_ID INTEGER PRIMARY KEY AUTO_INCREMENT,

     -- this one shows an error.
     MY_CURRENT_TIME TIME DEFAULT CURRENT_TIME

) TYPE=INNODB;

How to repeat:
CREATE TABLE MYTABLE (

     MY_ID INTEGER PRIMARY KEY AUTO_INCREMENT,

     -- this one shows an error.
     MY_CURRENT_TIME TIME DEFAULT CURRENT_TIME

) TYPE=INNODB;

Suggested fix:
none
[12 Oct 2005 9:23] Melvin Zamora 
CREATE TABLE MYTABLE (

     MY_ID INTEGER PRIMARY KEY AUTO_INCREMENT,

     -- this one shows an error.
     MY_CURRENT_TIME TIME DEFAULT CURRENT_TIME

) TYPE=INNODB;

IS THIS A BUG, OR SOME KIND OF DEPRECATED KEYWORD? IF IT IS DEPRECATED WHAT
WOULD BE THE REPLACEMENT USAGE. AND IF IT IS NOT, ANY SUGGESTION ON WORK AROUND.
I AM USING THIS AS I MIGRATE MY SQLS DDL FROM HSQLDB AS PART OF MY PROJECT.
THANK YOU. please send me and email if there is a solution at mijzcx@yahoo.com
[12 Oct 2005 10:31] Valeriy Kravchuk 
We're sorry, but the bug system is not the appropriate forum for 
asking help on using MySQL products. Your problem is not the result 
of a bug.

Support on using our products is available both free in our forums
at http://forums.mysql.com and for a reasonable fee direct from our
skilled support engineers at http://www.mysql.com/support/

Thank you for your interest in MySQL.

Additional info:

There is no appropriate "automatic timing default" for TIME columns. Read the http://dev.mysql.com/doc/mysql/en/create-table.html:

"The DEFAULT clause specifies a default value for a column. With one exception, the default value must be a constant; it cannot be a function or an expression. This means, for example, that you cannot set the default for a date column to be the value of a function such as NOW() or CURRENT_DATE. The exception is that you can specify CURRENT_TIMESTAMP as the default for a TIMESTAMP column."