[MDEV-7687] Can't create SPATIAL index on top of persistent virtual column - JIRA

Details

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

Hide

Permalink

Sergei Golubchik added a comment - 2015-03-10 11:56

Can't create SPATIAL index on top of persistent virtual column? Or not persistent?

Show

Sergei Golubchik added a comment - 2015-03-10 11:56 Can't create SPATIAL index on top of persistent virtual column? Or not persistent?

Hide

Permalink

VAROQUI Stephane added a comment - 2015-03-10 11:59

Hi Sergei, was persistent

Show

VAROQUI Stephane added a comment - 2015-03-10 11:59 Hi Sergei, was persistent

Hide

Permalink

Sergei Golubchik added a comment - 2015-03-10 12:40

what mariadb version?

Show

Sergei Golubchik added a comment - 2015-03-10 12:40 what mariadb version?