The solution fixes the query but cause the failing of

org.hibernate.test.quote.QuoteGlobalTest

org.hibernate.AnnotationException: Unable to create unique key constraint (house3) on table User: database column 'house3' not found ...