View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0005003 | SymmetricDS | Bug | public | 2021-05-25 16:31 | 2021-05-28 20:40 |
| Reporter | pmarzullo | Assigned To | pmarzullo | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.12.9 | ||||
| Target Version | 3.12.10 | Fixed in Version | 3.12.10 | ||
| Summary | 0005003: Oracle: Geometry column type can not be used in a where clause | ||||
| Description | The default conflict resolution is USE_CHANGED_DATA. For an update, a where clause is appended with the changed columns, using the old value of the changed column. For Oracle, a SDO_GEOMETRY column can not be used in this case, because Oracle does not allow it. | ||||
| Steps To Reproduce | 1. Create a sync scenario synching Oracle to Oracle. 2. Create a table with a SDO_GEOMETRY column. 3. Populate the source with a record. 4. Initial load the target. 5. Update the SDO_GEOMETRY column in the source. | ||||
| Tags | conflict manager, data type, dialect: oracle | ||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2021-05-25 16:31 | pmarzullo | New Issue | |
| 2021-05-25 16:31 | pmarzullo | Status | new => assigned |
| 2021-05-25 16:31 | pmarzullo | Assigned To | => pmarzullo |
| 2021-05-25 16:31 | pmarzullo | Tag Attached: conflict manager | |
| 2021-05-25 16:31 | pmarzullo | Tag Attached: data type | |
| 2021-05-25 16:31 | pmarzullo | Tag Attached: dialect: oracle | |
| 2021-05-25 16:33 | pmarzullo | Status | assigned => resolved |
| 2021-05-25 16:33 | pmarzullo | Resolution | open => fixed |
| 2021-05-25 16:33 | pmarzullo | Fixed in Version | => 3.12.10 |
| 2021-05-25 16:34 | pmarzullo | Relationship added | related to 0004682 |
| 2021-05-25 17:00 | pmarzullo | Changeset attached | => SymmetricDS 3.12 d87f547c |
| 2021-05-28 20:40 | admin | Status | resolved => closed |