[MDEV-16524] ST_WITHIN returns wrong result with POINT and MULTIPOLYGON Created: 2018-06-19  Updated: 2018-06-21  Resolved: 2018-06-21

Status: Closed
Project: MariaDB Server
Component/s: GIS
Affects Version/s: 10.2.9, 10.2.15
Fix Version/s: N/A

Type: Bug Priority: Blocker
Reporter: Alex U Assignee: Unassigned
Resolution: Not a Bug Votes: 0
Labels: None

Attachments: PNG File mdev16524.png    

 Description   

SELECT ST_WITHIN( ST_GEOMFROMTEXT(' POINT(55 37) ') , ST_GEOMFROMTEXT(' MULTIPOLYGON(((50 30,46 -179,67 179,68 29,50 30))) '));

returns false but expected true

 Comments   
Comment by Elena Stepanova [ 2018-06-21 ]

I've attached visualization of your polygon and point produced by QGIS (not by any of our tools). Visualization seems to be reasonable, and it confirms that the point is not within.

Generated at Thu Feb 08 08:29:33 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.