MySQL Forums
Forum List  »  General

Cannot add spatial index for generated column
Posted by: Lee Colarelli
Date: August 20, 2022 04:05AM

Hi all.

I have a stored generated column, creating a POINT from lat and long columns. This is obviously a very common practice.

However, I found that a spatial index cannot be generated for this column because the column cannot be nullable.

But a generated column is always nullable!

This is, in my opinion, something that should be fixed. Especially since the two columns which are generating the point are both not nullable, hence the generated column is not nullable? Surely the server can determine this?

Options: ReplyQuote

Written By
Cannot add spatial index for generated column
August 20, 2022 04:05AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.