View Issue Details

IDProjectCategoryView StatusLast Update
0004682SymmetricDSBugpublic2020-12-04 19:19
Reporterelong Assigned Toelong  
Prioritynormal 
Status assignedResolutionopen 
Product Version3.12.0 
Target Version3.13.0 
Summary0004682: Oracle putting geometry types in where clause for conflict detection
DescriptionOn 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';
Tagsconflict manager

Activities

There are no notes attached to this issue.

Issue History

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