• Dmitry Lenev's avatar
    Follow-up for the fix for bug #46947 "Embedded SELECT without · 6ceacd4f
    Dmitry Lenev authored
    FOR UPDATE is causing a lock".
     
    This patch tries to address problems which were exposed 
    during backporting of original patch to 5.1 tree.
     
    - It ensures that we don't change locking behavior of simple
      SELECT statements on InnoDB tables when they are executed
      under LOCK TABLES ... READ and with @@innodb_table_locks=0.
      Also we no longer pass TL_READ_DEFAULT/TL_WRITE_DEFAULT 
      lock types, which are supposed to be parser-only, to 
      handler::start_stmt() method.
    - It makes check_/no_concurrent_insert.inc auxiliary scripts 
      more robust against changes in test cases that use them
      and also ensures that they don't unnecessarily change 
      environment of caller.
    6ceacd4f
sql_base.cc 291 KB