I have a many-to-many bi-directional association between EntityA and EntityB. Also I have a removed boolean flag to soft delete the EntityA when needed.
During a left outer join, I was expecting to get only the non removed items from EntityA when fetching the bag from EntityB as I added a @Where annotation there to exclude the removed items (please see attachments). An inner join is working fine. More information below.

• Left Outer Join test
  The following JPQL:

select distinct b from EntityB b left outer join fetch b.entityAs _as

It is being turned into the following SQLs:

select
        distinct entityb0_.id as id1_2_0_,
        entitya2_.id as id1_0_1_,
        entitya2_.removed as removed2_0_1_,
        entityas1_.bid as bid2_1_0__,
        entityas1_.aid as aid1_1_0__ 
    from
        entity_b entityb0_ 
    left outer join
        entity_a_b entityas1_ 
            on entityb0_.id=entityas1_.bid 
    left outer join
        entity_a entitya2_ 
            on entityas1_.aid=entitya2_.id 
            and (
                entitya2_.removed is 0
            )

Additionally, another SQL is executed to load the entity:

select
        entitya0_.id as id1_0_0_,
        entitya0_.removed as removed2_0_0_ 
    from
        entity_a entitya0_ 
    where
        entitya0_.id=?

The above SQL is retrieving the removed entities which is wrong. I think it's because the double left outer join for both the entity_a_b and and entity_a tables. I think what's happening is that the entityA item is not being fully loaded because of that and then Hibernate is running a second query to hydrate the entityA finally. Is this expected behavior? Why does my @Where end up being ignored in the final result?

• Inner Join test
  The following JPQL:

select distinct b from EntityB b inner join fetch b.entityAs _as

It is being turned into the following SQL:

select
        distinct entityb0_.id as id1_2_0_,
        entitya2_.id as id1_0_1_,
        entitya2_.removed as removed2_0_1_,
        entityas1_.bid as bid2_1_0__,
        entityas1_.aid as aid1_1_0__ 
    from
        entity_b entityb0_ 
    inner join
        entity_a_b entityas1_ 
            on entityb0_.id=entityas1_.bid 
    inner join
        entity_a entitya2_ 
            on entityas1_.aid=entitya2_.id 
            and (
                entitya2_.removed is 0
            )

The above SQL query is not retrieving the removed entities which is right.