ON 12.2.0.1, SDO_AGGR_SET_UNION RETURNS NULL WHEN SET SPATIAL_VECTOR_ACCELERATION = TRUE

(Doc ID 2323666.1)

Last updated on DECEMBER 19, 2017

Applies to:

Oracle Spatial and Graph - Version 12.2 and later
Information in this document applies to any platform.

Symptoms

The following spatial query returns the wrong result (null) after patch 24747672 is installed on a 12.2.0.1 database.

SELECT sdo_aggr_set_union (get_geom_set ('test_m_oracle', 'geotable', 'id_set=''I461_004800'''), .005 ) FROM dual;

e.g.

SDO_AGGR_SET_UNION(GET_GEOM_SET('TEST_M_ORACLE','GEOMETRIA','ID_SET=''I461_00480
--------------------------------------------------------------------------------
SDO_GEOMETRY(2007, 8192, NULL, SDO_ELEM_INFO_ARRAY(1, 1003, 1, 133, 1003, 1, 447
, 2003, 1, 455, 1003, 1, 739, 1003, 1, 1033, 1003, 1, 1105, 1003, 1, 1509, 1003,
1, 1985, 1003, 1), SDO_ORDINATE_ARRAY(12.7968115, 43.4654054, 12.7966649, 43.46, 12.7861889, 43.4634095))

1 row selected.

alter session set spatial_vector_acceleration=TRUE;
Session altered.

SQL> SELECT sdo_aggr_set_union (get_geom_set ('test_m_oracle', 'geometria', 'id_set=''I461_004800'''), .005 ) FROM dual;

SDO_AGGR_SET_UNION(GET_GEOM_SET('TEST_M_ORACLE','GEOMETRIA','ID_SET=''I461_00480
--------------------------------------------------------------------------------




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