In a @Formula or @JoinFormula, NULLS FIRST | LAST breaks query

Description

Hi,
If NULLS FIRST or NULLS LAST is used in a @JoinFormula (or in a @Formula I guess), Hibernate prefixes the keywords with the alias, ending up in a broken subquery:

Obviously, NULLS and LAST should not be prefixed

Environment

PostgreSQL

Status

Assignee

Unassigned

Reporter

Patrice Blanchardie

Fix versions

None

Labels

None

backPortable

None

Suitable for new contributors

None

Requires Release Note

None

Pull Request

None

backportDecision

None

Components

Affects versions

Priority

Major
Configure