An error occurred fetching the project authors.
  1. 14 Nov, 2003 1 commit
  2. 03 Nov, 2003 1 commit
    • unknown's avatar
      Simplified 'wrong xxx name' error messages by introducing 'general' ER_WRONG_NAME error · bee5d9d4
      unknown authored
      Cleaned up (and disabled part of) date/time/datetime format patch. One can't anymore change default read/write date/time/formats.
      This is becasue the non standard datetime formats can't be compared as strings and MySQL does still a lot of datetime comparisons as strings
      Changed flag argument to str_to_TIME() and get_date() from bool to uint
      Removed THD from str_to_xxxx functions and Item class.
      Fixed core dump when doing --print-defaults
      Move some common string functions to strfunc.cc
      Dates as strings are now of type my_charset_bin instead of default_charset()
      Introduce IDENT_QUOTED to not have to create an extra copy of simple identifiers (all chars < 128)
      Removed xxx_FORMAT_TYPE enums and replaced them with the old TIMESTAMP_xxx enums
      Renamed some TIMESTAMP_xxx enums to more appropriate names
      Use defines instead of integers for date/time/datetime string lengths
      Added to build system and use the new my_strtoll10() function.
      
      
      
      BUILD/compile-pentium-valgrind-max:
        Remove double printing of warning
      VC++Files/libmysqld/libmysqld.dsp:
        Added strfunc.cc
      VC++Files/sql/mysqld.dsp:
        Added strfunc.cc
      VC++Files/sql/mysqldmax.dsp:
        Added strfunc.cc
      VC++Files/strings/strings.dsp:
        added my_strtoll10.c
      include/m_ctype.h:
        Removed MY_LEX_FOUND_IDENT (not used)
      include/m_string.h:
        Added my_strtoll10()
      include/mysqld_error.h:
        simplified 'wrong xxx name' error messages
      include/sql_state.h:
        simplified 'wrong xxx name' error messages
      libmysqld/Makefile.am:
        Added strfunc.cc
      mysql-test/mysql-test-run.sh:
        Simplified some options
        changed $@ to "$@" in an attempt to handle options with space (Didn't succeed;  Problem will disappear when mysql-test-run is rewritten in C)
      mysql-test/r/ctype_latin1_de.result:
        Added new tests
      mysql-test/r/ctype_recoding.result:
        Extended tests
      mysql-test/r/date_formats.result:
        Cleaned up tests
        Disabled some tests that can't yet be run
      mysql-test/r/func_compress.result:
        New error message
      mysql-test/r/rpl_temporary.result:
        Added new test
      mysql-test/t/create.test:
        Changed error numbers
      mysql-test/t/ctype_latin1_de.test:
        New tests
      mysql-test/t/ctype_recoding.test:
        Extended tests
      mysql-test/t/date_formats-master.opt:
        Removed datetime_format as we can't handle options with space in mysql-test-run
      mysql-test/t/date_formats.test:
        Cleaned up tests
        Disabled some tests that can't yet be run
      mysql-test/t/rpl_temporary.test:
        Added testing of open temporary table on slave shutdown
      mysql-test/t/symlink.test:
        Fixed error numbers
      mysys/default.c:
        Fixed core dump when doing --print-defaults
      sql/Makefile.am:
        Added strfunc.cc
      sql/derror.cc:
        Fixed compiler warning
      sql/field.cc:
        Changed argument to str_to_TIME() from bool to uint
        Removed THD argument from str_to_TIME()
        Moved find_enum() and find_set() to strfunc.cc
      sql/field.h:
        Changed type of last argument to get_date() to be able to handle more options
      sql/init.cc:
        Remove not used variable dayord
      sql/item.cc:
        Changed type of last argument to get_date() to be able to handle more options
        Removed THD* element from item.
        Don't use make_date_time() to generate date/time/datetimes
      sql/item.h:
        Changed type of last argument to get_date() to be able to handle more options
        Removed THD* from Item
      sql/item_create.cc:
        Indentation cleanup
      sql/item_func.cc:
        Use new find_type()
      sql/item_func.h:
        Changed type of last argument to get_date() to be able to handle more options
      sql/item_strfunc.h:
        space change
      sql/item_timefunc.cc:
        Changed month_names[] to be easier to use
        Moved check_names[] to strfunc.cc
        Added back old make_datetime() function
        Optimized extract_date_time()
        Use my_strtoll10() insetad of my_strntoll()
        Optimized make_date_time()
        Replaced short variable names with long ones.
        Use new functions make_time(), make_date() and make_datetime()
        Dates as strings are now of type my_charset_bin instead of default_charset()
        Changed Item_func_str_to_date() to by default return a date.
      sql/item_timefunc.h:
        Changed charset for date string from default_charset() to my_charset_bin
        Changed type of last argument to get_date() to be able to handle more options
        Use defines instead of integers for date/time/datetime string lengths
      sql/mysql_priv.h:
        Fixed/added new prototypes
      sql/mysqld.cc:
        Removed opt_datetime_format_names
        Cleaned up handling of date_time format handling. (Fixed core dump when mysqld had error on startup)
        Removed some unnecessary double init of collation variables
      sql/protocol.cc:
        Changed back protocol functions to always return dates in ISO format
      sql/set_var.cc:
        Added variables time_format, date_format and datetime_format
        This had to be recoded becasue checking was done in 'update' method and not in 'check' method.
      sql/set_var.h:
        Removed class sys_var_datetime_format() as this defined a variable (which doesn't work) instead of updating a variable
      sql/share/czech/errmsg.txt:
        simplified 'wrong xxx name' error messages
      sql/share/danish/errmsg.txt:
        simplified 'wrong xxx name' error messages
      sql/share/dutch/errmsg.txt:
        simplified 'wrong xxx name' error messages
      sql/share/english/errmsg.txt:
        simplified 'wrong xxx name' error messages
      sql/share/estonian/errmsg.txt:
        simplified 'wrong xxx name' error messages
      sql/share/french/errmsg.txt:
        simplified 'wrong xxx name' error messages
      sql/share/german/errmsg.txt:
        simplified 'wrong xxx name' error messages
      sql/share/greek/errmsg.txt:
        simplified 'wrong xxx name' error messages
      sql/share/hungarian/errmsg.txt:
        simplified 'wrong xxx name' error messages
      sql/share/italian/errmsg.txt:
        simplified 'wrong xxx name' error messages
      sql/share/japanese/errmsg.txt:
        simplified 'wrong xxx name' error messages
      sql/share/korean/errmsg.txt:
        simplified 'wrong xxx name' error messages
      sql/share/norwegian-ny/errmsg.txt:
        simplified 'wrong xxx name' error messages
      sql/share/norwegian/errmsg.txt:
        simplified 'wrong xxx name' error messages
      sql/share/polish/errmsg.txt:
        simplified 'wrong xxx name' error messages
      sql/share/portuguese/errmsg.txt:
        simplified 'wrong xxx name' error messages
      sql/share/romanian/errmsg.txt:
        simplified 'wrong xxx name' error messages
      sql/share/russian/errmsg.txt:
        simplified 'wrong xxx name' error messages
      sql/share/serbian/errmsg.txt:
        simplified 'wrong xxx name' error messages
      sql/share/slovak/errmsg.txt:
        simplified 'wrong xxx name' error messages
      sql/share/spanish/errmsg.txt:
        simplified 'wrong xxx name' error messages
      sql/share/swedish/errmsg.txt:
        simplified 'wrong xxx name' error messages
      sql/share/ukrainian/errmsg.txt:
        simplified 'wrong xxx name' error messages
      sql/sql_base.cc:
        Use new find_type()
      sql/sql_class.cc:
        Allocate/free date_time format variables
      sql/sql_class.h:
        Define datetime_format variables
      sql/sql_db.cc:
        Use new ER_WRONG_NAME error
      sql/sql_lex.cc:
        Change lex to generate IDENT_QUOTED for quoted identifiers or identifers that are using characters > 128.
        This enabled us to not have to copy and convert the identifier to utf8 for simpe identifiers
      sql/sql_parse.cc:
        Use new ER_WRONG_NAME error
        Use new find_type() function
      sql/sql_prepare.cc:
        Use new defines
      sql/sql_table.cc:
        Use new ER_WRONG_NAME error
      sql/sql_yacc.yy:
        Don't copy and convert simple identifiers to utf8.
        Replace __FORMAT_TYPE defines with TIMESTAMP... defines
      sql/structs.h:
        Renamed DATETIME_FORMAT to DATE_TIME format to indicate that it's for date/time/datetime formats
        Renamed WRONT_TIMESTAMP_FULL to TIMESTAMP_DATETIME_ERROR and TIMESTAMP_FULL to TIMESTAMP_DATETIME
        Added KNOWN_DATE_TIME_FORMAT struct for Item_func_get_format
      sql/time.cc:
        Prepare str_to_TIME and str_to_time() for general date/time handling
        Removed THD from str_to... functions
        Renamed date/time/datetime functions to use 'date_time' instead of 'datetime'
        Added functions to make and copy DATE_TIME_FORMAT's
        Added trivial functions 'make_time()', 'make_date()' and 'make_datetime()'
      strings/Makefile.am:
        Added my_strtoll10()
      strings/ctype-bin.c:
        Cleared upper part of binary state map to be able to easily identify simple identifiers
      strings/my_vsnprintf.c:
        F
      bee5d9d4
  3. 31 Oct, 2003 1 commit
    • unknown's avatar
      old_total_warn_count is not used · 0992a2a7
      unknown authored
      and was removed from THD
      
      
      sql/sql_class.h:
        old_total_warn_count removed
      sql/sql_parse.cc:
        old_total_warn_count removed
      0992a2a7
  4. 30 Oct, 2003 1 commit
  5. 20 Oct, 2003 1 commit
  6. 15 Oct, 2003 1 commit
    • unknown's avatar
      Better fix for CREATE TABLE IF NOT EXISTS ... SELECT · b06eb4d8
      unknown authored
      Fixed chsize() problem on windows
      Extend default timeout on windows clients to 1 year (to avoid timeout problems)
      
      
      include/mysql.h:
        Added client timeouts (for TCP/IP)
      libmysql/libmysql.c:
        Added client timeouts (for TCP/IP)
      mysql-test/r/create.result:
        More tests for CREATE TABLE IF NOT EXISTS ... SELECT
      mysql-test/t/create.test:
        More tests for CREATE TABLE IF NOT EXISTS ... SELECT
      mysys/my_chsize.c:
        Fix for windows
      sql/handler.h:
        Remove not used field 'if_not_exists'
        Ordered fields to be more optimized for new CPU's
        Added field 'table_existed'
      sql/slave.cc:
        Cleanup temporary tables when slave ends
      sql/sql_class.h:
        Remove not used 'do_not_drop' field
      sql/sql_insert.cc:
        Better fix for CREATE TABLE IF NOT EXISTS ... SELECT
      sql/sql_table.cc:
        Better fix for CREATE TABLE IF NOT EXISTS ... SELECT
      b06eb4d8
  7. 13 Oct, 2003 1 commit
    • unknown's avatar
      Many files: · d212ba60
      unknown authored
        ALTER TABLE ... DISCARD/IMPORT TABLESPACE
        Track crash in buf_LRU_block_remove_hashed_page + 1807 reported in MySQL-3.23.5x
      
      
      sql/ha_innodb.cc:
        ALTER TABLE ... DISCARD/IMPORT TABLESPACE
      sql/sql_class.cc:
        ALTER TABLE ... DISCARD/IMPORT TABLESPACE
      sql/sql_parse.cc:
        ALTER TABLE ... DISCARD/IMPORT TABLESPACE
      sql/sql_table.cc:
        ALTER TABLE ... DISCARD/IMPORT TABLESPACE
      sql/ha_innodb.h:
        ALTER TABLE ... DISCARD/IMPORT TABLESPACE
      sql/handler.h:
        ALTER TABLE ... DISCARD/IMPORT TABLESPACE
      sql/lex.h:
        ALTER TABLE ... DISCARD/IMPORT TABLESPACE
      sql/mysql_priv.h:
        ALTER TABLE ... DISCARD/IMPORT TABLESPACE
      sql/sql_class.h:
        ALTER TABLE ... DISCARD/IMPORT TABLESPACE
      sql/sql_lex.h:
        ALTER TABLE ... DISCARD/IMPORT TABLESPACE
      sql/sql_yacc.yy:
        ALTER TABLE ... DISCARD/IMPORT TABLESPACE
      innobase/ha/ha0ha.c:
        Track crash in buf_LRU_block_remove_hashed_page + 1807 reported in MySQL-3.23.5x
      innobase/ha/hash0hash.c:
        Track crash in buf_LRU_block_remove_hashed_page + 1807 reported in MySQL-3.23.5x
      innobase/buf/buf0buf.c:
        Track crash in buf_LRU_block_remove_hashed_page + 1807 reported in MySQL-3.23.5x
      innobase/buf/buf0flu.c:
        Track crash in buf_LRU_block_remove_hashed_page + 1807 reported in MySQL-3.23.5x
      innobase/buf/buf0lru.c:
        Track crash in buf_LRU_block_remove_hashed_page + 1807 reported in MySQL-3.23.5x
      innobase/buf/buf0rea.c:
        Track crash in buf_LRU_block_remove_hashed_page + 1807 reported in MySQL-3.23.5x
      innobase/btr/btr0btr.c:
        Track crash in buf_LRU_block_remove_hashed_page + 1807 reported in MySQL-3.23.5x
      innobase/btr/btr0sea.c:
        Track crash in buf_LRU_block_remove_hashed_page + 1807 reported in MySQL-3.23.5x
      innobase/fil/fil0fil.c:
        ALTER TABLE ... DISCARD/IMPORT TABLESPACE
      innobase/include/buf0buf.h:
        ALTER TABLE ... DISCARD/IMPORT TABLESPACE
      innobase/include/ha0ha.h:
        ALTER TABLE ... DISCARD/IMPORT TABLESPACE
      innobase/include/hash0hash.h:
        ALTER TABLE ... DISCARD/IMPORT TABLESPACE
      innobase/include/row0mysql.h:
        ALTER TABLE ... DISCARD/IMPORT TABLESPACE
      innobase/include/buf0buf.ic:
        ALTER TABLE ... DISCARD/IMPORT TABLESPACE
      innobase/include/ha0ha.ic:
        ALTER TABLE ... DISCARD/IMPORT TABLESPACE
      innobase/include/ibuf0ibuf.ic:
        ALTER TABLE ... DISCARD/IMPORT TABLESPACE
      innobase/page/page0page.c:
        ALTER TABLE ... DISCARD/IMPORT TABLESPACE
      innobase/row/row0mysql.c:
        ALTER TABLE ... DISCARD/IMPORT TABLESPACE
      innobase/row/row0purge.c:
        ALTER TABLE ... DISCARD/IMPORT TABLESPACE
      innobase/row/row0uins.c:
        ALTER TABLE ... DISCARD/IMPORT TABLESPACE
      innobase/row/row0umod.c:
        ALTER TABLE ... DISCARD/IMPORT TABLESPACE
      d212ba60
  8. 11 Oct, 2003 2 commits
    • unknown's avatar
      Add warnings for single line inserts. To do this I had to convert... · 0cdddbf1
      unknown authored
      Add warnings for single line inserts. To do this I had to convert count_cuted_fields to an enum (to be able to detect setting a NOT NULL field to NULL)
      
      
      mysql-test/r/ctype_mb.result:
        update results after adding more warnings
      mysql-test/r/null.result:
        update results after adding more warnings
      mysql-test/r/select_found.result:
        update results after adding more warnings
      mysql-test/r/warnings.result:
        update results after adding more warnings
      mysql-test/t/ctype_mb.test:
        Add missing drop table
      mysql-test/t/myisam.test:
        Disable some warnings
      mysql-test/t/select_found.test:
        update results after adding more warnings
      sql/field_conv.cc:
        Add warnings for single line inserts
      sql/item_func.cc:
        Remove compile warnings
      sql/sql_class.cc:
        Add warnings for single line inserts
      sql/sql_class.h:
        Add warnings for single line inserts
      sql/sql_insert.cc:
        Add warnings for single line inserts
      sql/sql_load.cc:
        Add warnings for single line inserts
      sql/sql_select.cc:
        Add warnings for single line inserts
      sql/sql_table.cc:
        Add warnings for single line inserts
      sql/sql_update.cc:
        Add warnings for single line inserts
      0cdddbf1
    • unknown's avatar
      Add new user variables for tuning memory usage: · 74ea4594
      unknown authored
      query_alloc_block_size, query_prealloc_size, range_alloc_block_size,transaction_alloc_block_size and transaction_prealloc_size
      Add more checks for "out of memory" detection in range optimization
      
      
      configure.in:
        Added detection of mallinfo
      mysql-test/r/variables.result:
        Test of new variables
      mysql-test/t/variables.test:
        Test of new variables
      sql/ha_berkeley.cc:
        Use init_sql_alloc instead of init_alloc_root for better OOM detection
      sql/log_event.cc:
        Add new user variables for tuning memory usage
      sql/mysql_priv.h:
        Add new user variables for tuning memory usage
      sql/mysqld.cc:
        Add new user variables for tuning memory usage
      sql/opt_ft.cc:
        Add new user variables for tuning memory usage
      sql/opt_ft.h:
        Add new user variables for tuning memory usage
      sql/opt_range.cc:
        Add new user variables for tuning memory usage
        Add more checks for out of memory conditions
      sql/opt_range.h:
        Add new user variables for tuning memory usage
      sql/set_var.cc:
        Add new user variables for tuning memory usage
      sql/sql_acl.cc:
        Add new user variables for tuning memory usage
      sql/sql_class.h:
        Add new user variables for tuning memory usage
      sql/sql_delete.cc:
        Add new user variables for tuning memory usage
      sql/sql_parse.cc:
        Add new user variables for tuning memory usage
      sql/sql_select.cc:
        Add new user variables for tuning memory usage
      sql/sql_test.cc:
        Add information about memory useage if system supports mallinfo()
      sql/sql_udf.cc:
        Add new user variables for tuning memory usage
      sql/sql_update.cc:
        Add new user variables for tuning memory usage
      sql/table.cc:
        Add new user variables for tuning memory usage
      74ea4594
  9. 08 Oct, 2003 1 commit
    • unknown's avatar
      Fixed bug in error handling of CREATE ... SELECT · 32747b19
      unknown authored
      More tests cases
      After merge fixes
      
      
      BitKeeper/deleted/.del-ansi-master.opt~4d337eb61642a838:
        Delete: mysql-test/t/ansi-master.opt
      mysql-test/r/ansi.result:
        Cleaned up test to be able to remove ansi-master.opt
      mysql-test/r/create.result:
        Updated results
      mysql-test/r/insert_select.result:
        Updated results
      mysql-test/r/rpl000009.result:
        Updated results
      mysql-test/t/ansi.test:
        Cleaned up test to be able to remove ansi-master.opt
      mysql-test/t/create.test:
        More tests
      mysql-test/t/insert_select.test:
        More tests
      mysql-test/t/mysqlbinlog.test:
        Fixed test after merge
      sql/mysql_priv.h:
        Added character-sets-dir to 'show variables'
      sql/set_var.cc:
        Added character-sets-dir to 'show variables'
      sql/sql_class.cc:
        Fixed that send_error() is called properly when a SELECT fails
      sql/sql_class.h:
        Fixed that send_error() is called properly when a SELECT fails
      sql/sql_insert.cc:
        Fixed bug in error handling of CREATE ... SELECT
      sql/sql_select.cc:
        Fixed bug in error handling of CREATE ... SELECT
      32747b19
  10. 06 Oct, 2003 2 commits
    • unknown's avatar
      bug #1434 (and related issues) · e86fc82c
      unknown authored
      e86fc82c
    • unknown's avatar
      Fix for #1487 · f9ce2f4b
      unknown authored
      libmysqld/lib_sql.cc:
        arg_parameters now are stored in these THD members
      sql/sql_class.h:
        members to store query arguments
      sql/sql_prepare.cc:
        query arguments retrieval added for embedded case
        code not necessary in embedded server #ifdefed
      f9ce2f4b
  11. 02 Oct, 2003 1 commit
    • unknown's avatar
      Optimized code for setting user variables with := and fixed some bugs in old code (Bug #1194) · 2985e91a
      unknown authored
      Use forced close of socket to make mysqld shutdown faster when used under valgrind
      
      
      mysql-test/mysql-test-run.sh:
        Added --skip-bdb for valgrind
      mysql-test/r/user_var.result:
        Extended test for user variables
      mysql-test/t/user_var.test:
        Extended test for user variables
      sql/item_func.cc:
        Optimized code for setting user variables with := and fixed some bugs in old code
      sql/item_func.h:
        Optimized code for setting user variables
      sql/log.cc:
        Fixed comments
      sql/mysqld.cc:
        Use forced close of socket to make mysqld shutdown faster when used under valgrind
      sql/sql_class.h:
        Optimized code for setting user variables
      2985e91a
  12. 17 Sep, 2003 1 commit
    • unknown's avatar
      SCRUM: · 194f6725
      unknown authored
      prepared statements in embedded library
      
      
      include/mysql.h:
        Another 'virtual' method
      libmysql/client_settings.h:
        client implementation declared
      libmysql/libmysql.c:
        mysql_execute edited to work with embedded implementation
      libmysqld/lib_sql.cc:
        one error fixed (we do need parameter's buffer in embedded library)
        embedded recordset transfer methods implementations added
      sql-common/client.c:
        method added to the table
      sql/client_settings.h:
        no prepared statements in mimiclient
      sql/mysql_priv.h:
        these functions became global
      sql/protocol.cc:
        the stub added
      sql/protocol.h:
        had to change Protocol's interface for embedded library
      sql/sql_class.h:
        i changed this only for embedded case, but i think it's better to do the
        same for remote server also
      sql/sql_prepare.cc:
        parts of code #ifndef-ed
      194f6725
  13. 16 Sep, 2003 1 commit
    • unknown's avatar
      SCRUM · d0580715
      unknown authored
      Prepared statements in embedded server
      Several changes in library code with two goals:
      to make mysql_prepare_stmt working in embedded server
      to get rid of #define mysql_interface_func mysql->methods->interface_func
      in user's interface
      
      
      include/mysql.h:
        modifications of interface
        two goals: to implement prepared statements and to get rid
        of #define mysql_proc (mysql->smth) in interface
      include/sql_common.h:
        read_rows function got 'virtual'
      libmysql/client_settings.h:
        interface of some functions declared in client.c moved here
      libmysql/libmysql.c:
        several functions changed with declared goals
      libmysqld/embedded_priv.h:
        libmysqld.c <--> lib_sql.cc interface moved here
      libmysqld/lib_sql.cc:
        all embedded 'virtual' functions moved here so they can be static
      libmysqld/libmysqld.c:
        embedded 'virtual' function was moved out of here
      sql-common/client.c:
        several changes with the declared goal
      sql/sql_class.h:
        place to store statement data added to THD
      sql/sql_prepare.cc:
        storing of prepare_statement result for embedded server added
      d0580715
  14. 15 Sep, 2003 1 commit
  15. 29 Aug, 2003 2 commits
    • unknown's avatar
      comment left after merge was moved to correct · 06b4c4bc
      unknown authored
      place
      
      
      sql/sql_class.h:
        comment moved to correct place
      06b4c4bc
    • unknown's avatar
      Revert change of lower-case-table handling as this breaks how alias works. · 6d17d7f5
      unknown authored
      Changes like this should be done to 4.1, not to a stable release
      
      
      mysql-test/r/lowercase_table.result:
        Revert change of lower-case-table handling
      mysql-test/t/lowercase_table.test:
        Revert change of lower-case-table handling
      sql/sql_class.cc:
        Revert change of lower-case-table handling
      sql/sql_class.h:
        Revert change of lower-case-table handling
      sql/sql_parse.cc:
        Revert change of lower-case-table handling
      sql/sql_table.cc:
        Revert change of lower-case-table handling
      sql/sql_yacc.yy:
        Revert change of lower-case-table handling
      6d17d7f5
  16. 28 Aug, 2003 1 commit
    • unknown's avatar
      Portability fixes · 6fd5403d
      unknown authored
      client/mysqltest.c:
        Removed not used functions
      myisam/mi_dynrec.c:
        Added assert to avoid compilation errors
      mysql-test/r/isam.result:
        Updated results after merge
      sql/log_event.cc:
        Cleanup
      sql/mysql_priv.h:
        Cleanup
      sql/sql_class.cc:
        Moved Table_ident functions to .cc file to allow them to use table_case_convert()
      sql/sql_class.h:
        Moved Table_ident functions to .cc file to allow them to use table_case_convert()
      6fd5403d
  17. 25 Aug, 2003 1 commit
    • unknown's avatar
      Clearer states in SHOW PROCESSLIST for replication threads. · c47ee569
      unknown authored
      For example the Binlog_dump thread (on the master) sometimes showed "Slave:".
      And there were confusing messages where "binlog" was employed instead
      of "relay log".
      
      
      sql/log.cc:
        MYSQL_LOG::wait_for_update() is used by the binlog_dump and I/Oslave threads,
        and it updates thd->proc_info, so we need a bool to not show the same
        proc_info for 2 different things (previously we showed "Slave: etc" and that's
        bad for a binlog_dump thread).
      sql/slave.cc:
        Clearer thd-proc_info for slave threads.
      sql/sql_class.h:
        prototype change
      sql/sql_repl.cc:
        clearer thd->proc_info for binlog_dump thread
      c47ee569
  18. 22 Aug, 2003 1 commit
    • unknown's avatar
      2 minor edits, plus · fdfb10f2
      unknown authored
      fix for BUG#1113 "INSERT into non-trans table SELECT ; ROLLBACK" does not send warning"
      and
      fix for BUG#873 "In transaction, INSERT to non-trans table is written too early to binlog".
      Now we don't always write the non-trans update immediately to the binlog;
      if there is something in the binlog cache we write it to the binlog cache
      (because the non-trans update could depend on a trans table which was modified
      earlier in the transaction); then in case of ROLLBACK, we write the binlog
      cache to the binlog, wrapped with BEGIN/ROLLBACK.
      This guarantees that the slave does the same updates.
      For ROLLBACK TO SAVEPOINT: when we execute a SAVEPOINT command we write it
      to the binlog cache. At ROLLBACK TO SAVEPOINT, if some non-trans table was updated,
      we write ROLLBACK TO SAVEPOINT to the binlog cache; when the transaction
      terminates (COMMIT/ROLLBACK), the binlog cache will be flushed to the binlog
      (because of the non-trans update) so we'll have SAVEPOINT and ROLLBACK TO
      SAVEPOINT in the binlog.
      
      Apart from this rare case of updates of mixed table types in transaction, the
      usual way is still clear the binlog cache at ROLLBACK, or chop it at
      ROLLBACK TO SAVEPOINT (meaning the SAVEPOINT command is also chopped, which
      is fine).
      Note that BUG#873 encompasses subbugs 1) and 2) of BUG#333 "3 binlogging bugs when doing INSERT with mixed InnoDB/MyISAM".
      
      
      client/mysqldump.c:
        Minor edit: one CHANGE MASTER with 2 arguments instead of 2 CHANGE MASTER with one argument each.
      mysql-test/r/rpl_loaddata.result:
        result update
      mysql-test/t/rpl_loaddata.test:
        minor edit: simplifying the test.
      sql/handler.cc:
        Fix for BUG#873. See comments in code, and the description of the changeset.
      sql/log.cc:
        * Previously, if a query updated a non-transactional table we wrote it immediately
        to the real binlog. This causes a bug when the update is done inside a transaction
        and uses the content of an updated transactional table (because this makes
        a wrong order of queries in the binlog). So if the binlog cache is not empty,
        we write the query to the binlog cache; otherwise we can write it to the binlog.
        * Previously, when we flushed the binlog cache to the binlog, we wrapped it
        with BEGIN/COMMIT. Now it's also possible to wrap it with BEGIN/ROLLBACK, to handle
        transactions which update both transactional and non-transactional tables.
      sql/log_event.cc:
        The slave thread can leave a transaction if COMMIT or if ROLLBACK.
      sql/sql_class.h:
        prototype
      sql/sql_insert.cc:
        Fix for BUG#1113:
        this was because the INSERT SELECT code did not set OPTION_STATUS_NO_TRANS_UPDATE.
      sql/sql_parse.cc:
        Don't send ER_WARNING_NOT_COMPLETE_ROLLBACK if this is the SQL slave thread (see comments).
      fdfb10f2
  19. 20 Aug, 2003 1 commit
    • unknown's avatar
      quick fix for found row counter · 94d018c2
      unknown authored
      code cleunup
      
      
      sql/sql_class.h:
        removed unused variables
      sql/sql_union.cc:
        quick fix for found row counter
        layout fixed
      sql/sql_update.cc:
        lelect_limit in THD is not used
      94d018c2
  20. 19 Aug, 2003 1 commit
    • unknown's avatar
      Fix for BUG#1086. Now we don't preserve event's log_pos through · e3541b8a
      unknown authored
      log-slave-updates since this causes unexpected values in 
      Exec_master_log_pos in A->B->C replication setup, synchronization
       problems in master_pos_wait()... 
      Still this brokes some functionality in sql/repl_failsafe.cc 
      (but this file is not used now)
      
      
      mysql-test/r/rpl_log.result:
        SHOW BINLOG EVENTS for binlog on slave should give the same 
        Orig_log_pos and Pos values
      sql/log_event.cc:
        Do not propagate our master's log pos to our bin log
      sql/repl_failsafe.cc:
        Added comment about broken SHOW NEW MASTER
      sql/slave.cc:
        Do not propagate our master's log pos to our bin log
      sql/sql_class.cc:
        THD::log_pos is no longer needed
      sql/sql_class.h:
        THD::log_pos is no longer needed
      sql/sql_parse.cc:
        Added comment about broken SHOW NEW MASTER
      e3541b8a
  21. 18 Aug, 2003 1 commit
    • unknown's avatar
      After merge fixes · 2901c3b8
      unknown authored
      Use server character set if --default-character-set is not used
      Added convert_string() for more efficient alloc+character-set convert of strings
      
      
      BitKeeper/deleted/.del-convert.result~a3b56e1db6f498e9:
        Delete: mysql-test/r/convert.result
      BitKeeper/deleted/.del-convert.test~f4ceb743194dfe72:
        Delete: mysql-test/t/convert.test
      BitKeeper/deleted/.del-make_win_src_distribution.old~5c9ebdc4a852b43b:
        Delete: scripts/make_win_src_distribution.old
      client/mysql.cc:
        Use server character set if --default-character-set is not used
      client/mysqltest.c:
        Code cleanup (merge identical code)
        More debug messages
      heap/hp_create.c:
        After merge fix
      include/m_ctype.h:
        After merge fix
      include/my_global.h:
        Remove size_str (we already have size_s)
      include/mysql_com.h:
        After merge fix
      libmysql/libmysql.c:
        After merge fix
      libmysqld/Makefile.am:
        After merge fix
      mysql-test/r/auto_increment.result:
        After merge fix
      mysql-test/r/create.result:
        After merge fix
      mysql-test/r/ctype_latin1_de.result:
        After merge fix
      mysql-test/r/distinct.result:
        After merge fix
      mysql-test/r/drop.result:
        After merge fix
      mysql-test/r/fulltext.result:
        After merge fix
      mysql-test/r/func_gconcat.result:
        After merge fix
      mysql-test/r/func_str.result:
        After merge fix
      mysql-test/r/func_test.result:
        After merge fix
      mysql-test/r/grant.result:
        After merge fix
      mysql-test/r/group_by.result:
        After merge fix
      mysql-test/r/handler.result:
        After merge fix
      mysql-test/r/heap.result:
        After merge fix
      mysql-test/r/heap_btree.result:
        After merge fix
      mysql-test/r/heap_hash.result:
        After merge fix
      mysql-test/r/innodb.result:
        After merge fix
      mysql-test/r/insert.result:
        After merge fix
      mysql-test/r/insert_select.result:
        After merge fix
      mysql-test/r/join_outer.result:
        After merge fix
      mysql-test/r/key.result:
        After merge fix
      mysql-test/r/key_cache.result:
        After merge fix
      mysql-test/r/loaddata.result:
        After merge fix
      mysql-test/r/myisam.result:
        After merge fix
      mysql-test/r/null.result:
        After merge fix
      mysql-test/r/null_key.result:
        After merge fix
      mysql-test/r/order_by.result:
        After merge fix
      mysql-test/r/rpl_do_grant.result:
        After merge fix
      mysql-test/r/rpl_error_ignored_table.result:
        After merge fix
      mysql-test/r/rpl_ignore_grant.result:
        After merge fix
      mysql-test/r/rpl_loaddata.result:
        After merge fix
      mysql-test/r/rpl_log.result:
        After merge fix
      mysql-test/r/rpl_log_pos.result:
        After merge fix
      mysql-test/r/rpl_max_relay_size.result:
        After merge fix
      mysql-test/r/rpl_replicate_do.result:
        After merge fix
      mysql-test/r/rpl_reset_slave.result:
        After merge fix
      mysql-test/r/rpl_rotate_logs.result:
        After merge fix
      mysql-test/r/rpl_user_variables.result:
        After merge fix
      mysql-test/r/select.result:
        After merge fix
      mysql-test/r/select_safe.result:
        After merge fix
      mysql-test/r/subselect.result:
        After merge fix
      mysql-test/r/type_blob.result:
        After merge fix
      mysql-test/r/type_decimal.result:
        After merge fix
      mysql-test/r/type_float.result:
        After merge fix
      mysql-test/r/type_ranges.result:
        After merge fix
      mysql-test/r/type_time.result:
        After merge fix
      mysql-test/r/type_uint.result:
        After merge fix
      mysql-test/r/union.result:
        After merge fix
      mysql-test/r/warnings.result:
        After merge fix
      mysql-test/t/auto_increment.test:
        After merge fix
      mysql-test/t/case.test:
        After merge fix
      mysql-test/t/ctype_collate.test:
        After merge fix
      mysql-test/t/ctype_latin1_de.test:
        After merge fix
      mysql-test/t/drop.test:
        After merge fix
      mysql-test/t/func_in.test:
        After merge fix
      mysql-test/t/func_set.test:
        After merge fix
      mysql-test/t/func_str.test:
        After merge fix
      mysql-test/t/func_test.test:
        After merge fix
      mysql-test/t/grant.test:
        After merge fix
      mysql-test/t/group_by.test:
        After merge fix
      mysql-test/t/handler.test:
        After merge fix
      mysql-test/t/heap.test:
        After merge fix
      mysql-test/t/heap_btree.test:
        After merge fix
      mysql-test/t/heap_hash.test:
        After merge fix
      mysql-test/t/innodb.test:
        After merge fix
      mysql-test/t/insert_select.test:
        After merge fix
      mysql-test/t/key.test:
        After merge fix
      mysql-test/t/key_cache.test:
        After merge fix
      mysql-test/t/lock_tables_lost_commit-master.opt:
        After merge fix
      mysql-test/t/lock_tables_lost_commit.test:
        After merge fix
      mysql-test/t/myisam.test:
        After merge fix
      mysql-test/t/row.test:
        After merge fix
      mysql-test/t/subselect.test:
        After merge fix
      mysql-test/t/type_decimal.test:
        After merge fix
      mysql-test/t/type_ranges.test:
        After merge fix
      mysql-test/t/type_uint.test:
        After merge fix
      mysql-test/t/variables.test:
        After merge fix
      mysql-test/t/warnings.test:
        After merge fix
      scripts/make_win_src_distribution.sh:
        after merge fixes
      sql-common/client.c:
        After merge fix
        Change my_connect() to use poll()
        If character set is not given, use servers character set.
      sql/field.cc:
        After merge fix
        Don't give warnings when storing data in fields in optimizer.
      sql/ha_myisammrg.h:
        After merge fix
      sql/log.cc:
        After merge fix
      sql/log_event.cc:
        After merge fix
      sql/mysqld.cc:
        After merge fix
      sql/opt_range.cc:
        After merge fix
      sql/set_var.cc:
        Code cleanup
        Fixed wrong usage of base_names (like medium.key_buffer) that caused core dumps
      sql/set_var.h:
        Fixed wrong usage of base_names (like medium.key_buffer) that caused core dumps
      sql/slave.cc:
        After merge fix
      sql/sql_acl.cc:
        After merge fix
        Code cleanup
      sql/sql_class.cc:
        Added convert_string() for more efficient alloc+character-set convert of strings
        Add cached flags to avoid calling mysql_charset_same() during parsing.
      sql/sql_class.h:
        Added convert_string() for more efficient alloc+character-set convert of strings
        Add cached flags to avoid calling mysql_charset_same() during parsing.
      sql/sql_handler.cc:
        After merge fix
      sql/sql_lex.h:
        After merge fix
      sql/sql_parse.cc:
        Optimize and fix memory reference errors reported by valgrind
      sql/sql_repl.cc:
        After merge fix
      sql/sql_yacc.yy:
        After merge fix
        Avoid calling mysql_charset_same() when parsing identifiers
      strings/ctype-latin1.c:
        Port latin_de conversion code from 4.0
      2901c3b8
  22. 12 Aug, 2003 1 commit
    • unknown's avatar
      optimisation of independent ALL/ANY with aggregate function (WL#1115) (SCRUM) · 964ffc34
      unknown authored
      mysql-test/r/subselect.result:
        test of new optimisation
      mysql-test/t/subselect.test:
        test of new optimisation
      sql/item_subselect.cc:
        special subselect to finding max/min of returned values
        optimisation of independent ALL/ANY with aggregate function
      sql/item_subselect.h:
        special subselect to finding max/min of returned values
      sql/sql_class.cc:
        class for collaction result for max/min subquery
      sql/sql_class.h:
        class for collaction result for max/min subquery
      964ffc34
  23. 08 Aug, 2003 1 commit
    • unknown's avatar
      rewritten test using loop (BUG#930) · 05f5df0c
      unknown authored
      removed unused field (now it is in variables)
      
      
      mysql-test/r/query_cache.result:
        rewritten test using loop
      mysql-test/t/query_cache.test:
        rewritten test using loop
      sql/sql_class.h:
        removed unused field (now it is in variables)
      05f5df0c
  24. 23 Jul, 2003 1 commit
  25. 18 Jul, 2003 2 commits
    • unknown's avatar
      few compile-time bugs fixed · 4df473b8
      unknown authored
      include/mysql.h:
        fixed compile-time bug
      sql/sql_class.cc:
        fixed compile-time bug
      sql/sql_class.h:
        fixed compile-time bug
      4df473b8
    • unknown's avatar
      Style fixes, comments for 4.1.1 authorization · 30ced7f7
      unknown authored
      Now special 1-byte packet is used for request of old password
      Fixed bug with --skip-grant-tables and acl_getroot
      
      
      include/mysql.h:
        removed scramble_323 member as now scramble_323 function does not count
        on trailing zero for scramble
      include/mysql_com.h:
        updated declarations
      libmysql/libmysql.c:
        now server sends special 1-byte packet instead of old scramble
        to re-request password.
        mysql->scramble_323 replaced with mysql->scramble
      sql-common/client.c:
        now server sends special 1-byte packet instead of old scramble
        to re-request password.
        mysql->scramble_323 replaces with mysql->scramble
      sql/password.c:
        comments beautified
        hash_password now accepts password length
      sql/protocol.cc:
        added send_old_password_request function
      sql/protocol.h:
        added send_old_password_request function
      sql/sql_acl.cc:
        style fixes, bug with --skip-grant-tables and acl_getroot
        fixed
      sql/sql_class.h:
        thd->scramble_323 removed as now
        old functions accept not null-terminated scrambles
      sql/sql_crypt.cc:
        fixed with new hash_password proto
      sql/sql_parse.cc:
        style fixes
        few comments added
      30ced7f7
  26. 14 Jul, 2003 2 commits
    • unknown's avatar
      Better fix for bug #791: At binlog rotation, INSERTs may not find their way into the binlog · 128feded
      unknown authored
      mysql-test/t/rpl_flush_log_loop.test:
        Add timer to avoid problem when 'flush logs' is executed before we have read all data from master
      sql/log.cc:
        Better fix for bug #791:
        Mark log as LOG_TO_BE_OPENED instead of LOG_CLOSED when it's closed and opened.
      sql/mysqld.cc:
        Better startup message
      sql/slave.cc:
        Fix argument to close()
      sql/sql_class.h:
        Better handling of log.close()
      128feded
    • unknown's avatar
      Safety and speedup fixes: · e1a30696
      unknown authored
      Changed is_open() to work as before.
      Added back inited argument to LOG
      
      
      mysql-test/r/rpl_flush_log_loop.result:
        Fixed results (probably bug in previous rpatch)
      sql/handler.cc:
        Changed is_open() to work as before
      sql/item_func.cc:
        Changed is_open() to work as before
      sql/log.cc:
        Part revert of previous patch.
        The reason for adding back 'inited' is that is that we can't be 100 % sure that init_pthread_objects() is called before mysqld dies (for example on windows)
        I removed mutex lock handling in is_open() as the new code didn't have ANY affect except beeing slower.
        Added back checking of is_open() to some functions as we don't want to do a mutex lock when we are not using logging.
        Indentation/comment fixes
      sql/log_event.cc:
        Changed is_open() to work as before
      sql/repl_failsafe.cc:
        Changed is_open() to work as before
      sql/sql_base.cc:
        Changed is_open() to work as before
      sql/sql_class.h:
        Changed is_open() to work as before. Added back 'inited' variable
      sql/sql_db.cc:
        Changed is_open() to work as before
      sql/sql_delete.cc:
        Changed is_open() to work as before
      sql/sql_insert.cc:
        Changed is_open() to work as before
      sql/sql_load.cc:
        Changed is_open() to work as before
      sql/sql_parse.cc:
        Changed is_open() to work as before
      sql/sql_rename.cc:
        Changed is_open() to work as before
      sql/sql_repl.cc:
        Changed is_open() to work as before
      sql/sql_table.cc:
        Changed is_open() to work as before
      sql/sql_update.cc:
        Changed is_open() to work as before
      e1a30696
  27. 12 Jul, 2003 2 commits
    • unknown's avatar
      Member no_rotate in MYSQL_LOG was always 0, I delete it. · 5526d454
      unknown authored
      sql/log.cc:
        Member no_rotate of MYSQL_LOG is useless; this shows it for sure:
        [guilhem@gbichot2 mysql-4.0]$ bk -r grep no_rotate
        sql/log.cc      1.83       no_rotate(0), need_start_event(1)
        sql/log.cc      1.75      if (no_rotate)
        sql/log.cc      1.89      if (!no_rotate)
        sql/sql_class.h 1.119     bool no_rotate;
        i.e. no_rotate is 0 all the time. So we don't need it.
        Biggest part of the patch is indentation change.
      sql/sql_class.h:
        suppress no_rotate
      5526d454
    • unknown's avatar
      removed 2 small useless if(). · 543208de
      unknown authored
      sql/log.cc:
        a comment for the future.
      sql/mysqld.cc:
        if (p) is not needed: fn_ext() always returns a valid pointed; the way
        to test if an extension was found is if (*p), not if (p).
        But here even if there's no extension, we still want to truncate opt_name
        to FN_REFLEN, so we always execute the code.
        By design, the test was always 'false' (because we strip the extension before
        testing if there's an extension) so log->set_no_rotate never executed.
      sql/sql_class.h:
        remove set_no_rotate as we don't need it.
      543208de
  28. 11 Jul, 2003 1 commit
    • unknown's avatar
      Fix for BUG#791: · d974959b
      unknown authored
      a safer way of initing the mutexes in MYSQL_LOG.
      is_open() is now always thread-safe.
      See each file for details.
      
      
      sql/handler.cc:
        is_open() with locks
      sql/item_func.cc:
        is_open() with locks
      sql/log.cc:
        No more 'inited'.
        We now always use is_open() in a thread-safe manner.
        This simplifies some functions (no more need to test is_open() twice).
      sql/log_event.cc:
        is_open() with locks
      sql/mysqld.cc:
        Init mutexes for the global MYSQL_LOG objects.
        We care about no_rotate, because we can't do it in open() anymore (because
        we don't have 'inited' anymore).
      sql/repl_failsafe.cc:
        is_open() with locks
      sql/slave.cc:
        init pthread objects (mutexes, conds) in the constructor of st_relay_log_info.
        Some better locking in rotate_relay_log().
      sql/sql_base.cc:
        is_open() with locks
      sql/sql_class.h:
        Before, we inited LOCK_log in MYSQL_LOG::open(), so in other places of the code
        when we were never 100% sure that it had been inited. For example, if the server
        was running without --log-bin, ::open() was not called so the mutex was not
        inited. We could detect it with !inited, but not safely as 'inited' was not
        protected by any mutex.
        So now:
        we *always* init the LOCK_log mutex, even if the log is not used. We can't init
        the mutex in MYSQL_LOG's constructor, because for global objects like
        mysql_bin_log, mysql_log etc, the constructor is called before MY_INIT(), but
        safe_mutex depends on MY_INIT(). So we have a new function MYSQL_LOG::init_pthread_objects
        which we call in main(), after MY_INIT().
        For the relay log, we call this function in the constructor of
        st_relay_log_info, which is called before any function tries to
        use the relay log (the relay log is always invoked as rli.relay_log).
        So now we should be safe in all cases and we don't need 'inited'.
      sql/sql_db.cc:
        is_open() with locks
      sql/sql_delete.cc:
        is_open() with locks
      sql/sql_insert.cc:
        is_open() with locks
      sql/sql_load.cc:
        is_open() with locks
      sql/sql_parse.cc:
        is_open() with locks
      sql/sql_rename.cc:
        is_open() with locks
      sql/sql_repl.cc:
        is_open() with locks
      sql/sql_table.cc:
        is_open() with locks
      sql/sql_update.cc:
        is_open() with locks
      d974959b
  29. 07 Jul, 2003 1 commit
    • unknown's avatar
      Preliminary support for options --secure-auth, · 78c3d968
      unknown authored
      --old-passwords
      Support for option --old-protocol was removed.
      Some test performed.
      Tests for SSL and replication are pending.
      More strict following to specification for --old-passwords
      is in the TODO.
      
      
      include/mysql_com.h:
        support for 3.20 passwords removed from
        scramble_323
      include/mysqld_error.h:
        added error code for --secure-auth mode
      libmysql/libmysql.c:
        removed support for 3.20 password and protocol
        version 9
      mysql-test/r/connect.result:
        added check for new syntax of 
        set password
      mysql-test/r/func_crypt.result:
        tests for two-argument of password() were removed.
        Instead added tests for cooperation of password() and
        old_passwords session/global variable, passwords() and spaces 
        in argument string
      mysql-test/t/connect.test:
        added check for new syntax of
        set password
      mysql-test/t/func_crypt.test:
        tests for two-argument of password() were removed.
        Instead added tests for cooperation of password() and
        old_passwords session/global variable, passwords() and spaces 
        in argument string
      sql-common/client.c:
        removed support for 3.20 servers and 
        protocol version 9
      sql/item_strfunc.h:
        fixed comment
      sql/mysql_priv.h:
        added declarartion for option opt_secure_auth
      sql/mysqld.cc:
        added option opt_secure_auth
        option old-password placed according to
        sort order
      sql/password.c:
        removed support for 3.20 clients and 
        old scrambles
      sql/set_var.cc:
        added system variable 'secure_auth'
        added system/thread variable 'old_passwords'
      sql/set_var.h:
        sys_old_passwords needs to be exported 
        because sys_old_passwords.after_update is used
        in sql_acl.cc
      sql/sql_acl.cc:
        support for 3.20 passwords removed
        now acl_init honors options works properly with
        options/variables --secure-auth and --old-passwords
      sql/sql_acl.h:
        support for 3.20 clients removed
      sql/sql_class.h:
        added system/thread variable old_passwords
      sql/sql_parse.cc:
        support for 3.20 clients removed
        now check_user takes into account option
        secure_auth
      sql/sql_yacc.yy:
        global variable use_old_passwords 
        replaced with thread-specific variable 
        old_passwords
      sql/share/czech/errmsg.txt:
        error message for --secure-auth added
        (as suggested by Paul)
      sql/share/danish/errmsg.txt:
        error message for --secure-auth added
        (as suggested by Paul)
      sql/share/dutch/errmsg.txt:
        error message for --secure-auth added
        (as suggested by Paul)
      sql/share/english/errmsg.txt:
        error message for --secure-auth added
        (as suggested by Paul)
      sql/share/estonian/errmsg.txt:
        error message for --secure-auth added
        (as suggested by Paul)
      sql/share/french/errmsg.txt:
        error message for --secure-auth added
        (as suggested by Paul)
      sql/share/german/errmsg.txt:
        error message for --secure-auth added
        (as suggested by Paul)
      sql/share/greek/errmsg.txt:
        error message for --secure-auth added
        (as suggested by Paul)
      sql/share/hungarian/errmsg.txt:
        error message for --secure-auth added
        (as suggested by Paul)
      sql/share/italian/errmsg.txt:
        error message for --secure-auth added
        (as suggested by Paul)
      sql/share/japanese/errmsg.txt:
        error message for --secure-auth added
        (as suggested by Paul)
      sql/share/korean/errmsg.txt:
        error message for --secure-auth added
        (as suggested by Paul)
      sql/share/norwegian-ny/errmsg.txt:
        error message for --secure-auth added
        (as suggested by Paul)
      sql/share/norwegian/errmsg.txt:
        error message for --secure-auth added
        (as suggested by Paul)
      sql/share/polish/errmsg.txt:
        error message for --secure-auth added
        (as suggested by Paul)
      sql/share/portuguese/errmsg.txt:
        error message for --secure-auth added
        (as suggested by Paul)
      sql/share/romanian/errmsg.txt:
        error message for --secure-auth added
        (as suggested by Paul)
      sql/share/russian/errmsg.txt:
        error message for --secure-auth added
        (as suggested by Paul)
      sql/share/serbian/errmsg.txt:
        error message for --secure-auth added
        (as suggested by Paul)
      sql/share/slovak/errmsg.txt:
        error message for --secure-auth added
        (as suggested by Paul)
      sql/share/spanish/errmsg.txt:
        error message for --secure-auth added
        (as suggested by Paul)
      sql/share/swedish/errmsg.txt:
        error message for --secure-auth added
        (as suggested by Paul)
      sql/share/ukrainian/errmsg.txt:
        error message for --secure-auth added
        (as suggested by Paul)
      78c3d968
  30. 06 Jul, 2003 1 commit
    • unknown's avatar
      WL#912 (more user control on relay logs): · 27601fc5
      unknown authored
      FLUSH LOGS now rotates relay logs,
      and a new variable max_relay_log_size.
      Plus a very small bit of code cleaning.
      
      
      libmysqld/lib_sql.cc:
        open_log has no default arguments anymore.
      mysql-test/r/rpl_flush_log_loop.result:
        result update now that FLUSH LOGS rotates relay logs.
      mysql-test/r/rpl_log.result:
        result update now that FLUSH LOGS rotates relay logs.
      mysql-test/r/rpl_rotate_logs.result:
        result update now that max_binlog_size is 4096.
      mysql-test/t/rpl_rotate_logs-master.opt:
        now max_binlog_size must be a multiple of 4096 (see change in mysqld.cc)
      sql/log.cc:
        Got rid of default arguments of various MYSQL_LOG methods (the default arguments
        made code reading uneasy).
        Set max_size in ::init().
        New function set_max_size() to set max_size of a MYSQL_LOG on-the-fly.
        More DBUG info.
      sql/mysql_priv.h:
        no defaults in open_log().
        New variables max_relay_log_size.
      sql/mysqld.cc:
        New variable and option max_relay_log_size.
        max_binlog_size and max_relay_log_size are multiples of IO_SIZE.
        No more default arguments for log functions.
      sql/set_var.cc:
        New variable max_relay_log_size.
        If it is 0, then max_binlog_size will apply to relay logs.
        When one of these variables is changed, fix_max_%log_size is called
        to update max_size of the binary and/or relay logs.
      sql/slave.cc:
        New function rotate_relay_log().
      sql/slave.h:
        New function rotate_relay_log().
      sql/sql_class.h:
        New member max_size of MYSQL_LOG (for automatic rotation).
        New method set_max_size() for setting on-the-fly.
      sql/sql_parse.cc:
        Flush the relay log in FLUSH LOGS.
      27601fc5
  31. 01 Jul, 2003 1 commit
    • unknown's avatar
      First version of new authentification procedure: now authentification is... · dbb088b0
      unknown authored
      First version of new authentification procedure: now authentification is one-stage (instead of two-stage in 4.1)
      
      For now following tasks have been done:
      - PASSWORD() function was rewritten. PASSWORD() now returns SHA1
        hash_stage2; for new passwords user.password contains '*'hash_stage2; sql_yacc.yy also fixed; 
      
      - password.c: new functions were implemented, old rolled back to 4.0 state
      
      - server code was rewritten to use new authorization algorithm (check_user(), change
        user, and other stuff in sql/sql_parse.cc)
      
      - client code was rewritten to use new authorization algorithm
        (mysql_real_connect, myslq_authenticate in sql-common/client.c)
      
      - now server barks on 45-byte-length 4.1.0 passwords and refuses 4.1.0-style
        authentification. Users with 4.1.0 passwords are blocked (sql/sql_acl.cc)
      
      - mysqladmin.c was fixed to work correctly with new passwords
      
      Tests for 4.0-4.1.1, 4.1.1-4.1.1 (with or without db/password) logons was performed;
      mysqladmin also was tested. Additional check are nevertheless necessary.
      
      
      BitKeeper/etc/ignore:
        Added start_mysqld.sh mysys/main.cc to the ignore list
      client/mysqladmin.c:
        fixed with new password api
      include/mysql.h:
        So as scramble_323 accepts only null-terminated message, two scramble buffs are necessary.
        gotta be fixed
      include/mysql_com.h:
        new constants and password.c api changes
      libmysql/libmysql.c:
        mysql_change_user rewritten to work with new password api
      scripts/mysql_create_system_tables.sh:
        fixed 'Password' column length to 41
      scripts/mysql_fix_privilege_tables.sql:
        fixed 'Password' column length to 41
      sql-common/client.c:
        mysql_real_connect rewritten to support new handshake procedure
      sql/item_strfunc.cc:
        Item_func_password and Item_func_old_password rewritten with new password api
      sql/item_strfunc.h:
        bit commented, numbers replaced with #defined constants
      sql/mysql_priv.h:
        removed unnecessary declaration as now all constants defined is in mysql_com.h
      sql/mysqld.cc:
        scramble initialization moved to sql_parce.cc:check_connection
      sql/password.c:
        All 4.1 functions were rolled back to 4.0 with attempt to save all possible 4.0-4.1 changes.
        Names for 4.0 functions were suffixed with '_323'
        Functions for new handshake were added.
      sql/slave.cc:
        Fixed to new constant; Bug #766 remains to be fixed
      sql/slave.h:
        fixed to new constant; Buf #766 remains to be fixed
      sql/sql_acl.cc:
        rewritten to support new passwords (41 byte-long) and password api
      sql/sql_acl.h:
        ditto
      sql/sql_class.cc:
        initialization for new members added
      sql/sql_class.h:
        same thing as in struct mysql - scramble is used for new family of functions, scramble_323 - for old
      sql/sql_parse.cc:
        check_connections was renamed to check_connection as this name reflects better what this function does
        authorization part of check_connection was rewritten
        check_user was rewritten with new password and acl api
        new function 'authenticate', which optionally re-request scramble from client was added
        fixed some typos
        COM_CHANGE_USER piece of dipsatch_command() was rewritten
      sql/sql_repl.h:
        HASH_PASSWORD_LENGTH replaced with SCRAMBLED_PASSWORD_CHAR_LENGTH
        bug #766 remains
      sql/sql_yacc.yy:
        Two-argument form of PASSWORD() was removed
        PASSWORD() function was fixed with new password api.
      BitKeeper/etc/logging_ok:
        Logging to logging@openlogging.org accepted
      dbb088b0
  32. 30 Jun, 2003 1 commit
  33. 27 Jun, 2003 1 commit
    • unknown's avatar
      Added thread variable max_seeks_for_key · c2cb9b97
      unknown authored
      Change optimizer to prefer key lookups before table scan
      Change table scans to be done after tables with constrains on scanned table 
      
      
      mysql-test/r/distinct.result:
        Update results
      mysql-test/r/group_by.result:
        Update results
      mysql-test/r/heap.result:
        Update results
      mysql-test/r/join.result:
        Update results
      mysql-test/r/key_diff.result:
        Update results
      mysql-test/r/myisam.result:
        Update results
      mysql-test/r/order_by.result:
        Update results
      mysql-test/r/select_safe.result:
        Update results
      mysql-test/t/distinct.test:
        Change test to be repeatable
      mysql-test/t/join.test:
        Change test to be repeatable
      mysql-test/t/select_safe.test:
        Add tests for MAX_SEEKS_FOR_KEY
      sql/handler.h:
        Optimize structure for 64 bit machines (and to avoid problems with gdb)
      sql/item_cmpfunc.cc:
        Initialize not_null_tables_cache properly
      sql/mysqld.cc:
        Added max_seeks_for_key
      sql/set_var.cc:
        Added max_seeks_for_key
      sql/sql_class.h:
        Added max_seeks_for_key
      sql/sql_select.cc:
        Added max_seeks_for_key
        Change optimizer to prefer key lookups before table scan.
        Change table scans to be done after tables with constrains on scanned table
      c2cb9b97
  34. 26 Jun, 2003 1 commit
    • unknown's avatar
      cond_count moved to SELECT_LEX_NODE · 54cd790b
      unknown authored
      fixed BUG #726
      
      
      mysql-test/r/subselect.result:
        test of bug #726
      mysql-test/t/subselect.test:
        test of bug #726
      sql/item_cmpfunc.cc:
        cond_count moved to SELECT_LEX_NODE
      sql/item_subselect.cc:
        fixed current_select pointer
      sql/sql_base.cc:
        cond_count moved to SELECT_LEX_NODE
      sql/sql_class.cc:
        cond_count moved to SELECT_LEX_NODE
      sql/sql_class.h:
        cond_count moved to SELECT_LEX_NODE
      sql/sql_lex.cc:
        cond_count moved to SELECT_LEX_NODE
      sql/sql_lex.h:
        cond_count moved to SELECT_LEX_NODE
      sql/sql_select.cc:
        cond_count moved to SELECT_LEX_NODE
      54cd790b