View Issue Details

IDProjectCategoryView StatusLast Update
0005782SymmetricDSImprovementpublic2023-04-10 14:00
Reporterjvanmeter Assigned Tojvanmeter  
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


There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.14 eae714c4

2023-04-10 13:12:29


Details Diff
0005782: Unique Index with Multiple Nulls not Properly Handled for
Certain Databases
Affected Issues
mod - symmetric-db/src/main/java/org/jumpmind/db/platform/ Diff File
mod - symmetric-db/src/main/java/org/jumpmind/db/platform/ Diff File
mod - symmetric-io/src/main/java/org/jumpmind/symmetric/io/data/writer/ Diff File
mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/db2/ Diff File
mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/derby/ Diff File
mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/informix/ Diff File
mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/mssql/ 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