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

For PaginatedCriteriaBuilder: throw exception for subqueries in order by that reference collection fields of the surrounding query #40

Closed
Mobe91 opened this issue Aug 6, 2014 · 1 comment
Assignees
Milestone

Comments

@Mobe91
Copy link
Contributor

Mobe91 commented Aug 6, 2014

This requirement resulted from issue #38
An exception is required in this scenario because this is the only scenario in which the id query can result in multiple result set rows with the same root entity id. This is because we have to include the subquery in the select clause if it is used in the order by. Furthermore, if the subquery references a collection from the surrounding query it will cause the final result set to contain multiple rows for the same root entity.

@Mobe91 Mobe91 self-assigned this Aug 6, 2014
@beikov beikov added this to the 1.0 milestone Aug 11, 2014
@beikov
Copy link
Member

beikov commented Aug 11, 2014

This is only valid for subqueries that are used in the order by clause.

@Mobe91 Mobe91 closed this as completed in 4c6e7f6 Aug 12, 2014
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants