• Marko Mäkelä's avatar
    MDEV-13847 Allow ALTER TABLE…ADD SPATIAL INDEX…ALGORITHM=INPLACE · 96f06f95
    Marko Mäkelä authored
    MDEV-13851 Always check table options in ALTER TABLE…ALGORITHM=INPLACE
    
    In the merge of MySQL 5.7.9 to MariaDB 10.2.2, some code was included
    that prevents ADD SPATIAL INDEX from being executed with ALGORITHM=INPLACE.
    
    Also, the constant ADD_SPATIAL_INDEX was introduced as an alias
    to ADD_INDEX. We will remove that alias now, and properly implement
    the same ADD SPATIAL INDEX restrictions as MySQL 5.7 does:
    
    1. table-rebuilding operations are not allowed if SPATIAL INDEX survive it
    2. ALTER TABLE…ADD SPATIAL INDEX…LOCK=NONE is not allowed
    
    ha_innobase::prepare_inplace_alter_table(): If the ALTER TABLE
    requires actions within InnoDB, enforce the table options (MDEV-13851).
    In this way, we will keep denying ADD SPATIAL INDEX for tables
    that use encryption (MDEV-11974), even if ALGORITHM=INPLACE is used.
    96f06f95
alter_spatial_index.test 24.1 KB