View Issue Details

IDProjectCategoryView StatusLast Update
0006691SymmetricDSImprovementpublic2025-01-06 22:00
Reporterelong Assigned Toelong  
Prioritynormal 
Status resolvedResolutionfixed 
Product Version3.16.0 
Target Version3.16.0Fixed in Version3.16.0 
Summary0006691: Skip querying of self-referencing foreign key child levels if constraints are deferred
DescriptionFor a table with a self-referencing foreign key, the querying of each level of child rows is not needed if the table is being created or truncated with constraints deferred. Data can be loaded without any constraints, and then the constraints are added afterwards. (The table_reload_request has the create_table flag on and the initial.load.defer.create.constraints parameter is true.)
Tagsinitial/partial load

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.16 06ec6107

2025-01-06 21:25:45

admin

Details Diff
0006691: Skip querying of self-referencing foreign key child levels if
constraints are deferred
Affected Issues
0006691
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/extract/SelectFromTableSource.java Diff File

Issue History

Date Modified Username Field Change
2025-01-06 21:25 elong New Issue
2025-01-06 21:25 elong Status new => assigned
2025-01-06 21:25 elong Assigned To => elong
2025-01-06 21:25 elong Tag Attached: initial/partial load
2025-01-06 21:25 elong Status assigned => resolved
2025-01-06 21:25 elong Resolution open => fixed
2025-01-06 21:25 elong Fixed in Version => 3.16.0
2025-01-06 22:00 admin Changeset attached => SymmetricDS 3.16 06ec6107