SDO_AGGR_MBR Returns Incorrect Results When 3rd Dimension Not Planar (Doc ID 1523274.1)

Last updated on FEBRUARY 08, 2017

Applies to:

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

Symptoms

SDO_AGGR_MBR returning incorrect results in 11.2.0.3

SDO_AGGR_MBR returns correct results in 10g (10.2.0.3)

The geometries are using three coordinates X, Y, Z


10.2.0.3 CORRECT output:

select sdo_aggr_mbr(vm.shape)
from vmarkering vm;


SDO_AGGR_MBR(VM.SHAPE)(SDO_GTYPE, SDO_SRID, SDO_POINT(X, Y, Z), SDO_ELEM_INFO, S
--------------------------------------------------------------------------------
SDO_GEOMETRY(3003, NULL, NULL, SDO_ELEM_INFO_ARRAY(1, 1003, 3), SDO_ORDINATE_ARR
AY(120214.256, 427005.363, -496.176, 166297.978, 478632.227, 19.299))


10.2.0.3 Validation:
-----------------------
spool val.txt
DROP TABLE val_results;
CREATE TABLE val_results (sdo_rowid ROWID, result varchar2(1000));
CALL SDO_GEOM.VALIDATE_LAYER_WITH_CONTEXT('VMARKERING','SHAPE','VAL_RESULTS');
col result format a40
SELECT * from val_results;
spool off

SDO_ROWID RESULT
------------------ ----------------------------------------
  Rows Processed

All geometries are valid in 10.2.0.3

The problem is when using this in 11.2.0.3

11.2.0.3.0 WRONG output:

select sdo_aggr_mbr(vm.shape)
from vmarkering vm;

SDO_AGGR_MBR(VM.SHAPE)(SDO_GTYPE, SDO_SRID, SDO_POINT(X, Y, Z), SDO_ELEM_INFO, S
--------------------------------------------------------------------------------
SDO_GEOMETRY(3008, NULL, NULL, SDO_ELEM_INFO_ARRAY(1, 1003, 3), SDO_ORDINATE_ARR
AY(0, 0, -496.176, 166297.978, 478632.227, 19.299))

As we can see the "min x" and "min y" are both 0
They should be 120214.256, 427005.363 as the output for 10g shows

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