View Issue Details

IDProjectCategoryView StatusLast Update
0003863SymmetricDSBugpublic2019-03-14 12:48
Reporterelong Assigned Toelong  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.10.0 
Target Version3.10.0Fixed in Version3.10.0 
Summary0003863: DbFill cascade and select handle composite and self-referencing foreign key
DescriptionHandle foreign key constraints during cascade and select options when composite (more than one column) constraints and for self-referencing constraints are involved.

* Handle composite constraints that overlap same column
* Handle self-referencing foreign key constraint
* Use smallest size for column definition by looking at all FK column references
* Fixed commit size to honor command line option
* Caching of selected rows until next repeat
* Added truncate option
* If select and cascade are both used, it will try select first, but in case of no rows, it will cascade one row
* Improved logging
TagsNo tags attached.

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.10 ae60f826

2019-01-25 14:21:52

admin

Details Diff
0003863: DbFill cascade and select handle composite and self-referencing
foreign key
Affected Issues
0003863
mod - symmetric-assemble/src/asciidoc/appendix/dbfill.ad Diff File
mod - symmetric-client/src/main/java/org/jumpmind/symmetric/DbFillCommand.java Diff File
mod - symmetric-client/src/main/resources/symmetric-messages.properties Diff File
mod - symmetric-io/src/main/java/org/jumpmind/symmetric/io/data/DbFill.java Diff File

Issue History

Date Modified Username Field Change
2019-01-24 21:13 elong New Issue
2019-01-24 21:13 elong Status new => assigned
2019-01-24 21:13 elong Assigned To => elong
2019-01-25 19:22 elong Status assigned => resolved
2019-01-25 19:22 elong Resolution open => fixed
2019-01-25 19:22 elong Fixed in Version => 3.10.0
2019-01-25 20:00 admin Changeset attached => SymmetricDS 3.10 ae60f826
2019-03-14 12:48 admin Status resolved => closed