SDO_RELATE query returns different results in 10.2.0.5 and 18.104.22.168, 22.214.171.124
Last updated on DECEMBER 05, 2013
Applies to:Oracle Spatial and Graph - Version 126.96.36.199 to 188.8.131.52 [Release 11.2]
Information in this document applies to any platform.
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
Database has been upgraded from 10.2.0.5 to 184.108.40.206
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