0001-try-to-do-the-same-in-jpa.patch

You are right, I most certainly missed something in my setup that causes the issue. In my case, the different operations are executing in a tomee instance, executing hibernate through jpa, and using either hsqldb or mariadb as a database (I reproduced it with both databases).

I tried to develop on your sample code to do the same on jpa, but I see a problem in fetching the rank again, but here is is probably that I did something wrong.