1. 27 Oct, 2005 1 commit
    • unknown's avatar
      support of view underlying tables and SP functions security check added (BUG#9505) (WL#2787) · 9c6c527c
      unknown authored
      
      mysql-test/r/information_schema.result:
        error message changed
      mysql-test/r/sp.result:
        error message changed
      mysql-test/r/sql_mode.result:
        fixed test suite
      mysql-test/r/view.result:
        error message changed
      mysql-test/r/view_grant.result:
        test of underlying view tables check
      mysql-test/t/sql_mode.test:
        fixed test suite
      mysql-test/t/view_grant.test:
        test of underlying view tables check
      sql/item.cc:
        check of underlying tables privilege added
      sql/item.h:
        Name the resolution context points to the security  context of view (if item belong to the view)
      sql/item_func.cc:
        a view error hiding for execution of prepared function belonged to a view
        fixed checking privileges if stored functions belonds to some view
      sql/mysql_priv.h:
        refult of derived table processing functions changed to bool
        Security_context added as an argument to find_field_in_table()
      sql/share/errmsg.txt:
        error message fixed
      sql/sql_acl.cc:
        Storing requested privileges of tables added
        View underlying tables privilege check added
      sql/sql_base.cc:
        View underlying tables privilege check added
      sql/sql_cache.cc:
        Code cleunup: we should not register underlying tables of view second time
      sql/sql_delete.cc:
        ancestor -> merge_underlying_list renaming
      sql/sql_derived.cc:
        refult of derived table processing functions changed to bool
        do not give SELECT_ACL for TEMPTABLE views
      sql/sql_lex.h:
        The comment added
      sql/sql_parse.cc:
        registration of requested privileges added
      sql/sql_prepare.cc:
        registration of requested privileges added
      sql/sql_update.cc:
        manipulation of requested privileges for underlying tables made the same as for table which we are updating
      sql/sql_view.cc:
        underlying tables of view security check support added
      sql/table.cc:
        renaming and fixing view preparation methods, methods for checking underlyoing tables security context added
      sql/table.h:
        storege for reuested privileges added
      9c6c527c
  2. 19 Oct, 2005 5 commits
  3. 18 Oct, 2005 21 commits
  4. 17 Oct, 2005 13 commits
    • unknown's avatar
      1fa2f356
    • unknown's avatar
      Merge bk-internal.mysql.com:/home/bk/mysql-5.0 · 21d0fe01
      unknown authored
      into  mysql.com:/home/emurphy/src/bk-clean/mysql-5.0
      
      21d0fe01
    • unknown's avatar
      Merge bk-internal.mysql.com:/home/bk/mysql-5.0 · 057c0f08
      unknown authored
      into  mysql.com:/home/emurphy/src/bk-clean/mysql-5.0
      
      057c0f08
    • unknown's avatar
      Merge pgalbraith@bk-internal.mysql.com:/home/bk/mysql-5.0 · 008e4abf
      unknown authored
      into  krsna.patg.net:/home/patg/mysql-build/mysql-5.0.test1
      
      008e4abf
    • unknown's avatar
      Merge pgalbraith@bk-internal.mysql.com:/home/bk/mysql-5.0 · fff4897f
      unknown authored
      into  krsna.patg.net:/home/patg/mysql-build/mysql-5.0.test1
      
      fff4897f
    • unknown's avatar
      BUG# 13052 Changed text in options to TIMESTAMP · 138f1a25
      unknown authored
      
      client/mysqldump.c:
        BUG# 13052 Changed text in option to TIMESTAMP
      138f1a25
    • unknown's avatar
      Merge bk-internal.mysql.com:/home/bk/mysql-5.0 · 17ff2406
      unknown authored
      into  mysql.com:/home/dlenev/src/mysql-5.0-bg12739
      
      
      sql/mysql_priv.h:
        Auto merged
      sql/sql_base.cc:
        Auto merged
      sql/sql_table.cc:
        Auto merged
      17ff2406
    • unknown's avatar
      Fix for bug #12739 "Deadlock in multithreaded environment during creating/ · 1a00e60b
      unknown authored
      droping trigger on InnoDB table".
      
      Deadlock occured in cases when we were trying to create two triggers for
      the same InnoDB table concurrently and both threads were able to reach
      close_cached_table() simultaneously. Bugfix implements new approach to
      table locking and table cache invalidation during creation/dropping
      of trigger.
      
      No testcase is supplied since bug was repeatable only under high concurrency.
      
      
      sql/mysql_priv.h:
        reopen_name_locked_table():
          Changed function signature to make it more robust against erroneous usage.
      sql/sql_base.cc:
        reopen_name_locked_table():
          Changed function signature to make it more robust against erroneous usage.
          Obtaining LOCK_open lock is now resposibility of caller.
          When searching for the table to open we should not prefer connection's current
          database over database which was explicitly specified in TABLE_LIST::db member
          (even if database is not explicitly specified for table in original query
          TABLE_LIST::db will be set properly at parsing stage).
          Fixed behavior of function in cases when error occurs during opening of table.
      sql/sql_table.cc:
        prepare_for_restore()/prepare_for_repair():
          We should not prefer connection's current database over database which was
          specified in TABLE_LIST::db member (even if database is not explicitly
          specified for table in original query TABLE_LIST::db will be set properly
          at parsing stage). Fixed behavior in unlikely case when we are unable
          to open table which we are restoring/reparing at the end of preparation
          stage.
      sql/sql_trigger.cc:
        mysql_create_or_drop_trigger():
          Now instead of opening and locking table, creating trigger, and then trying
          to invalidate all instances of this table in table cache, we obtain name
          lock on table first (thus ensuring that no other thread has this table
          open), open it, create trigger and then close table therefore releasing lock.
          New approach is more in line with other places where change .frm files
          (i.e. change table meta-data).
          With this change we also get rid of deadlock which occured in cases when we
          were trying to create two triggers for the same InnoDB table concurrently
          and both threads were able to reach close_cached_table() simultaneously.
          (Alternative was to forbid to InnoDB downgrade locks for CREATE/DROP
           TRIGGER statements in one way or another but I think that proposed
           solution is better long term).
      1a00e60b
    • unknown's avatar
      Merge bk-internal.mysql.com:/home/bk/mysql-5.0 · 9af97324
      unknown authored
      into  mysql.com:/home/emurphy/src/bk-clean/mysql-5.0
      
      9af97324
    • unknown's avatar
      BUG#13900 DATETIME data changes after inserting a new row in a InnoDB table · c5615673
      unknown authored
      Applying patch from Marko.
      All tests pass in pentium-debug-max build on Linux.
      
      
      innobase/include/rem0rec.h:
        BUG#13900 DATETIME data changes after inserting a new row in a InnoDB table
        Applying patch from Marko.
      innobase/include/rem0rec.ic:
        BUG#13900 DATETIME data changes after inserting a new row in a InnoDB table
        Applying patch from Marko.
      innobase/row/row0upd.c:
        BUG#13900 DATETIME data changes after inserting a new row in a InnoDB table
        Applying patch from Marko.
      c5615673
    • unknown's avatar
      Merge kboortz@bk-internal.mysql.com:/home/bk/mysql-5.0 · 162076e4
      unknown authored
      into mysql.com:/Users/kent/mysql/bk/mysql-5.0
      
      162076e4
    • unknown's avatar
      Bug #13377. Small update, code formatting. · df494c54
      unknown authored
      df494c54
    • unknown's avatar
      Merge svlasenko@bk-internal.mysql.com:/home/bk/mysql-5.0 · ac4756d4
      unknown authored
      into  selena.:H:/MYSQL/src/#13377-mysql-5.0
      
      
      mysql-test/include/check_var_limit.inc:
        Auto merged
      mysql-test/include/have_big5.inc:
        Auto merged
      mysql-test/include/have_compress.inc:
        Auto merged
      mysql-test/include/have_crypt.inc:
        Auto merged
      mysql-test/include/have_outfile.inc:
        Auto merged
      mysql-test/include/have_query_cache.inc:
        Auto merged
      mysql-test/include/have_tis620.inc:
        Auto merged
      mysql-test/include/have_ucs2.inc:
        Auto merged
      mysql-test/include/have_ujis.inc:
        Auto merged
      mysql-test/include/not_embedded.inc:
        Auto merged
      mysql-test/include/system_db_struct.inc:
        Auto merged
      mysql-test/include/test_outfile.inc:
        Auto merged
      mysql-test/r/greedy_optimizer.result:
        Auto merged
      mysql-test/r/index_merge.result:
        Auto merged
      mysql-test/r/index_merge_bdb.result:
        Auto merged
      mysql-test/r/index_merge_innodb.result:
        Auto merged
      mysql-test/r/index_merge_innodb2.result:
        Auto merged
      mysql-test/r/index_merge_ror.result:
        Auto merged
      mysql-test/r/index_merge_ror_cpk.result:
        Auto merged
      mysql-test/r/join_nested.result:
        Auto merged
      mysql-test/r/rowid_order_bdb.result:
        Auto merged
      mysql-test/r/rowid_order_innodb.result:
        Auto merged
      mysql-test/r/rpl_session_var.result:
        Auto merged
      mysql-test/r/sp-error.result:
        Auto merged
      mysql-test/r/sp-security.result:
        Auto merged
      mysql-test/r/sp.result:
        Auto merged
      mysql-test/r/sum_distinct.result:
        Auto merged
      mysql-test/std_data/des_key_file:
        Auto merged
      mysql-test/std_data/init_file.dat:
        Auto merged
      mysql-test/std_data/loaddata1.dat:
        Auto merged
      mysql-test/std_data/loaddata2.dat:
        Auto merged
      mysql-test/std_data/loaddata3.dat:
        Auto merged
      mysql-test/std_data/loaddata4.dat:
        Auto merged
      mysql-test/std_data/rpl_loaddata.dat:
        Auto merged
      mysql-test/std_data/rpl_loaddata2.dat:
        Auto merged
      mysql-test/std_data/warnings_loaddata.dat:
        Auto merged
      mysql-test/t/greedy_optimizer.test:
        Auto merged
      mysql-test/t/index_merge.test:
        Auto merged
      mysql-test/t/index_merge_bdb.test:
        Auto merged
      mysql-test/t/index_merge_innodb.test:
        Auto merged
      mysql-test/t/index_merge_innodb2.test:
        Auto merged
      mysql-test/t/index_merge_ror.test:
        Auto merged
      mysql-test/t/index_merge_ror_cpk.test:
        Auto merged
      mysql-test/t/join_nested.test:
        Auto merged
      mysql-test/t/rowid_order_bdb.test:
        Auto merged
      mysql-test/t/rowid_order_innodb.test:
        Auto merged
      mysql-test/t/rpl_session_var.test:
        Auto merged
      mysql-test/t/sp-error.test:
        Auto merged
      mysql-test/t/sp-security.test:
        Auto merged
      mysql-test/t/sp.test:
        Auto merged
      mysql-test/t/sum_distinct.test:
        Auto merged
      sql/log.cc:
        Auto merged
      sql/slave.cc:
        Auto merged
      sql/sql_class.h:
        Auto merged
      ac4756d4