• Marko Mäkelä's avatar
    Bug#28573894 ALTER PARTITIONED TABLE ADD AUTO_INCREMENT DIFF RESULT DEPENDING ON ALGORITHM · 1cd31bc1
    Marko Mäkelä authored
    For partitioned table, ensure that the AUTO_INCREMENT values will
    be assigned from the same sequence. This is based on the following
    change in MySQL 5.6.44:
    
    commit aaba359c13d9200747a609730dafafc3b63cd4d6
    Author: Rahul Malik <rahul.m.malik@oracle.com>
    Date:   Mon Feb 4 13:31:41 2019 +0530
    
        Bug#28573894 ALTER PARTITIONED TABLE ADD AUTO_INCREMENT DIFF RESULT DEPENDING ON ALGORITHM
    
        Problem:
        When a partition table is in-place altered to add an auto-increment column,
        then its values are starting over for each partition.
    
        Analysis:
        In the case of in-place alter, InnoDB is creating a new sequence object
        for each partition. It is default initialized. So auto-increment columns
        start over for each partition.
    
        Fix:
        Assign old sequence of the partition to the sequence of next partition
        so it won't start over.
    
        RB#21148
        Reviewed by Bin Su <bin.x.su@oracle.com>
    1cd31bc1
handler0alter.cc 180 KB