An error occurred fetching the project authors.
  1. 28 Nov, 2003 1 commit
  2. 29 Oct, 2003 1 commit
    • unknown's avatar
      Fix for BUG#1686 · 03dbf8cc
      unknown authored
      "If 2 master threads with same-name temp table, slave makes bad binlog"
      and (two birds with one stone) for
      BUG#1240 "slave of slave breaks when STOP SLAVE was issud on parent slave
      and temp tables".
      
      Here is the design change:
      in a slave running with --log-slave-updates, events are now logged with the
      thread id they had on the master. So no more id conflicts between master threads,
      but introduces id conflicts between one master thread and one normal 
      client thread connected to the slave. This is solved by storing the server id
      in the temp table's name.
      
      New test which requires mysql-test-run to be run with --manager,
      otherwise it will be skipped.
      
      Undoing a Monty's change (hum, a chill runs down my spine ;) which was
      "Cleanup temporary tables when slave ends" in ChangeSet 1.1572.1.1.
      
      
      mysql-test/mysql-test-run.sh:
        One new test which needs more than one slave so must be hardcoded in mysql-test-run.sh.
      sql/log_event.cc:
        The event needs to carry a slave_proxy_id (which is set at event's creation
        and used at event's logging).
        This is used for events created by ::exec_event() in the slave SQL thread:
        now we want to log these events with the thread id they had on the master.
        This is so that several same-name temp tables simultaneously created on
        the master end up with not the same thread id in the slave's binlog.
      sql/log_event.h:
        Query and Load need to carry a slave_proxy_id, like they carried a thread_id
        (to replicate temp tables well).
      sql/slave.cc:
        Do not free temp tables in the slave SQL thread. Or they will be lost when
        one does STOP SLAVE / START SLAVE.
        We even save them in rli->save_temporary_tables and set thd->temporary_tables=0
        to prevent them to be freed.
      sql/sql_base.cc:
        Put the server id in the table cache key name for temp tables
        (we already put the slave_proxy_id, but we also need the server id
        in case normal clients (not slave threads) are using temp tables
        on the slave).
      sql/unireg.h:
        4 more bytes, to store the server id.
      03dbf8cc
  3. 28 Sep, 2003 1 commit
    • unknown's avatar
      Fix for BUG#1345 "SQL Syntax Error in binarylog with DROP TABLES": · 3106e311
      unknown authored
      it's just backquoting the db's and table's names
      when writing DROP TEMPORARY TABLE to the binlog when a connection ends.
      A testcase for this.
      
      
      sql/sql_base.cc:
        backquote db and table name when writing DROP TEMPORARY TABLE to the binlog
        when a connection ends.
      3106e311
  4. 14 Jul, 2003 1 commit
    • 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
  5. 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
  6. 26 Jun, 2003 1 commit
    • unknown's avatar
      LEFT JOIN optimization: Change LEFT JOIN to normal join if possible · a3beaaa3
      unknown authored
      mysql-test/r/select.result:
        Added test for LEFT JOIN optimization
      mysql-test/t/select.test:
        Added test for LEFT JOIN optimization
      sql/item.h:
        LEFT JOIN optimization
      sql/item_cmpfunc.cc:
        LEFT JOIN optimization
      sql/item_cmpfunc.h:
        LEFT JOIN optimization
      sql/item_func.cc:
        LEFT JOIN optimization
      sql/item_func.h:
        LEFT JOIN optimization
      sql/item_strfunc.cc:
        LEFT JOIN optimization
      sql/sql_base.cc:
        Heart of LEFT JOIN optimization
      a3beaaa3
  7. 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
  8. 07 May, 2003 2 commits
  9. 03 May, 2003 1 commit
  10. 29 Apr, 2003 2 commits
    • unknown's avatar
      Porting back security fix from 4.0. · 4845193d
      unknown authored
      All tests plus grant.pl test passed.
      
      
      4845193d
    • unknown's avatar
      code cleanup · 38b70f06
      unknown authored
      mysql-test/r/innodb.result:
        fixing result
      mysql-test/t/innodb.test:
        fixing test
      sql/sql_base.cc:
        committing a fix in order to pull new stuff
      38b70f06
  11. 28 Apr, 2003 1 commit
    • unknown's avatar
      Fix for openssl on Solaris · a34fc634
      unknown authored
      Fix for grant bug with SELECT *
      
      
      include/my_global.h:
        Fix for openssl on Solaris
      sql/item_strfunc.cc:
        Fix for openssl on Solaris
      sql/sql_acl.cc:
        Indentation cleanup
      sql/sql_base.cc:
        Fix for grant bug with SELECT *
      sql/sql_parse.cc:
        Added comment
      tests/grant.pl:
        New grant test for SELECT *
      tests/grant.res:
        new grant results
      a34fc634
  12. 13 Mar, 2003 1 commit
  13. 12 Mar, 2003 1 commit
  14. 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
  15. 28 Jan, 2003 2 commits
    • 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
    • unknown's avatar
      72455300
  16. 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
  17. 03 Dec, 2002 1 commit
    • unknown's avatar
      Change of internal key_field=NULL handling to avoid error messages. · 80b143c1
      unknown authored
      Optimized SELECT DISTINCT ... ORDER BY ... LIMIT
      Fixed reference to uninitalized variable
      
      
      mysql-test/r/distinct.result:
        Updated results for new tests
      mysql-test/r/func_math.result:
        Fixed test of RND()
      mysql-test/r/innodb.result:
        Updated results for new tests
      mysql-test/r/null.result:
        Updated results for new tests
      mysql-test/t/distinct.test:
        New distinct test
      mysql-test/t/func_math.test:
        Fixed test of RND()
      mysql-test/t/innodb.test:
        Test for bugs
      mysql-test/t/null.test:
        TEst for bugs
      sql/field.h:
        Change of NULL handling to avoid error messages
      sql/field_conv.cc:
        Change of NULL handling to avoid error messages
      sql/item.cc:
        Change of NULL handling to avoid error messages
      sql/item.h:
        Change of NULL handling to avoid error messages
      sql/item_cmpfunc.cc:
        Change of NULL handling to avoid error messages
      sql/item_func.cc:
        Change of NULL handling to avoid error messages
      sql/item_func.h:
        Cleaned up RND() handling
      sql/item_timefunc.cc:
        Change of NULL handling to avoid error messages
      sql/item_timefunc.h:
        Change of NULL handling to avoid error messages
      sql/opt_range.cc:
        Fixed bug in <=> NULL
      sql/password.c:
        Indentation cleanup
      sql/sql_base.cc:
        Change of NULL handling to avoid error messages
      sql/sql_class.cc:
        Fixed reference to uninitalized variable
      sql/sql_handler.cc:
        Change of NULL handling to avoid error messages
      sql/sql_select.cc:
        Change of NULL handling to avoid error messages
        Optimized SELECT DISTINCT ... ORDER BY ... LIMIT
      sql/sql_select.h:
        Change of NULL handling to avoid error messages
      sql/unireg.cc:
        Change of NULL handling to avoid error messages
      80b143c1
  18. 29 Nov, 2002 1 commit
    • unknown's avatar
      New multi-table-update code · 46536219
      unknown authored
      New (simpler) internal timestamp handling.
      More debuging to heap tables.
      Small cleanups to multi-table-delete
      false -> 0 and true -> 1  (We should use TRUE and FALSE)
      
      
      heap/_check.c:
        Added checking of rows
      heap/hp_delete.c:
        Extra debugging
      heap/hp_scan.c:
        Extra debugging
      heap/hp_update.c:
        Extra debugging
      heap/hp_write.c:
        Extra debugging
      include/my_base.h:
        Added option to disable row cache when using updates
      isam/extra.c:
        Added option to disable row cache when using updates
      myisam/mi_check.c:
        Comment cleanup
      myisam/mi_extra.c:
        Added option to disable row cache when using updates
      myisam/sort.c:
        Indentaion cleanups
      myisammrg/myrg_extra.c:
        Added option to disable row cache when using updates
      mysql-test/r/multi_update.result:
        Updated results
      mysql-test/t/multi_update.test:
        Cleanup up to only use table names t1, t2,...
      mysys/mf_iocache.c:
        Safety fix
      sql/item_cmpfunc.cc:
        change true-> 1 and false -> 0
      sql/mysql_priv.h:
        Cleaned up SQL_LIST handling
      sql/sql_base.cc:
        Fixed grant checking if SELECT tablename.*
      sql/sql_class.h:
        Cleaned up multi-table-update
      sql/sql_delete.cc:
        Fixed OPTION_SAFE_UPDATE checking in multi-table-delete.
        Fixed query-cache invalidation in multi-table-delete
      sql/sql_insert.cc:
        cleaned up timestamp handling
      sql/sql_olap.cc:
        false -> 0
      sql/sql_parse.cc:
        Optimized some list handling.
        Moved multi-table-update to sql_update.cc
      sql/sql_select.cc:
        More comments
        Fixed create_tmp_table for multi-table-update
      sql/sql_select.h:
        New prototypes
      sql/sql_union.cc:
        false -> 0
        Cleaned up timestamp handling
      sql/sql_update.cc:
        New multi-update-table code
      sql/sql_yacc.yy:
        false -> 0, true -> 1
        Optimized some list handling
      sql/table.h:
        Added union for temporary values.
        Made shared int to be able to store counters.
      sql/uniques.cc:
        Indentation cleanup
      46536219
  19. 16 Nov, 2002 1 commit
    • unknown's avatar
      Small improvement to alloc_root · bd1c2d65
      unknown authored
      Add support for LIMIT # OFFSET #
      Changed lock handling:  Now all locks should be stored in TABLE_LIST instead of passed to functions.
      Don't call query_cache_invalidate() twice in some cases
      mysql_change_user() now clears states to be equal to close + connect.
      Fixed a bug with multi-table-update and multi-table-delete when used with LOCK TABLES
      Fixed a bug with replicate-do and UPDATE
      
      
      BitKeeper/etc/ignore:
        added autom4te.cache/* bdb/dist/autom4te.cache/* innobase/autom4te.cache/*
      include/my_alloc.h:
        Small improvement to alloc_root
      libmysql/libmysql.c:
        Removed compiler warning
      myisam/mi_page.c:
        Better DBUG message
      mysql-test/r/multi_update.result:
        Added test with lock tables
      mysql-test/r/rpl_replicate_do.result:
        Update results
      mysql-test/r/rpl_rotate_logs.result:
        Make test independent of if t1 exists
      mysql-test/t/multi_update.test:
        Added test with lock tables
      mysql-test/t/rpl_rotate_logs.test:
        Make test independent of if t1 exists
      mysys/my_alloc.c:
        Small imprevement to alloc_root
        (Don't free blocks less than ALLOC_MAX_BLOCK_ROOT (4K)
      sql/ha_innodb.cc:
        More debug messages
      sql/ha_myisam.cc:
        Safety change
      sql/lex.h:
        Add support for LIMIT # OFFSET #
      sql/lock.cc:
        Added assertion
      sql/mysql_priv.h:
        Change of lock handling
      sql/mysqld.cc:
        Added function clear_error_messages()
      sql/sql_base.cc:
        Change lock handling by open_ltable() and open_and_lock_tables()
      sql/sql_class.cc:
        Split THD::THD to two functions
        Move some code from cleanup() to ~THD:THD
        Add THD::change_user()
      sql/sql_class.h:
        Prototype changes in class THD
      sql/sql_delete.cc:
        Remove locking argument from mysql_delete()
        Locking type is now stored in TABLE_LIST
        Small code change to not call query_cache_invalidate() twice for transactional tables.
      sql/sql_insert.cc:
        Remove locking argument from mysql_insert()
        Locking type is now stored in TABLE_LIST
        Small code change to not call query_cache_invalidate() twice for transactional tables.
        Don't use bulk insert if bulk_insert_buff_size is 0
      sql/sql_parse.cc:
        Changes to make mysql_change_user() work as close+connect
        Changed command statistics to use statstics_increment to get more speed
        Update code to handle that locks is now stored in TABLE_LIST
      sql/sql_update.cc:
        Remove locking argument from mysql_update()
        Locking type is now stored in TABLE_LIST
        Small code change to not call query_cache_invalidate() twice for transactional tables.
      sql/sql_yacc.yy:
        Locking type is now stored in TABLE_LIST
        Added support for LIMIT # OFFSET # syntax
        Removed some wrong (never true) checks for SQLCOM_MULTI_UPDATE
      mysql-test/t/rpl_replicate_do-slave.opt:
        Changed tables to use t1,t2,...
      mysql-test/t/rpl_replicate_do.test:
        Changed tables to use t1,t2,...
      bd1c2d65
  20. 13 Nov, 2002 1 commit
  21. 12 Nov, 2002 2 commits
    • unknown's avatar
      IGNORE_INDEX fix for 4.0 · e2d1ab84
      unknown authored
      e2d1ab84
    • unknown's avatar
      Extended WEEK() to be able to handle ISO weeks. · e1c1abd0
      unknown authored
      unlink socket file if mysqld dies on startup
      Some optimization of AND expressions
      
      
      mysql-test/r/func_time.result:
        Update for new week() handling
      mysql-test/t/func_time.test:
        Update for new week() handling
      sql/item_cmpfunc.cc:
        Optimization of IF( and-expression,,)
      sql/item_cmpfunc.h:
        Optimization of AND expressions
      sql/item_timefunc.cc:
        Extended WEEK() to be able to handle ISO weeks.
      sql/mysqld.cc:
        unlink socket file if mysqld dies on startup
      sql/sql_base.cc:
        Fixed problem with SIGHUP and INSERT DELAYED
      tests/Makefile.am:
        Added missing myisam-big-rows.tst file to source distribution
      e1c1abd0
  22. 11 Nov, 2002 1 commit
    • unknown's avatar
      Fixed that NULL and 0 returns 0 instead of NULL · 3165440c
      unknown authored
      This is coded to not cause a speed impact on top level AND expressions where we don't care if an AND expression returns 0 or NULL
      
      
      mysql-test/r/bdb.result:
        Fix results after serges last patch
      mysql-test/r/innodb.result:
        Fix results after serges last patch
      mysql-test/r/null.result:
        Update for new AND handling of NULL
      scripts/mysqld_safe.sh:
        Fix 'isroot' test to work even if user is not root
      sql/item.h:
        Fixed that NULL and 0 returns 0 instead of NULL
      sql/item_cmpfunc.cc:
        Fixed that NULL and 0 returns 0 instead of NULL
      sql/item_cmpfunc.h:
        Fixed that NULL and 0 returns 0 instead of NULL
      sql/sql_base.cc:
        Fixed that NULL and 0 returns 0 instead of NULL
      sql/sql_parse.cc:
        Fixed that NULL and 0 returns 0 instead of NULL
      sql/sql_select.cc:
        Fixed that NULL and 0 returns 0 instead of NULL
      sql/sql_yacc.yy:
        Fixed that NULL and 0 returns 0 instead of NULL
      3165440c
  23. 09 Nov, 2002 1 commit
  24. 07 Nov, 2002 3 commits
    • unknown's avatar
      Portability fix extern "C" static -> extern "C" · 8fc4319a
      unknown authored
      client/mysqlbinlog.cc:
        Portability fix
      sql/gen_lex_hash.cc:
        Portability fix
      sql/repl_failsafe.cc:
        Portability fix
      sql/sql_class.cc:
        Portability fix
      sql/sql_udf.cc:
        Portability fix
      sql/mysqld.cc:
        Portability fix
      sql/sql_base.cc:
        Portability fix
      sql/sql_insert.cc:
        Portability fix
      sql/sql_parse.cc:
        Portability fix
      sql/sql_delete.cc:
        Portability fix
      8fc4319a
    • unknown's avatar
      Put temporary files in binlog cache when using BEGIN/COMMIT · 72413e7f
      unknown authored
      Let MySQL 4.0 read 4.1 .frm files without 4.1 specific extensions
      New variables @@rand_seed1 and @@rand_seed2 (used by replication)
      DROP TEMPORARY TABLE
      
      
      mysql-test/r/rpl_log.result:
        Update of results after last replication change
      mysql-test/r/variables.result:
        Test of new variables @@rand_seed1 and @@rand_seed2
      mysql-test/t/variables.test:
        Test of new variables @@rand_seed1 and @@rand_seed2
      sql/field.cc:
        Let MySQL 4.0 read 4.1 .frm files without 4.1 specific extensions
      sql/field.h:
        Let MySQL 4.0 read 4.1 .frm files without 4.1 specific extensions
      sql/item_func.cc:
        Put temporary files in binlog cache when using BEGIN/COMMIT
      sql/log.cc:
        Put temporary files in binlog cache when using BEGIN/COMMIT
        More debug information
      sql/log_event.cc:
        Put temporary files in binlog cache when using BEGIN/COMMIT
      sql/log_event.h:
        Put temporary files in binlog cache when using BEGIN/COMMIT
      sql/set_var.cc:
        Add system variables @@rand_seed1 and @@rand_seed2
      sql/set_var.h:
        Add system variables @@rand_seed1 and @@rand_seed2
      sql/slave.cc:
        Put temporary files in binlog cache when using BEGIN/COMMIT
      sql/sql_acl.cc:
        Put temporary files in binlog cache when using BEGIN/COMMIT
      sql/sql_base.cc:
        Store DROP of temporary tables in binlog cache
      sql/sql_class.h:
        Put temporary files in binlog cache when using BEGIN/COMMIT
      sql/sql_db.cc:
        Put temporary files in binlog cache when using BEGIN/COMMIT
      sql/sql_delete.cc:
        Put temporary files in binlog cache when using BEGIN/COMMIT
      sql/sql_insert.cc:
        Put temporary files in binlog cache when using BEGIN/COMMIT
      sql/sql_lex.h:
        DROP TEMPORARY TABLE
      sql/sql_load.cc:
        Put temporary files in binlog cache when using BEGIN/COMMIT
      sql/sql_parse.cc:
        Put temporary files in binlog cache when using BEGIN/COMMIT
      sql/sql_rename.cc:
        Put temporary files in binlog cache when using BEGIN/COMMIT
      sql/sql_repl.cc:
        Put temporary files in binlog cache when using BEGIN/COMMIT
      sql/sql_repl.h:
        Put temporary files in binlog cache when using BEGIN/COMMIT
      sql/sql_table.cc:
        Put temporary files in binlog cache when using BEGIN/COMMIT
      sql/sql_update.cc:
        Put temporary files in binlog cache when using BEGIN/COMMIT
      sql/sql_yacc.yy:
        DROP TEMPORARY
      sql/table.cc:
        Let MySQL 4.0 read 4.1 .frm files without 4.1 specific extensions
      sql/unireg.cc:
        Let MySQL 4.0 read 4.1 .frm files without 4.1 specific extensions
      72413e7f
    • unknown's avatar
      Portability fixes for Fortre C++ 5.0 (on Sun) in 32 and 64 bit modes. · c88b9102
      unknown authored
      client/mysqlbinlog.cc:
        Portability fix
      configure.in:
        Added use of ASFLAGS (For Solaris with Forte 5.0)
      include/my_global.h:
        Portability fix
      include/myisam.h:
        Portability fix
      include/queues.h:
        Portability fix
      innobase/include/ut0ut.h:
        Portability fix
      innobase/log/log0log.c:
        Portability fix
      innobase/rem/rem0cmp.c:
        Portability fix
      innobase/trx/trx0sys.c:
        Portability fix
      isam/pack_isam.c:
        Portability fix
      myisam/ft_boolean_search.c:
        Portability fix
      myisam/mi_dynrec.c:
        Code change to go around bug in Forte 5.0
      myisam/sort.c:
        Portability fix
      mysys/my_aes.c:
        Portability fix
      scripts/Makefile.am:
        Support for ASFLAGS
      scripts/mysqlbug.sh:
        Support for ASFLAGS
      sql/field.cc:
        Portability fix
      sql/filesort.cc:
        Portability fix
      sql/gen_lex_hash.cc:
        Portability fix
      sql/ha_innodb.cc:
        Portability fix
        Changed SHOW INNODB STATUS to return error instead of writing message to log file.
      sql/ha_isammrg.cc:
        Portability fix
      sql/ha_myisam.cc:
        Portability fix
      sql/ha_myisammrg.cc:
        Portability fix
      sql/hash_filo.h:
        Portability fix
      sql/hostname.cc:
        Portability fix
      sql/item_cmpfunc.h:
        Indentation change
      sql/item_func.cc:
        Portability fix
      sql/item_func.h:
        Portability fix
      sql/log.cc:
        Portability fix
      sql/log_event.cc:
        Portability fix
      sql/mysql_priv.h:
        Portability fix
      sql/mysqld.cc:
        Portability fix
        Fixed bug with rpl_recovery_rank command line option on 64 bit systems
      sql/opt_range.cc:
        Portability fix
      sql/repl_failsafe.cc:
        Portability fix
      sql/slave.cc:
        Portability fix
      sql/slave.h:
        Portability fix
      sql/sql_acl.cc:
        Portability fix
      sql/sql_base.cc:
        Portability fix
      sql/sql_cache.cc:
        Portability fix
      sql/sql_cache.h:
        Portability fix
      sql/sql_class.cc:
        Portability fix
      sql/sql_delete.cc:
        Portability fix
      sql/sql_insert.cc:
        Portability fix
      sql/sql_manager.cc:
        Portability fix
      sql/sql_parse.cc:
        Portability fix
      BUILD/compile-solaris-sparc-forte:
        C
      sql/sql_udf.cc:
        Portability fix
      sql/sql_update.cc:
        Portability fix
      strings/Makefile.am:
        Portability fix
      strings/bmove_upp-sparc.s:
        Fix so that this works on 32 and 64 bit sparcs
      strings/str_test.c:
        Cleanup
      strings/strappend-sparc.s:
        Fix so that this works on 32 and 64 bit sparcs
      strings/strend-sparc.s:
        Fix so that this works on 32 and 64 bit sparcs
      strings/strmake-sparc.s:
        Fix so that this works on 32 and 64 bit sparcs
      strings/strmov-sparc.s:
        Fix so that this works on 32 and 64 bit sparcs
      strings/strnmov-sparc.s:
        Fix so that this works on 32 and 64 bit sparcs
      strings/strstr-sparc.s:
        Fix so that this works on 32 and 64 bit sparcs
      strings/strxmov-sparc.s:
        Fixes to make this more portable, but it's still not usable on 64 bit systems :(
      BitKeeper/etc/logging_ok:
        Logging to logging@openlogging.org accepted
      c88b9102
  25. 05 Nov, 2002 1 commit
    • unknown's avatar
      Removed wrong patch to fix DATE BETWEEN TIMESTAMP1 AND TIMESTAMP2 · 841fa6f6
      unknown authored
      Some simple optimizations
      
      
      Docs/manual.texi:
        Updted how binary log works
      mysql-test/mysql-test-run.sh:
        Added usage of --port to mysqltest
      mysql-test/r/func_test.result:
        Moved test of datetime comparison to func_time
      mysql-test/r/func_time.result:
        New test
      mysql-test/t/func_test.test:
        Moved test of datetime comparison to func_time
      mysql-test/t/func_time.test:
        Test of DATE BETWEEN TIMESTAMPS
      sql/field.h:
        Removed wrong patch
      sql/item_cmpfunc.cc:
        Removed wrong patch
        (Need to be fixed by taking into account all arguments to between)
      sql/lock.cc:
        Removed call to current_thd
      sql/set_var.cc:
        Don't show 'socket' variable if sockets are not used
      sql/sql_base.cc:
        Simple optimisation
      841fa6f6
  26. 29 Oct, 2002 1 commit
    • unknown's avatar
      Added back old LARGEFILE handling · ea3ffb9b
      unknown authored
      Fixed reference to freed memory in acl_init()/grant_init()
      Fixed possible memory leak. (Could only happen in very strange circumstances)
      Fixed bug in ALTER TABLE with BDB tables
      Updated mysql-test for valgrind
      
      
      Docs/manual.texi:
        ChangeLog
      acinclude.m4:
        Added back old LARGEFILE handling.
        (Needed to get MySQL to compile on Solaris 2.9 with gcc 3.x)
      configure.in:
        Added back old LARGEFILE handling.
        (Needed to get MySQL to compile on Solaris 2.9 with gcc 3.x)
      libmysqld/lib_sql.cc:
        Fixed reference to freed memory
      mysql-test/mysql-test-run.sh:
        Added option --valgrind
      mysys/Makefile.am:
        Removed warning when doing make
      sql/mysqld.cc:
        Free regexp memory on shutdown.
        read 'des' key files from data directory
        Fixed reference to freed memory in grant_init()
      sql/slave.cc:
        Fixed wrong printf() argument
      sql/sql_acl.cc:
        Fixed reference to freed memory
      sql/sql_acl.h:
        Fixed reference to freed memory
      sql/sql_base.cc:
        Fixed possible memory leak. (Could only happen in very strange circumstances)
      sql/sql_parse.cc:
        Updated arguments to grant_reload()
      sql/sql_table.cc:
        Fixed bug in ALTER TABLE with BDB tables
      sql/sql_yacc.yy:
        memset -> bzero
      ea3ffb9b
  27. 25 Oct, 2002 1 commit
  28. 23 Oct, 2002 1 commit
  29. 21 Sep, 2002 1 commit
    • unknown's avatar
      Change name -> alias in TABLE_LIST. · b804e278
      unknown authored
      Added missing mutex-lock around critical section in GRANT handling.
      
      
      Docs/manual.texi:
        ChangeLog
      sql/lock.cc:
        Change name -> alias in TABLE_LIST.
      sql/slave.cc:
        Change name -> alias in TABLE_LIST.
      sql/sql_acl.cc:
        Added missing mutex-lock around critical section in GRANT handling.
        Changed name -> alias
      sql/sql_base.cc:
        Change name -> alias in TABLE_LIST.
      sql/sql_insert.cc:
        Change name -> alias in TABLE_LIST.
      sql/sql_parse.cc:
        Change name -> alias in TABLE_LIST.
      sql/sql_show.cc:
        Change name -> alias in TABLE_LIST.
      sql/sql_table.cc:
        Change name -> alias in TABLE_LIST.
      sql/sql_udf.cc:
        Change name -> alias in TABLE_LIST.
      sql/table.h:
        Change name -> alias in TABLE_LIST.
      tests/grant.pl:
        Fixed grant test
      b804e278
  30. 20 Sep, 2002 1 commit
    • unknown's avatar
      Changed table_list->name -> table_list->alias to find places where we where... · f631f93e
      unknown authored
      Changed table_list->name -> table_list->alias to find places where we where using alias instead of table_name.
      This should fix some issues where --lower-case-table-names doesn't work properly under windows.
      
      
      client/mysql.cc:
        Added missing sslopt-case.h
      sql/lock.cc:
        Changed table_list->name -> table_list->alias to find places where we where using alias instead of table_name.
      sql/log_event.cc:
        Changed table_list->name -> table_list->alias to find places where we where using alias instead of table_name.
      sql/mysqld.cc:
        Fixed that --ssl and --skip-ssl works
      sql/slave.cc:
        Changed table_list->name -> table_list->alias to find places where we where using alias instead of table_name.
      sql/sql_acl.cc:
        Changed table_list->name -> table_list->alias to find places where we where using alias instead of table_name.
      sql/sql_base.cc:
        Changed table_list->name -> table_list->alias to find places where we where using alias instead of table_name.
      sql/sql_cache.cc:
        Changed table_list->name -> table_list->alias to find places where we where using alias instead of table_name.
      sql/sql_handler.cc:
        Changed table_list->name -> table_list->alias to find places where we where using alias instead of table_name.
      sql/sql_insert.cc:
        Changed table_list->name -> table_list->alias to find places where we where using alias instead of table_name.
      sql/sql_parse.cc:
        Changed table_list->name -> table_list->alias to find places where we where using alias instead of table_name.
      sql/sql_show.cc:
        Changed table_list->name -> table_list->alias to find places where we where using alias instead of table_name.
      sql/sql_table.cc:
        Changed table_list->name -> table_list->alias to find places where we where using alias instead of table_name.
      sql/sql_udf.cc:
        Changed table_list->name -> table_list->alias to find places where we where using alias instead of table_name.
      sql/sql_union.cc:
        Changed table_list->name -> table_list->alias to find places where we where using alias instead of table_name.
      sql/sql_yacc.yy:
        Changed table_list->name -> table_list->alias to find places where we where using alias instead of table_name.
      sql/table.h:
        Changed table_list->name -> table_list->alias to find places where we where using alias instead of table_name.
      f631f93e
  31. 05 Sep, 2002 1 commit
    • unknown's avatar
      Fixed searching after ssl directories. · 8f2482d2
      unknown authored
      Fixed that GRANT ... REQUIRE options are not forgot when doing new GRANT
      Changed fn_ext to point at first '.' after directory.
      FLUSH LOGS removed numerical extension for all future update logs.
      Fixed the mysqld --help reports right values for --datadir and --bind-address
      --log-binary=a.b.c now properly strips of .b.c
      Fix that one can DROP UDF functions that was not loaded at startup
      Made AND optional in REQUIRE
      Added REQUIRE NONE
      
      
      BitKeeper/deleted/.del-CodingStyle~1ba7ff62d4cd0ea:
        Delete: vio/docs/CodingStyle
      BitKeeper/deleted/.del-COPYING.dbug~ca0c017a4d7e8609:
        Delete: vio/docs/COPYING.dbug
      BitKeeper/deleted/.del-COPYING.mysql~471498c82977cd3a:
        Delete: vio/docs/COPYING.mysql
      BitKeeper/deleted/.del-README~947354991dc882f8:
        Delete: vio/docs/README
      Docs/manual.texi:
        Changelog
      acinclude.m4:
        Fixed searching after ssl directories.
      client/Makefile.am:
        Moved openssl include to avoid problem with installed readline
      include/Makefile.am:
        Install my_global.h
      include/violite.h:
        Fixed that GRANT ... REQUIRE options are not forgot when doing new grant
      libmysqld/examples/Makefile.am:
        Moved openssl include to avoid problem with installed readline
      mysql-test/mysql-test-run.sh:
        Improved 'which' handling to give error if command is not found
      mysys/mf_fn_ext.c:
        Changed fn_ext to point at first '.' after directory.
      sql/Makefile.am:
        More comments
      sql/lex.h:
        Added NONE as keyword
      sql/log.cc:
        FLUSH LOGS removed numerical extension for all future update logs.
        Simple code cleanup
      sql/mysqld.cc:
        Fixed the --help reports right values for --datadir and --bind-address
        --log-binary=a.b.c now properly strips of .b.c
        Removed option --skip-external-locking (not needed as this is automatic)
      sql/repl_failsafe.cc:
        Moved some common THD initalization to store_globals()
      sql/slave.cc:
        Moved openssl include to avoid problem with installed readline
      sql/sql_acl.cc:
        Moved openssl include to avoid problem with installed readline
      sql/sql_acl.h:
        Updated function prototypes
      sql/sql_base.cc:
        Added comment
      sql/sql_class.cc:
        Moved openssl include to avoid problem with installed readline.
        Changed THD::thd to make things work for main thread.
      sql/sql_class.h:
        Fixed wrongly removed line (fixes compiler problem on MacOSX)
      sql/sql_insert.cc:
        Moved openssl include to avoid problem with installed readline
      sql/sql_lex.cc:
        Moved save_to_cache_query=0 to udf detection function to make sql_yacc.yy simpler
      sql/sql_lex.h:
        Indentation cleanup
      sql/sql_parse.cc:
        Moved openssl include to avoid problem with installed readline.
        Added THD argument to acl_reload()
      sql/sql_repl.h:
        Made opt_bin_logname static
      sql/sql_udf.cc:
        Fix that one can DROP UDF functions that was not loaded at startup
      sql/sql_yacc.yy:
        made AND optional in REQUIRE
        Added REQUIRE NONE
        Fixed that old SSL options are not forgotten when doing new GRANT.
      sql/udf_example.cc:
        Improved comments
      8f2482d2
  32. 03 Sep, 2002 3 commits
    • unknown's avatar
      a fix for a bug with all_fields.elements not being changed by · bdf91563
      unknown authored
      expansion of the wildcards
      
      
      bdf91563
    • unknown's avatar
      Fixed bug introduces by last changeset · 3307f955
      unknown authored
      (Fixing of problem with ALTER TABLE on BDB tables)
      
      
      mysql-test/r/distinct.result:
        Fixed results after bug fix
      sql/mysql_priv.h:
        Split close_thread_tables() into two functions.
        (Needed for bug fix from 4.0)
      sql/sql_base.cc:
        Split close_thread_tables() into two functions.
        (Needed for bug fix from 4.0)
      3307f955
    • unknown's avatar
      Some trivial optimzations · 0f2ab68c
      unknown authored
      Check if AND/OR expression can be NULL; Fixed bug in GROUP BY and-or-expression where expression could be NULL
      Bug fix for SHOW OPEN TABLES when user didn't have privilege to access all open tables.
      Better fix for ALTER TABLE on BDB tables.
      
      
      Docs/manual.texi:
        Changelog
      client/mysql.cc:
        Simple optimization
      libmysql/libmysql.c:
        Removed initialization of varibles that are already set to zero
      myisam/myisamchk.c:
        Fixed comment for extend-check
      mysql-test/r/bdb-alter-table-1.result:
        Updated results
      mysql-test/r/bdb-alter-table-2.result:
        Updated results
      mysql-test/r/distinct.result:
        Updated results after bug fix
      mysql-test/r/handler.result:
        Updated results
      mysql-test/r/innodb_handler.result:
        Updated results
      mysql-test/r/select.result:
        Updated results
      mysql-test/r/varbinary.result:
        Updated results
      mysql-test/t/bdb-alter-table-1.test:
        Added comments
      mysql-test/t/bdb-alter-table-2.test:
        Added comments
      mysql-test/t/select.test:
        Remove OPTION in SET OPTION
        Added tests for ORDER BY key LIMIT
      sql/item_cmpfunc.cc:
        Check if AND/OR expression can be NULL
      sql/mysqld.cc:
        mysqld --help now shows value of datadir
      sql/share/english/errmsg.txt:
        Better error message for syntax error
      sql/sql_base.cc:
        Bug fix for SHOW OPEN TABLES
      sql/sql_class.cc:
        Moved virtual function to .cc file to avoid that we have to include assert.h everywhere.
      sql/sql_class.h:
        Moved virtual function to .cc file to avoid that we have to include assert.h everywhere.
      sql/sql_parse.cc:
        Removed old dead code from 3.23
      sql/sql_select.cc:
        Improved optimization of ORDER BY key LIMIT
      sql/sql_table.cc:
        More comments,
        Better fix for ALTER TABLE on BDB tables.
      0f2ab68c