db-ddlutils-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Thomas Dudziak" <tom...@gmail.com>
Subject Re: Be more tolerance about model comparison.
Date Wed, 31 Jan 2007 06:54:22 GMT
On 1/30/07, Jun Li <allanjunli@gmail.com> wrote:

> DdlUtils considers the following two columns are different when comparing
> models.
>
> <column name="test" primaryKey="false" required="true" type="MUMERIC"
> size="18" autoIncrement="false"/>
>
>  <column name="test" primaryKey="false" required="true" type="REAL"
> size="18" autoIncrement="false"/>
>
> But, they are not at least on Oracle, therefore the sql update statements
> generated is kind of redundant.

Actually they are different: NUMERIC(18) means precision 18 and scale
0 and is mapped to Oracle's NUMBER(18) which is an integer data type.
For the JDBC type REAL, DdlUtils uses the Oracle datatype REAL instead
of NUMBER, which internally is mapped by Oracle to NUMBER with a
precision of 18 and some scale value that is not stated in the docs.

Tom

Mime
View raw message