View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0004682 | SymmetricDS | Bug | public | 2020-12-04 19:19 | 2021-10-26 14:01 |
| Reporter | elong | Assigned To | pmarzullo | ||
| Priority | normal | ||||
| Status | closed | Resolution | duplicate | ||
| Product Version | 3.12.0 | ||||
| Target Version | 3.13.0 | Fixed in Version | 3.13.0 | ||
| Summary | 0004682: Oracle putting geometry types in where clause for conflict detection | ||||
| Description | On Oracle, the geometry types can't be in where clause. But the conflict detection of USE_CHANGED_DATA is putting geometry types in the where clause. The workaround is to change the conflict manager to use USE_PK_DATA. UPDATE o.foo SET xy = sym_wkt2geom('POINT (-76.993456 37.883456)', (SELECT srid FROM all_sdo_geom_metadata WHERE owner = 'O' AND table_name = 'FOO' AND column_name = 'XY')) WHERE xy = sym_wkt2geom('POINT (-76.993456 37.993456)', (SELECT srid FROM all_sdo_geom_metadata WHERE owner = 'O' AND table_name = 'FOO' AND column_name = 'XY')) AND id = '979b3734-66d8-40a6-af1d-f28677c07eac'; | ||||
| Tags | conflict manager | ||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2020-12-04 19:19 | elong | New Issue | |
| 2020-12-04 19:19 | elong | Status | new => assigned |
| 2020-12-04 19:19 | elong | Assigned To | => elong |
| 2020-12-04 19:19 | elong | Tag Attached: conflict manager | |
| 2021-05-25 16:34 | pmarzullo | Relationship added | related to 0005003 |
| 2021-05-25 16:36 | pmarzullo | Assigned To | elong => |
| 2021-05-25 16:36 | pmarzullo | Status | assigned => closed |
| 2021-05-25 16:36 | pmarzullo | Resolution | open => duplicate |
| 2021-10-26 14:01 | elong | Assigned To | => pmarzullo |
| 2021-10-26 14:01 | elong | Fixed in Version | => 3.13.0 |