An error occurred fetching the project authors.
  1. 12 May, 2004 1 commit
  2. 05 May, 2004 3 commits
  3. 29 Apr, 2004 1 commit
    • unknown's avatar
      InnoDB: implement LOCK TABLE (Bug #3299) · 3594adb1
      unknown authored
      innobase/include/lock0lock.h:
        Add lock_table_unlock() and lock_release_tables_off_kernel()
        Add LOCK_TABLE_EXP
      innobase/include/row0mysql.h:
        Add row_unlock_table_for_mysql() and row_lock_table_for_mysql()
      innobase/include/trx0trx.h:
        Add n_tables_locked
      innobase/lock/lock0lock.c:
        Add LOCK_TABLE_EXP for explicit LOCK TABLE commands
        Add lock_table_unlock()
        Add lock_release_tables_off_kernel()
      innobase/row/row0mysql.c:
        Add row_unlock_table_for_mysql() and row_lock_table_for_mysql()
      innobase/trx/trx0trx.c:
        Add n_tables_locked
      mysql-test/r/innodb.result:
        Updated handling of auto_inc columns
      sql/ha_innodb.cc:
        Call row_lock_table_for_mysql() and row_unlock_table_for_mysql()
      3594adb1
  4. 09 Apr, 2004 1 commit
    • unknown's avatar
      ha_innodb.cc, sync0sync.h, sync0sync.c: · 6366a909
      unknown authored
        Use only noninlined InnoDB functions in ha_innodb.cc
      
      
      innobase/sync/sync0sync.c:
        Use only noninlined InnoDB functions in ha_innodb.cc
      innobase/include/sync0sync.h:
        Use only noninlined InnoDB functions in ha_innodb.cc
      sql/ha_innodb.cc:
        Use only noninlined InnoDB functions in ha_innodb.cc
      6366a909
  5. 06 Apr, 2004 1 commit
    • unknown's avatar
      InnoDB: send diagnostic output to stderr or files · 80fe399f
      unknown authored
      instead of stdout or fixed-size memory buffers
      
      
      innobase/btr/btr0btr.c:
        Output to stderr; quote table and index names
      innobase/btr/btr0cur.c:
        Output to stderr; quote table and index names
      innobase/btr/btr0sea.c:
        Output to stderr
      innobase/buf/buf0buf.c:
        Output to stderr; quote table and index names
      innobase/buf/buf0flu.c:
        Output to stderr
      innobase/buf/buf0lru.c:
        Output to stderr
      innobase/buf/buf0rea.c:
        Output to stderr
      innobase/data/data0data.c:
        Remove dtuple_validate() unless #ifdef UNIV_DEBUG
        Remove unnecessary sprintf() calls
        Output to stderr
      innobase/data/data0type.c:
        Output to stderr
      innobase/dict/dict0boot.c:
        Remove dummy call to printf()
      innobase/dict/dict0crea.c:
        Output diagnostic information to stream, not to memory
      innobase/dict/dict0dict.c:
        Output diagnostics to a file, not to a memory buffer
      innobase/dict/dict0load.c:
        Output to stderr; quote table and index names
      innobase/eval/eval0eval.c:
        Output to stderr
      innobase/fil/fil0fil.c:
        Output to stderr
      innobase/fsp/fsp0fsp.c:
        Output to stderr
        Avoid sprintf()
      innobase/fut/fut0lst.c:
        Output to stderr
      innobase/ha/ha0ha.c:
        Output to stream, not to memory buffer
      innobase/ibuf/ibuf0ibuf.c:
        Output to stderr
        Avoid sprintf()
      innobase/include/buf0buf.h:
        Output to stream, not to memory buffer
      innobase/include/buf0buf.ic:
        Use %p for displaying pointers
      innobase/include/data0data.h:
        Remove dtuple_sprintf()
      innobase/include/dict0dict.h:
        Output to stream, not to memory buffer
      innobase/include/ha0ha.h:
        Output to stream, not to memory buffer
      innobase/include/ibuf0ibuf.h:
        Output to stream, not to memory buffer
      innobase/include/lock0lock.h:
        Output to stream, not to memory buffer
      innobase/include/log0log.h:
        Output to stream, not to memory buffer
      innobase/include/mtr0log.ic:
        Output to stderr
        Display pointers with %p
      innobase/include/os0file.h:
        Output to stream, not to memory buffer
      innobase/include/rem0rec.h:
        Remove rec_sprintf()
      innobase/include/rem0rec.ic:
        Output to stderr
      innobase/include/row0sel.ic:
        Output to stderr
      innobase/include/row0upd.ic:
        Quote table and index names
      innobase/include/srv0srv.h:
        Remove srv_sprintf_innodb_monitor()
      innobase/include/sync0arr.h:
        Output to stream, not to memory buffer
      innobase/include/sync0sync.h:
        Output to stream, not to memory buffer
      innobase/include/trx0sys.h:
        Output to stderr
      innobase/include/trx0trx.h:
        Output to stream, not to memory buffer
      innobase/include/ut0ut.h:
        Remove ut_sprintf_buf()
        Add ut_print_name(), ut_print_namel() and ut_copy_file()
      innobase/lock/lock0lock.c:
        Output to stream, not to memory buffer
      innobase/log/log0log.c:
        Output to stderr
      innobase/log/log0recv.c:
        Output to stderr
      innobase/mem/mem0dbg.c:
        Output to stderr
      innobase/mtr/mtr0log.c:
        Display pointers with %p
      innobase/mtr/mtr0mtr.c:
        Output to stderr
      innobase/os/os0file.c:
        Output to stream, not to memory buffer
      innobase/os/os0proc.c:
        Output to stderr
      innobase/os/os0thread.c:
        Output to stderr
      innobase/page/page0cur.c:
        Output to stderr
      innobase/page/page0page.c:
        Avoid sprintf()
        Output to stderr instead of stdout
      innobase/pars/pars0opt.c:
        Output to stderr instead of stdout
      innobase/rem/rem0rec.c:
        Remove rec_sprintf()
        Output to stderr instead of stdout
      innobase/row/row0ins.c:
        Output diagnostics to stream instead of memory buffer
      innobase/row/row0mysql.c:
        Output to stderr instead of stdout
        Quote table and index names
      innobase/row/row0purge.c:
        Output to stderr instead of stdout
      innobase/row/row0row.c:
        Quote table and index names
      innobase/row/row0sel.c:
        Output to stderr instead of stdout
        Quote table and index names
      innobase/row/row0umod.c:
        Avoid sprintf()
        Quote table and index names
      innobase/row/row0undo.c:
        Output to stderr instead of stdout
      innobase/row/row0upd.c:
        Avoid sprintf()
      innobase/srv/srv0srv.c:
        Output to stderr instead of stdout
      innobase/srv/srv0start.c:
        Handle srv_monitor_file
        Make some global variables static
      innobase/sync/sync0arr.c:
        Output to stderr instead of stdout
        Output to stream instead of memory buffer
      innobase/sync/sync0rw.c:
        Output to stderr instead of stdout
      innobase/sync/sync0sync.c:
        Output to stderr instead of stdout
        Output to stream instead of memory buffer
      innobase/trx/trx0purge.c:
        Output to stderr instead of stdout
      innobase/trx/trx0rec.c:
        Quote index and table names
        Avoid sprintf()
      innobase/trx/trx0roll.c:
        Quote identifier names
        Output to stderr instead of stdout
      innobase/trx/trx0sys.c:
        Output to stderr instead of stdout
      innobase/trx/trx0trx.c:
        Output to stream instead of memory buffer
      innobase/trx/trx0undo.c:
        Output to stderr instead of stdout
      innobase/ut/ut0ut.c:
        Declare mysql_get_identifier_quote_char()
        Remove ut_sprintf_buf()
        Add ut_print_name() and ut_print_namel()
        Add ut_copy_file()
      sql/ha_innodb.cc:
        innobase_mysql_print_thd(): output to stream, not to memory buffer
        Add mysql_get_identifier_quote_char()
        Remove unused function innobase_print_error()
        Display pointers with %p
        Buffer InnoDB output via files, not via statically allocated memory
      80fe399f
  6. 05 Apr, 2004 1 commit
  7. 02 Apr, 2004 1 commit
    • unknown's avatar
      InnoDB: ignore intra-database foreign key references between tables · fac3642c
      unknown authored
      when dropping database (Bug #3058)
      
      
      innobase/dict/dict0crea.c:
        Add a parameter to row_drop_table_for_mysql()
      innobase/dict/dict0dict.c:
        Make dict_tables_have_same_db() a global function
      innobase/include/dict0dict.h:
        Make dict_tables_have_same_db() a global function
      innobase/include/row0mysql.h:
        Add a parameter to row_drop_table_for_mysql()
      innobase/row/row0mysql.c:
        Add a parameter "drop_db" to row_drop_table_for_mysql()
        to skip foreign constraint checks on tables in same database
      innobase/trx/trx0roll.c:
        Add a parameter to row_drop_table_for_mysql()
      sql/ha_innodb.cc:
        Add a parameter "drop_db" to row_drop_table_for_mysql()
        innobase_drop_database(): allocate namebuf dynamically
      fac3642c
  8. 01 Apr, 2004 1 commit
    • unknown's avatar
      InnoDB cleanup: fixing buffer overflows and quoting of quotes · 025ddfea
      unknown authored
      innobase/dict/dict0crea.c:
        Remove unneeded prototypes for static functions
        Remove unused parameters from some functions
        Replace some assertions with compile-time checks
        dict_create_add_foreigns_to_dictionary():
        allocate space dynamically for the SQL, and quote quotes
      innobase/dict/dict0dict.c:
        Remove unnecessary prototypes for static functions
        dict_tables_have_same_db(): Remove length limitation
        dict_remove_db_name(): Use strchr()
        dict_get_db_name_len(): Use strchr()
        Replace mem_heap_alloc()+strlen()+memcpy() with mem_heap_strdup()
        Remove unnecessary strlen() calls
        Allocate space dynamically for generated strings
        dict_scan_id(): allow quotes within quoted strings
      innobase/dict/dict0load.c:
        Remove unnecessary strlen() calls
        Replace mem_heap_alloc()+strlen()+memcpy() with mem_heap_strdup()
      innobase/dict/dict0mem.c:
        Replace mem_heap_alloc()+strlen()+memcpy() with mem_heap_strdup()
      innobase/eval/eval0eval.c:
        Make TO_CHAR() work with any machine word width
      innobase/fil/fil0fil.c:
        Replace mem_alloc()+strlen()+strcpy() with mem_strdup()
      innobase/ibuf/ibuf0ibuf.c:
        Make some global variables static
        Add #ifdef UNIV_IBUF_DEBUG around debug statements
      innobase/include/data0data.h:
        Add #ifdef UNIV_DEBUG around dtuple_validate()
      innobase/include/data0data.ic:
        Replace = with == in ut_ad(tuple->magic_n == DATA_TUPLE_MAGIC_N)
      innobase/include/dict0dict.h:
        Add const qualifiers
      innobase/include/lock0lock.h:
        Add UL suffixes to unsigned long masks
      innobase/include/log0log.h:
        Remove unused parameter "type" of log_group_write_buf()
      innobase/include/mem0mem.h:
        Add mem_strdup(), mem_strdupl(), mem_strdupq(), mem_heap_strdup(),
        and mem_heap_strdupl()
      innobase/include/mem0mem.ic:
        Add mem_strdup(), mem_strdupl(), mem_strdupq(), mem_heap_strdup(),
        and mem_heap_strdupl()
      innobase/include/row0uins.h:
        Remove unused parameter "thr" of row_undo_ins()
      innobase/include/row0undo.h:
        Remvoe unused parameter "thr" of row_undo_search_clust_to_pcur()
      innobase/include/ut0byte.h:
        Add const qualifier to ut_cpy_in_lower_case()
        Remove parameter "len" of ut_cmp_in_lower_case()
      innobase/include/ut0mem.h:
        Add ut_strlenq(), ut_strcpyq() and ut_memcpyq()
      innobase/include/ut0mem.ic:
        Add ut_strlenq()
      innobase/include/ut0ut.h:
        Declare ut_sprintf() as a printf-style function
      innobase/lock/lock0lock.c:
        lock_clust_rec_modify_check_and_lock(): Remove unused variable "trx"
      innobase/log/log0log.c:
        Remove unused parameters
      innobase/log/log0recv.c:
        Remove parameter "type" from log_group_write_buf()
      innobase/mem/mem0mem.c:
        Simplify the initialization of block->init_block
      innobase/mtr/mtr0log.c:
        Add a debug assertion to mlog_parse_initial_log_record()
      innobase/page/page0cur.c:
        Add debug assertion to page_cur_insert_rec_write_log()
        Remove hard-coded buffer size in page_cur_parse_insert_rec()
      innobase/page/page0page.c:
        Remove unneeded variable rec
      innobase/pars/pars0opt.c:
        Correct a potential buffer overflow
      innobase/pars/pars0pars.c:
        Replace mem_heap_alloc()+strlen()+memcpy() with mem_heap_strdup()
      innobase/row/row0ins.c:
        Replace parameter "thr" with "trx" in row_ins_foreign_report_add_err()
        Remove unnecessary strlen() call
        Use strchr()
      innobase/row/row0mysql.c:
        Add row_mysql_is_recovered_tmp_table()
        Add row_mysql_is_system_table()
        Compare reserved table names with exact match
        Use strstr() and strchr() and mem_strdupl()
        Compute space needed for generated SQL, and allocate it dynamically
      innobase/row/row0purge.c:
        Remove unused parameters "thr"
      innobase/row/row0row.c:
        Simplify row_get_clust_rec()
      innobase/row/row0uins.c:
        Remove unused parameters "thr"
      innobase/row/row0umod.c:
        Remove unused variable "index"
        row_undo_mod_del_unmark_sec_and_undo_update():
         Remove parameter "node" and variable "rec"
        Remove unused parameters "thr"
      innobase/row/row0undo.c:
        Remove unused parameters "thr"
      innobase/srv/srv0srv.c:
        Replace UT_NOT_USED() with __attribute__((unused))
      innobase/srv/srv0start.c:
        Remove unnecessary strlen() calls
        Remove unused parameter "create_new_db" of open_or_create_log_file()
      innobase/trx/trx0roll.c:
        Replace mem_alloc()+strlen()+memcpy() with mem_strdup()
      innobase/trx/trx0sys.c:
        Remove unnecessary strlen() call
      innobase/ut/ut0byte.c:
        Add const qualifier to ut_cpy_in_lower_case()
        Remove parameter "len" of ut_cmp_in_lower_case()
      innobase/ut/ut0mem.c:
        Add ut_strlenq() and ut_memcpyq()
      sql/ha_innodb.cc:
        Remove parameter "len" of ut_cmp_in_lower_case()
      025ddfea
  9. 01 Mar, 2004 1 commit
    • unknown's avatar
      Fix for BUG#3015 · 12ede13a
      unknown authored
      "(binlog, position) stored by InnoDB for a replication slave can be wrong".
      This code contains conditional #if to distinguish between versions;
      it should be merged into 4.1 and 5.0.
      
      
      sql/ha_innodb.cc:
        correcting the binlog position stored in InnoDB in a slave.
      sql/log_event.cc:
        better code to store the binlog position in InnoDB for a slave.
      sql/slave.h:
        Better code for storing the binlog position in InnoDB for a slave.
      12ede13a
  10. 24 Feb, 2004 1 commit
    • unknown's avatar
      ha_innodb.cc: · 7b185bb4
      unknown authored
        Add diagnostic code to analyze an assertion failure in ha_innodb.cc on line 2020 reported by a user (Bug #2903)
      
      
      sql/ha_innodb.cc:
        Add diagnostic code to analyze an assertion failure in ha_innodb.cc on line 2020 reported by a user (Bug #2903)
      7b185bb4
  11. 16 Feb, 2004 1 commit
    • unknown's avatar
      ha_innodb.cc: · 5d037cb6
      unknown authored
        Make the drop InnoDB database operation aware of the setting FOREIGN_KEY_CHECKS=0; DROP DATABASE seems to work ok anyway, but that is because MySQL first calls DROP TABLE for each table which has an .frm file
      
      
      sql/ha_innodb.cc:
        Make the drop InnoDB database operation aware of the setting FOREIGN_KEY_CHECKS=0; DROP DATABASE seems to work ok anyway, but that is because MySQL first calls DROP TABLE for each table which has an .frm file
      5d037cb6
  12. 09 Feb, 2004 1 commit
    • unknown's avatar
      row0mysql.c: · e2646f09
      unknown authored
        Allow always DROPping of a table which is only referenced by FOREIGN KEY constraints from the same table
      Many files:
        Do not let REPLACE to perform internally an UPDATE if the table is referenced by a FOREIGN KEY: the manual says that REPLACE must resolve a duplicate key error semantically with DELETE(s) + INSERT, and not by an UPDATE; the internal update caused foreign key checks and cascaded operations to behave in a semantically wrong way
      
      
      sql/ha_innodb.cc:
        Do not let REPLACE to perform internally an UPDATE if the table is referenced by a FOREIGN KEY: the manual says that REPLACE must resolve a duplicate key error semantically with DELETE(s) + INSERT, and not by an UPDATE; the internal update caused foreign key checks and cascaded operations to behave in a semantically wrong way
      sql/sql_insert.cc:
        Do not let REPLACE to perform internally an UPDATE if the table is referenced by a FOREIGN KEY: the manual says that REPLACE must resolve a duplicate key error semantically with DELETE(s) + INSERT, and not by an UPDATE; the internal update caused foreign key checks and cascaded operations to behave in a semantically wrong way
      sql/ha_innodb.h:
        Do not let REPLACE to perform internally an UPDATE if the table is referenced by a FOREIGN KEY: the manual says that REPLACE must resolve a duplicate key error semantically with DELETE(s) + INSERT, and not by an UPDATE; the internal update caused foreign key checks and cascaded operations to behave in a semantically wrong way
      sql/handler.h:
        Do not let REPLACE to perform internally an UPDATE if the table is referenced by a FOREIGN KEY: the manual says that REPLACE must resolve a duplicate key error semantically with DELETE(s) + INSERT, and not by an UPDATE; the internal update caused foreign key checks and cascaded operations to behave in a semantically wrong way
      innobase/dict/dict0dict.c:
        Do not let REPLACE to perform internally an UPDATE if the table is referenced by a FOREIGN KEY: the manual says that REPLACE must resolve a duplicate key error semantically with DELETE(s) + INSERT, and not by an UPDATE; the internal update caused foreign key checks and cascaded operations to behave in a semantically wrong way
      innobase/include/dict0dict.h:
        Do not let REPLACE to perform internally an UPDATE if the table is referenced by a FOREIGN KEY: the manual says that REPLACE must resolve a duplicate key error semantically with DELETE(s) + INSERT, and not by an UPDATE; the internal update caused foreign key checks and cascaded operations to behave in a semantically wrong way
      innobase/row/row0mysql.c:
        Allow always DROPping of a table which is only referenced by FOREIGN KEY constraints from the same table
      e2646f09
  13. 08 Feb, 2004 1 commit
    • unknown's avatar
      ha_innodb.cc: · b0076aad
      unknown authored
        If AUTOCOMMIT=1, then we do not need to make a plain SELECT set shared locks even on the SERIALIZABLE isolation level, because we know the transaction is read-only: a read-only transaction can always be performed on the REPEATABLE READ level, and that does not endanger the serializability
      
      
      sql/ha_innodb.cc:
        If AUTOCOMMIT=1, then we do not need to make a plain SELECT set shared locks even on the SERIALIZABLE isolation level, because we know the transaction is read-only: a read-only transaction can always be performed on the REPEATABLE READ level, and that does not endanger the serializability
      b0076aad
  14. 01 Feb, 2004 1 commit
    • unknown's avatar
      dict0dict.c: · 08177508
      unknown authored
        Remove redundant code; parse both the database name and the table name in a FOREIGN KEY constraint with quotes in mind
      row0mysql.c, ha_innodb.cc, sql_table.cc:
        Return error message Cannot delete or update a parent row... if we try to drop a table which is referenced by a FOREIGN KEY constraint, and the user has not set foreign_key_checks=0
      
      
      sql/sql_table.cc:
        Return error message Cannot delete or update a parent row... if we try to drop a table which is referenced by a FOREIGN KEY constraint, and the user has not set foreign_key_checks=0
      sql/ha_innodb.cc:
        Return error message Cannot delete or update a parent row... if we try to drop a table which is referenced by a FOREIGN KEY constraint, and the user has not set foreign_key_checks=0
      innobase/row/row0mysql.c:
        Return error message Cannot delete or update a parent row... if we try to drop a table which is referenced by a FOREIGN KEY constraint, and the user has not set foreign_key_checks=0
      innobase/dict/dict0dict.c:
        Remove redundant code; parse both the database name and the table name in a FOREIGN KEY constraint with quotes in mind
      08177508
  15. 30 Dec, 2003 1 commit
    • unknown's avatar
      Some small portability fixes. · 376fb080
      unknown authored
      Added support for lower_case_table_names=2, which is to be used on case insensitive file systems.
      This tells MySQL to preserve the used case of filenames and database names to make it esier to move files between cases sensitive can case insensitive file systems (like Windows and Linux)
      
      
      client/mysqltest.c:
        Indentation cleanup
      include/myisam.h:
        Made some pointers 'const'
      mysql-test/mysql-test-run.sh:
        Portability fix for OSX
      sql/filesort.cc:
        Safety fix (not needed for current code but needed for 5.0)
      sql/ha_berkeley.cc:
        More debugging
        Changed 'create' to return error number
      sql/ha_berkeley.h:
        Added HA_FILE_BASED
      sql/ha_innodb.cc:
        Added missing DBUG_RETURN
      sql/ha_isam.cc:
        Changed create to return error number
      sql/ha_isam.h:
        Added HA_FILE_BASED
      sql/ha_isammrg.h:
        Added HA_FILE_BASED
      sql/ha_myisam.cc:
        Changed create to return error number
      sql/ha_myisam.h:
        Added HA_FILE_BASED
      sql/ha_myisammrg.cc:
        Changed create to return error number
      sql/ha_myisammrg.h:
        Added HA_FILE_BASED
      sql/handler.cc:
        Ensure that table engines gets table names in lower case even if we are using lower_case_table_names
        Removed test for DB_TYPE_INNODB by ensuring that create method returns error number.
      sql/handler.h:
        Added HA_FILE_BASED
        Made some struct entries 'const'
        Added 'alias' for create to be able to create tables in mixed case on case insensitive file systems
      sql/mysql_priv.h:
        Support for lower_case_table_names=2
      sql/mysqld.cc:
        Support for lower_case_table_names=2
        Moved test of case insenstive file system after all mutex are created
      sql/set_var.cc:
        Support for lower_case_table_names=2
      sql/sql_class.h:
        Indentation change
      sql/sql_db.cc:
        Support for lower_case_table_names=2
      sql/sql_insert.cc:
        Indentation change
      sql/sql_parse.cc:
        Support for lower_case_table_names=2
      sql/sql_rename.cc:
        Support for lower_case_table_names=2
        Added missing 'unpack_filename' to RENAME which may fix a bug in RENAME TABLE on windows
      sql/sql_show.cc:
        If lower_case_table_name=2 is given, show original case in SHOW CREATE TABLE
      sql/sql_table.cc:
        Support for lower_case_table_names=2 for DROP TABLE, RENAME TABLE, ALTER TABLE and CREATE TABLE
      376fb080
  16. 12 Dec, 2003 1 commit
    • unknown's avatar
      Fix autoincrement for signed columns (Bug #1366) · 759ea82e
      unknown authored
      Fixed problem with char > 128 in QUOTE() function. (Bug #1868)
      Disable creation of symlinks if my_disable_symlink is set
      Fixed searching of TEXT with end space. (Bug #1651)
      Fixed caching bug in multi-table-update where same table was used twice. (Bug #1711)
      Fixed problem with UNIX_TIMESTAMP() for timestamps close to 0. (Bug #1998)
      Fixed timestamp.test
      
      
      include/my_base.h:
        Add HA_END_SPACE_KEY to mark keys that has VARCHAR/TEXT fields.
      myisam/mi_check.c:
        Delete not used variable
      myisam/mi_key.c:
        Fix autoincrement for signed columns (Bug #1366). Patch by Holyfoot
      myisam/mi_open.c:
        Bug fix for future (doesn't affect current code)
      myisam/mi_search.c:
        Ignore end space for VARCHAR/TEXT columns
      mysql-test/r/auto_increment.result:
        Test auto_increment with signed numbers
      mysql-test/r/binary.result:
        Update results (old result was wrong)
      mysql-test/r/func_str.result:
        Added test of QUOTE()
      mysql-test/r/func_time.result:
        Add test of unix_timestamp()
      mysql-test/r/have_met_timezone.require:
        Fixed test
      mysql-test/r/innodb.result:
        Add test for InnoDB behaviour with TRUNCATE
      mysql-test/r/multi_update.result:
        Test of multi-update bug
      mysql-test/r/symlink.result:
        Test of ALTER TABLE and symlinks
      mysql-test/r/timezone.result:
        Test of from_unixtime()
      mysql-test/r/truncate.result:
        Test of truncate and auto_increment
      mysql-test/r/type_blob.result:
        Test of key search on TEXT/VARCHAR column with end space
      mysql-test/t/auto_increment.test:
        Test auto_increment with signed numbers
      mysql-test/t/func_str.test:
        Added test of QUOTE()
      mysql-test/t/func_time.test:
        Add test of unix_timestamp()
      mysql-test/t/innodb.test:
        Add test for InnoDB behaviour with TRUNCATE
      mysql-test/t/multi_update.test:
        Test of multi-update bug
      mysql-test/t/symlink.test:
        Test of ALTER TABLE and symlinks
      mysql-test/t/timezone.test:
        Test of from_unixtime()
      mysql-test/t/truncate.test:
        Test of truncate and auto_increment
      mysql-test/t/type_blob.test:
        Test of key search on TEXT/VARCHAR column with end space
      mysys/my_symlink2.c:
        Disable creation of symlinks if my_disable_symlink is set
      sql/field.h:
        Indentation cleanup
      sql/ha_innodb.cc:
        HA_PART_KEY -> HA_PART_KEY_SEG
      sql/item_strfunc.cc:
        Fixed problem with char > 128 in QUOTE() function. (Bug #1868)
      sql/mysql_priv.h:
        Make check_dup() external
      sql/opt_range.cc:
        Fixed searching of TEXT with end space. (Bug #1651)
      sql/records.cc:
        Fixed caching bug in multi-table-update where same table was used twice.
        (Bug #1711)
      sql/sql_acl.cc:
        Reset ip and ip_mask if hostname is NULL
      sql/sql_parse.cc:
        Make check_dup() global
      sql/sql_select.cc:
        Fixed searching of TEXT with end space. (Bug #1651)
      sql/sql_table.cc:
        Fixed searching of TEXT with end space. (Bug #1651)
      sql/sql_update.cc:
        Fixed caching bug in multi-table-update where same table was used twice.
        (Bug #1711)
      sql/table.cc:
        Fixed searching of TEXT with end space. (Bug #1651)
      sql/table.h:
        Fixed caching bug in multi-table-update where same table was used twice.
        (Bug #1711)
      sql/time.cc:
        Fixed problem with UNIX_TIMESTAMP() for timestamps close to 0. (Bug #1998)
      759ea82e
  17. 17 Oct, 2003 1 commit
    • unknown's avatar
      thr0loc.c, srv0start.c, srv0srv.c, srv0srv.h, os0thread.h, ha_innodb.cc: · 14affe7e
      unknown authored
        Backport from 4.1: reduce InnoDB memory consumption if buf pool < 8 MB
      
      
      sql/ha_innodb.cc:
        Backport from 4.1: reduce InnoDB memory consumption if buf pool < 8 MB
      innobase/include/os0thread.h:
        Backport from 4.1: reduce InnoDB memory consumption if buf pool < 8 MB
      innobase/include/srv0srv.h:
        Backport from 4.1: reduce InnoDB memory consumption if buf pool < 8 MB
      innobase/srv/srv0srv.c:
        Backport from 4.1: reduce InnoDB memory consumption if buf pool < 8 MB
      innobase/srv/srv0start.c:
        Backport from 4.1: reduce InnoDB memory consumption if buf pool < 8 MB
      innobase/thr/thr0loc.c:
        Backport from 4.1: reduce InnoDB memory consumption if buf pool < 8 MB
      14affe7e
  18. 20 Aug, 2003 2 commits
    • unknown's avatar
      Fixed some varnings from valgrind · de5d47c3
      unknown authored
      Set min value of max_allowed_packet to 1024
      Fixed problem with UNION's without braces and SQL_CALC_FOUND_ROWS, LIMIT #,#
      and ORDER BY...LIMIT
      
      
      include/m_string.h:
        Added memcpy_overlap() to avoid warnings when using valgrind on memcpy(A,A,...)
      myisam/mi_create.c:
        Fixed comment
      myisam/mi_search.c:
        Fix warning from valgrind
      myisam/mi_write.c:
        Indentation fix
      mysql-test/mysql-test-run.sh:
        Add options handled by general skip- option
      mysql-test/r/packet.result:
        Update results after change to mysqld (min max_allowed_packet length is now 1024)
      mysql-test/r/union.result:
        Added testing of UNION with SQL_CALC_FOUND_ROWS
      mysql-test/t/packet.test:
        Update results after change to mysqld (min max_allowed_packet length is now 1024)
      mysql-test/t/union.test:
        Added testing of UNION with SQL_CALC_FOUND_ROWS
      sql/field.cc:
        Fix to remove waarning from valgrind
      sql/ha_innodb.cc:
        Remove wrong include file
      sql/item_cmpfunc.cc:
        Safety fix to handle EOM conditions in IN
      sql/item_sum.cc:
        Fixed prototype for update_field() (argument was alwys 0)
      sql/item_sum.h:
        Fixed prototype for update_field() (argument was alwys 0)
      sql/item_uniq.h:
        Fixed prototype for update_field() (argument was alwys 0)
      sql/log.cc:
        Indentation fix
      sql/mysqld.cc:
        Set min value of max_allowed_packet to 1024 (to avoid it getting set to 0)
      sql/net_serv.cc:
        Indentation changes + trivial optimization
      sql/sql_select.cc:
        Fixed prototype for update_field() (argument was alwys 0)
      sql/sql_union.cc:
        Fixed problem with UNION's without braces and
        - SQL_CALC_FOUND_ROWS
        - LIMIT #,#
        - ORDER BY ... LIMIT
      de5d47c3
    • unknown's avatar
      item_func.h: · 22ad5163
      unknown authored
        Fix for a bug with LEAST() in WHERE clause
      ha_innodb.cc:
        Fix for a configure bug
      multi_update.result, multi_update.test:
        Fix for the update with NULL's in the result set
      sql_update.cc:
        Fix for the update with NULL's in the result set
         Fix for the update with NULL's in the result set
         Fix for the update with NULL's in the result set
      
      
      sql/sql_update.cc:
        Fix for the update with NULL's in the result set
         Fix for the update with NULL's in the result set
         Fix for the update with NULL's in the result set
      mysql-test/t/multi_update.test:
        Fix for the update with NULL's in the result set
      mysql-test/r/multi_update.result:
        Fix for the update with NULL's in the result set
      sql/ha_innodb.cc:
        Fix for a configure bug
      sql/item_func.h:
        Fix for a bug with LEAST() in WHERE clause
      22ad5163
  19. 08 Jul, 2003 1 commit
    • unknown's avatar
      ha_innodb.cc: · f0f7eccc
      unknown authored
        Prevent the user from creating InnoDB tables with > 1000 columns
      
      
      sql/ha_innodb.cc:
        Prevent the user from creating InnoDB tables with > 1000 columns
      f0f7eccc
  20. 03 Jul, 2003 2 commits
    • unknown's avatar
      ha_innodb.cc: · a29adff6
      unknown authored
        Since the mysql interactive client or some other phase in communication cuts > 64 kB strings to very short, restrict the output of SHOW INNODB STATUS to at most 60 kB
      
      
      sql/ha_innodb.cc:
        Since the mysql interactive client or some other phase in communication cuts > 64 kB strings to very short, restrict the output of SHOW INNODB STATUS to at most 60 kB
      a29adff6
    • unknown's avatar
      Many files: · 5dc1e4b9
      unknown authored
        Remove potential starvation of a full log buffer flush: only flush up to the lsn which was the largest at the time when we requested the full log buffer flush
      os0sync.h, os0sync.c:
        Fix a bug in os_event on Unix: even though we signaled the event, some threads could continue waiting if the event became nonsignaled quickly again; this made group commit less efficient than it should be
      
      
      innobase/os/os0sync.c:
        Fix a bug in os_event on Unix: even though we signaled the event, some threads could continue waiting if the event became nonsignaled quickly again; this made group commit less efficient than it should be
      innobase/include/os0sync.h:
        Fix a bug in os_event on Unix: even though we signaled the event, some threads could continue waiting if the event became nonsignaled quickly again; this made group commit less efficient than it should be
      innobase/log/log0log.c:
        Remove potential starvation of a full log buffer flush: only flush up to the lsn which was the largest at the time when we requested the full log buffer flush
      innobase/include/log0log.h:
        Remove potential starvation of a full log buffer flush: only flush up to the lsn which was the largest at the time when we requested the full log buffer flush
      innobase/srv/srv0srv.c:
        Remove potential starvation of a full log buffer flush: only flush up to the lsn which was the largest at the time when we requested the full log buffer flush
      innobase/row/row0mysql.c:
        Remove potential starvation of a full log buffer flush: only flush up to the lsn which was the largest at the time when we requested the full log buffer flush
      innobase/trx/trx0trx.c:
        Remove potential starvation of a full log buffer flush: only flush up to the lsn which was the largest at the time when we requested the full log buffer flush
      sql/ha_innodb.cc:
        Remove potential starvation of a full log buffer flush: only flush up to the lsn which was the largest at the time when we requested the full log buffer flush
      innobase/btr/btr0btr.c:
        Remove potential starvation of a full log buffer flush: only flush up to the lsn which was the largest at the time when we requested the full log buffer flush
      5dc1e4b9
  21. 01 Jul, 2003 3 commits
    • unknown's avatar
      ha_innodb.cc: · 24d93bed
      unknown authored
        Cleanup
      
      
      sql/ha_innodb.cc:
        Cleanup
      24d93bed
    • unknown's avatar
      ha_innodb.cc: · 593c6d9a
      unknown authored
        Remove still some potential hangs over the btr0sea.c semaphore
      
      
      sql/ha_innodb.cc:
        Remove still some potential hangs over the btr0sea.c semaphore
      593c6d9a
    • unknown's avatar
      ha_innodb.cc: · 25230490
      unknown authored
        Fix a possible hang over the btr0sea.c latch
      
      
      sql/ha_innodb.cc:
        Fix a possible hang over the btr0sea.c latch
      25230490
  22. 23 Jun, 2003 1 commit
  23. 22 Jun, 2003 1 commit
    • unknown's avatar
      dict0dict.h, dict0dict.c, ha_innodb.cc: · e0be1a89
      unknown authored
        In ORDER BY MySQL seems to set the key read flag also in the case where the primary key contains only a prefix of a column - not the whole column; to prevent potential bugs retrieve the whole column if the index contains a prefix of it
      
      
      sql/ha_innodb.cc:
        In ORDER BY MySQL seems to set the key read flag also in the case where the primary key contains only a prefix of a column - not the whole column; to prevent potential bugs retrieve the whole column if the index contains a prefix of it
      innobase/dict/dict0dict.c:
        In ORDER BY MySQL seems to set the key read flag also in the case where the primary key contains only a prefix of a column - not the whole column; to prevent potential bugs retrieve the whole column if the index contains a prefix of it
      innobase/include/dict0dict.h:
        In ORDER BY MySQL seems to set the key read flag also in the case where the primary key contains only a prefix of a column - not the whole column; to prevent potential bugs retrieve the whole column if the index contains a prefix of it
      e0be1a89
  24. 15 Jun, 2003 2 commits
    • unknown's avatar
      row0mysql.c, dict0dict.ic: · 722e8060
      unknown authored
        Cleanup
      ha_innodb.cc, data0type.h:
        Make sure non-latin1 users can downgrade from 4.0.14 to an earlier version if they have not created DATA_BLOB column prefix indexes
      
      
      innobase/include/data0type.h:
        Make sure non-latin1 users can downgrade from 4.0.14 to an earlier version if they have not created DATA_BLOB column prefix indexes
      sql/ha_innodb.cc:
        Make sure non-latin1 users can downgrade from 4.0.14 to an earlier version if they have not created DATA_BLOB column prefix indexes
      innobase/include/dict0dict.ic:
        Cleanup
      innobase/row/row0mysql.c:
        Cleanup
      722e8060
    • unknown's avatar
      handler.h, ha_innodb.h, ha_innodb.cc: · 52506029
      unknown authored
        Cleanup; remove compiler warning on Windows
      
      
      sql/ha_innodb.cc:
        Cleanup; remove compiler warning on Windows
      sql/ha_innodb.h:
        Cleanup; remove compiler warning on Windows
      sql/handler.h:
        Cleanup; remove compiler warning on Windows
      52506029
  25. 14 Jun, 2003 1 commit
    • unknown's avatar
      Many files: · 8fe7e029
      unknown authored
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      
      
      sql/ha_innodb.h:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      sql/handler.h:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      sql/sql_lex.h:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      sql/ha_innodb.cc:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      sql/handler.cc:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      sql/sql_parse.cc:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      sql/sql_yacc.yy:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      include/my_base.h:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      mysql-test/t/innodb.test:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      mysql-test/r/innodb.result:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/btr/btr0cur.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/btr/btr0pcur.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/buf/buf0buf.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/buf/buf0flu.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/data/data0data.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/data/data0type.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/dict/dict0boot.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/dict/dict0crea.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/dict/dict0dict.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/dict/dict0load.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/dict/dict0mem.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/fil/fil0fil.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/fsp/fsp0fsp.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/ha/ha0ha.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/ibuf/ibuf0ibuf.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/include/btr0cur.h:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/include/buf0buf.h:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/include/data0data.h:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/include/data0type.h:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/include/db0err.h:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/include/dict0dict.h:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/include/dict0mem.h:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/include/fil0fil.h:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/include/lock0lock.h:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/include/os0file.h:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/include/page0page.h:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/include/rem0cmp.h:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/include/row0row.h:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/include/row0sel.h:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/include/row0upd.h:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/include/srv0srv.h:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/include/data0type.ic:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/include/trx0roll.h:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/include/trx0trx.h:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/include/trx0types.h:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/include/ut0dbg.h:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/include/ut0mem.h:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/include/row0mysql.ic:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/include/trx0sys.ic:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/lock/lock0lock.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/log/log0log.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/log/log0recv.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/mem/mem0pool.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/os/os0file.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/os/os0thread.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/page/page0cur.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/page/page0page.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/pars/pars0opt.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/pars/pars0pars.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/rem/rem0cmp.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/row/row0ins.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/row/row0mysql.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/row/row0row.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/row/row0sel.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/row/row0umod.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/row/row0upd.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/row/row0vers.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/srv/srv0srv.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/srv/srv0start.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/trx/trx0rec.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/trx/trx0roll.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/trx/trx0sys.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/trx/trx0trx.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/ut/ut0mem.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/ut/ut0ut.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      8fe7e029
  26. 05 Jun, 2003 2 commits
    • unknown's avatar
      ha_innodb.cc: · d3d86c12
      unknown authored
        Revert a change to dict_mem_index_add_field which slipped prematurely into the bk tree
      
      
      sql/ha_innodb.cc:
        Revert a change to dict_mem_index_add_field which slipped prematurely into the bk tree
      d3d86c12
    • unknown's avatar
      ha_innodb.cc, handler.cc: · 6d4ed167
      unknown authored
        Fix the BDB crash in the previous push; to save CPU remove duplicate calls of commit in InnoDB
      
      
      sql/handler.cc:
        Fix the BDB crash in the previous push; to save CPU remove duplicate calls of commit in InnoDB
      sql/ha_innodb.cc:
        Fix the BDB crash in the previous push; to save CPU remove duplicate calls of commit in InnoDB
      6d4ed167
  27. 02 May, 2003 1 commit
    • unknown's avatar
      Many files: · 8d8f52e9
      unknown authored
        Eliminate the LOCK_log bottleneck in group commit in binlogging: flush InnoDB log files only after it has been released
      
      
      sql/log.cc:
        Eliminate the LOCK_log bottleneck in group commit in binlogging: flush InnoDB log files only after it has been released
      sql/handler.cc:
        Eliminate the LOCK_log bottleneck in group commit in binlogging: flush InnoDB log files only after it has been released
      sql/handler.h:
        Eliminate the LOCK_log bottleneck in group commit in binlogging: flush InnoDB log files only after it has been released
      sql/ha_innodb.cc:
        Eliminate the LOCK_log bottleneck in group commit in binlogging: flush InnoDB log files only after it has been released
      sql/ha_innodb.h:
        Eliminate the LOCK_log bottleneck in group commit in binlogging: flush InnoDB log files only after it has been released
      innobase/include/log0log.h:
        Eliminate the LOCK_log bottleneck in group commit in binlogging: flush InnoDB log files only after it has been released
      innobase/include/trx0trx.h:
        Eliminate the LOCK_log bottleneck in group commit in binlogging: flush InnoDB log files only after it has been released
      innobase/os/os0file.c:
        Eliminate the LOCK_log bottleneck in group commit in binlogging: flush InnoDB log files only after it has been released
      innobase/buf/buf0flu.c:
        Eliminate the LOCK_log bottleneck in group commit in binlogging: flush InnoDB log files only after it has been released
      innobase/trx/trx0trx.c:
        Eliminate the LOCK_log bottleneck in group commit in binlogging: flush InnoDB log files only after it has been released
      innobase/log/log0log.c:
        Eliminate the LOCK_log bottleneck in group commit in binlogging: flush InnoDB log files only after it has been released
      innobase/srv/srv0srv.c:
        Eliminate the LOCK_log bottleneck in group commit in binlogging: flush InnoDB log files only after it has been released
      innobase/row/row0mysql.c:
        Eliminate the LOCK_log bottleneck in group commit in binlogging: flush InnoDB log files only after it has been released
      8d8f52e9
  28. 27 Apr, 2003 1 commit
    • unknown's avatar
      trx0trx.h, trx0trx.c, ha_innodb.cc: · 0f78cb18
      unknown authored
        Remove code never actually used in IGNORE; InnoDB just rolls back the latest row insert or update on a duplicate key error and leaves it for MySQL to decide whether to ignore the error
      
      
      sql/ha_innodb.cc:
        Remove code never actually used in IGNORE; InnoDB just rolls back the latest row insert or update on a duplicate key error and leaves it for MySQL to decide whether to ignore the error
      innobase/trx/trx0trx.c:
        Remove code never actually used in IGNORE; InnoDB just rolls back the latest row insert or update on a duplicate key error and leaves it for MySQL to decide whether to ignore the error
      innobase/include/trx0trx.h:
        Remove code never actually used in IGNORE; InnoDB just rolls back the latest row insert or update on a duplicate key error and leaves it for MySQL to decide whether to ignore the error
      0f78cb18
  29. 24 Apr, 2003 2 commits
    • unknown's avatar
      ha_innodb.cc: · aaa3e827
      unknown authored
        When FLUSH LOGS is called, flush InnoDB logs to disk also in the case innodb_flush_log_at_trx_commit=0
      
      
      sql/ha_innodb.cc:
        When FLUSH LOGS is called, flush InnoDB logs to disk also in the case innodb_flush_log_at_trx_commit=0
      aaa3e827
    • unknown's avatar
      ha_innodb.h, ha_innodb.cc: · 1e841480
      unknown authored
        Make ANALYZE TABLE to update index cardinality and other statistics also for an InnoDB table; note that the estimates are based on 10 random dives, not on an exhaustive read of the table
      
      
      sql/ha_innodb.cc:
        Make ANALYZE TABLE to update index cardinality and other statistics also for an InnoDB table; note that the estimates are based on 10 random dives, not on an exhaustive read of the table
      sql/ha_innodb.h:
        Make ANALYZE TABLE to update index cardinality and other statistics also for an InnoDB table; note that the estimates are based on 10 random dives, not on an exhaustive read of the table
      1e841480
  30. 23 Apr, 2003 1 commit
    • unknown's avatar
      Fixes for valgrind · 70324868
      unknown authored
      Added optimzation for clustered index
      Fixed bug in UPDATE ... ORDER BY
      Fixed handling of UPDATE ... LIMIT
      
      
      BitKeeper/deleted/.del-.cvsignore~7e29af89a3559f4c:
        Delete: Images/.cvsignore
      BitKeeper/deleted/.del-README~d5a4e7ca3a2e87a9:
        Delete: repl-tests/README
      BitKeeper/deleted/.del-run-all-tests~4deb6479a13e4568:
        Delete: repl-tests/run-all-tests
      BitKeeper/deleted/.del-run.test~3dc5b9bd1e9feea5:
        Delete: repl-tests/test-repl-alter/run.test
      BitKeeper/deleted/.del-run.test~4020771cff278f14:
        Delete: repl-tests/test-bad-query/run.test
      BitKeeper/deleted/.del-run.test~452f2b66537404a8:
        Delete: repl-tests/test-dump/run.test
      BitKeeper/deleted/.del-run.test~b1f0c1f96554df8:
        Delete: repl-tests/test-auto-inc/run.test
      BitKeeper/deleted/.del-table-dump-check.master~e13afeb8c79264b5:
        Delete: repl-tests/test-dump/table-dump-check.master
      BitKeeper/deleted/.del-table-dump-select.master~744acb955e33f3db:
        Delete: repl-tests/test-dump/table-dump-select.master
      BitKeeper/deleted/.del-x.master~29a93ed7956c8693:
        Delete: repl-tests/test-auto-inc/x.master
      BitKeeper/deleted/.del-x.master~3b248cbac9abda2b:
        Delete: repl-tests/test-bad-query/x.master
      BitKeeper/deleted/.del-foo-dump-master.master~b49ae6bec1e918ee:
        Delete: repl-tests/test-repl/foo-dump-master.master
      BitKeeper/deleted/.del-foo-dump-slave.master~f16ed20457d59be9:
        Delete: repl-tests/test-repl/foo-dump-slave.master
      BitKeeper/deleted/.del-repl-timestamp.master.reject~3492d2b74b413771:
        Delete: repl-tests/test-repl-ts/repl-timestamp.master.reject
      BitKeeper/deleted/.del-repl-timestamp.master~4b7782da5cc13161:
        Delete: repl-tests/test-repl-ts/repl-timestamp.master
      BitKeeper/deleted/.del-run.test~a1e32ea1e4253af4:
        Delete: repl-tests/test-repl/run.test
      BitKeeper/deleted/.del-run.test~ce5e626c91b760ec:
        Delete: repl-tests/test-repl-ts/run.test
      BitKeeper/deleted/.del-sum-wlen-master.master~1a5ea625c79e978:
        Delete: repl-tests/test-repl/sum-wlen-master.master
      BitKeeper/deleted/.del-sum-wlen-slave.master~f016d98833433084:
        Delete: repl-tests/test-repl/sum-wlen-slave.master
      BitKeeper/deleted/.del-test.master~5829e7b3770179db:
        Delete: repl-tests/test-repl-alter/test.master
      BitKeeper/deleted/.del-master-slave.inc~6775f6ae10137c39:
        Delete: repl-tests/include/master-slave.inc
      include/my_global.h:
        Fix for purify/valgrind
      myisam/mi_info.c:
        Updated comment
      mysql-test/r/group_by.result:
        New test results
      mysql-test/r/innodb.result:
        New test results
      mysql-test/r/join_outer.result:
        New test results
      mysql-test/r/multi_update.result:
        New test results
      mysql-test/r/null_key.result:
        New test results
      mysql-test/r/update.result:
        New test results
      mysql-test/t/group_by.test:
        Added extra explain to 'suspicious' test.
      mysql-test/t/innodb.test:
        Added test for UPDATE ... ORDER BY
      mysql-test/t/join_outer.test:
        Changed test to be repeatable
      mysql-test/t/multi_update.test:
        Slight change of test to catch more bugs
      mysql-test/t/update.test:
        Better test for UPDATE ... ORDER BY
      sql/field.cc:
        Simple optimization
      sql/ha_heap.h:
        Added optimzation for clustered index
      sql/ha_innodb.cc:
        Added optimzation for clustered index
      sql/ha_innodb.h:
        Added optimzation for clustered index
      sql/handler.h:
        Added optimzation for clustered index
      sql/item_sum.cc:
        Removed some usage of current_thd
      sql/mysqld.cc:
        Fix bug when compiling for purify/valgrind
      sql/opt_range.cc:
        Added optimzation for clustered index
      sql/records.cc:
        Fixed comment
      sql/sql_list.h:
        Fixed comment
      sql/sql_select.cc:
        Removed some usage of current_thd
      sql/sql_select.h:
        Removed some usage of current_thd
      sql/sql_union.cc:
        Removed some usage of current_thd
      sql/sql_update.cc:
        Fixed bug in UPDATE ... ORDER BY
        Fixed handling of UPDATE ... LIMIT
      support-files/my-huge.cnf.sh:
        Added default size for query cache
      support-files/my-large.cnf.sh:
        Added default size for query cache
      70324868
  31. 18 Apr, 2003 1 commit
    • unknown's avatar
      ha_innodb.cc: · b09b7a1f
      unknown authored
        Prevent crash if MySQL calls rnd_end WITOUT calling rnd_init first: only restore active_index if it the old value was pushed in rnd_init
        Initialize active_index to a sensible value: prevent crash if we restore it to the original value after an table scan
      
      
      sql/ha_innodb.cc:
        Prevent crash if MySQL calls rnd_end WITOUT calling rnd_init first: only restore active_index if it the old value was pushed in rnd_init
      b09b7a1f