Oracle Data Type: DATE - defaultValueComputed should be defaultValue

Description

Create table using the following DDL:

CREATE TABLE TESTDATE( DATE_NULL DATE NULL, DATE_NOTNULL DATE NOT NULL, DATE_DEFAULT DATE DEFAULT '01-JAN-00' , DATE_PK DATE , DATE_UNIQUE DATE , CONSTRAINT PK_DATE PRIMARY KEY (DATE_PK) , CONSTRAINT UN_DATE UNIQUE (DATE_UNIQUE) );

Generate Change Log will give you this:

<changeSet author="robert" id="1382988622897-2">
<createTable tableName="TESTDATE">
<column name="DATE_NULL" type="date"/>
<column name="DATE_NOTNULL" type="date">
<constraints nullable="false"/>
</column>
<column defaultValueComputed="01-JAN-00" name="DATE_DEFAULT" type="date"/>
<column name="DATE_PK" type="date">
<constraints nullable="false"/>
</column>
<column name="DATE_UNIQUE" type="date"/>
</createTable>
</changeSet>

Notice the use of defaultValueComputed. This attribute is used for functions, but this is not a function. It's just a straight default value and should be gen'd like this:

<column defaultValue="01-JAN-00" name="DATE_DEFAULT" type="date"/>

Environment

Windows 8, Oracle

Status

Reporter

Kevin Chappell

Fix versions

Affects versions

Priority

Major
Configure