• unknown's avatar
    Bug#4118: multi-table UPDATE takes WRITE lock on read table · 308b6792
    unknown authored
      Ensures that WRITE lock is not obtained on all tables referenced.
    
    
    mysql-test/r/lock_multi.result:
      Bug#4118
        New test for multi-update locking
    mysql-test/r/multi_update.result:
      Bug#4118
        Fix test
    mysql-test/t/lock_multi.test:
      Bug#4118
        New test for multi-update locking
    mysql-test/t/multi_update.test:
      Bug#4118
        Fix test
    sql/sql_parse.cc:
      Bug#4118
        Split multi-update to its own case statement in sql_parse.cc
    sql/sql_update.cc:
      Bug#4118
        Overview of locking checking:    
          1. Open and acquire READ lock
          2. Check to see which tables need WRITE lock
          3. Unlock tables and relock
    sql/sql_yacc.yy:
      Bug#4118
        Split multi-update to its own case statement in sql_parse.cc
    308b6792
multi_update.result 11.4 KB