We're updating the issue view to help you get more done. 

Nested spatial functions are not rendered correctly on SAP HANA

Description

Nested spatial functions are not rendered correctly when the nested function contains a statement parameter:

1 dwithin(geom, srid(:filter, 0), 1) = true

is rendered as

1 geom.ST_WithinDistance(?.ST_SRID(0), 1) = 1

which leads to a statement parsing error.

The expression should be rendered as

1 geom.ST_WithinDistance(ST_GeomFromEWKB(?).ST_SRID(0), 1) = 1

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
5.3.2

Priority

Major