MySQL raises warning 3195 when GEOMFROMWKB() is used to force SRID 0; the call is deprecated and will be replaced by ST_SRID().
ER_WARN_USING_GEOMFROMWKB_TO_SET_SRID_ZERO warns that GEOMFROMWKB(geom,0) is deprecated. Replace the call with ST_SRID(ST_AsWKB(geom),0) or store the geometry with a valid SRID to clear the warning.
ER_WARN_USING_GEOMFROMWKB_TO_SET_SRID_ZERO
Warning 3195 appears when a query calls GEOMFROMWKB() with an SRID value of 0. MySQL flags this as deprecated behaviour because future versions will handle SRID assignment with ST_SRID().
The server emits the warning during INSERT, UPDATE, or SELECT statements that attempt to coerce a geometry column to SRID 0 through GEOMFROMWKB(). It is first seen in MySQL 5.7.19 and persists in 8.x.
Although flagged as a warning, ignoring it can break forward-compatibility. Queries relying on the deprecated call may fail or return different results after an upgrade.
Replace GEOMFROMWKB(geom,0) with ST_SRID(ST_AsWKB(geom),0) or, better, store the geometry with its proper SRID and avoid forcing 0 altogether.
GEOMFROMWKB() was never intended for SRID manipulation. Using it with a second argument of 0 triggers the warning.
Old ETL jobs that zero-out SRID values to sidestep coordinate reference checks will surface the warning after 5.7.19.
Older code examples published before the deprecation still circulate online, leading teams to replicate the pattern.
General notice that a called function is deprecated; replace with the recommended alternative.
Raised when MySQL cannot locate the specified SRID in the spatial reference system tables.
Alerts you that a particular SQL syntax element will be removed in future releases.
No. It is a warning, so the statement completes but is logged in the warning list.
MySQL documentation indicates the old signature will be dropped in a future major release, likely 9.0.
SRID 0 is reserved for unspecified or Cartesian data. Most production datasets should store a real spatial reference like 4326.
Galaxy surfaces MySQL warnings inline and offers AI-generated fixes, letting you refactor the query without leaving the editor.
.avif)
.avif){kind=logo}
