• Thirunarayanan Balathandayuthapani's avatar
    MDEV-30655 IMPORT TABLESPACE fails with column count or index count mismatch · 903ae300
    Thirunarayanan Balathandayuthapani authored
    Problem:
    ========
    Currently import operation fails with schema mismatch when
    cfg file has hidden fts document id and hidden fts document index.
    
    Fix:
    ====
    To fix this issue, simply add the fts doc id column,
    indexes in table definition and try to import the table.
    In case of success:
    1) update the fts document id in sys columns.
    2) update the number of columns in sys tables.
    3) insert the new fts index entry in sys indexes table
    and sys fields.
    4) Reload the table with new table definition
    903ae300
import_hidden_fts.test 1.43 KB