ON 12.2.0.1, SDO_AGGR_SET_UNION RETURNS NULL WHEN SET SPATIAL_VECTOR_ACCELERATION = TRUE
(Doc ID 2323666.1)
Last updated on APRIL 08, 2022
Applies to:
Oracle Spatial and Graph - Version 12.2 and laterInformation 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
--------------------------------------------------------------------------------
Changes
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 |