View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0005169 | SymmetricDS | Bug | public | 2021-12-27 13:13 | 2022-01-17 13:39 |
| Reporter | pmarzullo | Assigned To | pmarzullo | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.12.14 | ||||
| Target Version | 3.12.15 | Fixed in Version | 3.12.15 | ||
| Summary | 0005169: Tibero reading of indexes fails when index is in another schema | ||||
| Description | When 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 Reproduce | Set 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. | ||||
| Tags | dialect: tibero | ||||
|
|
This also breaks conflicts generated by unique indexes. The code can't find the unique index in another schema. |
|
|
This has been merged into 3.13 and 3.14 |
|
|
A patch has been provided for 3.12 and 3.13. |
|
SymmetricDS: 3.12 1ce80b88 2021-12-27 13:16:56 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 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 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 | ||
| 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 |