addColumn problem

General Discussion
1

I am having a strange problem when trying to add a new column to a database.

If have changeset that has the following property details

Now if I use the following

  1. <changeSet author="UnicentaOpos - John L"

    id=“Create Categories Table”>




The table is created ok, but

If a do the following to add the CATSHOWNAME column when it does not exist.

  1. <column name=“CATSHOWNAME”

    type="${boolean.type}" defaultValueBoolean=“true”>


I get the error that that smallint can hold the value of type Boolean.

Does any one have any Ideas why this is happening.

Thanks