DB2 st_dishoint does not work with SELECTIVITY clause

Description

DB2 produces a syntax error when using SELECTIVITY with st_disjoint.

Example

select count(*) from mytable where db2gse.st_disjoint(geom,?) = 1 selectivity 0.00001

A workaround could be

select count(*) from mytable where db2gse.st_intersects(geom,?) = 0 selectivity 0.00001

Environment

None

Status

Assignee

Christian Mueller

Reporter

Christian Mueller

Triage

None

Components

Fix versions

Affects versions

Priority

Highest
Configure