View Issue Details

IDProjectCategoryView StatusLast Update
0004246SymmetricDSBugpublic2022-08-08 19:31
Reporterpmarzullo Assigned Topmarzullo  
Status closedResolutionfixed 
Product Version3.11.3 
Target Version3.11.4Fixed in Version3.11.4 
Summary0004246: Conflict Resolution: Problem with timestamp with time zones as the USE_TIMESTAMP column
DescriptionWhen the USE_TIMESTAMP type of conflict resolution is configured, and the specified column is a Timestamp with time zone type of column, we have problems parsing that type of column, and the conflict resolution does not get resolved.
Steps To Reproduce1. Configure conflict resolution with a USE_TIMESTAMP type, and specify the timestamp column to use that is a timestamp with time zone type.
2. Cause a conflict, where the target timestamp with time zone column has a value greater than the source column.
3. The source values will still be written to the target.
Additional InformationOracle and Postgres have timestamp with time zone types.
Tagsconflict manager


related to 0004062 resolved SimpleDateFormat is incompatible with PostgreSql microsecond template 


There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.11 cea5d08b

2020-01-17 13:11:45

Philip Marzullo

Details Diff
0004246: Conflict Resolution: Problem with timestamp with time zones as
the USE_TIMESTAMP column
Affected Issues
mod - symmetric-db/src/main/java/org/jumpmind/db/sql/ Diff File
mod - symmetric-io/src/main/java/org/jumpmind/symmetric/io/data/writer/ Diff File
mod - symmetric-util/src/main/java/org/jumpmind/util/ Diff File

Issue History

Date Modified Username Field Change
2020-01-17 18:09 pmarzullo New Issue
2020-01-17 18:09 pmarzullo Status new => assigned
2020-01-17 18:09 pmarzullo Assigned To => pmarzullo
2020-01-17 18:09 pmarzullo Tag Attached: conflict manager
2020-01-17 18:12 pmarzullo Status assigned => resolved
2020-01-17 18:12 pmarzullo Resolution open => fixed
2020-01-17 18:12 pmarzullo Fixed in Version => 3.11.4
2020-01-17 19:00 Changeset attached => SymmetricDS 3.11 cea5d08b
2020-01-23 20:42 admin Status resolved => closed
2022-08-08 19:31 emiller Relationship added related to 0004062