[mapguide-users] MGOS 3.1.2 and MySQL 8.0 - unable to display spatial objects

[Jackie Ng]

Just to add to this, is your MySQL 8 table using srid 4326?

If so then they've made a breaking change in MySQL 8 in how geographic
coordinates are meant to be interpreted (as lat/long instead of long/lat). 

Ref:
https://dba.stackexchange.com/questions/242001/mysql-8-st-geomfromtext-giving-error-latitude-out-of-range-in-function-st-geomfr

It could very well be that the rendering is failing because the view box
geometry we're constructing for the spatial intersection filter is
constructing the view box geometry coordinates in long/lat instead of
lat/long but only iff the table in question is using srid 4326 for its geom
column.

- Jackie



--
Sent from: http://osgeo-org.1560.x6.nabble.com/MapGuide-Users-f4182607.html