Skip to content
  • Thirunarayanan Balathandayuthapani's avatar
    0635e432
    Bug #23533396 ASSERTION !M_PREBUILT->TRX->CHECK_FOREIGNS · 0635e432
    Thirunarayanan Balathandayuthapani authored
    
    
    Analysis:
    ========
    A foreign key constraint cannot reference a secondary index defined
    on a generated virtual column. While adding new index/drop existing
    column, server internally drops the internal foreign key index and
    it leads to choose the virtual secondary index as foreign key index.
    But innodb doesn't allow foreign key constraint reference to
    secondary virtual index.
    
    Fix:
    ===
    Allow foreign key constraint refer to secondary index defined on
    a generated virutal column.
    
    Reviewed-by: default avatarJimmy <Yang&lt;jimmy.yang@oracle.com>
    RB: 13586
    0635e432
    Bug #23533396 ASSERTION !M_PREBUILT->TRX->CHECK_FOREIGNS
    Thirunarayanan Balathandayuthapani authored
    
    
    Analysis:
    ========
    A foreign key constraint cannot reference a secondary index defined
    on a generated virtual column. While adding new index/drop existing
    column, server internally drops the internal foreign key index and
    it leads to choose the virtual secondary index as foreign key index.
    But innodb doesn't allow foreign key constraint reference to
    secondary virtual index.
    
    Fix:
    ===
    Allow foreign key constraint refer to secondary index defined on
    a generated virutal column.
    
    Reviewed-by: default avatarJimmy <Yang&lt;jimmy.yang@oracle.com>
    RB: 13586
Loading