I need to apply a condition on the Join not in the where clause. SQL supports this. I read on JIRA that Hibernate 3.1 beta version should be able to do this. But teh output of teh following query is not correct.

Code between sessionFactory.openSession() and session.close():
select p from Portals p left outer join p.clientPortalsSet as cp with cp.clients.feedId = 1
where cp.clientPortalId is not null

The output of this is that of the following query
select p from Portals p left outer join p.clientPortalsSet as cp
where cp.clientPortalId is not null and cp.clients.feedId = 1

I need to select all teh portals from Client portal set where they do not have a feed id.

Can some one please help me with this ?
Thanks.

Hibernate version:
Hibernate 3.1 beta

Name and version of the database you are using:
POstgresql