SDO_RELATE query returns different results in 10.2.0.5 and 11.2.0.2, 11.2.0.3 (Doc ID 1605745.1)

Last updated on DECEMBER 05, 2013

Applies to:

Oracle Spatial and Graph - Version 11.2.0.2 to 11.2.0.3 [Release 11.2]
Information in this document applies to any platform.

Symptoms

Below is the query which is giving different results in 10.2.0.5 and 11.2.03:

SELECT * FROM PS_CBRE_PROP_VW3
WHERE OPRID = '10111277'
AND CBRE_PRIV_REC_IND = 'N' AND CBRE_PROPERTY_TYPE IN ('1', '2', '3', '4') AND EFF_STATUS = 'A'
AND CBRE_PROPERTY_ID IN ( SELECT CBRE_PROPERTY_ID FROM CBRE_PROPERTY_GEO WHERE SDO_RELATE(CBRE_GEO_LOCATION,MDSYS.SDO_GEOMETRY(2003, 8307, null ,SDO_ELEM_INFO_ARRAY(1, 1003, 1),
SDO_ORDINATE_ARRAY(-87.95894622802734,43.05308479146335,-87.95448303222656,43.06224098411819,-87.92461395263672,43.06487470411881,-87.93525695800781,43.05195585112235,-87.95894622802734,43.05308479146335)), 'mask=INSIDE') = 'TRUE')
ORDER BY 2

 

Changes

Database has been upgraded from 10.2.0.5 to 11.2.0.3

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms