View Issue Details

Related ChangesetsJump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0006572SymmetricDSBugpublic2024-08-30 17:282024-08-30 18:00
Reporterelong Assigned Toelong  
Prioritynormal 
Status resolvedResolutionfixed 
Product Version3.9.16 
Target Version3.15.9Fixed in Version3.15.9 
Summary0006572: SQL Server updates create duplicate rows with datetime2 in primary key
DescriptionOn SQL-Server, when using datetime2(7) in the primary key, and using db.treat.date.time.as.varchar.enabled=true parameter, updates will cause a duplicate row to be inserted. This is happening because the string of timestamp is cast to a datetime2(6), so only the microseconds are used instead of the nanoseconds.
Tagsdialect: sql-server

Relationships

related to 0003837 resolvedjosh-a-hicks MSSQL Support for datetime2 values that are before January 1, 1753 

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.15 08d18303

2024-08-30 17:32:02

admin

Details Diff 		0006572: SQL Server updates create duplicate rows with datetime2 in
primary key		 Affected Issues
0006572
mod - symmetric-db/src/main/java/org/jumpmind/db/platform/mssql/MsSqlDmlStatement.java Diff File

Issue History

Date Modified Username Field Change
2024-08-30 17:28 elong New Issue
2024-08-30 17:28 elong Status new => assigned
2024-08-30 17:28 elong Assigned To => elong
2024-08-30 17:28 elong Tag Attached: dialect: sql-server
2024-08-30 17:30 elong Relationship added related to 0003837
2024-08-30 17:32 elong Status assigned => resolved
2024-08-30 17:32 elong Resolution open => fixed
2024-08-30 17:32 elong Fixed in Version => 3.15.9
2024-08-30 18:00 admin Changeset attached => SymmetricDS 3.15 08d18303