Migrator.NET icon indicating copy to clipboard operation
Migrator.NET copied to clipboard

SQL Server does not remove the unique index on ChangeColumn() with no ColumnProperty.Unique

Open JaBistDuNarrisch opened this issue 3 months ago • 0 comments

On SQL Server and may be on others as well a unique index is created if using ColumnProperty.Unique.

If the ColumnProperty.Unique is removed by changing the column using ChangeColumn(), the unique index is not removed.

This one is tricky since it could remove an index that was intended and that matches the naming pattern used in ChangeColumn().

https://github.com/dotnetprojects/Migrator.NET/blob/00fbba47334029efc866f7ead7d9b521ce8ee224/src/Migrator.Tests/Providers/SQLServer/SQLServerTransformationProvider_ChangeColumnTests.cs#L39

=> Remove Ignore in test after fix

https://github.com/dotnetprojects/Migrator.NET/blob/d17eab4ec42764b100862bf1252dfa0b1118b923/src/Migrator/Providers/TransformationProvider.cs#L562

JaBistDuNarrisch avatar Oct 10 '25 07:10 JaBistDuNarrisch