I’m not getting duplicate elements, my problem is the deleted elements are not filtered due to the new JOIN added by the entity graph. It’s worse if I add a combination of ORDER BY + DISTINCT to the same query, in that case I receive a database exception ORA-01791: not a SELECTed expression because the query JOIN is replaced by the entity graph JOIN in the SELECTed results and they are not used to declare the order in the original query.

On internet there are solutions similar to mine https://stackoverflow.com/a/65703150/1432916, does this means with Hibernate 6 we can’t use LEFT JOIN + ON with entity graph to fetch data?

I have used Blaze before and would be a good option, but now I’m trying to migrate a project to Jakarta 10 making as few changes as possible.