View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0004723 | SymmetricDS | Improvement | public | 2020-12-24 08:46 | 2022-07-27 18:59 |
| Reporter | kraynopp | Assigned To | elong | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.12.5 | ||||
| Target Version | 3.14.0 | Fixed in Version | 3.14.0 | ||
| Summary | 0004723: Send column with Oracle DATE type to PostgreSQL | ||||
| Description | If source table in oracle contains DATE column, the target table in PostgreSQL should be created with "timeatmp(0) without time zone" datatype instead of "timeatmp without time zone" (without milliseconds). Oracle DATE datatype does not contain milliseconds so sometimes it leads to conflict. | ||||
| Tags | ddl/schema | ||||
|
|
Should only be an issue while moving data from PG to Oracle and the column is part of the PK. |
|
|
Not only PK. It will be an issue if conflict resolution is configured. 2021-01-11 09:55:58,186 DEBUG [oracle-001] [DefaultDatabaseWriter] [oracle-001-dataloader-3] Preparing dml: update "DATA"."SYMTEST1" set "DATA_DATE" = ? where "DATA_DATE" = ? and "KEY1" = ? 2021-01-11 09:55:58,186 DEBUG [oracle-001] [DefaultDatabaseWriter] [oracle-001-dataloader-3] Submitting data [{ts '2021-01-11 09:55:21.913'}, {ts '2021-01-11 09:53:28.626'}, 1] with types [TIMESTAMP, TIMESTAMP, NUMERIC] 2021-01-11 09:55:58,189 DEBUG [oracle-001] [AbstractDatabaseWriterConflictResolver] [oracle-001-dataloader-3] Conflict detected: pgsql_2_oracle in batch 215 at line 1 for table DATA.SYMTEST1 2021-01-11 09:55:58,191 DEBUG [oracle-001] [AbstractDatabaseWriterConflictResolver] [oracle-001-dataloader-3] Row data: "1","1.20","2021-01-11 09:55:21.913366","Proba4" 2021-01-11 09:55:58,191 DEBUG [oracle-001] [AbstractDatabaseWriterConflictResolver] [oracle-001-dataloader-3] Old data: "1","1.20","2021-01-11 09:53:28.626937","Proba4" 2021-01-11 09:55:58,192 DEBUG [oracle-001] [DataLoaderService$LoadIntoDatabaseOnArrivalListener$1] [oracle-001-dataloader-3] CSV parsed: commit,215 BTW, the bug https://www.symmetricds.org/issues/view.php?id=4724 will result the same conflict. |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2020-12-24 08:46 | kraynopp | New Issue | |
| 2020-12-24 08:46 | kraynopp | Tag Attached: ddl/schema | |
| 2021-01-06 18:35 | josh-a-hicks | Note Added: 0001879 | |
| 2021-01-06 21:37 | elong | Status | new => acknowledged |
| 2021-01-11 07:13 | kraynopp | Note Added: 0001880 | |
| 2022-04-26 17:41 | elong | Relationship added | related to 0005280 |
| 2022-04-26 17:43 | elong | Assigned To | => elong |
| 2022-04-26 17:43 | elong | Status | acknowledged => resolved |
| 2022-04-26 17:43 | elong | Resolution | open => fixed |
| 2022-04-26 17:43 | elong | Fixed in Version | => 3.14.0 |
| 2022-04-26 17:43 | elong | Target Version | => 3.14.0 |
| 2022-07-27 18:59 | admin | Status | resolved => closed |