Hi,
I'm having a tricky time getting a query to work the way I would like.
The query is pretty simple:

select o
from ConveyanceMake as o
where ( o.owner is null or o.owner.id = 9 )
order by o.code

This returns no results. However, when I remove the second half of my
where clause, it does return results:

select o
from ConveyanceMake as o
where ( o.owner is null ) order by o.code

So, that made me think that the issue is with null making the entire where
statement null because I've encountered the same thing in sql. However,
according to this documentation: http://java.sun.com/j2ee/tutorial/1_3-fcs/doc/EJBQL5.html#72 299
the first query should always be a superset of the second query. Am I
reading this wrong or is this not the right documentation to be looking
at? And as a side note, I'm wondering what the best way to rewrite my
query is.