View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0004977 | SymmetricDS | Bug | public | 2021-05-05 19:05 | 2021-05-28 20:40 |
| Reporter | elong | Assigned To | elong | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.12.0 | ||||
| Target Version | 3.12.10 | Fixed in Version | 3.12.10 | ||
| Summary | 0004977: Oracle create index under same user/schema as table | ||||
| Description | On Oracle, the index is created without qualifying the index name, so it is owned by the SymmetricDS user. When multiple user schemas are being synchronized, it becomes more likely that a name collision will occur. Example of current use: CREATE INDEX "I_LAST_NAME" ON "ELONG"."CUSTOMER" ("LAST_NAME"); Should be changed to include owner/schema qualification: CREATE INDEX "ELONG"."I_LAST_NAME" ON "ELONG"."CUSTOMER" ("LAST_NAME"); | ||||
| Tags | dialect: oracle, dialect: tibero | ||||
|
SymmetricDS: 3.12 6b6b5ef8 2021-05-05 19:07:49 Details Diff |
0004977: Oracle create index under same user/schema as table |
Affected Issues 0004977 |
|
| mod - symmetric-db/src/main/java/org/jumpmind/db/platform/oracle/OracleDdlBuilder.java | Diff File | ||
| mod - symmetric-db/src/main/java/org/jumpmind/db/platform/tibero/TiberoDdlBuilder.java | Diff File | ||
|
SymmetricDS: 3.12 dd19e0c8 2021-05-05 19:16:51 Details Diff |
0004977: Oracle create index under same user/schema as table |
Affected Issues 0004977 |
|
| mod - symmetric-db/src/main/java/org/jumpmind/db/platform/AbstractDdlBuilder.java | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2021-05-05 19:05 | elong | New Issue | |
| 2021-05-05 19:05 | elong | Status | new => assigned |
| 2021-05-05 19:05 | elong | Assigned To | => elong |
| 2021-05-05 19:05 | elong | Tag Attached: dialect: oracle | |
| 2021-05-05 19:05 | elong | Tag Attached: dialect: tibero | |
| 2021-05-05 19:12 | elong | Status | assigned => resolved |
| 2021-05-05 19:12 | elong | Resolution | open => fixed |
| 2021-05-05 19:12 | elong | Fixed in Version | => 3.12.10 |
| 2021-05-05 20:00 | admin | Changeset attached | => SymmetricDS 3.12 dd19e0c8 |
| 2021-05-05 20:00 | admin | Changeset attached | => SymmetricDS 3.12 6b6b5ef8 |
| 2021-05-28 20:40 | admin | Status | resolved => closed |