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: Problem with using DdlUtils with MySql
Date Thu, 14 Feb 2008 03:19:04 GMT
Hi Satish,

could you post the definition of the existing table (i.e. the CREATE
TABLE statement), and the part from the schema XML that defines how
this table should look like ? Also, which MySql version are you using
?

Tom

On Feb 12, 2008 3:05 PM, Satish Yellanki <satish.yellanki@ineoquest.com> wrote:
> Hello,
>
> I am trying to use DdlUtil with MySql database to upgrade from one
> version to another. I create a model file from the latest schema and try
> to alter an existing database to match that file. However, there is
> problem with the default values.
>
> Some of the columns have default values defined as "" (empty string),
> while some don't have any default values. However, the DdlUtils package
> out of the box is treating them the same... the xml output I create does
> not have any default values in it.
>
> When I add a new column to the database which is "NOT NULL" and has a
> default value of "", the utility is trying to delete the existing table
> and recreate it. I understand that this is because the utility assumes
> there is no default value and since it cannot add a NOT NULL column
> without a default, it is deleting and re-creating the table.
>
> Is there a way I can make MySql handler treat the "" (Empty String) and
> null values differently and also, save the "" default values in the
> model file? This could potentially solve my problem.
>
> Thanks,
>
> Satish

Mime
View raw message