1

Recently I noticed that ST_Within stopped working properly on some features. The geometry that breaks st_within has 1337 vertices (ESRI arc - many segments 1cm distance). If I reduce the vertices number the ST_Within works again. The MariaDB version that I am using is 10.3.29. I do not know if there was an update that caused the above problem, but it was working perfectly a week ago. Any ideas what is causing the problem?

The vertices and SQL are uploaded to this file as they too large/messy to add to this context

Sql data and WKT

----UPDATE-----

The spatial index is the one that causes the breaking. When I dropped the spatial index of the column the ST_Within started working again. Any ideas what causes the spatial index to ignore the geometry?

Improve this question

1 Answer 1

Reset to default
0

10.3.29 was released yesterday with the introduction of ST_DISTANCE_SPHERE (https://jira.mariadb.org/browse/MDEV-13467). It's not supposed to have had an impact on any existing functionality, but perhaps its related. Either way, if it was working before, and is not now, you should report it as a bug with more details, and someone can investigate further.

Improve this answer
1
  • Note that ST_DISTANCE_SPHERE seems to work on a pair of Points only, all other combinations yield an "Internal error: st_distance_sphere" (MariaDB 10.5.13)
    – BenMorel
    Commented Oct 13, 2022 at 21:11

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.