My Oracle Support Banner

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

-- 10.2.0.5 SDO_REALTE query results
--
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'
/

CBRE_PROPERTY_ID
----------------
       110492262

 

-- 11.2.0.3 SDO_REALTE query results
--
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'
/

CBRE_PROPERTY_ID
----------------
       110488861

 

Changes

Database has been upgraded from 10.2.0.5 to 11.2.0.3

Cause

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
Symptoms
Changes
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.