View Issue Details

IDProjectCategoryView StatusLast Update
0005320SymmetricDSImprovementpublic2022-06-06 12:37
Reporterelong Assigned Toelong  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.13.0 
Target Version3.13.5Fixed in Version3.13.5 
Summary0005320: Use unique index for PK column names in trigger hist when table is missing primary key
DescriptionIf 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.
TagsNo tags attached.

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.13 a7c54c8b

2022-06-01 15:02:06

admin

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

admin

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

Issue History

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