[ https://issues.apache.org/jira/browse/CAY-2855?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17851170#comment-17851170 ]
Jadon Hansell commented on CAY-2855: ------------------------------------ I've attached a patch containing a breaking test (and similar tests for the other prefetch types). Once I added the relationship for the test a couple other tests in the file started to fail because {{IvImpl}} was inserted with a foreign key to {{IvOther}} before the corresponding {{IvOther}} row was inserted. I'm thinking that might be a separate existing issue. > Vertical Inheritance: Fix Disjoint By Id Prefetch On Sub-Entity > --------------------------------------------------------------- > > Key: CAY-2855 > URL: https://issues.apache.org/jira/browse/CAY-2855 > Project: Cayenne > Issue Type: Bug > Affects Versions: 4.2 > Reporter: Jadon Hansell > Priority: Major > Attachments: disjoint-by-id-issue.patch > > > I ran into an issue with prefetching a belongs-to relationship whose target > was the sub-entity of a vertical inheritance scenario. When {{disjointById}} > is used, the select for the sub-entity looks for an ID of {{null}} instead of > the actual ID assigned to the relationship. > For example, lets say I have a base entity {{Base}}, a vertically inherited > sub-entity {{Impl}}, and a separate entity called {{Other}}. > If {{Other}} has a belongs-to relationship to {{Impl}} called > {{Other.impl}}, attempting to use a {{disjointById}} prefetch on that > relationship will always find no results. -- This message was sent by Atlassian Jira (v8.20.10#820010)