View Issue Details

IDProjectCategoryView StatusLast Update
0003598SymmetricDSImprovementpublic2020-06-29 12:08
Reporterelong Assigned Toelong  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.9.9 
Target Version3.9.9Fixed in Version3.9.9 
Summary0003598: Order rows in initial load for table with self-referencing foreign key
DescriptionFor initial load of a table with a self-referencing foreign key, order the rows so that parent rows come before children rows. Handle a hierarchical set of data with multiple levels of parents.

create table relations (
  id integer not null primary key,
  pid integer references relations(id)
)
TagsNo tags attached.

Relationships

related to 0003711 closedjosh-a-hicks Table reload request for a table with a foreign to itself and a data row where the row fk is to itself doesn't load any data 
related to 0004459 closedelong Too many rows sent in reload for table when self-referencing foreign key 

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.9 84cc52f3

2018-06-11 13:22:29

admin

Details Diff
0003598: Order rows in initial load for table with self-referencing
foreign key
Affected Issues
0003598
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/DataExtractorService.java Diff File
mod - symmetric-db/src/main/java/org/jumpmind/db/model/Table.java Diff File

SymmetricDS: 3.9 4b11e728

2018-06-15 08:26:37

admin

Details Diff
0003598: Order rows in initial load for table with self-referencing
foreign key
Affected Issues
0003598
mod - symmetric-db/src/main/java/org/jumpmind/db/model/Table.java Diff File

SymmetricDS: 3.9 985cbf66

2018-06-21 14:47:59

admin

Details Diff
0003598: Order rows in initial load for table with self-referencing
foreign key
Affected Issues
0003598
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/DataExtractorService.java Diff File

Issue History

Date Modified Username Field Change
2018-06-11 17:20 elong New Issue
2018-06-11 17:20 elong Status new => assigned
2018-06-11 17:20 elong Assigned To => elong
2018-06-11 18:00 admin Changeset attached => SymmetricDS 3.9 84cc52f3
2018-06-15 12:26 elong Status assigned => resolved
2018-06-15 12:26 elong Resolution open => fixed
2018-06-15 12:26 elong Fixed in Version => 3.9.9
2018-06-15 13:00 admin Changeset attached => SymmetricDS 3.9 4b11e728
2018-06-21 19:00 admin Changeset attached => SymmetricDS 3.9 985cbf66
2018-06-21 19:16 admin Status resolved => closed
2018-10-03 17:34 hanes Relationship added related to 0003711
2020-06-29 12:08 elong Relationship added related to 0004459