6 Replies Latest reply: Apr 15, 2013 8:08 AM by Siva Ravada RSS

    ORACLE 11.2.0.3.0 crahes at  SDO_GEOM.SDO_CONCAVEHULL

    _jum
      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?