"sysdate" as default value for oracle

[Gary Baker <ga...@movielink.com>]

There is a problem when specifying "sysdate" default value for a date
column.

<table name="MY_TABLE">
        <column name="MY_DATE_FIELD" type="DATE" default="sysdate"/>
</table>

Yields the following create table statement...

CREATE TABLE MY_TABLE
(
    MY_DATE_FIELD DATE default 'sysdate' NOT NULL
);

This is an invalid create table statement.  The following is correct
(sans quotes)...

CREATE TABLE MY_TABLE
(
    MY_DATE_FIELD DATE default sysdate NOT NULL
);

Has this been addressed?  I wasn't able to find any posts in the
archives addressing this issue.  
Anyone know where this code is?


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-dev-unsubscribe@db.apache.org
For additional commands, e-mail: torque-dev-help@db.apache.org