空间运算报错
Error Code: 3033. Binary geometry function mbrwithin given two geometries of different srids: 0 and 4326, which should have been identical. 0.000 secError Code: 3037. Invalid GIS data provided to function st_geometryfromtext. 0.000 sec
Error Code: 3033. Binary geometry function mbrwithin given two geometries of different srids: 4326 and 0, which should have been identical. 0.016 sec
解决方法:
更改安全模式
SET SQL_SAFE_UPDATES = 0;
// 将表中的geomerty,全部改成0坐标。
UPDATE honor_db.honor_t_m_poi_main SET GEOMETRY = ST_GEOMFROMTEXT(ST_ASTEXT(GEOMETRY), 0)