On 1/30/07, Jun Li <[EMAIL PROTECTED]> 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
