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'
);
This is an invalid create table statement. The following is correct
(sans quotes)...
CREATE TABLE MY_TABLE
(
MY_DATE_FIELD DATE default sysdate
);
Has this been addressed? I wasn't able to find any posts in the
archives addressing this issue.
-Gary