mysql geometry索引,MySQL中的空间索引 - 错误 - 无法从发送到GEOMETRY字段的数据中获取几何对象...

I am new to the whole 'spatial index' thing, but it seems to be the best solution for filtering based on latitude/longitude. So I added a column to my table:

So I created a geometry field:

ALTER TABLE `addresses` ADD `point` POINT NOT NULL

And then I tried to add an index:

ALTER TABLE `addresses` ADD SPATIAL INDEX ( `point` )

But I get an error:

#1416 - Cannot get geometry object from data you send to the GEOMETRY field

What am I doing wrong here?

解决方案

OK I found the solution: Can't create a spatial index if some of the column fields contain no data. After running

UPDATE `addresses` SET `point` = POINT( lat, lng )

Everything worked fine.