I see, thanks. So will aim on upgrading to 6.2.2+ stream, hopefully this issue will be fixed soon.
Here it is:
https://hibernate.atlassian.net/jira/software/c/projects/HHH/issues/HHH-16581
I also attached there zip and PR for test case…to make test case pass you can downgrade hibernate to 6.1.7
Link to this forum topic: