DB2 Datatype - REAL and XML should not have datatype sizes

Description

Create table using REAL or XML datatypes. Note that datatype sizing is not accepted for these datatypes.

Generate a changeLog and notice that the datatype is sized: REAL(24) and XML(0). They should simply be REAL or XML.

<changeSet author="robert (generated)" id="1383245327365-14">
<createTable tableName="TESTREAL">
<column name="REAL_NULL" type="REAL"/>
<column name="REAL_NOTNULL" type="REAL">
<constraints nullable="false"/>
</column>
<column defaultValueNumeric="1" name="REAL_DEFAULT" type="REAL"/>
<column name="REAL_PK" type="REAL">
<constraints nullable="false"/>
</column>
<column name="REAL_UNIQUE" type="REAL">
<constraints nullable="false"/>
</column>
</createTable>
</changeSet>

<changeSet author="robert (generated)" id="1383245327365-20">
<createTable tableName="TESTXML">
<column name="XML_NULL" type="XML"/>
<column name="XML_NOTNULL" type="XML">
<constraints nullable="false"/>
</column>
</createTable>
</changeSet>

Environment

Windows 7, DB2

Status

Reporter

Kevin Chappell

Fix versions

Affects versions

Priority

Major
Configure