MySQL Bugs: #91464: Spatial Index on NULLABLE Geometry Columns

Bug #91464	Spatial Index on NULLABLE Geometry Columns
Submitted:	28 Jun 2018 12:05	Modified:	5 Dec 2019 13:43
Reporter:	Michael Frhler	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server	Severity:	S4 (Feature request)
Version:		OS:	Any
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
It would be very good to support spatial indexes on a NULLABLE geometry column.

The usage of spatial indexes is limited by the fact we can create them only on NOTNULL columns. 

Other DBMS Systems supporting spatial data (PostGIS, Oracle SDO ...) do not have that limitation and I don´t really see a technical problem. NULL - Geometries simply should be ignored by the index.

Support of NULLABLE geometry columns for Indexing would in my eyes make MySQL a lot easier to handle when using GIS / Spatial Data.

How to repeat:
Feature Request

Hi Mr. Frhler,

Thank you for your feature request.

However, we do not plan to support NULL-able geometry columns.

Not acceptable.