| In WildFly 11 Hibernate was updated from 5.0.7.Final to 5.1.10.Final. In new Hibernate "joins.add( treatAs );" adds extra JOIN to database query, so every row appears twice in result. Hibernate 5.0.7.Final public <X, T, V extends T> Join<X, V> treat(Join<X, T> join, Class<V> type) { return ( (JoinImplementor) join ).treatAs( type ); } Hibernate 5.1.10.Final public <X, T, V extends T> Join<X, V> treat(Join<X, T> join, Class<V> type) { final Set<Join<X, ?>> joins = join.getParent().getJoins(); final Join<X, V> treatAs = ( (JoinImplementor) join ).treatAs( type ); joins.add( treatAs ); return treatAs; } Result query: Hibernate 5.0.7.Final select internalbl0_.*
from blrecord internalbl0_
inner join blentry entries1_ on internalbl0_.id=entries1_.record_id
where internalbl0_.dtype='1' and entries1_.dtype=$1 and entries1_.value=$2 and internalbl0_.status=$3
group by internalbl0_.id
having count(internalbl0_.id)=1 Hibernate 5.1.10.Final select internalbl0_.*
from blrecord internalbl0_
inner join blentry entries1_ on internalbl0_.id=entries1_.record_id
inner join blentry entries2_ on internalbl0_.id=entries2_.record_id
where internalbl0_.dtype='1' and entries2_.dtype=$1 and entries2_.value=$2 and internalbl0_.status=$3
group by internalbl0_.id
having count(internalbl0_.id)=1 To make it works I need to add DISTINCT to "count(internalbl0_.id)" => "count(DISTINCT internalbl0_.id)". Hibernate 5.2.12.Final I've replaced 5.1.10 with 5.2.12 in WildFly 11 and got the same extra JOIN. How should I use treat method? May be approach was changed... |
