• Thirunarayanan Balathandayuthapani's avatar
    MDEV-16849 Extending indexed VARCHAR column should be instantaneous · b8aef872
    Thirunarayanan Balathandayuthapani authored
    Analysis:
    ========
    Increasing the length of the indexed varchar column is not an instant operation for
    innodb.
    
    Fix:
    ===
    - Introduce the new handler flag 'Alter_inplace_info::ALTER_COLUMN_INDEX_LENGTH' to
    indicate the index length differs due to change of column length changes.
    
    - InnoDB makes the ALTER_COLUMN_INDEX_LENGTH flag as instant operation.
    
    This is a port of Mysql fix.
    
        commit 913071c0b16cc03e703308250d795bc381627e37
        Author: Nisha Gopalakrishnan <nisha.gopalakrishnan@oracle.com>
        Date:   Wed May 30 14:54:46 2018 +0530
    
            BUG#26848813: INDEXED COLUMN CAN'T BE CHANGED FROM VARCHAR(15)
                          TO VARCHAR(40) INSTANTANEOUSLY
    b8aef872
alter_varchar_change.test 8.44 KB