I recently upgraded to MySQL 5.7.9 & am using MyISAM for my table engine.
Adding a new POINT column like so:
ALTER TABLE ADD centroid POINT NOT NULL;
gives this error:
ERROR 1138 (22004): Invalid use of NULL value
I can create the column without NOT NULL but then I am unable to create a spatial index on the column. This worked for me in MySQL 5.6, and I don't see anything relevant in the docs.
أكثر...
Adding a new POINT column like so:
ALTER TABLE ADD centroid POINT NOT NULL;
gives this error:
ERROR 1138 (22004): Invalid use of NULL value
I can create the column without NOT NULL but then I am unable to create a spatial index on the column. This worked for me in MySQL 5.6, and I don't see anything relevant in the docs.
أكثر...