Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORACLE 11.2.0.3.0 crahes at SDO_GEOM.SDO_CONCAVEHULL

_jumApr 12 2013 — edited Apr 15 2013

In some cases SDO_GEOM.SDO_CONCAVEHULL seems to crash.
After long examinations found a repeateable example.

SELECT SDO_GEOM.VALIDATE_GEOMETRY(geom, 0.01) val,
       SDO_GEOM.SDO_CONVEXHULL    (geom, 0.01)  cvh
     -- ,SDO_GEOM.SDO_CONCAVEHULL   (geom, 0.01)  cch
  FROM
(
SELECT SDO_GEOMETRY(2005,NULL,NULL,
         SDO_ELEM_INFO_ARRAY(1, 1, 8),
         SDO_ORDINATE_ARRAY(3375886.39, 5715693.49,
                            3375918.05, 5715691.42,
                            3375874.62, 5715730.85,
                            3375871.31, 5715753.88,
                            3375923.09, 5715656.62,
                            3375899.17, 5716028.49,
                            3375911.16, 5715750.67,
                            3375866.35, 5715712.28)) geom
  FROM dual
);

If I uncomment the SDO_GEOM.SDO_CONCAVEHULL function, my session crashes.
The geometry (MULTIPOINT) is valid, thousends of similar geometries work well.
Any ideas or workarounds?

Locked Post

New comments cannot be posted to this locked post.

Locked on May 13 2013

Added on Apr 12 2013

#database-key-features, #spatial

6 comments

613 views