Oracle Data Type: INTERVAL YEAR TO MONTH - returned at "INTERNAL(2) YEAR"

Description

NOTE: HAVING SAME ISSUE WITH "INTERVAL DAY TO SECOND"

Create table using the following:

CREATE TABLE TESTINTERVAL_YEAR_TO_MONTH( INTERVAL_YEAR_TO_MONTH_NULL INTERVAL YEAR TO MONTH NULL, INTERVAL_YEAR_TO_MONTH_NOTNULL INTERVAL YEAR TO MONTH NOT NULL, INTERVAL_YEAR_TO_MONTH_PK INTERVAL YEAR TO MONTH , INTERVAL_YEAR_TO_MONTH_UNIQUE INTERVAL YEAR TO MONTH , CONSTRAINT PK_INTERVAL_YEAR_TO_MONTH PRIMARY KEY (INTERVAL_YEAR_TO_MONTH_PK) , CONSTRAINT UN_INTERVAL_YEAR_TO_MONTH UNIQUE (INTERVAL_YEAR_TO_MONTH_UNIQUE) );

Snapshot returns:

<changeSet author="robert" id="1382988693362-3">
<createTable tableName="TESTINTERVAL_YEAR_TO_MONTH">
<column name="INTERVAL_YEAR_TO_MONTH_NULL" type="INTERVAL(2) YEAR"/>
<column name="INTERVAL_YEAR_TO_MONTH_NOTNULL" type="INTERVAL(2) YEAR">
<constraints nullable="false"/>
</column>
<column name="INTERVAL_YEAR_TO_MONTH_PK" type="INTERVAL(2) YEAR">
<constraints nullable="false"/>
</column>
<column name="INTERVAL_YEAR_TO_MONTH_UNIQUE" type="INTERVAL(2) YEAR"/>
</createTable>
</changeSet>

Should have "INTERVAL YEAR TO MONTH" as the type.

Environment

Windows 8, Oracle

Status

Reporter

Kevin Chappell

Fix versions

Affects versions

Priority

Major
Configure