View Issue Details

IDProjectCategoryView StatusLast Update
0006193SymmetricDSBugpublic2024-01-15 18:14
Reporterpmarzullo Assigned Topmarzullo  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.15.2 
Target Version3.15.3Fixed in Version3.15.3 
Summary0006193: Adjusting unique indexes to non-unique when columns can be null should be able to be turned off by parameter
DescriptionThe functionality to change unique indexes to non-unique indexes, when one of the columns in the index can be null and the database does not allow more than one null value in the unique index for a column, needs to be able to be turned off by parameter if the customer does not want this behavior.

Also, when the functionality is executed, the platform specific index information needs to be added to the non-unique index (in the case of SQL Server, the index filter and the index compression).
Additional InformationThe new parameter is:
create.index.convert.unique.to.nonunique.when.columns.not.required

 and defaults to true.
Tagsddl/schema

Relationships

related to 0005782 closedjvanmeter Unique Index with Multiple Nulls not Properly Handled for Certain Databases 
related to 0006192 closedpmarzullo Adjusting unique indexes to non-unique when columns can be null should be able to be turned off by parameter 

Activities

Issue History

Date Modified Username Field Change
2024-01-15 18:01 pmarzullo New Issue
2024-01-15 18:01 pmarzullo Status new => assigned
2024-01-15 18:01 pmarzullo Assigned To => pmarzullo
2024-01-15 18:01 pmarzullo Tag Attached: ddl/schema
2024-01-15 18:01 pmarzullo Relationship added related to 0005782
2024-01-15 18:01 pmarzullo Relationship added related to 0006192
2024-01-15 18:14 pmarzullo Status assigned => resolved
2024-01-15 18:14 pmarzullo Resolution open => fixed
2024-01-15 18:14 pmarzullo Fixed in Version => 3.15.3
2024-01-15 18:14 pmarzullo Note Added: 0002405
2024-02-05 18:58 admin Status resolved => closed