borinquenkid commented on PR #16821: URL: https://github.com/apache/grails-core/pull/16821#issuecomment-6584842903
Added integration scenarios for correlated subqueries (`SubqueryAliasScenarioSpec`) to both `grails-test-examples/hibernate5/grails-hibernate` and `hibernate7/grails-hibernate`. Two things for the team: 1. **Fixed in H7 to match H5:** `id == t.club` (an id compared with an association of the root alias) works on H5 and failed on H7 with `Cannot compare Long with ScenarioOwner`. H7's own `SubqueryAliasSpec` had been rewritten to `t.club.id`, which hid it. `PropertyComparisonCriterionHandler` now compares by the association's identifier, and the original form is back in that spec. 2. **H7 only:** a nested alias path through an association (`name == i.owner.name`) works on H7 (this PR). H5 rejects it with `could not resolve property: i`. It is in the H7 scenario spec only. It is an addition, not a behaviour change. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
