• Rucha Deodhar's avatar
    MDEV-26698: Incorrect row number upon INSERT .. SELECT from the same · 452c9a4d
    Rucha Deodhar authored
    table: rows are counted twice
    
    Analysis: When the table we are trying to insert into and the SELECT table
    are same for INSERT ... SELECT, rows from the SELECT table are copied into
    internal temporary table and then to the INSERT table. We only want to
    count the rows when we start inserting into the table.
    Fix: Reset the counter to 1 before starting to copy from internal temporary
    table to select table and then increment the counter.
    452c9a4d
insert_select.result 15.1 KB