• Marko Mäkelä's avatar
    MDEV-11369 Rewrite innodb.instant_alter test · 84167947
    Marko Mäkelä authored
    Create each table with a SPATIAL INDEX, because when MySQL 5.7
    (and MariaDB 10.2.2) introduced SPATIAL INDEX for InnoDB tables,
    a table-rebuilding LOCK=NONE would be refused if the table
    contains any SPATIAL INDEX. With instant ADD COLUMN, the operations
    must be allowed, and must report '0 rows affected' for everything
    else except ROW_FORMAT=COMPRESSED tables.
    
    FIXME: When instant ADD COLUMN is enabled, the ALGORITHM=INPLACE
    will have to be changed to LOCK=NONE.
    84167947
instant_alter.test 5.9 KB