Skip to content
  • Sivert Sorumgard's avatar
    2ff1aa8c
    Bug#30386119: ALTERING COLUMN COLLATION DOESN'T SEEM TO AFFECT UNIQUE INDEXES UNTIL RESTART · 2ff1aa8c
    Sivert Sorumgard authored
    When deciding whether a collation or character set change should prohibit
    using the inplace algorithm for an ALTER TABLE statement, the collation
    handlers were compared, and if they were the same, the change was
    accepcted even for indexed fields.
    
    However, we can use the same collation handler for different collations,
    so the decision should instead be based on comparing the pair of character
    set and collation being used for the source and destination field.
    
    Additionally, changing the collation should be prohibited for ALTER inplace
    if the column is indexed in the target table. Thus, changing the collation
    and adding a new index on the same column should be prohibited for ALTER
    inplace, while changing the collation and dropping an existing index
    should be allowed.
    
    Change-Id: I2d0c7fb2161103d4d05d29be0f62bde69a4aed0d
    2ff1aa8c
    Bug#30386119: ALTERING COLUMN COLLATION DOESN'T SEEM TO AFFECT UNIQUE INDEXES UNTIL RESTART
    Sivert Sorumgard authored
    When deciding whether a collation or character set change should prohibit
    using the inplace algorithm for an ALTER TABLE statement, the collation
    handlers were compared, and if they were the same, the change was
    accepcted even for indexed fields.
    
    However, we can use the same collation handler for different collations,
    so the decision should instead be based on comparing the pair of character
    set and collation being used for the source and destination field.
    
    Additionally, changing the collation should be prohibited for ALTER inplace
    if the column is indexed in the target table. Thus, changing the collation
    and adding a new index on the same column should be prohibited for ALTER
    inplace, while changing the collation and dropping an existing index
    should be allowed.
    
    Change-Id: I2d0c7fb2161103d4d05d29be0f62bde69a4aed0d
Loading