Migrator.NET
Migrator.NET copied to clipboard
SQL Server does not remove the unique index on ChangeColumn() with no ColumnProperty.Unique
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