View Issue Details

IDProjectCategoryView StatusLast Update
0006192SymmetricDSBugpublic2024-02-15 20:28
Reporterpmarzullo Assigned Topmarzullo  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.14.11 
Target Version3.14.12Fixed in Version3.14.12 
Summary0006192: 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 0006193 closedpmarzullo Adjusting unique indexes to non-unique when columns can be null should be able to be turned off by parameter 

Activities

Related Changesets

SymmetricDS: 3.14 b1614a01

2024-01-15 18:02:33

pmarzullo

Details Diff
0006192: Adjusting unique indexes to non-unique when columns can be null
should be able to be turned off by parameter
Affected Issues
0006192
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/common/ParameterConstants.java Diff File
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/load/AbstractDataLoaderFactory.java Diff File
mod - symmetric-core/src/main/resources/symmetric-default.properties Diff File
mod - symmetric-io/src/main/java/org/jumpmind/symmetric/io/data/writer/DatabaseWriterSettings.java Diff File
mod - symmetric-io/src/main/java/org/jumpmind/symmetric/io/data/writer/DefaultDatabaseWriter.java Diff File

SymmetricDS: 3.15 4f353ac2

2024-01-15 18:02:33

pmarzullo

Details Diff
0006192: Adjusting unique indexes to non-unique when columns can be null
should be able to be turned off by parameter
Affected Issues
0006192
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/common/ParameterConstants.java Diff File
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/load/AbstractDataLoaderFactory.java Diff File
mod - symmetric-core/src/main/resources/symmetric-default.properties Diff File
mod - symmetric-io/src/main/java/org/jumpmind/symmetric/io/data/writer/DatabaseWriterSettings.java Diff File
mod - symmetric-io/src/main/java/org/jumpmind/symmetric/io/data/writer/DefaultDatabaseWriter.java Diff File

Issue History

Date Modified Username Field Change
2024-01-15 17:59 pmarzullo New Issue
2024-01-15 17:59 pmarzullo Status new => assigned
2024-01-15 17:59 pmarzullo Assigned To => pmarzullo
2024-01-15 17:59 pmarzullo Tag Attached: ddl/schema
2024-01-15 17:59 pmarzullo Relationship added related to 0005782
2024-01-15 18:01 pmarzullo Relationship added related to 0006193
2024-01-15 18:22 pmarzullo Status assigned => resolved
2024-01-15 18:22 pmarzullo Resolution open => fixed
2024-01-15 18:22 pmarzullo Fixed in Version => 3.14.12
2024-01-15 18:22 pmarzullo Note Added: 0002406
2024-02-05 18:57 admin Status resolved => closed
2024-02-15 20:28 pmarzullo Changeset attached => SymmetricDS 3.14 b1614a01
2024-02-15 20:28 pmarzullo Changeset attached => SymmetricDS 3.15 4f353ac2