View Issue Details

IDProjectCategoryView StatusLast Update
0005169SymmetricDSBugpublic2022-01-17 13:39
Reporterpmarzullo Assigned Topmarzullo  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.12.14 
Target Version3.12.15Fixed in Version3.12.15 
Summary0005169: Tibero reading of indexes fails when index is in another schema
DescriptionWhen the DDL Reader for Tibero reads indexes in different schemas, the reader uses the USER_INDEXES, USER_IND_COLUMNS, and USER_CONSTRAINTS views, which only has access to the current logged in user. The views that should be used are ALL_INDEXES, ALL_IND_COLUMNS, and ALL_CONSTRAINTS.
Steps To ReproduceSet up synchronization of a table from Tibero that has a unique index, and is in another schema than the default user based schema.
Take a snapshot.
Look at the table in the table definitions. Should be missing the unique index.
Tagsdialect: tibero

Activities

pmarzullo

2021-12-27 13:14

developer   ~0002039

This also breaks conflicts generated by unique indexes. The code can't find the unique index in another schema.

pmarzullo

2021-12-27 13:26

developer   ~0002040

This has been merged into 3.13 and 3.14

pmarzullo

2021-12-27 13:40

developer   ~0002041

A patch has been provided for 3.12 and 3.13.

Related Changesets

SymmetricDS: 3.12 1ce80b88

2021-12-27 13:16:56

pmarzullo

Details Diff
0005169: Tibero reading of indexes fails when index is in another schema Affected Issues
0005169
mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/tibero/TiberoDdlReader.java Diff File

SymmetricDS: 3.13 11ab92e5

2021-12-27 13:16:56

pmarzullo

Details Diff
0005169: Tibero reading of indexes fails when index is in another schema
# Conflicts:
# symmetric-jdbc/src/main/java/org/jumpmind/db/platform/tibero/TiberoDdlReader.java
Affected Issues
0005169
mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/tibero/TiberoDdlReader.java Diff File

SymmetricDS: 3.14 eed86240

2021-12-27 13:16:56

pmarzullo

Details Diff
0005169: Tibero reading of indexes fails when index is in another schema
# Conflicts:
# symmetric-jdbc/src/main/java/org/jumpmind/db/platform/tibero/TiberoDdlReader.java
Affected Issues
0005169
mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/tibero/TiberoDdlReader.java Diff File

Issue History

Date Modified Username Field Change
2021-12-27 13:13 pmarzullo New Issue
2021-12-27 13:13 pmarzullo Status new => assigned
2021-12-27 13:13 pmarzullo Assigned To => pmarzullo
2021-12-27 13:13 pmarzullo Tag Attached: dialect: tibero
2021-12-27 13:14 pmarzullo Note Added: 0002039
2021-12-27 13:14 pmarzullo Steps to Reproduce Updated View Revisions
2021-12-27 13:26 pmarzullo Note Added: 0002040
2021-12-27 13:40 pmarzullo Note Added: 0002041
2021-12-27 13:41 pmarzullo Status assigned => resolved
2021-12-27 13:41 pmarzullo Resolution open => fixed
2021-12-27 13:41 pmarzullo Fixed in Version => 3.12.15
2021-12-27 14:00 pmarzullo Changeset attached => SymmetricDS 3.12 1ce80b88
2021-12-27 14:00 pmarzullo Changeset attached => SymmetricDS 3.13 11ab92e5
2021-12-27 14:00 pmarzullo Changeset attached => SymmetricDS 3.14 eed86240
2022-01-17 13:39 admin Status resolved => closed