An error occurred fetching the project authors.
  1. 04 Mar, 2004 1 commit
    • unknown's avatar
      Fixed Bug#2491, INSERT DELAYED causes binary log unusable by mysqlbinlog (replication is ok) · 52236ae1
      unknown authored
      Setting insert delayed threads = 0 at mysql_init_command.
      
      
      sql/mysql_priv.h:
        New session variable, max_insert_delayed_threads
      sql/mysqld.cc:
        New session variable, max_insert_delayed_threads
      sql/set_var.cc:
        New session variable, max_insert_delayed_threads
      sql/sql_class.h:
        New session variable, max_insert_delayed_threads
      sql/sql_insert.cc:
        New session variable, max_insert_delayed_threads
      BitKeeper/etc/logging_ok:
        Logging to logging@openlogging.org accepted
      52236ae1
  2. 03 Feb, 2004 1 commit
    • unknown's avatar
      Added new option --sync-frm / --skip-sync-frm · ec76183b
      unknown authored
      Marked --bdb-no-sync as deprecated
      Added --sync-bdb-logs / --disable-sync-bdb-logs as a synonym / alternative.
      
      
      mysys/my_getopt.c:
        Changed my_getopt so that disabled_my_option can be used for
        GET_BOOL type options too.
      sql/mysql_priv.h:
        Added opt_sync_frm
      sql/mysqld.cc:
        Added sync-frm / disable-sync-frm to mysqld, to be able to disable
        use of my_sync() (fsync()). This defaults to behavior in 4.0.16
        and before, where creating of new tables is quicker than currently.
        This option is enabled by default.
        
        Marked --bdb-no-sync as deprecated option and added another one,
        --sync-bdb-logs besides. --bdb-no-sync and --disabled-sync-bdb-logs
        are now synonyms.
      sql/unireg.cc:
        One can disable my_sync() by using --disable-sync-frm
      BitKeeper/etc/logging_ok:
        Logging to logging@openlogging.org accepted
      ec76183b
  3. 30 Jan, 2004 1 commit
    • unknown's avatar
      Fix for bug #2523 '"func_time" test fails on QNX'. · ef55f2dc
      unknown authored
      Moved all range checks for TIMESTAMP value to my_gmt_sec().
      Also fixed check of upper boundary of TIMESTAMP range (which 
      also now will catch datetime values which are too small for
      TIMESTAMP in case if time_t is unsigned).  
      
      
      mysql-test/r/timezone.result:
        Added test which checks if TIMESTAMP range is checked 
        correctly (current time zone is honoured and both upper 
        and lower bounds of TIMESTAMP range are checked).
      mysql-test/t/timezone.test:
        Added test which checks if TIMESTAMP range is checked 
        correctly (current time zone is honoured and both upper 
        and lower bounds of TIMESTAMP range are checked).
      sql/field.cc:
        Check if datetime value is in TIMESTAMP range has moved to 
        my_gmt_sec() function.
      sql/mysql_priv.h:
        Added more constants for checking if datetime is in allowed
        range for TIMESTAMP.
      sql/time.cc:
        Check if datetime value is in TIMESTAMP range has moved to 
        my_gmt_sec() function. Fixed check of its return value
        to catch overflows in both directions and also overflows in 
        case of unsigned time_t.
      ef55f2dc
  4. 30 Dec, 2003 1 commit
    • unknown's avatar
      Some small portability fixes. · 376fb080
      unknown authored
      Added support for lower_case_table_names=2, which is to be used on case insensitive file systems.
      This tells MySQL to preserve the used case of filenames and database names to make it esier to move files between cases sensitive can case insensitive file systems (like Windows and Linux)
      
      
      client/mysqltest.c:
        Indentation cleanup
      include/myisam.h:
        Made some pointers 'const'
      mysql-test/mysql-test-run.sh:
        Portability fix for OSX
      sql/filesort.cc:
        Safety fix (not needed for current code but needed for 5.0)
      sql/ha_berkeley.cc:
        More debugging
        Changed 'create' to return error number
      sql/ha_berkeley.h:
        Added HA_FILE_BASED
      sql/ha_innodb.cc:
        Added missing DBUG_RETURN
      sql/ha_isam.cc:
        Changed create to return error number
      sql/ha_isam.h:
        Added HA_FILE_BASED
      sql/ha_isammrg.h:
        Added HA_FILE_BASED
      sql/ha_myisam.cc:
        Changed create to return error number
      sql/ha_myisam.h:
        Added HA_FILE_BASED
      sql/ha_myisammrg.cc:
        Changed create to return error number
      sql/ha_myisammrg.h:
        Added HA_FILE_BASED
      sql/handler.cc:
        Ensure that table engines gets table names in lower case even if we are using lower_case_table_names
        Removed test for DB_TYPE_INNODB by ensuring that create method returns error number.
      sql/handler.h:
        Added HA_FILE_BASED
        Made some struct entries 'const'
        Added 'alias' for create to be able to create tables in mixed case on case insensitive file systems
      sql/mysql_priv.h:
        Support for lower_case_table_names=2
      sql/mysqld.cc:
        Support for lower_case_table_names=2
        Moved test of case insenstive file system after all mutex are created
      sql/set_var.cc:
        Support for lower_case_table_names=2
      sql/sql_class.h:
        Indentation change
      sql/sql_db.cc:
        Support for lower_case_table_names=2
      sql/sql_insert.cc:
        Indentation change
      sql/sql_parse.cc:
        Support for lower_case_table_names=2
      sql/sql_rename.cc:
        Support for lower_case_table_names=2
        Added missing 'unpack_filename' to RENAME which may fix a bug in RENAME TABLE on windows
      sql/sql_show.cc:
        If lower_case_table_name=2 is given, show original case in SHOW CREATE TABLE
      sql/sql_table.cc:
        Support for lower_case_table_names=2 for DROP TABLE, RENAME TABLE, ALTER TABLE and CREATE TABLE
      376fb080
  5. 12 Dec, 2003 1 commit
    • unknown's avatar
      Fix autoincrement for signed columns (Bug #1366) · 759ea82e
      unknown authored
      Fixed problem with char > 128 in QUOTE() function. (Bug #1868)
      Disable creation of symlinks if my_disable_symlink is set
      Fixed searching of TEXT with end space. (Bug #1651)
      Fixed caching bug in multi-table-update where same table was used twice. (Bug #1711)
      Fixed problem with UNIX_TIMESTAMP() for timestamps close to 0. (Bug #1998)
      Fixed timestamp.test
      
      
      include/my_base.h:
        Add HA_END_SPACE_KEY to mark keys that has VARCHAR/TEXT fields.
      myisam/mi_check.c:
        Delete not used variable
      myisam/mi_key.c:
        Fix autoincrement for signed columns (Bug #1366). Patch by Holyfoot
      myisam/mi_open.c:
        Bug fix for future (doesn't affect current code)
      myisam/mi_search.c:
        Ignore end space for VARCHAR/TEXT columns
      mysql-test/r/auto_increment.result:
        Test auto_increment with signed numbers
      mysql-test/r/binary.result:
        Update results (old result was wrong)
      mysql-test/r/func_str.result:
        Added test of QUOTE()
      mysql-test/r/func_time.result:
        Add test of unix_timestamp()
      mysql-test/r/have_met_timezone.require:
        Fixed test
      mysql-test/r/innodb.result:
        Add test for InnoDB behaviour with TRUNCATE
      mysql-test/r/multi_update.result:
        Test of multi-update bug
      mysql-test/r/symlink.result:
        Test of ALTER TABLE and symlinks
      mysql-test/r/timezone.result:
        Test of from_unixtime()
      mysql-test/r/truncate.result:
        Test of truncate and auto_increment
      mysql-test/r/type_blob.result:
        Test of key search on TEXT/VARCHAR column with end space
      mysql-test/t/auto_increment.test:
        Test auto_increment with signed numbers
      mysql-test/t/func_str.test:
        Added test of QUOTE()
      mysql-test/t/func_time.test:
        Add test of unix_timestamp()
      mysql-test/t/innodb.test:
        Add test for InnoDB behaviour with TRUNCATE
      mysql-test/t/multi_update.test:
        Test of multi-update bug
      mysql-test/t/symlink.test:
        Test of ALTER TABLE and symlinks
      mysql-test/t/timezone.test:
        Test of from_unixtime()
      mysql-test/t/truncate.test:
        Test of truncate and auto_increment
      mysql-test/t/type_blob.test:
        Test of key search on TEXT/VARCHAR column with end space
      mysys/my_symlink2.c:
        Disable creation of symlinks if my_disable_symlink is set
      sql/field.h:
        Indentation cleanup
      sql/ha_innodb.cc:
        HA_PART_KEY -> HA_PART_KEY_SEG
      sql/item_strfunc.cc:
        Fixed problem with char > 128 in QUOTE() function. (Bug #1868)
      sql/mysql_priv.h:
        Make check_dup() external
      sql/opt_range.cc:
        Fixed searching of TEXT with end space. (Bug #1651)
      sql/records.cc:
        Fixed caching bug in multi-table-update where same table was used twice.
        (Bug #1711)
      sql/sql_acl.cc:
        Reset ip and ip_mask if hostname is NULL
      sql/sql_parse.cc:
        Make check_dup() global
      sql/sql_select.cc:
        Fixed searching of TEXT with end space. (Bug #1651)
      sql/sql_table.cc:
        Fixed searching of TEXT with end space. (Bug #1651)
      sql/sql_update.cc:
        Fixed caching bug in multi-table-update where same table was used twice.
        (Bug #1711)
      sql/table.cc:
        Fixed searching of TEXT with end space. (Bug #1651)
      sql/table.h:
        Fixed caching bug in multi-table-update where same table was used twice.
        (Bug #1711)
      sql/time.cc:
        Fixed problem with UNIX_TIMESTAMP() for timestamps close to 0. (Bug #1998)
      759ea82e
  6. 07 Dec, 2003 1 commit
    • unknown's avatar
      WL#1175: more default_week_formats for iso compatibility · 468dcb60
      unknown authored
      New formats added for 'week()' function and 'default_week_format' option(4 - 7).
      Next formats is supported now:
      *Value* *Meaning*
        `0'     Week starts on Sunday; First Sunday of the year starts week 1.
        	  Week() returns 0-53.
        `1'     Week starts on Monday; Weeks numbered according to ISO 8601:1988.
      	  Week() returns 0-53.
        `2'     Week starts on Sunday; First Sunday of the year starts week 1.
        	  Week() returns 1-53.
        `3'     Week starts on Monday; Weeks numbered according to ISO 8601:1988.
      	  Week() returns 1-53.
        `4'     Week starts on Sunday; Weeks numbered according to ISO 8601:1988.
      	  Week() returns 0-53.
        `5'     Week starts on Monday;  First Monday of the year starts week 1.
        	  Week() returns 0-53.
        `6'     Week starts on Sunday; Weeks numbered according to ISO 8601:1988.
      	  Week() returns 1-53.
        `7'     Week starts on Monday;  First Monday of the year starts week 1.
        	  Week() returns 1-53.
      
      
      mysql-test/r/func_time.result:
        Test for 'default_week_format' option and 'week' function
      mysql-test/t/func_time.test:
        Test for 'default_week_format' option and 'week' function
      sql/item_timefunc.cc:
        WL#1175 more default_week_formats for iso compatibility
      sql/mysql_priv.h:
        WL#1175 more default_week_formats for iso compatibility
      sql/mysqld.cc:
        WL#1175 more default_week_formats for iso compatibility
      sql/time.cc:
        WL#1175 more default_week_formats for iso compatibility
      468dcb60
  7. 11 Oct, 2003 1 commit
    • 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
  8. 29 Sep, 2003 1 commit
  9. 12 Sep, 2003 1 commit
    • unknown's avatar
      Replaced deprecated since OpenSSL 0.9.7 des_ calls and types with · 867aec2f
      unknown authored
      their newer DES_ versions.
      Provided macros for backward compatibility.
      
      
      include/my_global.h:
        Added macros for DES_ OpenSSL functions for compatibility with pre 0.9.7
      sql/des_key_file.cc:
        Replaced deprecated OpenSSL des_ calls and types with newer
      sql/item_strfunc.cc:
        Replaced deprecated OpenSSL des_ calls and types with newer
      sql/mysql_priv.h:
        Replaced deprecated OpenSSL des_ types with newer
      867aec2f
  10. 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
  11. 23 Aug, 2003 1 commit
  12. 17 Aug, 2003 1 commit
    • unknown's avatar
      Fix mutex handling in SHOW_VARIABLES (key_buffer_size was not properly protected) · 0eaf4d8d
      unknown authored
      Changed some non fatal myisamchk error messages to warnings
      
      
      myisam/myisamchk.c:
        Change error -> warning
      sql/handler.cc:
        Add mutex around keybuff_size usage
      sql/mysql_priv.h:
        Indentation update
      sql/set_var.cc:
        Add mutex around longlong variable usage
      sql/sql_parse.cc:
        Fix mutex handling in SHOW_VARIABLES
      sql/sql_show.cc:
        Fix mutex handling in SHOW_VARIABLES
      0eaf4d8d
  13. 23 Jul, 2003 1 commit
  14. 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
  15. 04 Jul, 2003 1 commit
    • unknown's avatar
      Status query on killed mysql connection results in segmentation fault (Bug #738) · 2d5d754c
      unknown authored
      Added MAX_PASSWORD_LENGTH. This increased master-slave passwords to 32 bytes (Bug #766)
      Fixed server crash on purge master logs or show master logs when binlog is off. (Bug #733)
      
      
      client/mysql.cc:
        status query on killed mysql connection results in segmentation fault (Bug #738)
      configure.in:
        Portability fix for Unixware
      include/my_global.h:
        Removed wrong patch from previous changeset
      sql/mysql_priv.h:
        Added MAX_PASSWORD_LENGTH. This increased master-slave passwords to 32 bytes
      sql/slave.h:
        Optimized structure
      sql/sql_repl.cc:
        Memory overrun safety fixes (not critical)
        Fixed server crash on purge master logs or show master logs when binlog is off. (Bug #733)
      sql/sql_repl.h:
        Fixed to use right define
      strings/strmake.c:
        Fixed comment
      2d5d754c
  16. 03 Jul, 2003 1 commit
    • unknown's avatar
      Cleaner implementation if INSERT ... SELECT with same tables · 2373397e
      unknown authored
      Tests cleanup (put drop database first in tests)
      
      
      client/mysql.cc:
        Cleanup of code in last pull
      include/config-win.h:
        Remove HAVE_CHSIZE on windows as it's not 64 bit clean
      include/my_global.h:
        Portability fix
      mysql-test/r/drop.result:
        Clean up results
      mysql-test/r/flush.result:
        Clean up results
      mysql-test/r/grant_cache.result:
        Clean up results
      mysql-test/r/innodb.result:
        Clean up results
      mysql-test/r/insert_select.result:
        Clean up results
      mysql-test/r/merge.result:
        Clean up results
      mysql-test/r/query_cache.result:
        Clean up results
      mysql-test/t/drop.test:
        Clean up tests
      mysql-test/t/flush.test:
        Clean up tests
      mysql-test/t/grant_cache.test:
        Clean up tests
      mysql-test/t/innodb.test:
        Clean up tests
      mysql-test/t/insert_select.test:
        Added more tests
      mysql-test/t/merge.test:
        Test of bug 515
      mysql-test/t/query_cache.test:
        Clean up tests
      mysql-test/t/symlink.test:
        Clean up tests
      sql/mysql_priv.h:
        Cleaner implementation if INSERT ... SELECT with same tables
      sql/sql_lex.h:
        Cleaner implementation if INSERT ... SELECT with same tables
      sql/sql_list.h:
        Indentation cleanup
      sql/sql_parse.cc:
        Cleaner implementation if INSERT ... SELECT with same tables
      sql/sql_yacc.yy:
        Cleaner implementation if INSERT ... SELECT with same tables
      2373397e
  17. 10 Jun, 2003 1 commit
    • unknown's avatar
      Don't install signal handler for SIGINT by default · a1a58d6c
      unknown authored
      Added option --gdb
      Free memory used by replicate_xxx and binglog_xxx options
      
      
      mysql-test/mysql-test-run.sh:
        Added --gdb when using gdb
      mysys/thr_alarm.c:
        Safety check
      sql/mysql_priv.h:
        Don't install signal handler for SIGINT by default
      sql/mysqld.cc:
        Don't install signal handler for SIGINT by default
        Added option --gdb
        Free memory used by replicate_xxx and binglog_xxx options.
        Add statistics variable for killed threads
      sql/repl_failsafe.cc:
        Incremented aborted_connects on failure
      sql/sql_list.cc:
        Added free_list() to free memory on shutdown.
      a1a58d6c
  18. 01 Jun, 2003 1 commit
    • unknown's avatar
      Fixed bug in ALTER TABLE DISABLE KEYS and INSERT DELAYED. Bug #478 · 2ef52d46
      unknown authored
      mysql-test/r/alter_table.result:
        new results
      mysql-test/r/lowercase_table.result:
        new results
      mysql-test/t/alter_table.test:
        Test of ALTER TABLE DISABLE KEYS + INSERT DELAYED
      mysql-test/t/lowercase_table.test:
        Added test of alias name comparison
      sql/mysql_priv.h:
        Made closed_cached_table local
      sql/sql_table.cc:
        Fixed bug in ALTER TABLE DISABLE KEYS and INSERT DELAYED
      2ef52d46
  19. 30 May, 2003 1 commit
  20. 27 May, 2003 1 commit
    • unknown's avatar
      Fixed problem with mysql prompt when server disconnect. (Bug 356) · 4920a332
      unknown authored
      Fixed problem with localtime -> gmt where some times resulted in
      different (but correct) timestamps. Now MySQL should use the smallest
      possible timestamp value in this case.  (Bug 316)
      
      
      client/mysql.cc:
        Fixed problem with prompt when server disconnect. (Bug 356)
      client/mysqltest.c:
        More debug information
      mysql-test/mysql-test-run.sh:
        Added support for --timezone in -master.opt
      mysql-test/t/raid.test:
        Fixed test if raid is enabled
      sql/field.cc:
        New my_gmt_sec() parameters
      sql/mysql_priv.h:
        New my_gmt_sec() parameters
      sql/mysqld.cc:
        Remove LOCK_timezone.
        Code cleanup
      sql/time.cc:
        Fixed problem with localtime -> gmt where some times resulted in
        different (but correct) timestamps. Now MySQL should use the smallest
        possible timestamp value in this case.  (Bug 316)
      4920a332
  21. 19 May, 2003 1 commit
    • unknown's avatar
      Added option --read-only (Thanks to Markus Benning) · 18dd37b8
      unknown authored
      myisam/myisamchk.c:
        Removed warning from fulltext when repairing many tables with fulltext index
      sql/init.cc:
        Remove not used variables
      sql/mysql_priv.h:
        Remove not used variables
      sql/mysqld.cc:
        Removed not used variables
        Added option --read-only
        Change opt_do_pstack and master_ssl to get them to work with my_getopt
      sql/set_var.cc:
        Option --read-only
      sql/sql_parse.cc:
        Option --read-only
      18dd37b8
  22. 16 May, 2003 1 commit
    • unknown's avatar
      buf0lru.c, buf0flu.c, buf0buf.c, buf0lru.h: · e4a95f29
      unknown authored
        Search first only 10 % of the LRU list for a replaceable block before doing an LRU flush; enable again flushing of close pages also in a flush list (checkpointing) flush
      trx0trx.c:
        Add forgotten return value (it was not used anywhere, fortunately)
      ha_innodb.h, mysql_priv.h:
        Move declaration of srv_buf_pool_max_modified_pct to ha_innodb.h and enclose it to denote it is a C variable, not C++
      
      
      sql/mysql_priv.h:
        Move declaration of srv_buf_pool_max_modified_pct to ha_innodb.h and enclose it to denote it is a C variable, not C++
      sql/ha_innodb.h:
        Move declaration of srv_buf_pool_max_modified_pct to ha_innodb.h and enclose it to denote it is a C variable, not C++
      innobase/trx/trx0trx.c:
        Add forgotten return value (it was not used anywhere, fortunately)
      innobase/include/buf0lru.h:
        Search first only 10 % of the LRU list for a replaceable block before doing an LRU flush; enable again flushing of close pages also in a flush list (checkpointing) flush
      innobase/buf/buf0buf.c:
        Search first only 10 % of the LRU list for a replaceable block before doing an LRU flush; enable again flushing of close pages also in a flush list (checkpointing) flush
      innobase/buf/buf0flu.c:
        Search first only 10 % of the LRU list for a replaceable block before doing an LRU flush; enable again flushing of close pages also in a flush list (checkpointing) flush
      innobase/buf/buf0lru.c:
        Search first only 10 % of the LRU list for a replaceable block before doing an LRU flush; enable again flushing of close pages also in a flush list (checkpointing) flush
      e4a95f29
  23. 13 May, 2003 1 commit
    • unknown's avatar
      Fix for UNION and LEFT JOIN (Bug #386) · dc1e55f8
      unknown authored
      Fixed wrong logging of Access denied error (Bug #398)
      
      
      include/my_global.h:
        Fix for QNX
      mysql-test/r/union.result:
        new test case
      mysql-test/t/union.test:
        Test of bug in union and left join
      mysys/my_seek.c:
        Safety fix to find out when pos gets a wrong value
      sql/field.h:
        Fix for UNION and LEFT JOIN
      sql/mysql_priv.h:
        Fix for UNION and LEFT JOIN
      sql/sql_base.cc:
        Fix for UNION and LEFT JOIN
      sql/sql_insert.cc:
        Fix for UNION and LEFT JOIN
      sql/sql_parse.cc:
        Fixed wrong logging of Access denied error
      sql/sql_union.cc:
        Fix for UNION and LEFT JOIN
      sql/sql_update.cc:
        Fix for UNION and LEFT JOIN
      dc1e55f8
  24. 04 May, 2003 2 commits
    • unknown's avatar
      Minor fix to previous code · 81a752eb
      unknown authored
      sql/mysql_priv.h:
        Add ifdef to allow compilation without Innodb
      81a752eb
    • unknown's avatar
      Added innodb_max_dirty_pages_pct parameter to limit amount · 09b03ed2
      unknown authored
          of dirty pages in the buffer pool (can be changed online)
      
      
      sql/mysql_priv.h:
        Added innodb_max_dirty_pages_pct parameter to limit amount 
        of dirty pages in the buffer pool (can be changed online)
      sql/mysqld.cc:
        Added new option
      sql/set_var.cc:
        Added new variable handling
      09b03ed2
  25. 08 Apr, 2003 1 commit
  26. 05 Mar, 2003 1 commit
  27. 04 Mar, 2003 1 commit
    • unknown's avatar
      Fixed bug in LOCK TABLE + DROP TABLE when other thread was waiting for a table... · 3446199d
      unknown authored
      Fixed bug in LOCK TABLE + DROP TABLE when other thread was waiting for a table that was locked bug not droped
      
      
      client/mysqltest.c:
        Fixed bug that comments did a ping
      include/thr_lock.h:
        Added function to abort a lock for a specific thread
      mysql-test/mysql-test-run.sh:
        Fixed where mysqltest traces are put
      mysql-test/r/lock_multi.result:
        Test for LOCK TABLE + DROP TABLE bug
      mysql-test/t/lock_multi.test:
        Test for LOCK TABLE + DROP TABLE bug
      mysys/thr_lock.c:
        Added function to abort a lock for a specific thread
      sql/handler.cc:
        Indentation cleanup
      sql/lock.cc:
        Added function to abort a lock for a specific thread
      sql/mysql_priv.h:
        Added function to abort a lock for a specific thread
      sql/mysqld.cc:
        Use automatic recover even with --safe
      3446199d
  28. 03 Mar, 2003 1 commit
    • unknown's avatar
      Fixed a deadlock problem when using LOCK TABLE in one thread and DROP TABLE in another · 374ea106
      unknown authored
      sql/lock.cc:
        Added functions to handle list of table name locks
      sql/mysql_priv.h:
        Added functions to handle list of named locks
      sql/sql_rename.cc:
        Use new general table name lock functions
      sql/sql_table.cc:
        Require table name locks when doing drop table.
        This fixed a deadlock problem when using LOCK TABLE in one thread and DROP TABLE in another
      374ea106
  29. 17 Feb, 2003 1 commit
    • unknown's avatar
      Fixed multi-table-delete for InnoDB tables · 300b3fb6
      unknown authored
      Novell patches
      
      
      Makefile.am:
        Novell patch
      client/mysql.cc:
        Novell patch
      configure.in:
        Novell patch
      extra/mysql_waitpid.c:
        Novell patch
      include/my_pthread.h:
        Novell patch
      include/mysql.h:
        Novell patch
      libmysql/libmysql.c:
        Novell patch
      libmysqld/libmysqld.c:
        Novell patch
      mysql-test/mysql-test-run.sh:
        Don't use running server with --valgrind
      mysql-test/r/innodb.result:
        Updated results
      mysql-test/r/rpl000001.result:
        Updated results
      mysql-test/r/rpl000004.result:
        Updated results
      mysql-test/r/rpl_log.result:
        Updated results
      mysql-test/r/type_blob.result:
        Updated results
      mysql-test/std_data/words.dat:
        Added more words to make type_blob test relevant
      mysql-test/t/innodb.test:
        test of multi-table-delete
      mysql-test/t/rpl000001.test:
        Update for new word file
      mysql-test/t/type_blob.test:
        Test if BLOB IS NULL on NOT NULL column
      mysys/my_init.c:
        Novell patch
      mysys/my_netware.c:
        Novell patch
      netware/Makefile.am:
        Novell patch
      netware/init_db.sql:
        Novell patch
      netware/isamchk.def:
        Novell patch
      netware/isamlog.def:
        Novell patch
      netware/libmysql.def:
        Novell patch
      netware/my_print_defaults.def:
        Novell patch
      netware/myisamchk.def:
        Novell patch
      netware/myisamlog.def:
        Novell patch
      netware/myisampack.def:
        Novell patch
      netware/mysql.def:
        Novell patch
      netware/mysql_install_db.c:
        Novell patch
      netware/mysql_install_db.def:
        Novell patch
      netware/mysql_test_run.def:
        Novell patch
      netware/mysqladmin.def:
        Novell patch
      netware/mysqlbinlog.def:
        Novell patch
      netware/mysqlcheck.def:
        Novell patch
      netware/mysqld_safe.c:
        Novell patch
      netware/mysqldump.def:
        Novell patch
      netware/mysqlimport.def:
        Novell patch
      netware/mysqlshow.def:
        Novell patch
      netware/mysqltest.def:
        Novell patch
      netware/pack_isam.def:
        Novell patch
      netware/perror.def:
        Novell patch
      netware/replace.def:
        Novell patch
      netware/resolveip.def:
        Novell patch
      netware/test_db.sql:
        Novell patch
      scripts/make_binary_distribution.sh:
        Novell patch
      sql/item_cmpfunc.h:
        Optimization of 'IS NULL'
      sql/mysql_priv.h:
        Code cleanup
      sql/mysqld.cc:
        Novell patch
      sql/net_pkg.cc:
        Code cleanup
      sql/records.cc:
        Fixed multi-table-delete for InnoDB tables
      sql/sql_delete.cc:
        Fixed multi-table-delete for InnoDB tables
      sql/sql_handler.cc:
        Code cleanup
      sql/sql_table.cc:
        Code cleanup
      sql/structs.h:
        Fixed multi-table-delete for InnoDB tables
      300b3fb6
  30. 06 Feb, 2003 1 commit
    • unknown's avatar
      Added START TRANSACTION syntax · dacf7f8f
      unknown authored
      Added ALL as parameter option for all group functions.
      Make join handling uniform. This allows us to use ',', JOIN and INNER JOIN the same way.
      Sort NULL last if DESC is used (ANSI SQL 99 requirement)
      
      
      include/my_global.h:
        Moved LL from mysql_priv (as this is also in config-win.h)
      mysql-test/r/distinct.result:
        Updated results
      mysql-test/r/func_group.result:
        Updated results
      mysql-test/r/innodb.result:
        Updated results
      mysql-test/r/join.result:
        Updated results
      mysql-test/r/order_by.result:
        Updated results
      mysql-test/t/func_group.test:
        Added test for SUM(ALL ...)
      mysql-test/t/innodb.test:
        Added test for START TRANSACTION
      mysql-test/t/join.test:
        Test different join syntaxes
      mysql-test/t/order_by.test:
        Added new test of NULL ordering.
      sql/filesort.cc:
        Sort NULL last if DESC is used
      sql/lex.h:
        Added OLD_PASSWORD() as synonym for PASSWORD.
      sql/mysql_priv.h:
        Removed LL()
      sql/opt_range.cc:
        Sort NULL last if DESC is used
      sql/opt_range.h:
        Sort NULL last if DESC is used
      sql/slave.cc:
        Indentation changes
      sql/sql_parse.cc:
        After merge fix
      sql/sql_select.cc:
        Added comment
      sql/sql_yacc.yy:
        Added START TRANSACTION syntax
        Added ALL as parameter option for all group functions.
        Make join handling uniform.
      dacf7f8f
  31. 29 Jan, 2003 1 commit
    • unknown's avatar
      Fixed handling of lower_case_table_names in SHOW TABLE STATUS,... · bdfa5497
      unknown authored
      Fixed handling of lower_case_table_names in SHOW TABLE STATUS, mysql_list_fields() and mysql_table_dump().
      This fixes some Errcode 13 errors on Windows when deleting tables.
      
      
      
      sql/mysql_priv.h:
        Moved lower case conversion of database names to check_db_name()
      sql/mysqld.cc:
        Fix to be able to use 4.0 error message files
      sql/sql_db.cc:
        Moved lower case conversion of database names to check_db_name()
      sql/sql_parse.cc:
        Moved lower case conversion of database names to check_db_name()
        Added checking of lower_case_table_names for mysql_table_dump() and
        mysql_list_fields()
      sql/sql_show.cc:
        Moved lower case conversion of database names to check_db_name()
      sql/table.cc:
        Convert database names to lower case in check_db-name() if --lower-case-table-names is used.
      bdfa5497
  32. 28 Jan, 2003 3 commits
    • unknown's avatar
      Only write to the error log if --log-error is specified and --console is not specified · b533cd5c
      unknown authored
      (On Windows --log-error is enabled by default)
      
      
      
      mysys/my_getopt.c:
        Call get_one_option() also for boolean values.
      scripts/mysqld_safe.sh:
        Add option --log-error
      sql/log.cc:
        Fix for --log-error
      sql/mysql_priv.h:
        Fix for --log-error
      sql/mysqld.cc:
        Fix for --log-error
      sql/sql_udf.cc:
        Lock the mysql/func table properly
      b533cd5c
    • unknown's avatar
      fixed "DROP table_open_in_handler" hang · d490b56e
      unknown authored
      d490b56e
    • unknown's avatar
      Fixes for Netware · 84f81dc5
      unknown authored
      Call pthread_mutex_destroy() on not used mutex.
      Changed comments in .h and .c files from // -> /* */
      Added detection of mutex on which one didn't call pthread_mutex_destroy()
      Fixed bug in create_tmp_field() which causes a memory overrun in queries that uses "ORDER BY constant_expression"
      Added optimisation for ORDER BY NULL
      
      
      BitKeeper/deleted/.del-ChangeLog~dfc92e15bee6fc75:
        Delete: sql/ChangeLog
      BUILD/compile-pentium-valgrind-max:
        Don't use valgrind with safemalloc as this can hide some bugs
      Makefile.am:
        Added platform dirs
      bdb/os/os_handle.c:
        Portability fix
      client/mysql.cc:
        Fixes for Netware.
        Fixed duplicate output when using 'tee'
        Simple optimisations
      client/mysqldump.c:
        Portability fix
      client/mysqltest.c:
        Portability fix
      configure.in:
        Fixes for Netware
      extra/resolveip.c:
        Fixes for Netware
      include/Makefile.am:
        Fixes for Netware
      include/config-win.h:
        Portability fix
      include/my_global.h:
        Fixes for Netware
      include/my_net.h:
        Fixes for Netware
      include/my_pthread.h:
        Fixes for Netware
        Added detection of mutexes that was not destroyed
      include/my_sys.h:
        Fixes for Netware
        Added 'extern' before external functions
      include/mysql.h:
        Fixes for Netware
      innobase/configure.in:
        Fixes for Netware
      innobase/include/os0thread.h:
        Fixes for Netware
      innobase/os/os0sync.c:
        Fixes for Netware
      innobase/os/os0thread.c:
        Fixes for Netware
      innobase/srv/srv0srv.c:
        Fixes for Netware
      innobase/srv/srv0start.c:
        Fixes for Netware
      innobase/sync/sync0sync.c:
        Fixes for Netware
      isam/test3.c:
        Disable test on Netware
      libmysql/Makefile.shared:
        Added my_sleep
      libmysql/get_password.c:
        Fixes for Netware
      libmysql/libmysql.c:
        Fixes for Netware
        Made mysql_once_init() global
      libmysql/manager.c:
        Fixes for Netware
      myisam/mi_test3.c:
        Disable test for netware
      mysql-test/mysql-test-run.sh:
        Give warning if output file contains errors
      mysql-test/r/count_distinct.result:
        More tests
      mysql-test/r/group_by.result:
        Test of ORDER BY NULL
      mysql-test/t/backup.test:
        Fixes for Netware
      mysql-test/t/count_distinct.test:
        More tests
      mysql-test/t/func_crypt.test:
        Fixes for Netware
      mysql-test/t/grant_cache.test:
        Fixes for Netware
      mysql-test/t/group_by.test:
        Tests of ORDER BY NULL
      mysql-test/t/rpl000015.test:
        Fixes for Netware
      mysql-test/t/rpl000017.test:
        Fixes for Netware
      mysql-test/t/rpl_rotate_logs.test:
        Fixes for Netware
      mysys/Makefile.am:
        Added my_sleep.c and my_netware.c
      mysys/charset.c:
        Fixes for Netware
      mysys/default.c:
        Fixes for Netware
      mysys/mf_tempfile.c:
        Fixes for Netware
      mysys/my_clock.c:
        Fixes for Netware
      mysys/my_copy.c:
        Fixes for Netware
      mysys/my_getwd.c:
        Changed function comment from // -> /* */
      mysys/my_init.c:
        Fixes for Netware
      mysys/my_lock.c:
        Fixes for Netware
      mysys/my_messnc.c:
        Fixes for Netware
      mysys/my_os2cond.c:
        Removed comment
      mysys/my_os2dirsrch.c:
        Changed function comment from // -> /* */
        Fixed indentation
      mysys/my_os2dirsrch.h:
        Changed function comment from // -> /* */
        Fixed indentation
      mysys/my_os2file64.c:
        Changed function comment from // -> /* */
        Fixed indentation
      mysys/my_os2mutex.c:
        Changed function comment from // -> /* */
        Fixed indentation
      mysys/my_os2thread.c:
        Changed function comment from // -> /* */
        Fixed indentation
      mysys/my_os2tls.c:
        Changed function comment from // -> /* */
        Fixed indentation
      mysys/my_pthread.c:
        Fixes for Netware
      mysys/my_redel.c:
        Fixes for Netware
      mysys/my_tempnam.c:
        Fixes for Netware
      mysys/my_thr_init.c:
        Remove created mutexes when program ends.
      mysys/mysys_priv.h:
        Cleanup
      mysys/safemalloc.c:
        Prefix error messages with "Error:"
      mysys/thr_alarm.c:
        Destroy internal mutex on end_thr_alarm.
      mysys/thr_mutex.c:
        Added detection of mutex on which one didn't call pthread_mutex_destroy()
      scripts/make_binary_distribution.sh:
        Fixes for Netware
      sql/des_key_file.cc:
        Free mutex at end
      sql/ha_innodb.cc:
        Free mutex at end
      sql/ha_myisam.cc:
        Changed warnings from REPAIR Note:
        (For mysql-test-run)
      sql/hostname.cc:
        Fixes for Netware
      sql/item.h:
        Fixed bug in create_tmp_field() which causes a memory overrun
      sql/item_func.cc:
        Free used mutexes
      sql/item_sum.cc:
        Fixed bug in create_tmp_field() which causes a memory overrun
      sql/log.cc:
        Free used mutexes
      sql/my_lock.c:
        Fixes for Netware
      sql/mysql_priv.h:
        Fixes for Netware
      sql/mysqld.cc:
        Fixes for Netware
        Added Have_crypt
        Properly free mutexes from MYSQL_LOG by calling cleanup
        Free mutex before exit
      sql/repl_failsafe.cc:
        Fixes for Netware
      sql/set_var.cc:
        Added have_crypt
      sql/share/english/errmsg.txt:
        Added version socket and port to stderr log
      sql/slave.cc:
        Remove global MASTER_INFO variable and use instead an allocated variable.
        This allows us to correctly free used mutex.
      sql/slave.h:
        Move constructors and destuctors to slave.cc
        (To make it easier to clear all needed variables)
      sql/sql_base.cc:
        Safety fix
      sql/sql_class.h:
        Portability fixes.
        Added 'cleanup' to log handling to be able to free mutexes.
      sql/sql_insert.cc:
        Fixes for Netware
      mysys/my_sleep.c:
        E
      sql/sql_parse.cc:
        Fixes for Netware
      sql/sql_select.cc:
        Added optimisation for ORDER BY NULL
      sql/sql_select.h:
        Fixed bug in create_tmp_field() which causes a memory overrun
      sql/sql_table.cc:
        Fixed bug in create_tmp_field() which causes a memory overrun
      sql/sql_udf.cc:
        Free mutex on end
      vio/test-ssl.c:
        Simple code cleanup
      vio/test-sslclient.c:
        Simple code cleanup
      vio/test-sslserver.c:
        Simple code cleanup
      vio/viotest-ssl.c:
        Simple code cleanup
      84f81dc5
  33. 27 Jan, 2003 1 commit
  34. 09 Jan, 2003 1 commit
    • unknown's avatar
      Don't count NULL values in cardinalty for MyISAM tables. · b5e37b24
      unknown authored
      Free row buffer cache after each query for MyISAM tables.
      Added table join option FORCE INDEX
      Fixed core dump bug when connecting with hostname that could not be resolved.
      
      
      include/my_base.h:
        Don't count NULL values in cardinalty
      myisam/mi_check.c:
        Don't count NULL values in cardinalty
      myisam/mi_extra.c:
        Free row buffer cache after each query
      myisam/mi_open.c:
        Avoid realloc if cache size doesn't change
      myisam/mi_search.c:
        Don't count NULL values in cardinalty
      myisam/myisamdef.h:
        Change buffer length from uint to uint32 to make it more portable/predictable
      mysql-test/r/myisam.result:
        Test case for cardinality with NULL keys and FORCE INDEX
      mysql-test/t/myisam.test:
        Test case for cardinality with NULL keys and FORCE INDEX
      sql/lex.h:
        Added table join option FORCE INDEX
      sql/mysql_priv.h:
        Added table join option FORCE INDEX
      sql/opt_range.cc:
        Added table join option FORCE INDEX
      sql/sql_base.cc:
        Added table join option FORCE INDEX
      sql/sql_lex.h:
        Added table join option FORCE INDEX
      sql/sql_parse.cc:
        Added table join option FORCE INDEX
        Don't use strlen() on hostname without first checking if it's not NULL
      sql/sql_select.cc:
        Added table join option FORCE INDEX
      sql/sql_yacc.yy:
        Added table join option FORCE INDEX
      sql/table.h:
        Added table join option FORCE INDEX
      b5e37b24
  35. 07 Jan, 2003 1 commit
    • unknown's avatar
      Portability fixes · b3b66f64
      unknown authored
      Fixed test suite for HPUX 10.20 and MacOSX
      
      
      Build-tools/Do-compile:
        Added timeout to mysqladmin shutdown commands
        Kill old running mysqld started by earlier runs
        Removed run time warning from LD_LIBRARY_PATH
      client/mysqladmin.c:
        Return 1 if pid file isn't deleted on shutdown.
        Fix error message if pid file is not deleted
      client/mysqltest.c:
        Always allow --debug flag
        (Makes it easier to run mysql-test-run)
      mysql-test/mysql-test-run.sh:
        A lot of safety fixes. 
        This fixes some problems with test suite for HPUX 10.20 and MacOSX
      sql-bench/bench-init.pl.sh:
        Allow tests to change time limit.
      sql-bench/crash-me.sh:
        Indentation cleanups
        Added DROP for a created table
      sql-bench/test-alter-table.sh:
        Added default time limit
        Changed test to be estimated to get down run time.
        Fixed that add_multi_col is detected
      sql-bench/test-insert.sh:
        Comment cleanup
      sql/mysql_priv.h:
        Removed not needed prototype.
      sql/mysqld.cc:
        Removed DBUG warnings
        Removed default argument for clean_up() and made it static.
        More comments.
        Ignore SIGHUP during shutdown
      sql/net_pkg.cc:
        More comments
      sql/slave.cc:
        Added DBUG_PRINT messages
      b3b66f64
  36. 05 Dec, 2002 2 commits
    • unknown's avatar
      Copy arguments given to mysql_server_init() · fdb093fc
      unknown authored
      Made keybuff_size longlong (To make show variables work similar on 32
      and 64 bit systems)
      Fixed some 'not initalized variable errors' in multi-table-update.
      Fixed memory leak in multi-table-update.
      Now all tests works under valgrind without any errors.
      
      
      libmysqld/lib_sql.cc:
        Copy arguments given to mysql_server_init()
      mysql-test/r/temp_table.result:
        Update test results (after merge form 3.23)
      sql/handler.cc:
        Made keybuff_size longlong
      sql/mysql_priv.h:
        Made keybuff_size longlong
      sql/mysqld.cc:
        Made keybuff_size longlong
      sql/set_var.cc:
        Made keybuff_size longlong
      sql/set_var.h:
        Made keybuff_size longlong
      sql/sql_select.cc:
        Simple cleanup
      sql/sql_select.h:
        Make TMP_TABLE_PARAM to be allocated through Sql_alloc
      sql/sql_update.cc:
        Fixed some 'not initalized variable errors' in multi-table-update.
        Fixed memory leak in multi-table-update
      fdb093fc
    • unknown's avatar
      Removed copying of parameters as this leads to memory leaks in embedded server. · 591b0585
      unknown authored
      Fixed 'not initialized' memory error.
      
      
      mysql-test/mysql-test-run.sh:
        Updates to be able to more easily use --valgrind
      mysql-test/r/alter_table.result:
        Added missing drop table
      mysql-test/t/alter_table.test:
        Added missing drop table
      sql/field.cc:
        Simple optimizations
      sql/ha_innodb.cc:
        Remove copying of parameters as this leads to memory leaks in MySQL.
        Should be instead fixed by, in embedded server, make a temporary copy of
        all parameters and free them on server-end
      sql/log.cc:
        Simple optimization
      sql/mysql_priv.h:
        Move external reference to struct to include file
      sql/mysqld.cc:
        Added safety asserts
      sql/sql_class.cc:
        Fixed non fatal 'not initialized memory reference error' in thread init
      sql/sql_udf.cc:
        Clear current_thd for global thread
      strings/strto.c:
        Simple optimization
      591b0585