View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0005320 | SymmetricDS | Improvement | public | 2022-06-01 14:49 | 2022-06-06 12:37 |
| Reporter | elong | Assigned To | elong | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.13.0 | ||||
| Target Version | 3.13.5 | Fixed in Version | 3.13.5 | ||
| Summary | 0005320: Use unique index for PK column names in trigger hist when table is missing primary key | ||||
| Description | If a table is missing the primary key, but it has a unique index, then use the columns from the unique index for the PK column names in trigger history. Update and delete statements will use the PK column names from trigger hist. Since a unique index identifies a single tuple from the table, it is a good substitute for the primary key. The old behavior was to use all columns when the primary key was missing, so this change may help to avoid use of columns that can't be used in a "where" clause. | ||||
| Tags | No tags attached. | ||||
|
SymmetricDS: 3.13 a7c54c8b 2022-06-01 15:02:06 Details Diff |
0005320: Use unique index for PK column names when table is missing PK |
Affected Issues 0005320 |
|
| mod - symmetric-db/src/main/java/org/jumpmind/db/platform/AbstractDatabasePlatform.java | Diff File | ||
|
SymmetricDS: 3.14 60992522 2022-06-01 15:02:06 Details Diff |
0005320: Use unique index for PK column names when table is missing PK |
Affected Issues 0005320 |
|
| mod - symmetric-db/src/main/java/org/jumpmind/db/platform/AbstractDatabasePlatform.java | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2022-06-01 14:49 | elong | New Issue | |
| 2022-06-01 14:49 | elong | Status | new => assigned |
| 2022-06-01 14:49 | elong | Assigned To | => elong |
| 2022-06-01 15:03 | elong | Status | assigned => resolved |
| 2022-06-01 15:03 | elong | Resolution | open => fixed |
| 2022-06-01 15:03 | elong | Fixed in Version | => 3.13.5 |
| 2022-06-01 16:00 | admin | Changeset attached | => SymmetricDS 3.13 a7c54c8b |
| 2022-06-01 16:00 | admin | Changeset attached | => SymmetricDS 3.14 60992522 |
| 2022-06-06 12:37 | admin | Status | resolved => closed |