View Issue Details

Related ChangesetsJump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0005782SymmetricDSImprovementpublic2023-04-10 13:092024-01-15 18:01
Reporterjvanmeter Assigned Tojvanmeter  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.14.0 
Target Version3.14.7Fixed in Version3.14.7 
Summary0005782: Unique Index with Multiple Nulls not Properly Handled for Certain Databases
DescriptionIf a Unique Index with more than one null value is sent to a database that does not allow that, we get an error from the target database.
Steps To Reproduce1. Setup a database that allows multiple nulls in a Unique Index (Oracle) and one that does not (Sql Server)
2. Setup a table for replication from Oracle to Sql Server
3. Create a Unique Index on a column with multiple Null Values on the Oracle node
4. Try to send a create statement to the target database (Sql Server) and it will get an error when it tries to create the index
Tagsdata conversion

Relationships

related to 0006192 closedpmarzullo Adjusting unique indexes to non-unique when columns can be null should be able to be turned off by parameter 
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

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.14 eae714c4

2023-04-10 13:12:29

jakobvanmeter

Details Diff 		0005782: Unique Index with Multiple Nulls not Properly Handled for
Certain Databases		 Affected Issues
0005782
mod - symmetric-db/src/main/java/org/jumpmind/db/platform/AbstractDatabasePlatform.java Diff File
mod - symmetric-db/src/main/java/org/jumpmind/db/platform/IDatabasePlatform.java Diff File
mod - symmetric-io/src/main/java/org/jumpmind/symmetric/io/data/writer/DefaultDatabaseWriter.java Diff File
mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/db2/Db2DatabasePlatform.java Diff File
mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/derby/DerbyDatabasePlatform.java Diff File
mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/informix/InformixDatabasePlatform.java Diff File
mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/mssql/MsSql2000DatabasePlatform.java Diff File

Issue History

Date Modified Username Field Change
2023-04-10 13:09 jvanmeter New Issue
2023-04-10 13:09 jvanmeter Status new => assigned
2023-04-10 13:09 jvanmeter Assigned To => jvanmeter
2023-04-10 13:09 jvanmeter Tag Attached: data conversion
2023-04-10 13:13 jvanmeter Status assigned => resolved
2023-04-10 13:13 jvanmeter Resolution open => fixed
2023-04-10 14:00 Changeset attached => SymmetricDS 3.14 eae714c4
2023-05-12 19:49 admin Status resolved => closed
2024-01-15 17:59 pmarzullo Relationship added related to 0006192
2024-01-15 18:01 pmarzullo Relationship added related to 0006193