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

Activity

Andrea Aime 
February 15, 2017 at 11:36 AM

Mass transitioning all resolved issues that have not been updated in the last month to closed state

Fixed

Details

Assignee

Reporter

Components

Fix versions

Affects versions

Priority

Created September 10, 2015 at 9:59 AM
Updated February 15, 2017 at 11:36 AM
Resolved September 11, 2015 at 10:21 AM