Hi all,

I'm getting a problem trying to run these EJB-QJ queries:

- QUERY1: SELECT OBJECT(e) FROM EntregaVenta e WHERE e.enviament IS NULL

- QUERY2: SELECT OBJECT(e) FROM EntregaVenta e WHERE e.enviament IS NULL OR e.enviament.envioIdPk=?1

- QUERY3: SELECT OBJECT(e) FROM EntregaVenta e WHERE e.enviament.envioIdPk=?1 OR e.enviament IS NULL

where 'enviament' is a CMR field with multiplicity 1, of EntregaVenta EJB..

The first query returns 20 results, and the other ones return only 1 result ...

Queries 2 and 3 should return at least as many results as query 1. Is there anything wrong in the queries? Is there any limitation on EJB-QL / JBOSS-QL that can cause this error?

Thanks in advance,

Xavier