locate function doesn't work on SAP HANA

Description

The locate() SQL function doesn't work on SAP HANA because JPQL specifies it as locate (<needle>, <haystack>) whereas HANA specifies it as locate(<haystack>, <needle>).

Environment

SAP HANA

Status

Assignee

Unassigned

Reporter

Jonathan Bregler

Fix versions

Labels

None

backPortable

None

Suitable for new contributors

None

Requires Release Note

None

Pull Request

None

backportDecision

None

Components

Affects versions

5.2.17

Priority

Major