Oracle Database Free

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Regression in Oracle 23c when running spatial query combining MULTIPOLYGON and POINT in a GEOMETRYCOLLECTION

Lukas EderApr 4 2023

This query worked fine in 21c but now fails in 23c (I'm using https://hub.docker.com/r/gvenzl/oracle-free):

select sdo_geometry(wkt => 'GEOMETRYCOLLECTION (
   MULTIPOLYGON (((40 40, 20 45, 45 30, 40 40)), ((20 35, 10 30, 10 10, 30 5, 45 20, 20 35), (30 20, 20 15, 20 25, 30 20))),
   POINT (40 30)
)
', srid => null)
from DUAL

The failure is:

SQL Error [600] [60000]: ORA-00600: internal error code, arguments: [kghstack_underflow_internal_1], [0x7EFE8247CA08], ["mdfwkt.c":1028], [], [], [], [], [], [], [], [], []
ORA-06512: at "MDSYS.SDO_UTIL", line 7714
ORA-06512: at "MDSYS.SDO_UTIL", line 7802
ORA-06512: at "MDSYS.SDO_GEOMETRY", line 196
ORA-06512: at line 1

This post has been answered by Gerald Venzl-Oracle on Apr 5 2023

Jump to Answer

Added on Apr 4 2023

#spatial, #sql

3 comments

501 views

1 mention