View Issue Details

IDProjectCategoryView StatusLast Update
0004459SymmetricDSBugpublic2020-07-20 14:50
Reporterelong Assigned Toelong  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.9.9 
Target Version3.12.2Fixed in Version3.12.2 
Summary0004459: Too many rows sent in reload for table when self-referencing foreign key
DescriptionFor a table with a self-referencing foreign key, the load will order the rows by their dependency order using recursive queries. If the user has specified an initial load "where" clause (or if the reload batch is from the auto-resolve of foreign keys, which specifies a "where" clause), the "where" clause gets appended with SQL that returns too many rows because it contains an "or". The appended SQL needs to be enclosed in parenthesis to work correctly.
Tagsinitial/partial load

Relationships

related to 0003598 closedelong Order rows in initial load for table with self-referencing foreign key 

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.12 74f5c671

2020-06-29 08:08:34

admin

Details Diff
0004459: Too many rows sent in reload for table when self-referencing
foreign key
Affected Issues
0004459
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/DataExtractorService.java Diff File

Issue History

Date Modified Username Field Change
2020-06-29 12:08 elong New Issue
2020-06-29 12:08 elong Status new => assigned
2020-06-29 12:08 elong Assigned To => elong
2020-06-29 12:08 elong Tag Attached: initial/partial load
2020-06-29 12:08 elong Relationship added related to 0003598
2020-06-29 12:08 elong Status assigned => resolved
2020-06-29 12:08 elong Resolution open => fixed
2020-06-29 12:08 elong Fixed in Version => 3.12.2
2020-06-29 13:00 admin Changeset attached => SymmetricDS 3.12 74f5c671
2020-07-20 14:50 elong Status resolved => closed