Hello Panagiwths Mpougioukos, this issue looks similar to https://hibernate.atlassian.net/browse/HHH-15982 which was resolved in version 6.1.7.Final.
Could you please test with the latest Hibernate version and let me know if the problem still occurs?