MySQL 8.0 Release Notes
ST_GeomFromText(), ST_GeomFromWKB(), ST_LineFromText(), ST_LineFromWKB(),
ST_LineStringFromText(), ST_LineStringFromWKB(), ST_MLineFromText(),
ST_MLineFromWKB(), ST_MPointFromText(), ST_MPointFromWKB(), ST_MPolyFromText(),
ST_MPolyFromWKB(), ST_MultiLineStringFromText(), ST_MultiLineStringFromWKB(),
ST_MultiPointFromText(), ST_MultiPointFromWKB(), ST_MultiPolygonFromText(),
ST_MultiPolygonFromWKB(), ST_PointFromText(), ST_PointFromWKB(),
ST_PolyFromText(), ST_PolyFromWKB(), ST_PolygonFromText(), ST_PolygonFromWKB().
(ST_LatFromGeoHash(), ST_LongFromGeoHash(), and ST_PointFromGeoHash() do not have
this behavior because they cannot represent out-of-range values.)
ST_GeomFromGeoJSON() also now returns an error if a crs member that specifies an SRID different
from the top-level object SRID is found at a lower level of the GeoJSON document.
Note
If spatial data contains SRID values that refer to a geographic spatial reference
system and the data coordinates are out of range, existing queries using these
functions will return different results, compared to previous MySQL versions.
(Bug #26941370, Bug #88031, WL #9449)
• Incompatible Change: Previously, these spatial functions ignored the spatial reference system (SRS)
for geometry arguments and computed results on a Cartesian plane. They now support computations
for geometry arguments that specify a geographic SRS: ST_Distance_Sphere(), ST_IsSimple(),
ST_IsValid(), ST_Length().
Previously, these spatial functions ignored the SRS for any geometry arguments and computed
results on a Cartesian plane. They now produce an error when invoked with geometry
arguments that specify a geographic SRS: ST_Area(), ST_Buffer(), ST_Centroid(),
ST_ConvexHull(), ST_Difference(), ST_Envelope(), ST_Intersection(), ST_IsClosed(),
ST_MakeEnvelope(), ST_Simplify(), ST_SymDifference(), ST_Union(), ST_Validate().
Previously, these spatial functions permitted geometry arguments with an undefined
SRS. They now produce an error when invoked with geometry arguments that have
an undefined SRS: ST_Dimension(), ST_Distance_Sphere(), ST_EndPoint(),
ST_ExteriorRing(), ST_GeometryN(), ST_GeometryType(), ST_InteriorRingN(),
ST_IsEmpty(), ST_IsSimple(), ST_IsValid(), ST_Length(), ST_NumGeometries(),
ST_NumInteriorRing(), ST_NumInteriorRings(), ST_NumPoints(), ST_PointN(),
ST_StartPoint(), ST_SwapXY(), ST_X(), ST_Y().
Previously, the ST_GeoHash() spatial function accepted points with any SRID. ST_GeoHash() now
accepts only points with SRID 0 or 4326.
Note
If spatial data contains geometry values that now are interpreted differently by
the functions just listed, existing queries using these functions will return different
results, compared to previous MySQL versions.
(WL #10416, WL #10926, WL #10927, WL #10999, WL #11096)
• Incompatible Change: For the following spatial functions that take an SRID argument,
they now return an error if the SRID does not exist: ST_GeomCollFromText(),
ST_GeomCollFromTxt(), ST_GeomCollFromWKB(), ST_GeometryCollectionFromText(),
ST_GeometryCollectionFromWKB(), ST_GeometryFromText(), ST_GeometryFromWKB(),
ST_GeomFromGeoJSON(), ST_GeomFromText(), ST_GeomFromWKB(), ST_LineFromText(),
450