View Issue Details

IDProjectCategoryView StatusLast Update
0004682SymmetricDSBugpublic2021-10-26 14:01
Reporterelong Assigned Topmarzullo  
Prioritynormal 
Status closedResolutionduplicate 
Product Version3.12.0 
Target Version3.13.0Fixed in 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

Relationships

related to 0005003 closedpmarzullo Oracle: Geometry column type can not be used in a where clause 

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
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