SetNullableGenerator using columnDataType in "raw" form?

Liquibase Development
1

Hi,

SetNullableGenerator is appending the contents of the columnDataType of an addNotNullConstraint in “raw” form to the sql-statement.

I don’t understand if this is “expected”, or if it’s just missing the calls to the TypeConverter.

Given a createTable with

followed by a

this leads to the following sql running against an mssql-server:

CREATE TABLE […] [SYS_AUD_TX_When] DATETIME, […]
ALTER TABLE [dbo].[SYS_AUD_TX] ALTER COLUMN [SYS_AUD_TX_When] TIMESTAMP NOT NULL

which in turn leads to

    Reason: liquibase.exception.DatabaseException: Error executing SQL ALTER TABLE [dbo].[SYS_AUD_TX] ALTER COLUMN [SYS_AUD_TX_When] TIMESTAMP NOT NULL:
          Caused By: Error executing SQL ALTER TABLE [dbo].[SYS_AUD_TX] ALTER COLUMN [SYS_AUD_TX_When] TIMESTAMP NOT NULL:
          Caused By: The SYS_AUD_TX_When-Column can not be changed to the timestamp-Datatype.
(last message translated by me from german)

2

(sorry for the slow response, was on vacation and this post had gotten buried in my list)

It should be doing the type conversion.  I committed a fix to trunk for RC6

Nathan