I'm developing a spatial database of administrative areas. I started out with PostGIS, but as MySQL is being used in our other projects, I thought I would at least try to create a spatial-enabled MySQL database.
However, spatial queries give me different results than PostGIS does. Let's say I have a query like this
SELECT nazev FROM orp as o, kraje as k WHERE
Intersects(o.geom,k.geom) AND Within(Centroid(o.geom),k.geom) AND
k.nazev = 'Nazev'.
It should return a list of administrative areas within a county with defined name (nazev). Instead, it gives me expected areas + areas that touch boundary of a county, but are not contained by this county. When I run the same query with PostGIS, I get the correct results.
Have anyone ever faced this issue? I am using a national CRS (EPSG:102067) and have tried also with EPSG:4326 with same result. Isn't the implementation of the OGC spec the same as in PostGIS? Thanks for any hint.