• Aleksey Midenkov's avatar
    MDEV-31297 Create table as select on system versioned tables do not · fee0a905
    Aleksey Midenkov authored
    	   work consistently on replication
    
    Row-based replication does not execute CREATE .. SELECT but instead
    CREATE TABLE. CREATE .. SELECT creates implict system fields on
    unusual place: in-between declared fields and select fields. That was
    done because select_field_pos logic requires select fields go last in
    create_list.
    
    So, CREATE .. SELECT on master and CREATE TABLE on slave create system
    fields on different positions and replication gets field mismatch.
    
    To fix this we've changed CREATE .. SELECT to create implicit system
    fields on usual place in the end and updated select_field_pos for
    handling this case.
    fee0a905
rpl_row.result 2.07 KB