Hi, When migrating from springboot 2.7 with (hibernate 5.6.14.Final) to springboot 3.1 (hibernate 6.2.6.Final) my generated sql queries from jpql are wrongs. Inpacted queries are those with "select new" and "right join" : I use this to create a projection called MyProjection from two entities E & C. I need projection even if entity C is non existant. I need id of the E entity every time in my projection. With hibernate 5.6.14.Final it works (it works for a long time and with anterior hibernate versions). But withhibernate 6.2.6.Final I encounter a problem : the select always use the entity C forein key to E instead of the id of the E entity. So, when C is null, the id of the E entity is null in my projection. Is this a bug ? Or something else ? Exemple : Entity C
Entity E
My Projection
Queries JPQL Query
Hibernate 5.6.14.Final Generated SQL
Hibernate 6.2.6.Final Generated SQL
|