• ingo@mysql.com's avatar
    BUG#5390 - problems with merge tables · 76861ac6
    ingo@mysql.com authored
    Problem #1: INSERT...SELECT
    INSERT ... SELECT with the same table on both sides (hidden
    below a MERGE table) does now work by buffering the select result.
    The duplicate detection works now after open_and_lock_tables() 
    on the locks.
    I did not find a test case that failed without the change in
    sql_update.cc. I made the change anyway as it should in theory
    fix a possible MERGE table problem with multi-table update.
    76861ac6
merge.result 13.6 KB