• Marko Mäkelä's avatar
    MDEV-18152 Assertion 'num_fts_index <= 1' failed · 4e75bfcb
    Marko Mäkelä authored
    InnoDB does not allow creating multiple FULLTEXT INDEX
    in ALGORITHM=INPLACE. This constraint was not being properly
    enforced after MariaDB started to support ALGORITHM=INSTANT
    and instant ADD COLUMN.
    
    As a side effect of this bug, we again allow ALGORITHM=INPLACE
    to rebuild a table when one FULLTEXT INDEX survives.
    Also, we are returning a more accurate reason for refusing LOCK=NONE.
    
    innobase_fulltext_exist(): Return the number of fulltext indexes.
    
    ha_innobase::check_if_supported_inplace_alter(): If the table
    needs to be rebuilt, refuse the operation if multiple fulltext
    indexes would remain.
    4e75bfcb
innodb_mysql_sync.result 18.5 KB