View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0005892 | SymmetricDS | Bug | public | 2023-06-21 15:13 | 2023-06-21 17:00 |
Reporter | cquamme | Assigned To | cquamme | ||
Priority | normal | ||||
Status | closed | Resolution | fixed | ||
Target Version | 3.14.8 | Fixed in Version | 3.14.8 | ||
Summary | 0005892: DbCompare fails to write comparison SQL for timestamp with timezone values | ||||
Description | When you try to use DbCompare with a table that contains a timestamp with a timezone, and you select either the "Write differences to SQL editor" or "Write differences to file" option, DbCompare will throw the below error in the log: DbCompareDiffWriter - Timestamp format must be yyyy-mm-dd hh:mm:ss[.fffffffff] java.lang.IllegalArgumentException: Timestamp format must be yyyy-mm-dd hh:mm:ss[.fffffffff] This is because Timestamp.valueOf() does not parse timestamp values with a timezone. | ||||
Steps To Reproduce | 1. Set up table for replication with timestamp with timezone value 2. Use DbCompare to try and compare this table with another table 3. "Write differences to SQL editor" or "Write differences to file" 4. Error shows in log | ||||
Tags | No tags attached. | ||||
SymmetricDS: 3.14 f9cfe04b 2023-06-21 15:49:59 Details Diff |
0005892: DbCompare fails to write comparison SQL for timestamp with timezone values |
Affected Issues 0005892 |
|
mod - symmetric-db/src/main/java/org/jumpmind/db/sql/Row.java | Diff File | ||
SymmetricDS: 3.14 e64a3f8e 2023-06-21 16:35:47 Details Diff |
0005892: DbCompare fails to write comparison SQL for timestamp with timezone values |
Affected Issues 0005892 |
|
mod - symmetric-db/src/main/java/org/jumpmind/db/sql/Row.java | Diff File |
Date Modified | Username | Field | Change |
---|---|---|---|
2023-06-21 15:13 | cquamme | New Issue | |
2023-06-21 15:13 | cquamme | Status | new => assigned |
2023-06-21 15:13 | cquamme | Assigned To | => cquamme |
2023-06-21 15:51 | cquamme | Status | assigned => resolved |
2023-06-21 15:51 | cquamme | Resolution | open => fixed |
2023-06-21 16:00 | cquamme | Changeset attached | => SymmetricDS 3.14 f9cfe04b |
2023-06-21 17:00 | cquamme | Changeset attached | => SymmetricDS 3.14 e64a3f8e |
2023-07-19 12:58 | admin | Status | resolved => closed |