(Ignore my last comment, I was referring to another issue.)

I checkout out the test, but it succeeds if the statement use JOIN which is the exact opposite of what this issue is referring to: if the relation specifies @Fetch(FetchMode.SELECT) it should not use a JOIN to fetch collections, which would compromise skip/limit and fetching multiple collections.