[eclipselink-users] Order By Child Column modifies Join Order

[Tim Hollosy <hollosyt@xxxxxxxxx>]

We're getting some odd behavior:
Some JPQL like this

Select parent.label, child.label2
FROM parent
LEFT JOIN child

With the expression API if we add an order on child.label2, the query
is rewritten like this:

Select parent.label, child.label2
FROM child
LEFT JOIN parent
order by child.label2

Is there some hint that we have to use to tell EL to not rewrite like
this when ordering by a child column? Obviously query 2 is very
different from query 1.

Thanks

./tch