1. 24 May, 2003 1 commit
    • unknown's avatar
      Fix for bug #490 and #491 (see details below) · 3132a4cd
      unknown authored
      mysql-test/r/insert_select.result:
        Result update.
      mysql-test/r/rpl_insert_id.result:
        Test update
      mysql-test/t/insert_select.test:
        Check if a partly completed INSERT SELECT (failing because of "Duplicate key"
        after successfully inserting other rows) is written to the binlog if the
        table is not transactional and at least one row has been inserted (bug #491)
      mysql-test/t/rpl_insert_id.test:
        Test for bug #490 (INSERT SELECT in auto_increment)
      sql/sql_insert.cc:
        - In INSERT ... SELECT, if it fails with error but one row has been inserted and
        the table is not transactional, we must write to the binlog (the slave will stop
        because of the error code in the binlog event, this is normal). bug 491.
        - we must set INSERT_ID before writing to the binlog (bug 490
        accidentally introduced by another dev in 4.0.13).
      3132a4cd
  2. 13 May, 2003 1 commit
    • unknown's avatar
      Fix for UNION and LEFT JOIN (Bug #386) · 61b80c33
      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
      61b80c33
  3. 27 Apr, 2003 1 commit
    • unknown's avatar
      Fixed problem when comparing a key for a multi-byte-character set. (bug 152) · dd089517
      unknown authored
      Use 0x.... as strings if 'new' mode. (bug 152)
      Don't report -max on windows when InnoDB is enabled. (bug 332)
      Reset current_linfo;  This could cause a hang when doing PURGE LOGS.
      Fix for row numbers in EXPLAIN (bug 322)
       Fix that USE_FRM works for all table types (bug 97)
      
      
      VC++Files/libmysql/libmysql.dsp:
        Added new source files
      myisam/mi_key.c:
        Fixed problem when comparing a key for a multi-byte-character set.
      myisam/mi_range.c:
        Fixed problem when comparing a key for a multi-byte-character set.
      myisam/mi_rkey.c:
        Fixed problem when comparing a key for a multi-byte-character set.
      myisam/mi_search.c:
        Fixed problem when comparing a key for a multi-byte-character set.
      myisam/mi_test2.c:
        Fixed printf statements
      myisam/myisamdef.h:
        Fixed problem when comparing a key for a multi-byte-character set.
      myisam/sort.c:
        Fixed printf statements
      mysql-test/r/ctype_latin1_de.result:
        New test results
      mysql-test/r/join.result:
        New test results
      mysql-test/r/repair.result:
        New test results
      mysql-test/r/rpl_alter.result:
        New test results
      mysql-test/t/ctype_latin1_de-master.opt:
        --new is needed to get 0x... strings to work properly
      mysql-test/t/ctype_latin1_de.test:
        New test for latin1_de
      mysql-test/t/repair.test:
        Test of USE_FRM and HEAP tables
      sql/field.cc:
        Fixed problem when comparing a key for a multi-byte-character set.
      sql/item.cc:
        Use 0x.... as strings if 'new' mode
      sql/item.h:
        Use 0x.... as strings if 'new' mode
      sql/mysqld.cc:
        Don't report -max on windows when InnoDB is enabled.
      sql/sql_analyse.cc:
        Removed unused variable
      sql/sql_insert.cc:
        Removed debug message
      sql/sql_repl.cc:
        Reset current_linfo;  This could cause a hang when doing PURGE LOGS.
      sql/sql_select.cc:
        Fix for row numbers in EXPLAIN
      sql/sql_table.cc:
        Fix that USE_FRM works for all table types (without strange errors)
      sql/sql_yacc.yy:
        Removed compiler warnings.
      dd089517
  4. 26 Apr, 2003 2 commits
    • unknown's avatar
      Fix for -fbranch-probabilites (bug 268) · 570158b0
      unknown authored
      Fix for LEFT/RIGHT/MID with multi-byte-character sets (bug 314)
      Fix for new bison 1.875
      max_insert_delayed_threads and delayed_insert_timeout now works as documented (bug 211)
      Don't show port in SHOW PROCESSLIST for system threads
      Fix problem with ORDER BY being discarded for some DISTINCT queries (bug 275)
      Fixed bug with NATURAL LEFT JOIN, NATURAL RIGHT JOIN and RIGHT JOIN when
      using many joined tables (Bug 212)
      
      
      acinclude.m4:
        Fix for -fbranch-probabilites
      configure.in:
        Fix for -fbranch-probabilites
      myisam/mi_open.c:
        Give error instead of writing to stderr (Which user can't see)
      mysql-test/r/join.result:
        Update results after change to NATURAL/LEFT/RIGHT JOIN
      mysql-test/r/join_outer.result:
        Update results after change to NATURAL/LEFT/RIGHT JOIN
      mysql-test/r/select.result:
        Update results after change to NATURAL/LEFT/RIGHT JOIN
      mysql-test/t/join.test:
        Update results after change to NATURAL/LEFT/RIGHT JOIN
      sql/item_strfunc.cc:
        Fix for LEFT/RIGHT/MID with multi-byte-character sets
      sql/mysqld.cc:
        Fix for new bison 1.875 (Wrong error text message when one got syntax error)
      sql/sql_class.cc:
        Don't show port in SHOW PROCESSLIST for system threads
      sql/sql_insert.cc:
        max_insert_delayed_threads now works as documented.
        delayed_insert_timeout now works on Linux
      sql/sql_parse.cc:
        Added comment
      sql/sql_select.cc:
        Fix problem with ORDER BY being discarded and results returned un-sorted
      sql/sql_yacc.yy:
        Fixed bug with NATURAL LEFT JOIN, NATURAL RIGHT JOIN and RIGHT JOIN when
        using many joined tables.
      570158b0
    • unknown's avatar
      fixed incorrect number of affected rows in REPLACE...SELECT... (bug 130) · 0cc3d2e6
      unknown authored
      sql/sql_insert.cc:
        fixed incorrect number of affected rows in REPLACE...SELECT...
      BitKeeper/etc/logging_ok:
        Logging to logging@openlogging.org accepted
      0cc3d2e6
  5. 16 Mar, 2003 1 commit
  6. 12 Mar, 2003 1 commit
  7. 09 Mar, 2003 1 commit
  8. 06 Mar, 2003 2 commits
  9. 27 Feb, 2003 1 commit
    • unknown's avatar
      Added detection if pthread_attr_getstacksize() exists · ab1f1e19
      unknown authored
      Fixed bug in RAND() usage in mysqlbinlog
      
      
      configure.in:
        Added detection if pthread_attr_getstacksize() exists
      include/thr_lock.h:
        Fixed wrong comment
      sql/log_event.cc:
        Fixed bug in RAND() usage in mysqlbinlog
      sql/mysqld.cc:
        Portablity fix
      sql/repl_failsafe.cc:
        Set host_or_ip for system threads (to make other code simpler)
      sql/slave.cc:
        Set host_or_ip for system threads (to make other code simpler)
      sql/sql_class.cc:
        Set host_or_ip for system threads (to make other code simpler)
      sql/sql_insert.cc:
        Set host_or_ip for system threads (to make other code simpler)
      sql/sql_show.cc:
        Set host_or_ip for system threads (to make other code simpler)
      ab1f1e19
  10. 28 Jan, 2003 1 commit
    • unknown's avatar
      Fixes for Netware · 8c613c2c
      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_pthr...
      8c613c2c
  11. 14 Dec, 2002 1 commit
    • unknown's avatar
      Transactions in AUTOCOMMIT=0 mode didn't rotate binary log · 3bf84777
      unknown authored
      Don't enable any bulk insert or record caching code if inserting less than MIN_ROWS_TO_USE_BULK_INSERT rows (100)
      
      
      myisam/mi_check.c:
        Fixed bug in copying statistics for disabled index
      mysql-test/r/distinct.result:
        Fix result after not doing key statistics for first insert.
      mysql-test/r/fulltext.result:
        Fix result after not doing key statistics for first insert.
      mysql-test/r/insert.result:
        Fix result after not doing key statistics for first insert.
      mysql-test/r/key_diff.result:
        Fix result after not doing key statistics for first insert.
      mysql-test/r/order_by.result:
        Fix result after not doing key statistics for first insert.
      mysql-test/r/select.result:
        Fix result after not doing key statistics for first insert.
      mysql-test/r/show_check.result:
        Fix result after not doing key statistics for first insert.
      sql/ha_myisam.cc:
        Don't disable index when inserting only a few rows
      sql/log.cc:
        Transactions in AUTOCOMMIT=0 mode didn't rotate binary log.
      sql/sql_insert.cc:
        Don't enable any bulk insert or record caching code if inserting less than MIN_ROWS_TO_USE_BULK_INSERT
      3bf84777
  12. 07 Dec, 2002 1 commit
    • unknown's avatar
      bulk insert code optimized · f7604940
      unknown authored
      mysql-test/r/distinct.result:
        updated
      mysql-test/r/fulltext.result:
        updated
      mysql-test/r/select.result:
        updated
      mysql-test/r/show_check.result:
        updated
      mysql-test/t/insert.test:
        updated
      f7604940
  13. 29 Nov, 2002 1 commit
    • unknown's avatar
      New multi-table-update code · 7908c8d4
      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
      7908c8d4
  14. 21 Nov, 2002 1 commit
    • unknown's avatar
      fixed invalidation of query cache · 51828aa9
      unknown authored
      excluded double call of 'invalidate()'
      
      
      mysql-test/r/innodb_cache.result:
        test of invalidation
      mysql-test/t/innodb_cache.test:
        test of invalidation
      sql/handler.cc:
        excluded double call of 'invalidate()'
      sql/sql_delete.cc:
        fixed invalidation of query cache
      sql/sql_insert.cc:
        fixed invalidation of query cache
      sql/sql_update.cc:
        fixed invalidation of query cache
      51828aa9
  15. 20 Nov, 2002 1 commit
    • unknown's avatar
      Try to optimize the cache buffer size needed for bulk_insert · 61eb4ca1
      unknown authored
      Fix for shutdown on Mac OS X
      
      
      include/my_tree.h:
        Try to optimize the cache buffer size needed for bulk_insert
      myisam/mi_write.c:
        Try to optimize the cache buffer size needed for bulk_insert
      mysql-test/r/bdb.result:
        Make test repeatable
      mysql-test/t/bdb.test:
        Make test repeatable
      mysys/tree.c:
        Try to optimize the cache buffer size needed for bulk_insert
      sql/mysql_priv.h:
        Small optimization
      sql/mysqld.cc:
        Fix for shutdown on Mac OS X
      sql/sql_insert.cc:
        Try to optimize the cache buffer size needed for bulk_insert
      sql/sql_yacc.yy:
        Call thd->strmake() instead of sql_strmake()
      sql/table.cc:
        Try to optimize the cache buffer size needed for bulk_insert
      sql/table.h:
        Try to optimize the cache buffer size needed for bulk_insert
      61eb4ca1
  16. 16 Nov, 2002 1 commit
    • unknown's avatar
      Small improvement to alloc_root · f39f794d
      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 ...
      f39f794d
  17. 07 Nov, 2002 4 commits
    • unknown's avatar
      76b9e0b8
    • unknown's avatar
      Portability fix extern "C" static -> extern "C" · 74baca84
      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
      74baca84
    • unknown's avatar
      Put temporary files in binlog cache when using BEGIN/COMMIT · 4952de9f
      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
      4952de9f
    • unknown's avatar
      Portability fixes for Fortre C++ 5.0 (on Sun) in 32 and 64 bit modes. · 099974b5
      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 fi...
      099974b5
  18. 21 Sep, 2002 1 commit
    • unknown's avatar
      Change name -> alias in TABLE_LIST. · ada4f591
      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
      ada4f591
  19. 20 Sep, 2002 1 commit
    • unknown's avatar
      Changed table_list->name -> table_list->alias to find places where we where... · 0d2a457f
      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.
      0d2a457f
  20. 18 Sep, 2002 1 commit
    • unknown's avatar
      Added code to flush a bulk_insert index. · 202679d4
      unknown authored
      This fixes a bug when doing multi-row inserts on table with an auto_increment key that is not in the first key segment.
      
      
      Docs/manual.texi:
        Changelog
      include/my_base.h:
        Added code to flush a bulk_insert index
      myisam/mi_extra.c:
        Added code to flush a bulk_insert index
      mysql-test/r/insert.result:
        test of auto_increment and bulk_insert
      mysql-test/t/insert.test:
        test of auto_increment and bulk_insert
      sql/ha_myisam.cc:
        Added code to flush a bulk_insert index
      sql/sql_insert.cc:
        Mark that bulk_insert is used
      sql/sql_load.cc:
        Mark that bulk_insert is used
        Remove duplicated call to initialize bulk insert
      sql/table.h:
        Mark that bulk_insert is used
      vio/viosslfactories.c:
        Remove compiler warning
      202679d4
  21. 05 Sep, 2002 1 commit
    • unknown's avatar
      Fixed searching after ssl directories. · 3ec856ac
      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
      3ec856ac
  22. 22 Aug, 2002 1 commit
    • unknown's avatar
      Fixed bug in wait_for_update() that I had introduced. · 36d7df75
      unknown authored
      Changed option variables to my_bool (to avoid bugs in my_getopt())
      Added new thread specific mutex LOCK_delete to be able to free LOCK_thread_count early.
      Changed usage of LOCK_thread_count -> LOCK_status for statistics variables
      
      
      libmysqld/lib_sql.cc:
        Removed not needed LOCK
      mysql-test/mysql-test-run.sh:
        Log name of running test
      mysql-test/r/rpl_sporadic_master.result:
        Cleaned up test
      mysql-test/t/rpl_sporadic_master.test:
        cleaned up test
      sql/log.cc:
        Cleanup.
        Fixed bug in wait_for_update() that I had introduced.
      sql/mini_client.cc:
        Indentation changes.
      sql/mysql_priv.h:
        Changed option variables to my_bool.
      sql/mysqld.cc:
        Changed option variables to my_bool.
        Removed not used LOCK_server_id
        Minor code cleanups.
      sql/repl_failsafe.cc:
        Minor code cleanups
      sql/slave.cc:
        Minor code cleanups.
        Fixed usage of wait_for_update().
      sql/slave.h:
        Changed option variables to my_bool.
      sql/sql_class.cc:
        Added new thread specific mutex LOCK_delete to be able to free LOCK_thread_count early
      sql/sql_class.h:
        Added new thread specific mutex LOCK_delete to be able to free LOCK_thread_count early
      sql/sql_insert.cc:
        Do broadcast after unlock()
      sql/sql_parse.cc:
        Removed not needed LOCK
        Changed usage of LOCK_thread_count -> LOCK_status for statistics variables
        Changed killing of threads to not lock LOCK_thread_count for long.
      sql/sql_repl.cc:
        Changed options variables to my_bool
        Fixed usage of wait_for_update()
        Fixed loop to kill slaves to not lock LOCK_thread_count for long.
        Code optimization.
      sql/sql_repl.h:
        bool -> my_bool
        Fixed KICK_SLAVE to use LOCK_delete
      36d7df75
  23. 10 Aug, 2002 1 commit
  24. 08 Aug, 2002 1 commit
    • unknown's avatar
      Lots of code fixes to the replication code (especially the binary logging and... · 3a4baab1
      unknown authored
      Lots of code fixes to the replication code (especially the binary logging and index log file handling)
      Fixed bugs in my last changeset that made MySQL hard to compile.
      Added mutex around some data that could cause table cache corruptions when using OPTIMIZE TABLE / REPAIR TABLE or automatic repair of MyISAM tables.
      Added mutex around some data in the slave start/stop code that could cause THD linked list corruptions
      Extended my_chsize() to allow one to specify a filler character.
      Extend vio_blocking to return the old state (This made some usage of this function much simpler)
      Added testing for some functions that they caller have got the required mutexes before calling the function.
      Use setrlimit() to ensure that we can write core file if one specifies --core-file.
      Added --slave-compressed-protocol
      Made 2 the minimum length for ft_min_word_len
      Added variables foreign_key_checks & unique_checks.
      Less logging from replication code (if not started with --log-warnings)
      Changed that SHOW INNODB STATUS requre the SUPER privilege
      More DBUG statements and a lot of new code comments
      
      
      BitKeeper/deleted/.del-rpl_compat.result~c950bc346b12c61a:
        Delete: mysql-test/r/rpl_compat.result
      BitKeeper/deleted/.del-rpl_compat.test~5f6ba955e02aa95f:
        Delete: mysql-test/t/rpl_compat.test
      Docs/manual.texi:
        Updated manual with fixes in this changeset
      client/mysqltest.c:
        Indentation cleanup
        Better error messages for some error conditions.
      include/my_pthread.h:
        Added 'safe_mutex_assert_owner()' to check that the thread really owns the mutex.
      include/my_sys.h:
        Extended my_chsize() to allow one to specify a filler character.
        (For MySQL index logs)
      include/raid.h:
        New my_chsize()
      include/violite.h:
        Extend vio_blocking to return the old state
      innobase/include/dyn0dyn.h:
        Merge with 3.23 (AIX DYN_ARRAY_DATA_SIZE)
      innobase/include/dyn0dyn.ic:
        Merge with 3.23
      isam/create.c:
        Fix for new my_chsize()
      isam/isamchk.c:
        Fix for new my_chsize()
      isam/pack_isam.c:
        Fix for new my_chsize()
      libmysql/manager.c:
        Fix for new vio_blocking()
      libmysqld/lib_sql.cc:
        Fix for new open_log()
      myisam/mi_cache.c:
        Fix typo from previous checking
      myisam/mi_check.c:
        Fix for new my_chsize()
      myisam/mi_create.c:
        Fix for new my_chsize()
      myisam/mi_delete_all.c:
        Fix for new my_chsize()
      myisam/myisampack.c:
        Fix for new my_chsize()
      mysql-test/include/master-slave.inc:
        Better initialization for replication tests
      mysql-test/mysql-test-run.sh:
        Added option --log-warnings
      mysql-test/r/insert.result:
        More tests if INSERT ...(DEFAULT)
      mysql-test/r/rpl000001.result:
        Clean up tests for new master-slave.inc
        Remove 'use database'
      mysql-test/r/rpl000002.result:
        Clean up tests for new master-slave.inc
        Remove 'use database'
      mysql-test/r/rpl000003.result:
        Clean up tests for new master-slave.inc
        Remove 'use database'
      mysql-test/r/rpl000004.result:
        Clean up tests for new master-slave.inc
        Remove 'use database'
      mysql-test/r/rpl000005.result:
        Clean up tests for new master-slave.inc
        Remove 'use database'
      mysql-test/r/rpl000006.result:
        Clean up tests for new master-slave.inc
        Remove 'use database'
      mysql-test/r/rpl000007.result:
        Clean up tests for new master-slave.inc
        Remove 'use database'
      mysql-test/r/rpl000008.result:
        Clean up tests for new master-slave.inc
        Remove 'use database'
      mysql-test/r/rpl000009.result:
        Clean up tests for new master-slave.inc
        Remove 'use database'
      mysql-test/r/rpl000010.result:
        Clean up tests for new master-slave.inc
        Remove 'use database'
      mysql-test/r/rpl000011.result:
        Clean up tests for new master-slave.inc
        Remove 'use database'
      mysql-test/r/rpl000012.result:
        Clean up tests for new master-slave.inc
        Remove 'use database'
      mysql-test/r/rpl000013.result:
        Clean up tests for new master-slave.inc
        Remove 'use database'
      mysql-test/r/rpl000014.result:
        Clean up tests for new master-slave.inc
        Remove 'use database'
      mysql-test/r/rpl_alter.result:
        Clean up tests for new master-slave.inc
        Remove 'use database'
      mysql-test/r/rpl_empty_master_crash.result:
        Clean up tests for new master-slave.inc
        Remove 'use database'
      mysql-test/r/rpl_get_lock.result:
        Clean up tests for new master-slave.inc
        Remove 'use database'
      mysql-test/r/rpl_log.result:
        Clean up tests for new master-slave.inc
        Remove 'use database'
      mysql-test/r/rpl_magic.result:
        Clean up tests for new master-slave.inc
        Remove 'use database'
      mysql-test/r/rpl_mystery22.result:
        Clean up tests for new master-slave.inc
        Remove 'use database'
      mysql-test/r/rpl_skip_error.result:
        Clean up tests for new master-slave.inc
        Remove 'use database'
      mysql-test/r/rpl_sporadic_master.result:
        Clean up tests for new master-slave.inc
        Remove 'use database'
      mysql-test/t/insert.test:
        More tests if INSERT ...(DEFAULT)
      mysql-test/t/rpl000001.test:
        Clean up tests for new master-slave.inc
        Remove 'use database'
      mysql-test/t/rpl000002.test:
        Clean up tests for new master-slave.inc
        Remove 'use database'
      mysql-test/t/rpl000003.test:
        Clean up tests for new master-slave.inc
        Remove 'use database'
      mysql-test/t/rpl000004.test:
        Clean up tests for new master-slave.inc
        Remove 'use database'
      mysql-test/t/rpl000005.test:
        Clean up tests for new master-slave.inc
        Remove 'use database'
      mysql-test/t/rpl000006.test:
        Clean up tests for new master-slave.inc
        Remove 'use database'
      mysql-test/t/rpl000007.test:
        Clean up tests for new master-slave.inc
        Remove 'use database'
      mysql-test/t/rpl000009.test:
        Clean up tests for new master-slave.inc
        Remove 'use database'
      mysql-test/t/rpl000011.test:
        Clean up tests for new master-slave.inc
        Remove 'use database'
      mysql-test/t/rpl000013.test:
        Clean up tests for new master-slave.inc
        Remove 'use database'
      mysql-test/t/rpl000014.test:
        Clean up tests for new master-slave.inc
        Remove 'use database'
      mysql-test/t/rpl_alter.test:
        Clean up tests for new master-slave.inc
        Remove 'use database'
      mysql-test/t/rpl_empty_master_crash.test:
        Clean up tests for new master-slave.inc
        Remove 'use database'
      mysql-test/t/rpl_get_lock.test:
        Clean up tests for new master-slave.inc
        Remove 'use database'
      mysql-test/t/rpl_magic.test:
        Clean up tests for new master-slave.inc
        Remove 'use database'
      mysql-test/t/rpl_mystery22.test:
        Clean up tests for new master-slave.inc
        Remove 'use database'
      mysql-test/t/rpl_skip_error.test:
        Clean up tests for new master-slave.inc
        Remove 'use database'
      mysql-test/t/rpl_sporadic_master.test:
        Clean up tests for new master-slave.inc
        Remove 'use database'
      mysys/mf_iocache.c:
        More debug info
        Force seek after reinit_io_cache()
      mysys/mf_iocache2.c:
        Added my_b_filelength()
      mysys/my_chsize.c:
        Extended my_chsize() to allow one to specify a filler character.
        (For MySQL index logs)
      mysys/raid.cc:
        Extended my_chsize() to allow one to specify a filler character.
        (For MySQL index logs)
      sql/field.h:
        Fix for INSERT ... (DEFAULT)
      sql/ha_berkeley.h:
        Fix for dynamic variables
      sql/ha_innodb.cc:
        Change sprintf() to my_sprintf() to make code portable.
        Fix after sync with 3.23
        (We still need to fix the storage of the replication position in innodb)
      sql/ha_innodb.h:
        Fix for dynamic variables
      sql/handler.cc:
        Remove writting of COMMIT to the binary log.
        (Now done in MYSQL_LOG::write())
      sql/item_func.cc:
        Query_log_event() now always takes query length.
      sql/item_func.h:
        Indentation cleanup
      sql/item_strfunc.h:
        Indentation cleanup
      sql/item_timefunc.h:
        Indentation cleanup
      sql/lock.cc:
        Check that we own critical mutexes.
      sql/log.cc:
        Big code cleanup / rewrite / optimize.
        - The index log file has its own IO_CACHE object.
        - Many functions totally rewritten to make them smaller and faster.
        - New handling of index log files
        - Lots of new comments
      sql/log_event.cc:
        Code cleanup
        New comments
      sql/log_event.h:
        Query_log_event() now always takes query length.
      sql/mini_client.cc:
        Better error messages on reconnect.
        Fixed wrong variable usage from last commit.
      sql/mysql_priv.h:
        New arguments to open_log()
      sql/mysqld.cc:
        Use setrlimit() to ensure that we can write core file if one specifies --core-file
        Added index file name as parameter to openlog().
        Added --slave-compressed-protocol
        Made 2 the minimum length for ft_min_word_len
      sql/net_serv.cc:
        Use new vio_blocking()
        (The vio_blocking() change was done to make this code more readable)
      sql/repl_failsafe.cc:
        Minor code cleanup
      sql/set_var.cc:
        Added variables slave_compressed_protocol, foreign_key_checks & unique_checks.
      sql/set_var.h:
        Generalization
      sql/slave.cc:
        Code cleanup & rewrite.
        Dont call SELECT VERSION() on check_master_version()
        New init_slave() code.
        Ensure that all threads create a THD early.
        Add locks around manipulation of critical structures
        Don't retry a command more than master_retry_count times.
        Write less warnings to the log file (if not started with --log-warnings)
        Faster flush_relay_log_info()
      sql/slave.h:
        More comments
        Added new arguments to some functions.
      sql/sql_acl.cc:
        More DBUG info
        New parameter to Query_log_event()
      sql/sql_base.cc:
        Added some mutex checking.
      sql/sql_cache.cc:
        Less not critical debug info
      sql/sql_class.h:
        Fix for new log handling.
      sql/sql_db.cc:
        Added mutex around remove_db_from_cache()
      sql/sql_delete.cc:
        Added missing parameters to changed functions
      sql/sql_insert.cc:
        Added missing parameters to changed functions
      sql/sql_parse.cc:
        Do an 'end_active_trans()' before 'load_master_data'
        Changed that SHOW INNODB STATUS requre the SUPER privilege
        Added new function parameters to new functions
      sql/sql_rename.cc:
        Added missing parameters to changed functions
      sql/sql_repl.cc:
        Code cleanups / new comments
        Fix for new find_first_log() calling standard.
        More DBUG statements.
        Show binlogs updated to use new IO_CACHE:d index log file.
      sql/sql_repl.h:
        New function arguments
      sql/sql_select.cc:
        Indentation changes
      sql/sql_table.cc:
        Added missing parameters to changed functions
        Added checking of mutex
        Added mutex around critical regions.
      sql/sql_test.cc:
        Don't use THR_ALARM if the configuration doesn't support it.
      sql/sql_update.cc:
        Added missing parameters to changed functions
      sql/table.cc:
        Added missing parameters to changed functions
      vio/vio.c:
        Extend vio_blocking to return the old state
      vio/viosocket.c:
        Extend vio_blocking to return the old state
      vio/viossl.c:
        Extend vio_blocking to return the old state
      3a4baab1
  25. 05 Aug, 2002 1 commit
    • unknown's avatar
      Added some missing mutex_locks() when manipulating the table cache. · 5bdd5664
      unknown authored
      This should fix some possible table cache corruptions when doing
      OPTIMIZE or REPAIR table when other threads are opening new tables.
      
      
      sql/sql_base.cc:
        Added missing mutex unlock on error condition
      sql/sql_insert.cc:
        Added TODO item
      sql/sql_show.cc:
        Added missing pthread_mutex_lock(&LOCK_open) when calling
        query_table_status().
      sql/sql_table.cc:
        Added missing pthread_mutex_lock(&LOCK_open) when calling
        hash_delete(), unlock_table_name() and remove_table_from_cache().
      BitKeeper/etc/logging_ok:
        Logging to logging@openlogging.org accepted
      5bdd5664
  26. 24 Jul, 2002 2 commits
    • unknown's avatar
      INSERT ... VALUES(DEFAULT) · a5b1ccda
      unknown authored
      BitKeeper/deleted/.del-insert_set.test~35be5a761a410ac1:
        Delete: mysql-test/t/insert_set.test
      BitKeeper/deleted/.del-insert_set.result~fca5025db098c892:
        Delete: mysql-test/r/insert_set.result
      Docs/manual.texi:
        Changelog
      mysql-test/r/insert.result:
        Test new insert ... (DEFAULT)
      mysql-test/t/insert.test:
        Test new insert ... (DEFAULT)
      sql/item.cc:
        Indentation cleanup
      a5b1ccda
    • unknown's avatar
      Removed wrong implementation of CUBE/ROLLUP · 0862707d
      unknown authored
      Fixed bugfix of INSERT ... SET db_name.table_name.column_name
      Changed locking to external-locking
      Fix client hangup for some invalid SQL queries.
      
      
      Docs/manual.texi:
        Changelog & recent incompatible changes to 4.0.3
      include/mysqld_error.h:
        New error messages
      myisam/ft_boolean_search.c:
        Removed compiler warning
      myisam/mi_check.c:
        Change mi_fix_rec_buff_for_blob to mi_alloc_rec_buff
      myisam/mi_dynrec.c:
        Change mi_fix_rec_buff_for_blob to mi_alloc_rec_buff
      myisam/mi_extra.c:
        Change mi_fix_rec_buff_for_blob to mi_alloc_rec_buff
      myisam/mi_key.c:
        Change mi_fix_rec_buff_for_blob to mi_alloc_rec_buff
      myisam/mi_open.c:
        Change mi_fix_rec_buff_for_blob to mi_alloc_rec_buff
      myisam/mi_packrec.c:
        Change mi_fix_rec_buff_for_blob to mi_alloc_rec_buff
      myisam/myisamdef.h:
        Change mi_fix_rec_buff_for_blob to mi_alloc_rec_buff
      myisam/sort.c:
        Fixed uninitialized variable
      mysql-test/r/insert_set.result:
        Change test case to use database foo
      mysql-test/r/union.result:
        Test wrong usage of union
      mysql-test/t/insert_set.test:
        Test bug in insert
      mysql-test/t/union.test:
        Test wrong usage of union
      sql/item.h:
        Indentation cleanup
      sql/item_cmpfunc.h:
        Indentation cleanup
      sql/item_func.h:
        Indentation cleanup
      sql/item_strfunc.h:
        Indentation cleanup
      sql/item_sum.h:
        Indentation cleanup
      sql/item_timefunc.h:
        Indentation cleanup
      sql/item_uniq.h:
        Indentation cleanup
      sql/mysql_priv.h:
        Fix that we always generate an error message when calling YYABORT
      sql/mysqld.cc:
        Changed command line arguments regarding locking to always use --external-locking
        Disable external locking by default
      sql/procedure.h:
        Cleanup
      sql/set_var.cc:
        change locking -> external_locking
      sql/share/czech/errmsg.txt:
        New error messages
      sql/share/danish/errmsg.txt:
        New error messages
      sql/share/dutch/errmsg.txt:
        New error messages
      sql/share/english/errmsg.txt:
        New error messages
      sql/share/estonian/errmsg.txt:
        New error messages
      sql/share/french/errmsg.txt:
        New error messages
      sql/share/german/errmsg.txt:
        New error messages
      sql/share/greek/errmsg.txt:
        New error messages
      sql/share/hungarian/errmsg.txt:
        New error messages
      sql/share/italian/errmsg.txt:
        New error messages
      sql/share/japanese/errmsg.txt:
        New error messages
      sql/share/korean/errmsg.txt:
        New error messages
      mysql-test/r/olap.result:
        Removed CUBE/ROLLUP
      mysql-test/t/olap.test:
        Removed CUBE/ROLLUP
      sql/share/norwegian-ny/errmsg.txt:
        New error messages
      sql/share/norwegian/errmsg.txt:
        New error messages
      sql/share/polish/errmsg.txt:
        New error messages
      sql/share/portuguese/errmsg.txt:
        New error messages
      sql/share/romanian/errmsg.txt:
        New error messages
      sql/share/russian/errmsg.txt:
        New error messages
      sql/share/slovak/errmsg.txt:
        New error messages
      sql/share/spanish/errmsg.txt:
        New error messages
      sql/share/swedish/errmsg.txt:
        New error messages
      sql/share/ukrainian/errmsg.txt:
        New error messages
      sql/sql_base.cc:
        Removed wrong patch for INSERT...
      sql/sql_insert.cc:
        Fix bug in INSERT ... SET db_name.table_name.column_name
      sql/sql_lex.h:
        Changed NON_EXISTIONG_ONE -> UNSPECIFIED_OLAP_TYPE
      sql/sql_olap.cc:
        Removed wrong implementation of CUBE/ROLLUP
      sql/sql_parse.cc:
        Removed wrong implementation of CUBE/ROLLUP
        Added function to give better error messages
      sql/sql_select.cc:
        Removed wrong implementation of CUBE/ROLLUP
      sql/sql_union.cc:
        Added comment
      sql/sql_yacc.yy:
        Fix that we always generate an error message when calling YYABORT
      0862707d
  27. 23 Jul, 2002 1 commit
    • unknown's avatar
      New SET syntax & system variables. · 728cc2e2
      unknown authored
      Made a some new buffers thread specific and changeable.
      Resize of key_buffer.
      AUTO_COMMIT -> AUTOCOMMIT
      Fixed mutex bug in DROP DATABASE
      Fixed bug when using auto_increment as second part of a key where first part could include NULL.
      Split handler->extra() to extra() and extra_opt() to be able to support thread specific buffers.
      Don't write message to error log when slave reconnects becasue of timeout.
      Fixed possible update problem when using DELETE/UPDATE on small tables
      (In some cases we used index even if table scanning would be better)
      A lot of minior code cleanups
      
      
      BitKeeper/deleted/.del-net.c~ef21d6402bb882f9:
        Delete: libmysql/net.c
      BitKeeper/etc/ignore:
        added libmysql/net.c
      Docs/manual.texi:
        New SET syntax & system variables.
      client/client_priv.h:
        moved order of include files
      client/mysql.cc:
        Removed compiler warning
      client/mysqladmin.c:
        Use new SHOW GLOBAL syntax (if server supports it)
      configure.in:
        version change
      include/Makefile.am:
        indentation cleanup
      include/my_getopt.h:
        Made some helper functions global
      include/my_sys.h:
        Removed not used code
      include/myisam.h:
        Added extra argument to ..._extra()
      include/myisammrg.h:
        Added extra argument to ..._extra()
      include/mysql_com.h:
        changed NET to be able to support changeable system variables
      include/mysql_embed.h:
        Added MYSQL_SERVER_SUFFIX
      include/mysql_version.h.in:
        Added check of multiple including (needed for embedded library)
      include/mysqld_error.h:
        New error messages
      innobase/dict/dict0dict.c:
        Remove compiler warnings
      innobase/include/ut0mem.h:
        Remove compiler warnings
      innobase/include/ut0mem.ic:
        Remove compiler warnings
      isam/isamchk.c:
        new init_key_cache() arguments
      isam/isamlog.c:
        new init_key_cache() arguments
      isam/test2.c:
        new init_key_cache() arguments
      isam/test3.c:
        new init_key_cache() arguments
      libmysql/Makefile.am:
        Removed net.c (Automaticly make it from net_serv.cc)
      libmysql/Makefile.shared:
        Removed net.c (Automaticly make it from net_serv.cc)
      libmysql/libmysql.c:
        Changeable system variables
      libmysqld/Makefile.am:
        Added set_var.cc file
      libmysqld/embedded_priv.h:
        Changed order of include fiels
      libmysqld/lib_sql.cc:
        merge with mysqld.cc (for changeable variables)
      libmysqld/libmysqld.c:
        New changeable system variables
      myisam/mi_check.c:
        Added extra argument to ..._extra()
      myisam/mi_extra.c:
        Added extra argument to ..._extra()
      myisam/mi_open.c:
        Removed not used variable
      myisam/mi_test1.c:
        Changed call to init_key_cache
      myisam/mi_test2.c:
        Added extra argument to ..._extra()
      myisam/mi_test3.c:
        Added extra argument to ..._extra()
      myisam/mi_write.c:
        Add cache size argument to bulk-insert-init
      myisam/myisamchk.c:
        Use new key cache
      myisam/myisamdef.h:
        new mi_init_bulk_insert() arguments
      myisam/myisamlog.c:
        Added extra argument to ..._extra()
      myisam/myisampack.c:
        Added extra argument to ..._extra()
      myisammrg/myrg_extra.c:
        Added extra argument to ..._extra()
      myisammrg/myrg_rrnd.c:
        Added extra argument to ..._extra()
      mysql-test/r/insert_select.result:
        New changeable system variables
      mysql-test/r/key.result:
        Test of bug in auto_increment
      mysql-test/r/query_cache.result:
        New changeable system variables
      mysql-test/r/rpl000001.result:
        New changeable system variables
      mysql-test/r/rpl000016.result:
        New changeable system variables
      mysql-test/r/union.result:
        New changeable system variables
      mysql-test/r/user_var.result:
        New changeable system variables
      mysql-test/r/variables.result:
        New changeable system variables
      mysql-test/t/key.test:
        Test of bug in auto_increment
      mysql-test/t/query_cache.test:
        New changeable system variables
      mysql-test/t/rpl000001.test:
        New changeable system variables
      mysql-test/t/rpl000009.test:
        New changeable system variables
      mysql-test/t/rpl000016.test:
        New changeable system variables
      mysql-test/t/rpl_compat.test:
        New changeable system variables
      mysql-test/t/union.test:
        New changeable system variables
      mysql-test/t/user_var.test:
        New changeable system variables
      mysql-test/t/variables.test:
        New changeable system variables
      mysys/default.c:
        Bigger default memory allocation
      mysys/mf_iocache.c:
        Removed compiler warning
      mysys/mf_keycache.c:
        Made key cache resizable on the fly
        Removed not needed extra argument to init_key_cache()
      mysys/my_getopt.c:
        Made some helper functions global
      sql/Makefile.am:
        Aded set_var.cc
      sql/convert.cc:
        Comment cleanup
      sql/field.cc:
        new changeable system variables
      sql/filesort.cc:
        new changeable system variables
      sql/ha_berkeley.cc:
        AUTO_COMMIT -> AUTOCOMMIT
      sql/ha_innodb.cc:
        new changeable system variables
      sql/ha_myisam.cc:
        Added extra argument to ..._extra()
      sql/ha_myisam.h:
        Added extra argument to ..._extra()
      sql/ha_myisammrg.cc:
        Added extra argument to ..._extra()
      sql/ha_myisammrg.h:
        Added extra argument to ..._extra()
      sql/handler.cc:
        Added extra argument to ..._extra()
        Added resize of key cache
        Change ha_table_typelib for use with new system variables
      sql/handler.h:
        Added extra argument to ..._extra()
      sql/item.cc:
        new changeable system variables
      sql/item.h:
        Added better support of Item_uint
      sql/item_func.cc:
        Added support for SET @@[global | session] system_variable
      sql/item_strfunc.cc:
        new changeable system variables
      sql/key.cc:
        Fixed bug in auto_increment on second part keys
      sql/lex.h:
        Removed not needed keywords
      sql/log.cc:
        new changeable system variables
      sql/log_event.cc:
        new changeable system variables
      sql/log_event.h:
        Removed not needed var reference
      sql/mini_client.cc:
        new changeable system variables
        code cleanup
      sql/mini_client.h:
        Indentation cleanup
      sql/mysql_priv.h:
        Changed order of include files & variables to make file more readable
      sql/mysqld.cc:
        Changed order of variables to make file more readable.
        Support for changeable variables
        Rename of system variables
        Moved init_vars to set_var.cc
        Changed output of --help
      sql/net_pkg.cc:
        Added my_net_local_init() to make it possible to set different defaults for network connection depending if you are a client, embedded library or server.
      sql/net_serv.cc:
        new changeable system variables
        To support this, some global variables had to be move to the NET structure.
      sql/records.cc:
        new changeable system variables
        use extra_opt()
      sql/repl_failsafe.cc:
        new changeable system variables
        minior code cleanups
      sql/repl_failsafe.h:
        removed not needed external var reference
      sql/share/czech/errmsg.txt:
        new changeable system variables
      sql/share/danish/errmsg.txt:
        new changeable system variables
      sql/share/dutch/errmsg.txt:
        new changeable system variables
      sql/share/english/errmsg.txt:
        new changeable system variables
      sql/share/estonian/errmsg.txt:
        new changeable system variables
      sql/share/french/errmsg.txt:
        new changeable system variables
      sql/share/german/errmsg.txt:
        new changeable system variables
      sql/share/greek/errmsg.txt:
        new changeable system variables
      sql/share/hungarian/errmsg.txt:
        new changeable system variables
      sql/share/italian/errmsg.txt:
        new changeable system variables
      sql/share/japanese/errmsg.txt:
        new changeable system variables
      sql/share/korean/errmsg.txt:
        new changeable system variables
      sql/share/norwegian-ny/errmsg.txt:
        new changeable system variables
      sql/share/norwegian/errmsg.txt:
        new changeable system variables
      sql/share/polish/errmsg.txt:
        new changeable system variables
      sql/share/portuguese/errmsg.txt:
        new changeable system variables
      sql/share/romanian/errmsg.txt:
        new changeable system variables
      sql/share/russian/errmsg.txt:
        new changeable system variables
      sql/share/slovak/errmsg.txt:
        new changeable system variables
      sql/share/spanish/errmsg.txt:
        new changeable system variables
      sql/share/swedish/errmsg.txt:
        new changeable system variables
      sql/share/ukrainian/errmsg.txt:
        new changeable system variables
      sql/slave.cc:
        new changeable system variables
        Added some suppression of error messages
        Initialize current_thd for all slave threads.
      sql/sql_acl.cc:
        Added checking of arguments for SET PASSWORD (for new SET defintion)
      sql/sql_acl.h:
        new prototypes
      sql/sql_base.cc:
        new changeable system variables
      sql/sql_cache.cc:
        new changeable system variables
      sql/sql_cache.h:
        Renamed some arguments to make code more readable
      sql/sql_class.cc:
        new changeable system variables
      sql/sql_class.h:
        New changeable system variables
        Code cleanup
      sql/sql_db.cc:
        Fixed bug in DROP DATABASE
      sql/sql_delete.cc:
        Usage of wrong define in test (possible speed problem)
      sql/sql_insert.cc:
        use extra_opt()
        Code cleanup
      sql/sql_lex.cc:
        Added support for SET @@[global | session] system_variable
      sql/sql_lex.h:
        Added support for SET @@[global | session] system_variable
      sql/sql_load.cc:
        Cleanup for embedded library
        Use extra_opt()
      sql/sql_parse.cc:
        Cleanup for embedded library
        New changeable system variables
      sql/sql_repl.cc:
        new changeable system variables
      sql/sql_repl.h:
        Fixed variable definitions
      sql/sql_select.cc:
        new changeable system variables
      sql/sql_show.cc:
        New changeable system variables
      sql/sql_table.cc:
        Fixed bug in DROP DATABASE
      sql/sql_union.cc:
        New changeable system variables
      sql/sql_update.cc:
        Usage of wrong define in test (possible speed problem)
      sql/sql_yacc.yy:
        New changeable system variables
      sql/structs.h:
        Added typedef for SHOW_VAR
      sql/table.cc:
        Fixed bug in auto_increment on second part keys
      sql/uniques.cc:
        Comment fix
      sql/unireg.h:
        A
      728cc2e2
  28. 28 Jun, 2002 1 commit
    • unknown's avatar
      Updated windows files (VC++ files and winmysqladmin). · b3574dc2
      unknown authored
      Portability fixes.
      Removed compiler warnings.
      
      
      
      VC++Files/client/mysql.dsp:
        Updated to 4.0.2
      VC++Files/client/mysqladmin.dsp:
        Updated to 4.0.2
      VC++Files/client/mysqlclient.dsp:
        Updated to 4.0.2
      VC++Files/client/mysqldump.dsp:
        Updated to 4.0.2
      VC++Files/client/mysqlimport.dsp:
        Updated to 4.0.2
      VC++Files/client/mysqlshow.dsp:
        Updated to 4.0.2
      VC++Files/innobase/innobase.dsp:
        Updated to 4.0.2
      VC++Files/libmysql/libmySQL.dsp:
        Updated to 4.0.2
      VC++Files/libmysqltest/myTest.dsp:
        Updated to 4.0.2
      VC++Files/merge/merge.dsp:
        Updated to 4.0.2
      VC++Files/myisam/myisam.dsp:
        Updated to 4.0.2
      VC++Files/mysql.dsw:
        Updated to 4.0.2
      VC++Files/mysqlbinlog/mysqlbinlog.dsp:
        Updated to 4.0.2
      VC++Files/mysqlcheck/mysqlcheck.dsp:
        Updated to 4.0.2
      VC++Files/mysqlmanager/MySqlManager.dsp:
        Updated to 4.0.2
      VC++Files/mysys/mysys.dsp:
        Updated to 4.0.2
      VC++Files/pack_isam/pack_isam.dsp:
        Updated to 4.0.2
      VC++Files/perror/perror.dsp:
        Updated to 4.0.2
      VC++Files/replace/replace.dsp:
        Updated to 4.0.2
      VC++Files/sql/mysqld.dsp:
        Updated to 4.0.2
      VC++Files/test1/test1.dsp:
        Updated to 4.0.2
      VC++Files/thr_insert_test/thr_insert_test.dsp:
        Updated to 4.0.2
      VC++Files/thr_test/thr_test.dsp:
        Updated to 4.0.2
      VC++Files/vio/vio.dsp:
        Updated to 4.0.2
      VC++Files/zlib/zlib.dsp:
        Updated to 4.0.2
      include/config-win.h:
        Added isnan() and finite()
      include/myisam.h:
        Move thr_xxx functions to myisam_priv.h
      myisam/mi_check.c:
        Portability fix.
      myisam/mi_locking.c:
        Comment cleanup
      myisam/myisamchk.c:
        Removed compiler warning
      myisam/myisamdef.h:
        Added thr_xxx functions
      myisam/sort.c:
        Portability fix
      sql/field.cc:
        Portability fix
      sql/sql_insert.cc:
        R
      b3574dc2
  29. 12 Jun, 2002 1 commit
    • unknown's avatar
      Added the following new privleges: · 99004177
      unknown authored
      SHOW DATABASES
      CREATE TEMPORARY TABLE
      LOCK TABLES
      REPLICATION SLAVE & REPLICATION CLIENT
      SUPER
      EXECUTE
      
      All scripts & documentation is updated for this change.
      Added better error messages for global privileges 
      
      
      BitKeeper/deleted/.del-mysql_new_fix_privilege_tables.sh~b1664b401375eece:
        Delete: scripts/mysql_new_fix_privilege_tables.sh
      Docs/manual.texi:
        Updated manual for privilege changes.
      include/mysqld_error.h:
        new error messages
      mysql-test/install_test_db.sh:
        Updated to use new privileges
      mysql-test/r/grant_cache.result:
        Updated to use new privileges
      mysql-test/r/rpl000017.result:
        Updated to use new privileges
      mysql-test/t/rpl000017.test:
        Updated to use new privileges
      mysys/safemalloc.c:
        Cleanup
      scripts/mysql_fix_privilege_tables.sh:
        Updated to use new privileges
      scripts/mysql_install_db.sh:
        Updated to use new privileges
      sql/field.h:
        Cleanup
      sql/item_strfunc.cc:
        Updated to use new privileges
      sql/lex.h:
        Updated to use new privileges
      sql/log.cc:
        Updated to use new privileges
      sql/mysql_priv.h:
        Updated to use new privileges
      sql/mysqld.cc:
        Updated to use new privileges
      sql/repl_failsafe.cc:
        Updated to use new privileges
      sql/share/czech/errmsg.txt:
        new error messages
      sql/share/danish/errmsg.txt:
        new error messages
      sql/share/dutch/errmsg.txt:
        new error messages
      sql/share/english/errmsg.txt:
        new error messages
      sql/share/estonian/errmsg.txt:
        new error messages
      sql/share/french/errmsg.txt:
        new error messages
      sql/share/german/errmsg.txt:
        new error messages
      sql/share/greek/errmsg.txt:
        new error messages
      sql/share/hungarian/errmsg.txt:
        new error messages
      sql/share/italian/errmsg.txt:
        new error messages
      sql/share/japanese/errmsg.txt:
        new error messages
      sql/share/korean/errmsg.txt:
        new error messages
      sql/share/norwegian-ny/errmsg.txt:
        new error messages
      sql/share/norwegian/errmsg.txt:
        new error messages
      sql/share/polish/errmsg.txt:
        new error messages
      sql/share/portuguese/errmsg.txt:
        new error messages
      sql/share/romanian/errmsg.txt:
        new error messages
      sql/share/russian/errmsg.txt:
        new error messages
      sql/share/slovak/errmsg.txt:
        new error messages
      sql/share/spanish/errmsg.txt:
        new error messages
      sql/share/swedish/errmsg.txt:
        new error messages
      sql/share/ukrainian/errmsg.txt:
        new error messages
      sql/slave.cc:
        Portability cleanup
      sql/sql_acl.cc:
        Updated to use new privileges
      sql/sql_acl.h:
        Updated to use new privileges
      sql/sql_base.cc:
        Remove not used include file
      sql/sql_class.cc:
        Comment cleanup
      sql/sql_class.h:
        Updated to use new privileges
        Comment cleanups
      sql/sql_insert.cc:
        Updated to use new privileges
      sql/sql_lex.h:
        Indentation cleanup
      sql/sql_parse.cc:
        Updated to use new privileges
      sql/sql_repl.cc:
        Updated to use new privileges
        Comment cleanup
      sql/sql_show.cc:
        Updated to use new privileges
      sql/sql_yacc.yy:
        Updated to use new privileges
        Sorted some tockens for easer merge to 4.1 in the future.
      sql/table.h:
        Updated to use new privileges
      tests/grant.pl:
        Updated to use new privileges
      tests/grant.res:
        Updated to use new privileges
      99004177
  30. 11 Jun, 2002 1 commit
    • unknown's avatar
      Big code cleanup/review before 4.0.2 release. · 595f3d5f
      unknown authored
      (All commit emails since 4.0.1 checked)
      This had to be done now, before the 4.1 tree changes to much, to make it easy to propagate bug fixes to the 4.1 tree.
      
      
      BUILD/SETUP.sh:
        Added -DPEDANTIC_SAFEMALLOC as standard debug option
      Docs/manual.texi:
        Changes for new version.
      client/mysql.cc:
        Fixed default value for rehash
        cleanup
      client/mysqladmin.c:
        Cleanup
      client/mysqlbinlog.cc:
        cleanup
      client/mysqldump.c:
        Cleanup
      client/mysqlmanager-pwgen.c:
        Cleanup
      client/mysqlmanagerc.c:
        Cleanup
      client/mysqltest.c:
        Cleanup
      dbug/dbug.c:
        Cleanup
      extra/resolve_stack_dump.c:
        Cleanup & Simple optimizations
      include/ft_global.h:
        Cleanup
      include/my_alloc.h:
        Cleanup
      include/my_global.h:
        Cleanup
      include/my_sys.h:
        Cleanup
      include/myisam.h:
        Cleanup
      libmysql/libmysql.c:
        Cleanup
      libmysql/manager.c:
        Cleanup
      myisam/ft_boolean_search.c:
        Cleanup
      myisam/ft_dump.c:
        Change strcpy -> strmov
      myisam/ft_eval.c:
        Cleanup
      myisam/ft_nlq_search.c:
        Cleanup
      myisam/ft_test1.c:
        strncpy -> strnmov
      myisam/ft_update.c:
        Cleanup
      myisam/mi_static.c:
        Cleanup
      myisam/mi_test2.c:
        Cleanup
      myisam/mi_write.c:
        Cleanup
      mysys/mf_fn_ext.c:
        Cleanup
      mysys/mf_iocache.c:
        Cleanup
      mysys/mf_iocache2.c:
        Cleanup
      mysys/my_getopt.c:
        Cleanup
      mysys/my_read.c:
        Cleanup
      mysys/my_thr_init.c:
        Cleanup
      mysys/queues.c:
        Cleanup
      mysys/safemalloc.c:
        Cleanup
      sql/field.cc:
        Indentation cleanups
      sql/ha_berkeley.cc:
        Indentation cleanups
      sql/ha_myisam.cc:
        Cleanup
      sql/item.h:
        Indentation cleanups
      sql/item_cmpfunc.cc:
        Indentation cleanups
      sql/item_create.cc:
        cleanup
      sql/item_func.cc:
        Cleanup
      sql/item_func.h:
        Indentation cleanups
      sql/item_strfunc.cc:
        Indentation cleanups
      sql/item_sum.cc:
        Indentation cleanups
      sql/item_timefunc.cc:
        Indentation cleanups
      sql/lock.cc:
        Indentation cleanups
      sql/log.cc:
        Cleanup
        strnmov -> strmake
      sql/log_event.cc:
        Cleanup + optimizations
        Fixed memory leak
        Added missing pthread_mutex_unlock()  (On error condition)
      sql/log_event.h:
        Indentation and comment cleanup
        Merged #ifdef's into common blocks for better readability
      sql/mini_client.cc:
        Indentation cleanup
      sql/mysql_priv.h:
        Cleanup
        Changed int function to bool
      sql/mysqld.cc:
        Indentation and comment cleanup
      sql/net_pkg.cc:
        Indentation cleanup
      sql/net_serv.cc:
        Changed int function -> bool
      sql/nt_servc.cc:
        Cleanup
      sql/opt_range.cc:
        Indentation cleanup
      sql/repl_failsafe.cc:
        Cleanup + simple optimization
        strnmov -> strmake
      sql/slave.cc:
        strnmov -> strmake
        Cleanups
      sql/slave.h:
        Cleanup
      sql/sql_acl.cc:
        Indentation and DBUG_PRINT cleanup
        Changed WITH MAX... to not use =
      sql/sql_base.cc:
        Indentation cleanup
      sql/sql_cache.cc:
        Indentation cleanup
      sql/sql_class.cc:
        Indentation cleanup
      sql/sql_class.h:
        Renamed some struct slots
      sql/sql_delete.cc:
        Indentation cleanup
      sql/sql_handler.cc:
        Indentation cleanup
      sql/sql_insert.cc:
        Use new slot names.
      sql/sql_lex.cc:
        Indentation cleanup
      sql/sql_lex.h:
        Indentation cleanup
      sql/sql_load.cc:
        Indentation cleanup
      sql/sql_parse.cc:
        Indentation cleanup
        Removed not used check from LOCK TABLES
      sql/sql_repl.cc:
        strnmov -> strmake
      sql/sql_repl.h:
        Removed test if file is included (We want to know if it's included twice to avoid this)
      sql/sql_select.cc:
        Indentation cleanup
      sql/sql_show.cc:
        Indentation cleanup
      sql/sql_string.cc:
        Indentation cleanup
      sql/sql_table.cc:
        Indentation cleanup
      sql/sql_union.cc:
        Use renamed struct slot
      sql/sql_update.cc:
        Indentation cleanup
      sql/sql_yacc.yy:
        Removed = after GRANT ... MAX_  to make the syntax uniform
      sql/table.cc:
        Indentation cleanup
      sql/table.h:
        Indentation cleanup
      sql/time.cc:
        Indentation cleanup
      sql/udf_example.cc:
        Indentation cleanup
      sql/unireg.cc:
        strnmov -> strmake
      tests/grant.pl:
        Added test for LOCK TABLES
      tools/mysqlmanager.c:
        Cleanup
        fopen() -> my_fopen()
      vio/viosocket.c:
        DBUG_PRINT cleanups
      vio/viosslfactories.c:
        Indentation cleanup
        Checking of results from malloc()
        Fixed possible memory leak
      BitKeeper/etc/ignore:
        Added scripts/mysql_secure_installation to the ignore list
      BitKeeper/etc/logging_ok:
        Logging to logging@openlogging.org accepted
      595f3d5f
  31. 05 Jun, 2002 1 commit
  32. 24 May, 2002 1 commit
  33. 29 Apr, 2002 1 commit
    • unknown's avatar
      Fixed that enable-reads-from-master and repl-parse-query works in option files. · 7cec02a2
      unknown authored
      Fixed slowdown problem on win98
      Fixed syntax for ALTER TABLE .. RENAME
      
      
      Docs/manual.texi:
        changelog
      libmysql/libmysql.c:
        Fixed that enable-reads-from-master and repl-parse-query works in option files.
      myisam/ft_boolean_search.c:
        Portability fixes
      mysys/my_thr_init.c:
        cleanup
      sql/sql_base.cc:
        Fixed slowdown problem on win98
      sql/sql_delete.cc:
        Removed compiler warnings
      sql/sql_insert.cc:
        Removed compiler warnings
      sql/sql_update.cc:
        Removed compiler warnings
      sql/sql_yacc.yy:
        Fixed syntax for ALTER TABLE .. RENAME
      vio/vio.c:
        Added test of OS2
      vio/viosocket.c:
        cleanup
      7cec02a2
  34. 28 Apr, 2002 1 commit
    • unknown's avatar
      invalidation moved before tables unlocking · 743eb8c9
      unknown authored
      sql/sql_delete.cc:
        invalidation moved before tables unlocking
        invalidation on multidelete error (if something changed)
      sql/sql_parse.cc:
        invalidation moved to mysql_admin_table
        layout fixing
      sql/sql_table.cc:
        invalidation moved to mysql_admin_table
      sql/sql_update.cc:
        invalidation moved before tables unlocking
        invalidation on multiupdate error (if something changed)
      743eb8c9