Upgrading to Hibernate 6.1 from 5.6 now throws a QueryException where it used to work OK; the exception states:

function to_timestamp() has type STRING, but argument is of type java.lang.Double

For the following query:

entityManager.createQuery(
    "select r from Realm r where r.notBefore is null or r.notBefore = 0 or to_timestamp(r.notBefore) <= now()"    , Realm.class
).getResultList();

Seems that hibernate no longer recognises the alternative to_timestamp(double)

The dialect is being autodetected as org.hibernate.dialect.PostgreSQLDialect; I don’t know the internals of Hibernate to understand where this validation check is performed (I cannot see any mention of to_timestamp in the dialect code.

Is this breaking change expected? I couldn’t see anything in the release notes related to this but appreciate a lot has changed in 6.x.

I can work around the problem but would like to understand what has changed and also feel this should be documented if not already.