logilab-database #1710753 [sqlserver] change_col_type should drop/recreate views like it does indices [validation pending]
On SQL Server, we create views to implement multi-column unique indices. When changing a column's type, we need to temporarily drop these views, or the ALTER COLUMN will fail: The object 'utv_cw_foo_unique_xxxxx' is dependent on column 'cw_bar'. (5074) (SQLExecDirectW) | |
priority | normal |
---|---|
type | bug |
done in | 1.13.4 |
load | 2.000 |
load left | 0.000 |
closed by | #63c53029d5ef [sqlserver] drop/recreate unique_together views/indexes around changing column type |
patch | [sqlserver] drop/recreate unique_together views/indexes around changing column type [applied] |