Bug #2856 Server crashes when trying to create a SPATIAL INDEX on a GEOMETRY column of al
Submitted: 17 Feb 2004 23:42 Modified: 18 Feb 2004 0:34
Reporter: Jeremy Cole (Basic Quality Contributor) (OCA) Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:4.1 OS:Any (*)
Assigned to: Assigned Account CPU Architecture:Any

[17 Feb 2004 23:42] Jeremy Cole 
Description:
Server crashes when trying to create a SPATIAL INDEX on a GEOMETRY column of all-empty values.

How to repeat:
mysql> create table airports select latitude, longitude from flightstats.airports;
Query OK, 19793 rows affected (0.10 sec)
Records: 19793  Duplicates: 0  Warnings: 0

mysql> alter table airports add g geometry not null;
Query OK, 19793 rows affected (0.05 sec)
Records: 19793  Duplicates: 0  Warnings: 0

mysql> alter table airports add spatial index(g);
ERROR 2013 (HY000): Lost connection to MySQL server during query

Suggested fix:
duh. :)
[18 Feb 2004 0:34] Ramil Kalimullin 
Please do not submit the same bug more than once. An existing
bug report already describes this very problem. Even if you feel
that your issue is somewhat different, the resolution is likely
to be the same. Because of this, we hope you add your comments
to the original bug instead.

Thank you for your interest in MySQL.

Additional info:

#233 is the same.