View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0004246 | SymmetricDS | Bug | public | 2020-01-17 18:09 | 2022-08-08 19:31 |
| Reporter | pmarzullo | Assigned To | pmarzullo | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.11.3 | ||||
| Target Version | 3.11.4 | Fixed in Version | 3.11.4 | ||
| Summary | 0004246: Conflict Resolution: Problem with timestamp with time zones as the USE_TIMESTAMP column | ||||
| Description | When 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 Reproduce | 1. 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 Information | Oracle and Postgres have timestamp with time zone types. | ||||
| Tags | conflict manager | ||||
| related to | 0004062 | resolved | SimpleDateFormat is incompatible with PostgreSql microsecond template |
|
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 0004246 |
|
| mod - symmetric-db/src/main/java/org/jumpmind/db/sql/LogSqlBuilder.java | Diff File | ||
| mod - symmetric-io/src/main/java/org/jumpmind/symmetric/io/data/writer/DefaultDatabaseWriterConflictResolver.java | Diff File | ||
| mod - symmetric-util/src/main/java/org/jumpmind/util/FormatUtils.java | Diff File | ||
| 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 |