SDO_RELATE With Mask=Contains Returns Wrong Results If Where Clause = TRUE
(Doc ID 1584489.1)
Last updated on FEBRUARY 28, 2019
Applies to:Oracle Spatial and Graph - Version 188.8.131.52 to 184.108.40.206 [Release 11.2 to 12.1]
Information in this document applies to any platform.
While the SQL statement works correctly on Oracle 220.127.116.11 but, after upgrade to 18.104.22.168 the same query returns no rows.
The SQL statement has sdo_relate('mask=CONTAINS') in the select list and the where clause have a comparison to value "TRUE" .
FROM (SELECT F.ID AS FID, SDO_RELATE(T.POLYGON, F.POLYGON, 'mask=CONTAINS')
FROM GEOMTABLE1 T, GEOMTABLE2 F
WHERE T.ID in (1,2) and f.id=5)
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document