Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Major
-
Resolution: Unresolved
-
5.5, 10.0, 10.1, 10.2, 10.3, 10.4, 10.5, 10.6
-
None
Description
I don't have the details of error reported , but i remember server complaining about unique index
The workaround was to materialized the GEOM column not using virtual column :
alter table zip_all add column coord point not null
update zip_all set coord = POINT(lat,lon);
alter table zip_all_bis ADD SPATIAL INDEX(coord)
Thanks
Attachments
Issue Links
- duplicates
-
MDEV-12384 Cannot create SPATIAL/RTREE index on virtual column
- Closed
- relates to
-
MDEV-10964 Support for NULL/NOT NULL syntax for virtual columns
- Open
- links to