• unknown's avatar
    Fix for bug #9566 "explicit LOCK TABLE and store procedures result in · 188b8af6
    unknown authored
    illegal state".
    
    We should not assume that mysql.proc table does not exist if we are
    unable to open it under LOCK TABLES or in prelocked mode (and
    remember this fact by setting mysql_proc_table_exists to zero).
    
    
    mysql-test/r/sp.result:
      Added test for bug #9566 "explicit LOCK TABLE and store procedures result in illegal
      state"
    mysql-test/t/sp.test:
      Added test for bug #9566 "explicit LOCK TABLE and store procedures result in illegal
      state"
    sql/sp.cc:
      db_find_routine_aux():
        We should not assume that mysql.proc table does not exist if we are
        unable to open it under LOCK TABLES or in prelocked mode since this
        condition may be transient.
    188b8af6
sp.cc 35 KB