View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0006143 | SymmetricDS | Bug | public | 2023-12-04 18:44 | 2023-12-04 19:00 |
| Reporter | emiller | Assigned To | emiller | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.10.0 | ||||
| Target Version | 3.14.11 | Fixed in Version | 3.14.11 | ||
| Summary | 0006143: Postgres timestamp with time zone columns get their values formatted incorrectly when extracted for a load | ||||
| Description | When extracting data for a load that includes a Postgres timestamp with time zone column, the values get formatted incorrectly. Here is an example: Expected value: 2023-12-04 12:34:56.123456 -05:00 Actual value: 2023-12-04 12:34:56.123456-05 This leads to the time portion of the timestamp being incorrect in the target table. | ||||
| Tags | dialect: postgresql, extract, initial/partial load | ||||
|
SymmetricDS: 3.14 7496e95c 2023-12-04 18:59:40 evan-miller-jumpmind Details Diff |
0006143: Fixed Postgres timestamp with time zone columns getting their values formatted incorrectly when extracted for a load |
Affected Issues 0006143 |
|
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/db/AbstractTriggerTemplate.java | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2023-12-04 18:44 | emiller | New Issue | |
| 2023-12-04 18:44 | emiller | Status | new => assigned |
| 2023-12-04 18:44 | emiller | Assigned To | => emiller |
| 2023-12-04 18:44 | emiller | Tag Attached: dialect: postgresql | |
| 2023-12-04 18:44 | emiller | Tag Attached: extract | |
| 2023-12-04 18:44 | emiller | Tag Attached: initial/partial load | |
| 2023-12-04 18:46 | emiller | Issue cloned: 0006144 | |
| 2023-12-04 18:46 | emiller | Relationship added | related to 0006144 |
| 2023-12-04 18:48 | emiller | Description Updated | View Revisions |
| 2023-12-04 18:59 | emiller | Status | assigned => resolved |
| 2023-12-04 18:59 | emiller | Resolution | open => fixed |
| 2023-12-04 18:59 | emiller | Fixed in Version | => 3.14.11 |
| 2023-12-04 19:00 | Changeset attached | => SymmetricDS 3.14 7496e95c | |
| 2023-12-16 01:56 | admin | Status | resolved => closed |