• unknown's avatar
    WL#2130: Table locking for stored FUNCTIONs · 3f249321
    unknown authored
    Collect all tables and SPs refered by a statement, and open all tables
    with an implicit LOCK TABLES. Do find things refered by triggers and views,
    we open them first (and then repeat this until nothing new is found), before
    doing the actual lock tables.
    
    
    mysql-test/r/information_schema.result:
      Updated result for WL#2130.
    mysql-test/r/lock.result:
      Updated result for WL#2130.
    mysql-test/r/sp-error.result:
      Updated result for WL#2130.
    mysql-test/r/sp.result:
      Updated result for WL#2130.
    mysql-test/r/view.result:
      Updated result for WL#2130.
    mysql-test/t/information_schema.test:
      Disabled one test case due to a bug involving LOCK TABLES,
      which shows up with WL#2130.
    mysql-test/t/lock.test:
      New error message with WL#2130. This change is under debate and might change
      in the future, but will do for now.
    mysql-test/t/sp-error.test:
      Updated for WL#2130. Some tests are voided when table access does work from
      functions.
    mysql-test/t/sp.test:
      Updated for WL#2130.
    mysql-test/t/view.test:
      Updated for WL#2130.
    sql/item_func.cc:
      We now have to set net.no_send_ok for functions too, with WL#2130.
    sql/share/errmsg.txt:
      Reused an error code since the old use was voided by WL#2130, but a new
      one was needed instead (similar, but more specific restriction).
    sql/sp.cc:
      Fixed error handling and collection of used tables for WL#2130.
    sql/sp.h:
      Fixed error handling and collection of used tables for WL#2130.
    sql/sp_head.cc:
      Added support functions for collecting and merging hash tables and lists
      of used tables from SPs and substatements, for WL#2130.
    sql/sp_head.h:
      Added support functions for collecting and merging hash tables and lists
      of used tables from SPs and substatements, for WL#2130.
    sql/sql_base.cc:
      Changed the way table->query_id is tested and set during with locked tables
      in effect. This makes some SP test cases work with WL#2130, but has a side
      effect on some error cases with explicit LOCK TABLES. It's still debated if
      this is the correct way, so it might change.
    sql/sql_class.h:
      Added flags for circumventing some interference between WL#2130 and mysql_make_view().
    sql/sql_derived.cc:
      Added some missing initializations. (Potential bugs.)
    sql/sql_lex.cc:
      Clear the new hash tables for WL#2130.
    sql/sql_lex.h:
      Added hash tables for procedures and tables too (as for functions), for WL#2130.
    sql/sql_parse.cc:
      WL#2130: Make table accesses from stored functions work by adding an implicit
      LOCK TABLES around (most) executed statements. To do this, we have to go through
      a loop where we collect all SPs and tables in mysql_execute_statement.
    sql/sql_prepare.cc:
      Cache both functions and procedures for WL#2130.
    sql/sql_show.cc:
      Added some missing initializations. (Potential bugs.)
    sql/sql_view.cc:
      Shortcut mysql_make_view() if thd->shortcut_make_view is true during
      the pre-open phase for collecting tables in WL#2130. Otherwise, the
      similar mechanism here causes interference.
    sql/sql_yacc.yy:
      For WL#2130, added caching of procedures and disallowed LOCK/UNLOCK TABLES in SPs.
    3f249321
information_schema.test 10.9 KB