Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

ST_Overlap gives an incorrect answer. #25

Open
cuteDen-ECNU opened this issue Nov 22, 2023 · 1 comment
Open

ST_Overlap gives an incorrect answer. #25

cuteDen-ECNU opened this issue Nov 22, 2023 · 1 comment
Labels
bug-confirm coordinate trans Affine geometry using orthogonal matrix mysql GIS

Comments

@cuteDen-ECNU
Copy link
Owner

cuteDen-ECNU commented Nov 22, 2023

Consider the following statements:

SET @g1 = ST_GeomFromText('POLYGON((445 614,26 30,30 80,445 614))');
SET @g2 = ST_GeomFromText('MULTIPOLYGON(((445 614,26 30,30 80,445 614)),((1010 190,90 40,40 90,1010 190)))');

SELECT ST_Overlaps(@g2, @g1);
--expected{0}; actual{1}

According to the definition of ST_Overlaps:

Two geometries spatially overlap if they intersect and their intersection results in a geometry of the same dimension but not equal to either of the given geometries.

@g1 does not overlap @g2 because the intersection of @g1 and @g2 is equal to @g1which violates "neither one covers the other".

Version:
8.2.0
the latest version in Github:
87307d4ddd88405117e3f1e51323836d57ab1f57

@cuteDen-ECNU cuteDen-ECNU added the coordinate trans Affine geometry using orthogonal matrix label Mar 9, 2024
@cuteDen-ECNU cuteDen-ECNU changed the title After swapping the X and Y coordinates, ST_Overlap gives an incorrect answer. ST_Overlap gives an incorrect answer. Mar 9, 2024
@cuteDen-ECNU
Copy link
Owner Author

bugtracker link: https://bugs.mysql.com/bug.php?id=114291

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug-confirm coordinate trans Affine geometry using orthogonal matrix mysql GIS
Projects
None yet
Development

No branches or pull requests

1 participant