Re: MySQL 8: ST_Interects works very strange

[David Stokes]

It looks you are creating a one degree wide box around the antimeridian. MySQL will assume the shortest path between long -179 and long 180, so it doesn't intersect with his point.

Also, the shortest path between the south and north poles could go along any degree of longitude, so he really should use a third point to make it follow the longitude you want. It seems to work by accident in this case.

Thirdly, Boost Geometry and MySQL doesn't guarantee that polygons covering more than half the globe will work as expected. There's no guarantee that the query would work as expected even if you got the box right.