Null constraint removed

Lora Griffin

September 26, 2024 16:59 Updated

Applies to:

Liquibase Enterprise

Conditions:

All Liquibase Enterprise releases prior to version 7.14
Microsoft SQLServer projects

Issue Summary:

When deploying a create table changeSet with some not nullable columns like the following:

CREATE TABLE [dbo].[InsuringEntityInformation]( 2 [InsuringEntityIdentifier] [bigint] NOT NULL 3) ON [PRIMARY]

The NOT NULL constraint is unexpectedly removed on that column if some alter table changeSet is executed against it (i.e., changing bigint type to varchar(50)):

ALTER TABLE dbo.InsuringEntityInformation 2 ALTER COLUMN [InsuringEntityIdentifier] [varchar](50) NOT NULL;

Root Cause:

This issue is a defect with the DiffChangelog workflow.

Resolution:

Upgrade to version 7.14 or higher