I recently upgraded to MySQL 5.7.9 & am using MyISAM for my table engine.
Adding a new POINT column like so:
ALTER TABLE <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.