Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Incorrect results when selecting reference collection navigation chain on keyless entity #21828

Closed
smitpatel opened this issue Jul 28, 2020 · 0 comments · Fixed by #25835
Closed
Assignees
Labels
area-query closed-fixed The issue has been fixed and is/will be included in the release indicated by the issue milestone. customer-reported type-bug
Milestone

Comments

@smitpatel
Copy link
Contributor

Additional scenario of #21607

return AssertQuery(
                async,
                ss => ss.Set<OrderQuery>().Where(ov => ov.CustomerID == "ALFKI").Select(ov => ov.Customer)
                    .OrderBy(c => c.CustomerID)
                    .Select(cv => cv.Orders.Where(cc => true).ToList()),
                assertOrder: true,
                elementAsserter: (e, a) => AssertCollection(e, a),
                entryCount: 6);

OrderQuery is keyless. Customer is reference navigation. Putting a collection join on Customer causes issue since customers are repeated for different values of OrderQuery and we don't have a way to identify different OrderQuery results.

@ajcvickers ajcvickers modified the milestones: 5.0.0, Backlog Jul 31, 2020
@ajcvickers ajcvickers modified the milestones: Backlog, 6.0.0 Nov 5, 2020
@maumar maumar added the closed-fixed The issue has been fixed and is/will be included in the release indicated by the issue milestone. label Sep 2, 2021
maumar added a commit that referenced this issue Sep 2, 2021
Resolves #13560
Resolves #17364
Resolves #17803
Resolves #21078
Resolves #21828
Resolves #23041
maumar added a commit that referenced this issue Sep 2, 2021
Resolves #13560
Resolves #17364
Resolves #17803
Resolves #21078
Resolves #21828
Resolves #23041
maumar added a commit that referenced this issue Sep 2, 2021
Resolves #13560
Resolves #17364
Resolves #17803
Resolves #21078
Resolves #21828
Resolves #23041
maumar added a commit that referenced this issue Sep 2, 2021
Resolves #13560
Resolves #17364
Resolves #17803
Resolves #21078
Resolves #21828
Resolves #23041
@maumar maumar closed this as completed in d0b9686 Sep 2, 2021
@ajcvickers ajcvickers modified the milestones: 6.0.0, 6.0.0-rc2 Sep 4, 2021
@ajcvickers ajcvickers modified the milestones: 6.0.0-rc2, 6.0.0 Nov 8, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
area-query closed-fixed The issue has been fixed and is/will be included in the release indicated by the issue milestone. customer-reported type-bug
Projects
None yet
Development

Successfully merging a pull request may close this issue.

4 participants