View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0004682 | SymmetricDS | Bug | public | 2020-12-04 19:19 | 2020-12-04 19:19 |
| Reporter | elong | Assigned To | elong | ||
| Priority | normal | ||||
| Status | assigned | Resolution | open | ||
| Product Version | 3.12.0 | ||||
| Target 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 | ||||