View Issue Details

IDProjectCategoryView StatusLast Update
0005003SymmetricDSBugpublic2021-05-28 20:40
Reporterpmarzullo Assigned Topmarzullo  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.12.9 
Target Version3.12.10Fixed in Version3.12.10 
Summary0005003: Oracle: Geometry column type can not be used in a where clause
DescriptionThe 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 Reproduce1. 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.
Tagsconflict manager, data type, dialect: oracle

Relationships

related to 0004682 closed Oracle putting geometry types in where clause for conflict detection 

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.12 d87f547c

2021-05-25 16:32:53

pmarzullo

Details Diff
0005003: Oracle: Geometry column type can not be used in a where clause Affected Issues
0005003
mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/oracle/OracleDatabasePlatform.java Diff File

Issue History

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