• unknown's avatar
    BUG#5390 - problems with merge tables · f6cac54b
    unknown authored
    Problem #1: INSERT...SELECT, Version for 4.1.
    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.
    
    
    libmysqld/ha_blackhole.cc:
      BUG#5390 - problems with merge tables
      No idea, how the symlink change made it into my patch.
    mysql-test/r/create.result:
      BUG#5390 - problems with merge tables
      Removed a duplicate test.
    mysql-test/r/merge.result:
      BUG#5390 - problems with merge tables
      Problem #1: INSERT...SELECT, Version for 4.1.
      Added test results.
    mysql-test/t/create.test:
      BUG#5390 - problems with merge tables
      Removed a duplicate test.
    mysql-test/t/merge.test:
      BUG#5390 - problems with merge tables
      Problem #1: INSERT...SELECT, Version for 4.1.
      Added tests.
    sql/lock.cc:
      BUG#5390 - problems with merge tables
      Problem #1: INSERT...SELECT, Version for 4.1.
      Added a new function to find a duplicate lock in a list of tables.
    sql/mysql_priv.h:
      BUG#5390 - problems with merge tables
      Problem #1: INSERT...SELECT, Version for 4.1.
      Added a declaration for the new function.
    sql/sql_parse.cc:
      BUG#5390 - problems with merge tables
      Problem #1: INSERT...SELECT, Version for 4.1.
      Changed the duplicate tables detection for INSERT ... SELECT
      to use the new function, which does also work for MERGE tables.
    sql/sql_update.cc:
      BUG#5390 - problems with merge tables
      Problem #1: INSERT...SELECT, Version for 4.1.
      Changed the duplicate tables detection for UPDATE
      to use the new function, which does also work for MERGE tables.
    f6cac54b
create.test 15.7 KB