An error occurred fetching the project authors.
  1. 05 Mar, 2009 1 commit
    • Kristofer Pettersson's avatar
      Bug#39843 DELETE requires write access to table in subquery in where clause · 16347772
      Kristofer Pettersson authored
      An unnecessarily restrictive lock were taken on sub-SELECTs during DELETE.
      
      During parsing, a global structure is reused for sub-SELECTs and the attribute
      keeping track of lock options were not reset properly.
      This patch introduces a new attribute to keep track on the syntactical lock
      option elements found in a sub-SELECT and then sets the lock options accordingly.
      
      Now the sub-SELECTs will try to acquire a READ lock if possible
      instead of a WRITE lock as inherited from the outer DELETE statement.
      16347772
  2. 02 Aug, 2007 1 commit
  3. 05 Jun, 2007 1 commit
    • svoj@mysql.com/april.(none)'s avatar
      BUG#26976 - Missing table in merge not noted in related error msg + · bd8f81f4
      svoj@mysql.com/april.(none) authored
                  SHOW CREATE TABLE fails
      
      Underlying table names, that merge engine fails to open were not
      reported.
      
      With this fix CHECK TABLE issued against merge table reports all
      underlying table names that it fails to open. Other statements
      are unaffected, that is underlying table names are not included
      into error message.
      
      This fix doesn't solve SHOW CREATE TABLE issue.
      bd8f81f4
  4. 09 Mar, 2007 1 commit
    • kroki/tomash@moonlight.home's avatar
      BUG#9953: CONVERT_TZ requires mysql.time_zone_name to be locked · c19affef
      kroki/tomash@moonlight.home authored
      The problem was that some facilities (like CONVERT_TZ() function or
      server HELP statement) may require implicit access to some tables in
      'mysql' database.  This access was done by ordinary means of adding
      such tables to the list of tables the query is going to open.
      However, if we issued LOCK TABLES before that, we would get "table
      was not locked" error trying to open such implicit tables.
      
      The solution is to treat certain tables as MySQL system tables, like
      we already do for mysql.proc.  Such tables may be opened for reading
      at any moment regardless of any locks in effect.  The cost of this is
      that system table may be locked for writing only together with other
      system tables, it is disallowed to lock system tables for writing and
      have any other lock on any other table.
      
      After this patch the following tables are treated as MySQL system
      tables:
        mysql.help_category
        mysql.help_keyword
        mysql.help_relation
        mysql.help_topic
        mysql.proc (it already was)
        mysql.time_zone
        mysql.time_zone_leap_second
        mysql.time_zone_name
        mysql.time_zone_transition
        mysql.time_zone_transition_type
      
      These tables are now opened with open_system_tables_for_read() and
      closed with close_system_tables(), or one table may be opened with
      open_system_table_for_update() and closed with close_thread_tables()
      (the latter is used for mysql.proc table, which is updated as part of
      normal MySQL server operation).  These functions may be used when
      some tables were opened and locked already.
      
      NOTE: online update of time zone tables is not possible during
      replication, because there's no time zone cache flush neither on LOCK
      TABLES, nor on FLUSH TABLES, so the master may serve stale time zone
      data from cache, while on slave updated data will be loaded from the
      time zone tables.
      c19affef
  5. 07 Jul, 2006 1 commit
  6. 23 Jan, 2006 1 commit
  7. 24 May, 2005 1 commit
  8. 04 Mar, 2005 1 commit
    • dlenev@brandersnatch.localdomain's avatar
      Better approach for prelocking of tables for stored routines execution · 5a6c7027
      dlenev@brandersnatch.localdomain authored
      and some SP-related cleanups.
      
      - We don't have separate stage for calculation of list of tables
        to be prelocked and doing implicit LOCK/UNLOCK any more.
        Instead we calculate this list at open_tables() and do implicit
        LOCK in lock_tables() (and UNLOCK in close_thread_tables()).
        Also now we support cases when same table (with same alias) is
        used several times in the same query in SP.
      
      - Cleaned up execution of SP. Moved all common code which handles
        LEX and does preparations before statement execution or complex
        expression evaluation to auxilary sp_lex_keeper class. Now 
        all statements in SP (and corresponding instructions) that
        evaluate expression which can contain subquery have their
        own LEX.
      5a6c7027
  9. 08 Feb, 2005 1 commit
    • pem@mysql.comhem.se's avatar
      WL#2130: Table locking for stored FUNCTIONs · 2c26ebe3
      pem@mysql.comhem.se 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.
      2c26ebe3
  10. 16 Feb, 2004 1 commit
    • monty@mysql.com's avatar
      After merge fixes · f43093ec
      monty@mysql.com authored
      Added more DBUG statements
      Ensure that we are comparing end space with BINARY strings
      Use 'any_db' instead of '' to mean any database. (For HANDLER command)
      Only strip ' ' when comparing CHAR, not other space-like characters (like \t)
      f43093ec
  11. 03 Feb, 2004 1 commit
  12. 10 Dec, 2003 1 commit
  13. 04 Jun, 2003 1 commit
    • monty@narttu.mysql.fi's avatar
      Added SQLSTATE to client/server protocol · 23145cfe
      monty@narttu.mysql.fi authored
      bmove_allign -> bmove_align
      Added OLAP function ROLLUP
      Split mysql_fix_privilege_tables to a script and a .sql data file
      Added new (MEMROOT*) functions to avoid calling current_thd() when creating some common objects.
      Added table_alias_charset, for easier --lower-case-table-name handling
      Better SQL_MODE handling (Setting complex options also sets sub options)
      New (faster) assembler string functions for x86
      23145cfe
  14. 08 Oct, 2001 2 commits
    • monty@hundin.mysql.fi's avatar
      Cleanup after last merge · 2f603156
      monty@hundin.mysql.fi authored
      2f603156
    • monty@hundin.mysql.fi's avatar
      Updated manual about embedded version. · 88aff4bf
      monty@hundin.mysql.fi authored
      Speed up column-completion in 'mysql'
      Don't use ISAM if HAVE_ISAM is not defined
      A lot of fixes for the embedded version.  All libraries are now included in libmysqld.a
      Changed arguments to convert_dirname() to make it more general.
      Renamed files in the 'merge' directory to all use a common prefix.
      Don't compile both assembler and C functions on x86
      88aff4bf
  15. 28 Sep, 2001 1 commit
    • sasha@mysql.sashanet.com's avatar
      client/mysqlmanagerc.c · bb66c80a
      sasha@mysql.sashanet.com authored
          added support for quiet
          increased line buffer size
      client/mysqltest.c
          fixed memory leak
          added query logging to result file
          added error message logging to result file
          added enable_query_log/disable_query_log
      mysql-test/mysql-test-run.sh
          converted tests to use mysqlmanager
      
      Updated test results
      bb66c80a
  16. 17 Jul, 2001 1 commit
  17. 13 Jul, 2001 2 commits
  18. 18 Apr, 2001 1 commit
    • monty@donna.mysql.fi's avatar
      Added test for PTHREAD_YIELD · bc6fd0ac
      monty@donna.mysql.fi authored
      Removed test of default master parameter
      Don't lock locked tables in REPAIR
      Changed optimzation for SELECT * from table,table ORDER BY keypart LIMIT
      bc6fd0ac
  19. 27 Mar, 2001 1 commit