[eclipselink-users] Question on unexpected JPQL "ORDER BY"-clause behavi

[t3_chris <c.reiter@xxxxxxx>]

Hello!

I'v got an interesting behaviour with one of my JPQL queries. 
Here's the query:

SELECT c FROM Customer c 
ORDER BY 
  c.postalcode.country.countryName, c.postalcode.postalcodeId,
  c.postalcode.postalcodeCity, c.name1, c.name2, c.name3

What I expected is that this query would find all customers, regardless if
c.postalcode is null or 
if it points to a postalcode object (regular SQL behaviour)
.
But it does only return those whose postalcode property is not null. 
Is this the normal and intended behaviour?

Is there any workaround for selecting all customers and apply the sorting as
shown above?

Best Regards,

christian
-- 
View this message in context: http://old.nabble.com/Question-on-unexpected-JPQL-%22ORDER-BY%22-clause-behaviour-tp30785538p30785538.html
Sent from the EclipseLink - Users mailing list archive at Nabble.com.