Fix for recursive SQL returning extra level of descendants 14/134814/1
authordanielhanrahan <daniel.hanrahan@est.tech>
Mon, 12 Jun 2023 15:24:55 +0000 (16:24 +0100)
committerdanielhanrahan <daniel.hanrahan@est.tech>
Mon, 12 Jun 2023 17:02:53 +0000 (18:02 +0100)
commit7bf37672c41c84182063e6a25cb3ca4306dd142f
treef1fd69ed5594318dcb86f651a44be746f8252071
parentb3b44d9aa4e71c4264df140ffff27b5ba4c44e82
Fix for recursive SQL returning extra level of descendants

Recursive SQL queries are incorrectly returning maxDepth + 1 levels
of fragments due to incorrect comparison in the WHERE clause.
This code is used by getDataNodes and queryDataNodes to
prefetch the descendants before converting to datanodes.
Prefetching extra descendants causes high memory usage.

Issue-ID: CPS-1716
Signed-off-by: danielhanrahan <daniel.hanrahan@est.tech>
Change-Id: Ie22215c0c7018cd293f73cf75adca2cd55f218a6
cps-ri/src/main/java/org/onap/cps/spi/repository/FragmentRepository.java