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)