An error occurred fetching the project authors.
  1. 16 Mar, 2005 2 commits
    • dlenev@brandersnatch.localdomain's avatar
      Fixed behavior of LOAD DATA with subqueries in SET clause. · 3da06a55
      dlenev@brandersnatch.localdomain authored
      The idea is to use TABLE_LIST::lock_type for passing type of lock for
      target table to mysql_load() instead of using LEX::lock_option 
      (which were rewritten by first subselect in SET clause).
      
      This should also fix potential problem with LOAD DATA in SP
      (it is important for them to have right lock_type in the table
       list by the end of statement parsing).
      3da06a55
    • dlenev@brandersnatch.localdomain's avatar
      WL#874 "Extended LOAD DATA". · f1691140
      dlenev@brandersnatch.localdomain authored
      Now one can use user variables as target for data loaded from file
      (besides table's columns). Also LOAD DATA got new SET-clause in which
      one can specify values for table columns as expressions.
      
      For example the following is possible:
      LOAD DATA INFILE 'words.dat' INTO TABLE t1 (a, @b) SET c = @b + 1;
      
      This patch also implements new way of replicating LOAD DATA.
      Now we do it similarly to other queries.
      We store LOAD DATA query in new Execute_load_query event
      (which is last in the sequence of events representing LOAD DATA).
      When we are executing this event we simply rewrite part of query which
      holds name of file (we use name of temporary file) and then execute it
      as usual query. In the beggining of this sequence we use Begin_load_query
      event which is almost identical to Append_file event
      f1691140
  2. 12 Mar, 2005 1 commit
    • serg@serg.mylan's avatar
      if no xa recovery (or after it): · 32700d14
      serg@serg.mylan authored
        warning on startup if prepared foreign xids
        error on startup if prepared our xids
        temporarily: always rollback prepared our xids instead of an error
      32700d14
  3. 09 Mar, 2005 2 commits
  4. 05 Mar, 2005 1 commit
  5. 04 Mar, 2005 2 commits
    • acurtis@pcgem.rdg.cyberkinetica.com's avatar
      Bug#3788 · 5e1d2ad6
      acurtis@pcgem.rdg.cyberkinetica.com authored
        Crashes with stored procedure return non-string values
        Also fixes Bug#2773
      5e1d2ad6
    • 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
  6. 03 Mar, 2005 2 commits
  7. 02 Mar, 2005 1 commit
  8. 24 Feb, 2005 2 commits
  9. 22 Feb, 2005 1 commit
  10. 21 Feb, 2005 1 commit
  11. 19 Feb, 2005 1 commit
    • monty@mysql.com's avatar
      Fixed BUILD script to use --with-berkeley-db instead of --with-bdb · 218e00ac
      monty@mysql.com authored
      Lots of small fixes to multi-precision-math path
      Give Note for '123.4e'
      Added helper functions type 'val_string_from_real()
      Don't give warnings for end space for string2decimal()
      Changed storage of values for SP so that we can detect length of argument without strlen()
      Changed interface for str2dec() so that we must supple the pointer to the last character in the buffer
      218e00ac
  12. 17 Feb, 2005 2 commits
  13. 08 Feb, 2005 2 commits
  14. 05 Feb, 2005 1 commit
  15. 03 Feb, 2005 1 commit
    • guilhem@mysql.com's avatar
      WL#1062 "log charset info into all Query_log_event": · ed1696f6
      guilhem@mysql.com authored
      we store 7 bytes (1 + 2*3) in every Query_log_event.
      In the future if users want binlog optimized for small size and less safe,
      we could add --binlog-no-charset (and binlog-no-sql-mode etc): charset info
      is something by design optional (even if for now we don't offer possibility to disable it):
      it's not a binlog format change.
      We try to reduce the number of get_charset() calls in the slave SQL thread to a minimum
      by caching the charset read from the previous event (which will often be equal to the one of the current event).
      We don't use SET ONE_SHOT for charset-aware repl (we still do for timezones, will be fixed later).
      No more errors if one changes the global value of charset vars on master or slave
      (as we log charset info in all Query_log_event).
      Not fixing Load_log_event as it will be rewritten soon by Dmitri.
      Testing how mysqlbinlog behaves in rpl_charset.test.
      mysqlbinlog needs to know where charset file is (to be able to convert a charset number found
      in binlog (e.g. in User_var_log_event) to a charset name); mysql-test-run needs to pass
      the correct value for this option to mysqlbinlog.
      Many result udpates (adding charset info into every event shifts log_pos in SHOW BINLOG EVENTS).
      Roughly the same job is to be done for timezones :)
      ed1696f6
  16. 02 Feb, 2005 1 commit
  17. 01 Feb, 2005 1 commit
  18. 30 Jan, 2005 1 commit
  19. 27 Jan, 2005 1 commit
  20. 26 Jan, 2005 1 commit
  21. 21 Jan, 2005 2 commits
    • ram@gw.mysql.r18.ru's avatar
    • patg@pc248.lfp.kcls.org's avatar
      -Added quote_data and needs_quotes (moved from federated handler. · 1da60b9f
      patg@pc248.lfp.kcls.org authored
      -New tests and results
      
      logging_ok:
        Logging to logging@openlogging.org accepted
      ha_federated.h:
        removed quote_data and type_quote (now in the Field class)
      ha_federated.cc:
        moved quote_data and type_quote to field class
      field.h:
        new methods quote_data and needs_quotes declared
      field.cc:
        new field class methods quote_data and needs_quotes (per Monty's request)
      federated.test:
        more tests, joins, index tests
      have_federated_db.require:
        new name of federated system var
      federated.result:
        new test results for federated handler
      have_federated_db.inc:
        changed name of variable in test due to change in vars
      sql_analyse.cc:
        over-ridden append_escaped to take (String *, char *, uint) per requirements of 'create_where_from_key' method in federated handler.
      mysql_priv.h:
        define over-ridden append_escaped to take arguments from 'create_where_from_key' method in federated handler 
      ha_federated.cc:
        implemented "create_where_from_key" to deal properly with two-byte prefix and multi keys. Initial testing shows it works, but I still need to move quoting to field class and also look at changes per Segei's suggestions.
      1da60b9f
  22. 19 Jan, 2005 2 commits
    • dlenev@brandersnatch.localdomain's avatar
      Fix for bug #7637: "Test failure: 'user_limits' on QNX and 64-bit systems" · 348218d2
      dlenev@brandersnatch.localdomain authored
      Made user_limits.test scheduling independant (this solves failure on QNX).
      
      Made sys_var_max_user_conn variable int sized. Changed 
      max_user_connections from ulong to uint to be able to use it in 
      sys_var_max_user_conn::value_ptr() (solves failures on 64-bit platforms).
      348218d2
    • timour@mysql.com's avatar
      Final patch for BUG#4285. · 7fb0de20
      timour@mysql.com authored
      This patch collects all previous patches into one.
      
      The main problem was due to that there is are two variables -
      dflt_key_cache and sql_key_cache with have more or less duplicate
      function. The reson for the bug was that the default value in the key
      cache hash was set to dflt_key_cache, then sql_key_cache was set to a
      new key cache object, and then dflt_key_cache was set to sql_key_cache
      which was different from the dflt_key_cache_var. After sending SIGHUP,
      the server was using the original default value for the key cache hash,
      which was different from the actual key cache object used for the
      default key cache.
      7fb0de20
  23. 18 Jan, 2005 1 commit
  24. 16 Jan, 2005 1 commit
  25. 13 Jan, 2005 1 commit
  26. 06 Jan, 2005 1 commit
    • monty@mysql.com's avatar
      First stage of table definition cache · d35140a8
      monty@mysql.com authored
      Split TABLE to TABLE and TABLE_SHARE (TABLE_SHARE is still allocated as part of table, will be fixed soon)
      Created Field::make_field() and made Field_num::make_field() to call this
      Added 'TABLE_SHARE->db' that points to database name; Changed all usage of table_cache_key as database name to use this instead
      Changed field->table_name to point to pointer to alias. This allows us to change alias for a table by just updating one pointer.
      Renamed TABLE_SHARE->real_name to table_name
      Renamed TABLE->table_name to alias
      Renamed TABLE_LIST->real_name to table_name
      d35140a8
  27. 03 Jan, 2005 1 commit
  28. 31 Dec, 2004 1 commit
  29. 30 Dec, 2004 2 commits
  30. 29 Dec, 2004 1 commit