View Issue Details

IDProjectCategoryView StatusLast Update
0005731SymmetricDSBugpublic2023-03-08 22:00
Reporterpmarzullo Assigned Topmarzullo  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.14.5 
Target Version3.14.6Fixed in Version3.14.6 
Summary0005731: Functional indexes are only supported by Oracle
DescriptionWhen a functional index is on a table in Oracle, and schema is sent to a target table from Oracle, the functional index only works if the target table is also Oracle.

The data writer should filter out functional indexes if the platform does not support functional indexes.
Steps To Reproduce1. Create a table in Oracle with a functional index.
2. Initial load table from Oracle to H2, sending create table as part of the load.
Tagsdialect: oracle, initial/partial load

Related Changesets

SymmetricDS: 3.14 0248d077

2023-03-08 21:49:16

pmarzullo

Details Diff
0005731: Functional indexes are only supported by Oracle Affected Issues
0005731
mod - symmetric-db/src/main/java/org/jumpmind/db/platform/AbstractDatabasePlatform.java Diff File
mod - symmetric-db/src/main/java/org/jumpmind/db/platform/DatabaseInfo.java Diff File
mod - symmetric-db/src/main/java/org/jumpmind/db/platform/oracle/OracleDdlBuilder.java Diff File

Issue History

Date Modified Username Field Change
2023-03-08 21:44 pmarzullo New Issue
2023-03-08 21:44 pmarzullo Status new => assigned
2023-03-08 21:44 pmarzullo Assigned To => pmarzullo
2023-03-08 21:44 pmarzullo Tag Attached: dialect: oracle
2023-03-08 21:44 pmarzullo Tag Attached: initial/partial load
2023-03-08 22:00 pmarzullo Changeset attached => SymmetricDS 3.14 0248d077
2023-03-08 22:00 pmarzullo Status assigned => resolved
2023-03-08 22:00 pmarzullo Resolution open => fixed
2023-03-08 22:00 pmarzullo Fixed in Version => 3.14.6
2023-03-08 22:00 pmarzullo Note Added: 0002288
2023-03-17 17:25 admin Status resolved => closed