On Jan 26, 2017, at 7:07 PM, David G. Johnston wrote:
> Thinking aloud - why doesn't just finding every record with 5 descendants
> not work? Any chain longer than 5 would have at least 5 items.
Oh it works. This is why I ask these questions -- new perspectives!
> Even without recursion
There are over 20 million records in a self-referential database table, where
one record may point to another record as a descendant.
Because of a bug in application code, there was no limit on recursion. The max
was supposed to be 4. A few outlier records have between 5 and 5000
descendants