An error occurred fetching the project authors.
  1. 08 Oct, 2005 1 commit
  2. 27 Sep, 2005 1 commit
    • unknown's avatar
      CHECKSUM TABLE now allows concurrent inserts · 94496220
      unknown authored
      myisam/mi_check.c:
        info->s->state.checksum moved to info->state->checksum
      myisam/mi_delete.c:
        info->s->state.checksum moved to info->state->checksum
      myisam/mi_delete_all.c:
        info->s->state.checksum moved to info->state->checksum
      myisam/mi_open.c:
        info->s->state.checksum moved to info->state->checksum
      myisam/mi_update.c:
        info->s->state.checksum moved to info->state->checksum
      myisam/mi_write.c:
        info->s->state.checksum moved to info->state->checksum
      myisam/myisamchk.c:
        info->s->state.checksum moved to info->state->checksum
      myisam/myisamdef.h:
        info->s->state.checksum moved to info->state->checksum
      myisam/myisampack.c:
        info->s->state.checksum moved to info->state->checksum
      mysql-test/r/system_mysql_db.result:
        result fixed
      sql/ha_myisam.cc:
        info->s->state.checksum moved to info->state->checksum
      94496220
  3. 23 Sep, 2005 2 commits
    • unknown's avatar
      Several fixes revelaled by Intel compiler. · ecffc1b8
      unknown authored
      cmd-line-utils/readline/complete.c:
        Added a cast.
      dbug/my_main.c:
        Added an include to avoid implicit declaration of
        my_thread_global_init()
      include/my_global.h:
        undef cannot be used on this predefined name.
        Since it is a custom fix for gcc 2.8.0, let's make it only
        effective in that case.
      include/my_sys.h:
        Added a new type, TYPE_NOT_SET.
      myisam/ft_boolean_search.c:
        Added casts.
      myisam/mi_key.c:
        Added cast.
      myisam/mi_open.c:
        Added cast.
        Changed function types.
      myisam/mi_test1.c:
        Added cast.
      myisam/myisamchk.c:
        Added cast.
      myisam/myisamdef.h:
        Changed function type.
      myisam/myisampack.c:
        Added casts.
      myisam/sp_key.c:
        Added cast.
      mysys/mf_iocache.c:
        Fixed invalid use of 0 to info->type. According to comment it
        should not have been set, but in earlier code by setting it
        to 0 would have been same as setting it to READ_CACHE. This
        probably was not desired, potential bug.
      server-tools/instance-manager/instance_options.cc:
        Fixed a typo.
      server-tools/instance-manager/protocol.cc:
        Changed enum to int.
        Changed char to uchar.
        Added casts.
      sql/mysql_priv.h:
        Bit overflow.
      sql/sql_base.cc:
        Removed unused label. The code below label was unused too, because
        there is a return just before.
      sql/sql_parse.cc:
        Removed unneccessary extra argument.
      ecffc1b8
    • unknown's avatar
      Bug#9112 - Merge table with composite index producing invalid results with some queries · 674c8165
      unknown authored
      The problem was an ab-use of last_rkey_length.
      Formerly we saved the packed key length (of the search key)
      in this element. But in certain cases it got replaced by 
      the (packed) result key length.
      Now we use a new element of MI_INFO to save the packed key 
      length of the search key.
      
      
      myisam/mi_dbug.c:
        Bug#9112 - Merge table with composite index producing invalid results with some queries
        Fixed the recognition of NULL values in _mi_print_key().
      myisam/mi_rkey.c:
        Bug#9112 - Merge table with composite index producing invalid results with some queries
        Saved the packed key length in a new element of MI_INFO.
      myisam/mi_search.c:
        Bug#9112 - Merge table with composite index producing invalid results with some queries
        Added a comment and trace prints.
      myisam/myisamdef.h:
        Bug#9112 - Merge table with composite index producing invalid results with some queries
        Added a new element to store the packed key length
        for use by the MyISAMMRG engine.
      myisammrg/myrg_rkey.c:
        Bug#9112 - Merge table with composite index producing invalid results with some queries
        Changed to use the new element of MI_INFO to get at the
        packed key length.
      mysql-test/r/merge.result:
        Bug#9112 - Merge table with composite index producing invalid results with some queries
        The test result.
      mysql-test/t/merge.test:
        Bug#9112 - Merge table with composite index producing invalid results with some queries
        The test case.
      674c8165
  4. 05 Sep, 2005 1 commit
    • unknown's avatar
      a fix (bug #4214: Table corruption with myisampack and large BLOB objects). · 943f8335
      unknown authored
      myisam/mi_check.c:
        a fix (bug #4214: Table corruption with myisampack and large BLOB objects).
        - pass version to the save_pack_length().
      myisam/mi_packrec.c:
        a fix (bug #4214: Table corruption with myisampack and large BLOB objects).
        - code cleanup: read_pack_length() and calc_pack_length() introduced, 
                        save_pack_length() modified: now the behavior depends on packing version
        - save packing version in the share->pack.version
        - pass it to the read_pack_length()
      myisam/mi_static.c:
        a fix (bug #4214: Table corruption with myisampack and large BLOB objects).
        - packing version set to 2
      myisam/myisamdef.h:
        a fix (bug #4214: Table corruption with myisampack and large BLOB objects).
        - packing version slot introduced (see MI_PACK)
      myisam/myisampack.c:
        a fix (bug #4214: Table corruption with myisampack and large BLOB objects).
        - code cleanup
        - pass version to the calc_pack_length() and save_pack_length()
      943f8335
  5. 19 Jul, 2005 1 commit
    • unknown's avatar
      Bug#10932 - Building server with key limit of 128, makes test cases fail · f1d5c048
      unknown authored
      This patch allows to configure MyISAM for 128 indexes per table.
      The main problem is the key_map, wich is implemented as an ulonglong.
      To get rid of the limit and keep the efficient and flexible
      implementation, the highest bit is now used for all upper keys.
      This means that the lower keys can be disabled and enabled 
      individually as usual and the high keys can only be disabled and
      enabled as a block. That way the existing test suite is still
      applicable, while more keys work, though slightly less efficient.
      To really get more than 64 keys, some defines need to be changed.
      Another patch will address this.
      
      
      include/my_bitmap.h:
        Bug#10932 - Building server with key limit of 128, makes test cases fail
        Added the declaration for a function that extends the highest bit value
        to all upper bits of a bigger bitmap.
      include/myisam.h:
        Bug#10932 - Building server with key limit of 128, makes test cases fail
        Changed MI_MAX_POSSIBLE_KEY to what it was meant for.
        Added a bunch of macros to handle the MyISAM key_map.
      myisam/mi_check.c:
        Bug#10932 - Building server with key limit of 128, makes test cases fail
        Changed key_map access to use the new macros.
      myisam/mi_create.c:
        Bug#10932 - Building server with key limit of 128, makes test cases fail
        Changed key_map access to use the new macros.
      myisam/mi_delete.c:
        Bug#10932 - Building server with key limit of 128, makes test cases fail
        Changed key_map access to use the new macros.
      myisam/mi_extra.c:
        Bug#10932 - Building server with key limit of 128, makes test cases fail
        Changed key_map access to use the new macros.
      myisam/mi_open.c:
        Bug#10932 - Building server with key limit of 128, makes test cases fail
        Changed key_map access to use the new macros.
        Changed pointer types from signed char* to unsigned char*.
      myisam/mi_preload.c:
        Bug#10932 - Building server with key limit of 128, makes test cases fail
        Changed key_map access to use the new macros.
      myisam/mi_rsame.c:
        Bug#10932 - Building server with key limit of 128, makes test cases fail
        Changed key_map access to use the new macros.
      myisam/mi_rsamepos.c:
        Bug#10932 - Building server with key limit of 128, makes test cases fail
        Changed key_map access to use the new macros.
      myisam/mi_search.c:
        Bug#10932 - Building server with key limit of 128, makes test cases fail
        Changed key_map access to use the new macros.
      myisam/mi_update.c:
        Bug#10932 - Building server with key limit of 128, makes test cases fail
        Changed key_map access to use the new macros.
      myisam/mi_write.c:
        Bug#10932 - Building server with key limit of 128, makes test cases fail
        Changed key_map access to use the new macros.
      myisam/myisamchk.c:
        Bug#10932 - Building server with key limit of 128, makes test cases fail
        Changed key_map access to use the new macros.
      myisam/myisamdef.h:
        Bug#10932 - Building server with key limit of 128, makes test cases fail
        Changed pointer types from signed char* to unsigned char*.
      myisam/myisamlog.c:
        Bug#10932 - Building server with key limit of 128, makes test cases fail
        Changed key_map access to use the new macros.
      myisam/myisampack.c:
        Bug#10932 - Building server with key limit of 128, makes test cases fail
        Changed key_map access to use the new macros.
      myisam/sort.c:
        Bug#10932 - Building server with key limit of 128, makes test cases fail
        Changed key_map access to use the new macros.
      mysys/my_bitmap.c:
        Bug#10932 - Building server with key limit of 128, makes test cases fail
        Added a function that extends the highest bit value
        to all upper bits of a bigger bitmap.
      sql/ha_myisam.cc:
        Bug#10932 - Building server with key limit of 128, makes test cases fail
        Changed key_map access to use the new macros.
      sql/sql_bitmap.h:
        Bug#10932 - Building server with key limit of 128, makes test cases fail
        Added a method that extends the highest bit value
        to all upper bits of a bigger bitmap.
      f1d5c048
  6. 13 May, 2005 1 commit
    • unknown's avatar
      concurrent-insert can now be set to 2 for concurrent inserts when there is holes in the data file · b21cf962
      unknown authored
      myisam_max_extra_sort_file_size is depricated
      Ensure that myisam_data_pointer_size is honoured when creating new MyISAM files
      Changed default value of myisam_data_pointer_size from 4 to 6 to get rid of 'table-is-full' errors
      
      
      
      include/myisam.h:
        Change type of myisam_block_size and myisam_concurrent_insert to make them changeable in mysqld.cc
        Removed not used varaible myisam_max_extra_temp_length
      include/thr_lock.h:
        Added extra parameter to get_status
      myisam/mi_create.c:
        Ensure that myisam_data_pointer_size is honoured
      myisam/mi_dynrec.c:
        If 'append_insert_at_end' is set, only write at end of myisam record file
      myisam/mi_locking.c:
        Add extra argument to 'mi_get_status' to allow thr_lock to signal that we want to do a concurrent insert
        If this is used, we will append new insert rows at end of data file.
        Change mi_check_status() to allow concurrent_inserts even if there are holes in the file when myisam_concurent_insert=2
      myisam/mi_static.c:
        Change behavior of myisam_concurrent_insert so that setting this to 2 allows inserts even if there is a hole in the data file.
        Default value is 2 for MyISAM direct usage but will be set to 1 (old default) by mysqld.cc
      myisam/mi_statrec.c:
        If 'append_insert_at_end' is set, only write at end of myisam record file
      myisam/mi_write.c:
        If 'append_insert_at_end' is set, only write at end of myisam record file
      myisam/myisamdef.h:
        Support for insert-at-end even if there is holes in data file
      mysql-test/r/gis-rtree.result:
        Test result changed because default value for myisam_data_pointer_size is changed from 4 -> 6
      mysql-test/r/group_min_max.result:
        Test result changed because default value for myisam_data_pointer_size is changed from 4 -> 6
      mysql-test/r/index_merge.result:
        Test result changed because default value for myisam_data_pointer_size is changed from 4 -> 6
      mysql-test/r/index_merge_ror.result:
        Test result changed because default value for myisam_data_pointer_size is changed from 4 -> 6
      mysql-test/r/merge.result:
        Test result changed because default value for myisam_data_pointer_size is changed from 4 -> 6
      mysql-test/r/myisam.result:
        Test of concurrent_insert=2
      mysql-test/r/null.result:
        Test result changed because default value for myisam_data_pointer_size is changed from 4 -> 6
      mysql-test/r/preload.result:
        Test result changed because default value for myisam_data_pointer_size is changed from 4 -> 6
      mysql-test/r/ps_1general.result:
        Test result changed because default value for myisam_data_pointer_size is changed from 4 -> 6
      mysql-test/r/range.result:
        Test result changed because default value for myisam_data_pointer_size is changed from 4 -> 6
      mysql-test/r/variables.result:
        concurrent_insert is now a integer, not a boolean
        myisam_extra_sort_file_size is deleted
      mysql-test/r/view.result:
        Test result changed because default value for myisam_data_pointer_size is changed from 4 -> 6
      mysql-test/t/index_merge.test:
        Test result changed because default value for myisam_data_pointer_size is changed from 4 -> 6
      mysql-test/t/myisam.test:
        Test of concurrent_insert=2
      mysql-test/t/ps_1general.test:
        Drop test table
      mysql-test/t/variables.test:
        concurrent_insert is now a integer, not a boolean
        myisam_extra_sort_file_size is deleted
      mysql-test/t/view.test:
        Drop tables that may be left from previous tests
      mysys/thr_lock.c:
        Extra paramter to get_status to signal if concurrent_insert was used
      sql/mysqld.cc:
        concurrent-insert can now be set to 2 for concurrent inserts when there is holes in the data file
        myisam_max_extra_sort_file_size is depricated
      sql/set_var.cc:
        concurrent-insert is now an integer, not a bool
        myisam_max_extra_sort_file_size is deleted
      b21cf962
  7. 11 Apr, 2005 1 commit
  8. 02 Mar, 2005 1 commit
    • unknown's avatar
      Bug#8306 - TRUNCATE leads to index corruption · 26f75ffc
      unknown authored
      Added a check, if the table, which we are going to create, is open.
      This can happen if a MERGE mapped table is TRUNCATEd.
      
      
      myisam/mi_open.c:
        Bug#8306 - TRUNCATE leads to index corruption
        Made test_if_reopen() globally available.
      myisam/myisamdef.h:
        Bug#8306 - TRUNCATE leads to index corruption
        Declared test_if_reopen() as globally available.
      mysql-test/r/myisam.result:
        Bug#8306 - TRUNCATE leads to index corruption
        The test result.
      mysql-test/t/myisam.test:
        Bug#8306 - TRUNCATE leads to index corruption
        The test case.
      26f75ffc
  9. 31 Dec, 2004 1 commit
    • unknown's avatar
      After merge fixes · 45199f54
      unknown authored
      Cleanup of mi_print_error() handling
      Deleted 'merge' directory
      
      
      BitKeeper/deleted/.del-mrg_close.c~1fa9230422daa62a:
        Delete: merge/mrg_close.c
      BitKeeper/deleted/.del-mrg_create.c~b747c8ec2b801f6:
        Delete: merge/mrg_create.c
      BitKeeper/deleted/.del-mrg_delete.c~38b4156885bb4537:
        Delete: merge/mrg_delete.c
      BitKeeper/deleted/.del-mrg_extra.c~7eb6181e1761907e:
        Delete: merge/mrg_extra.c
      BitKeeper/deleted/.del-mrg_info.c~37728e7238cc5a11:
        Delete: merge/mrg_info.c
      BitKeeper/deleted/.del-mrg_locking.c~112756a2d581e1d0:
        Delete: merge/mrg_locking.c
      BitKeeper/deleted/.del-mrg_open.c~6e1d5c8bfa62a519:
        Delete: merge/mrg_open.c
      BitKeeper/deleted/.del-mrg_panic.c~e204e43cd6d55406:
        Delete: merge/mrg_panic.c
      BitKeeper/deleted/.del-mrg_rrnd.c~6087c3dd7ecb77:
        Delete: merge/mrg_rrnd.c
      BitKeeper/deleted/.del-mrg_rsame.c~3e8ed4be2a0952b1:
        Delete: merge/mrg_rsame.c
      BitKeeper/deleted/.del-mrg_static.c~75a4b78a165dbd0:
        Delete: merge/mrg_static.c
      BitKeeper/deleted/.del-mrg_update.c~4110a4f1fbf1ab45:
        Delete: merge/mrg_update.c
      BitKeeper/deleted/.del-Makefile.am~41238af048e60515:
        Delete: merge/Makefile.am
      BitKeeper/deleted/.del-make-ccc~4f1acbfc127e25d5:
        Delete: merge/make-ccc
      BitKeeper/deleted/.del-mrg_def.h~a10557d12a87ef1c:
        Delete: merge/mrg_def.h
      BitKeeper/deleted/.del-.cvsignore~2f287ba794db3da7:
        Delete: merge/.cvsignore
      include/myisam.h:
        Added 'share' to st_mi_keydef' to not have to pass 'st_myisam_info' to functions
      myisam/ft_static.c:
        Removed compiler warning
      myisam/mi_delete.c:
        Cleanup of mi_print_error() handling
        Break if get_key() return 0
        Don't test for HA_ERR_CRASHED; Print errors when my_errno is set
      myisam/mi_extra.c:
        Cleanup of mi_print_error() handling
      myisam/mi_key.c:
        Cleanup of mi_print_error() handling
      myisam/mi_keycache.c:
        Cleanup of mi_print_error() handling
      myisam/mi_locking.c:
        Cleanup of mi_print_error() handling
      myisam/mi_open.c:
        Added 'my_isam_share' to MI_KEYDEF
      myisam/mi_page.c:
        Cleanup of mi_print_error() handling
      myisam/mi_range.c:
        get_key() calls mi_print_error() if needed
      myisam/mi_rkey.c:
        Cleanup of mi_print_error() handling
      myisam/mi_search.c:
        Cleanup of mi_print_error() handling
        Break if get_key() return 0
        Don't test for HA_ERR_CRASHED; Print errors when my_errno is set
      myisam/mi_update.c:
        Cleanup of mi_print_error() handling
      myisam/mi_write.c:
        Cleanup of mi_print_error() handling
        Break if get_key() return 0
        Don't test for HA_ERR_CRASHED; Print errors when my_errno is set
      myisam/myisamdef.h:
        Cleanup of mi_print_error() handling
      mysql-test/r/grant.result:
        Update results after merge
      mysql-test/r/timezone2.result:
        Update results after merge
      mysql-test/t/grant.test:
        New error numbers
      mysql-test/t/timezone2.test:
        New error numbers
      sql/item_func.cc:
        Remove duplicate include file
      sql/sql_acl.cc:
        Remove warnings from valgrind
      sql/tztime.cc:
        Print wrong timezone names to log
      45199f54
  10. 23 Dec, 2004 1 commit
    • unknown's avatar
      WL#1895 - Print message to error log in case of detected MyISAM corruption · bec3feaa
      unknown authored
      Changed my_error() to print error messages, which come from
      arbitrary registered ranges of error messages. Messages can
      be unregistered (and should be at end of the program).
      Added registration of handler error messages.
      Added a new mi_print_error() macro and a new 
      mi_report_error() function, which supply error
      messages with a table name.
      Added calls to mi_print_error() or mi_report_error()
      at all places in MyISAM, where table corruption is detected.
      
      
      extra/comp_err.c:
        WL#1895 - Print message to error log in case of detected MyISAM corruption
        Added prints for ER_ERROR_FIRST and ER_ERROR_LAST.
        Removed print for ER_ERROR_MESSAGES.
      include/errmsg.h:
        WL#1895 - Print message to error log in case of detected MyISAM corruption
        Added declaration for a new function.
        Added first and last error number defines.
      include/my_base.h:
        WL#1895 - Print message to error log in case of detected MyISAM corruption
        Added first and last error number defines.
      include/my_sys.h:
        WL#1895 - Print message to error log in case of detected MyISAM corruption
        Removed obsolete defines.
        Removed a global variable, which held pointers to the error message arrays.
        Added declarations for new functions.
      include/mysys_err.h:
        WL#1895 - Print message to error log in case of detected MyISAM corruption
        Removed an obsolete define.
        Changed two defines to use the new defines.
        Added first and last error number defines.
      libmysql/errmsg.c:
        WL#1895 - Print message to error log in case of detected MyISAM corruption
        Replaced global array initialization by proper registration
        and unregistration of client error messages.
      libmysql/libmysql.c:
        WL#1895 - Print message to error log in case of detected MyISAM corruption
        Added a call for unregistration of client error messages.
      myisam/mi_delete.c:
        WL#1895 - Print message to error log in case of detected MyISAM corruption
        Added calls to the new error logging function at all places, where
        corruption is detected.
        Added a debugging call to pretend MyISAM corruption in case a special
        debug string is set.
        Added a debugging call to test undefined error numbers in case a special
        debug string is set.
      myisam/mi_extra.c:
        WL#1895 - Print message to error log in case of detected MyISAM corruption
        Added calls to the new error logging function at all places, where
        corruption is detected.
      myisam/mi_info.c:
        WL#1895 - Print message to error log in case of detected MyISAM corruption
        Added the error logging function.
      myisam/mi_key.c:
        WL#1895 - Print message to error log in case of detected MyISAM corruption
        Added calls to the new error logging function at all places, where
        corruption is detected.
      myisam/mi_keycache.c:
        WL#1895 - Print message to error log in case of detected MyISAM corruption
        Added calls to the new error logging function at all places, where
        corruption is detected.
      myisam/mi_locking.c:
        WL#1895 - Print message to error log in case of detected MyISAM corruption
        Added calls to the new error logging function at all places, where
        corruption is detected.
      myisam/mi_open.c:
        WL#1895 - Print message to error log in case of detected MyISAM corruption
        Added calls to the new error logging function at all places, where
        corruption is detected.
        Added a debugging call to pretend MyISAM corruption in case a special
        debug string is set.
      myisam/mi_page.c:
        WL#1895 - Print message to error log in case of detected MyISAM corruption
        Added calls to the new error logging function at all places, where
        corruption is detected.
      myisam/mi_range.c:
        WL#1895 - Print message to error log in case of detected MyISAM corruption
        Added calls to the new error logging function at all places, where
        corruption is detected.
      myisam/mi_rkey.c:
        WL#1895 - Print message to error log in case of detected MyISAM corruption
        Added calls to the new error logging function at all places, where
        corruption is detected.
      myisam/mi_search.c:
        WL#1895 - Print message to error log in case of detected MyISAM corruption
        Added calls to the new error logging function at all places, where
        corruption is detected.
      myisam/mi_update.c:
        WL#1895 - Print message to error log in case of detected MyISAM corruption
        Added calls to the new error logging function at all places, where
        corruption is detected.
        Added a debugging call to pretend MyISAM corruption in case a special
        debug string is set.
      myisam/mi_write.c:
        WL#1895 - Print message to error log in case of detected MyISAM corruption
        Added calls to the new error logging function at all places, where
        corruption is detected.
        Added a debugging call to pretend MyISAM corruption in case a special
        debug string is set.
      myisam/myisamdef.h:
        WL#1895 - Print message to error log in case of detected MyISAM corruption
        Added the declaration of the new error logging function
        and a new macro.
      mysql-test/r/merge.result:
        WL#1895 - Print message to error log in case of detected MyISAM corruption
        Changed test results. These come from the changed error reporting
        in openfrm().
      mysql-test/r/repair.result:
        WL#1895 - Print message to error log in case of detected MyISAM corruption
        Changed test results. These come from the changed error reporting
        in openfrm().
      mysql-test/t/merge.test:
        WL#1895 - Print message to error log in case of detected MyISAM corruption
        Changederror numbers. These come from the changed error reporting
        in openfrm().
      mysys/errors.c:
        WL#1895 - Print message to error log in case of detected MyISAM corruption
        Dropped the assignment of the global errors to the
        dropped global pointer array.
      mysys/my_error.c:
        WL#1895 - Print message to error log in case of detected MyISAM corruption
        Changed my_error() from using a static array of pointers to
        error message arrays to using a linked list of structures
        with pointers to array message arrays.
        Added functions for registering and unregistering error 
        message arrays to the chain.
      sql/derror.cc:
        WL#1895 - Print message to error log in case of detected MyISAM corruption
        Changed reading of mysqld error messages to using the new
        registering and unregistering functions.
      sql/handler.cc:
        WL#1895 - Print message to error log in case of detected MyISAM corruption
        Added initialization and deinitialization of handler error messages.
        Included more handler error messages in the mapping to
        mysqld error messages.
      sql/mysqld.cc:
        WL#1895 - Print message to error log in case of detected MyISAM corruption
        Changed deinitialization of error messages to proper
        unregistration.
      sql/table.cc:
        WL#1895 - Print message to error log in case of detected MyISAM corruption
        Changed error reporting in openfrm() so that error messages from
        handler::ha_open() are reported by handler::print_error(). This
        changed messages from "Can't open 't1.MYI' (errno: 130)" to
        "Incorrect file format 't1'" for example.
      sql/unireg.h:
        WL#1895 - Print message to error log in case of detected MyISAM corruption
        Changed two defines to use the new defines.
      bec3feaa
  11. 12 Jul, 2004 1 commit
  12. 26 May, 2004 1 commit
    • unknown's avatar
      Changed prototype of killed_ptr() to make it more portable · 30bffb02
      unknown authored
      Applied patches for Netware
      
      
      innobase/include/os0thread.h:
        Applied patches for Netware
      innobase/os/os0thread.c:
        Applied patches for Netware
      libmysql/libmysql.c:
        Applied patches for Netware
      libmysql/libmysql.def:
        Applied patches for Netware
      myisam/myisamchk.c:
        Applied patches for Netware
        Changed prototype of killed_ptr() to make it more portable
      myisam/myisamdef.h:
        Applied patches for Netware
        Changed prototype of killed_ptr() to make it more portable
      mysql-test/t/rpl_relayspace-slave.opt:
        Applied patches for Netware
      mysys/my_pthread.c:
        Applied patches for Netware
      mysys/my_static.h:
        Portability fix
      netware/BUILD/compile-linux-tools:
        Applied patches for Netware
        Changed prototype of killed_ptr() to make it more portable
      netware/BUILD/mwenv:
        Applied patches for Netware
        Changed prototype of killed_ptr() to make it more portable
      netware/BUILD/nwbootstrap:
        Applied patches for Netware
        Changed prototype of killed_ptr() to make it more portable
      netware/my_manage.c:
        Applied patches for Netware
        Changed prototype of killed_ptr() to make it more portable
      netware/mysql_fix_privilege_tables.pl:
        Applied patches for Netware
        Changed prototype of killed_ptr() to make it more portable
      netware/mysql_test_run.c:
        Applied patches for Netware
        Changed prototype of killed_ptr() to make it more portable
      netware/static_init_db.sql:
        Applied patches for Netware
        Changed prototype of killed_ptr() to make it more portable
      scripts/make_binary_distribution.sh:
        Applied patches for Netware
        Changed prototype of killed_ptr() to make it more portable
      sql/filesort.cc:
        Changed prototype of killed_ptr() to make it more portable
      sql/ha_myisam.cc:
        Changed prototype of killed_ptr() to make it more portable
      sql/mysqld.cc:
        Fixed some typos for Netware
      sql/sql_bitmap.h:
        Applied patches for Netware
      sql/sql_class.h:
        Changed prototype of killed_ptr() to make it more portable
      sql/sql_insert.cc:
        safety fix
      strings/my_strtoll10.c:
        Added comment
      30bffb02
  13. 06 May, 2004 1 commit
    • unknown's avatar
      WL#1687 - Optimize UNION DISTINCT ... UNION ALL (again). · bfe2425a
      unknown authored
      HEAP: Copies the key count to a backup variable and sets the key count to zero.
      That way, no HEAP function will ever try to touch any index.
      Re-enabling is done by copying back the backup variable.
      To avoid memory leak at table close, disable deletes all index trees.
      Re-enabling must be done with empty indexes and data anyway. Otherwise,
      the indexes would need to be repaired, wich HEAP is not capable of.
      MyISAM: Only the key_map is cleared and set.
      Re-enabling must be done with empty indexes and data. Otherwise, repair needs
      to be done which will enable all keys persistently.
      The former implementation disabled only non-unique keys and maked this persistent.
      The new implementation additionally can disable all keys, but only without
      making this persistent. Re-enabling all keys can be done without repair,
      if data file and indexes are empty.
      
      
      heap/heapdef.h:
        WL#1687 - Optimize UNION DISTINCT ... UNION ALL (again).
        Pulled hp_clear_keys() out of hp_clear().
      heap/hp_clear.c:
        WL#1687 - Optimize UNION DISTINCT ... UNION ALL (again).
        Pulled hp_clear_keys() out of hp_clear().
        Added the new functions for disabling and enabling keys and to ask for the key state.
      include/heap.h:
        WL#1687 - Optimize UNION DISTINCT ... UNION ALL (again).
        Added a new HP_SHARE element to save the key count while keys are disabled.
        Added declarations for the new functions.
      myisam/mi_open.c:
        WL#1687 - Optimize UNION DISTINCT ... UNION ALL (again).
        Added the new functions for disabling and enabling keys and to ask for the key state.
      myisam/myisamdef.h:
        WL#1687 - Optimize UNION DISTINCT ... UNION ALL (again).
        Added declarations for the new functions.
      sql/ha_heap.cc:
        WL#1687 - Optimize UNION DISTINCT ... UNION ALL (again).
        Pulled set_keys_for_scanning() out of open().
        Added the new functions for disabling and enabling keys and to ask for the key state.
      sql/ha_heap.h:
        WL#1687 - Optimize UNION DISTINCT ... UNION ALL (again).
        Added declarations for the new functions.
      sql/ha_myisam.cc:
        WL#1687 - Optimize UNION DISTINCT ... UNION ALL (again).
        Extended disable_indexes() for all keys and no save.
        The argument is now 'mode' as it must handle different cases.
        Extended enable_indexes() for no save.
        The new feature needs the new argument 'mode' with the same semantics as in disable_indexes().
        Added indexes_are_disabled() to ask for the key state.
        Extended the existing call to enable_indexes() by the new argument.
      sql/ha_myisam.h:
        WL#1687 - Optimize UNION DISTINCT ... UNION ALL (again).
        Modified the declarations of dis-/enable_indexes() for the new argument.
        Added the declaration of the new function to ask for the key state.
      sql/handler.h:
        WL#1687 - Optimize UNION DISTINCT ... UNION ALL (again).
        Added declarations for the operation modes for the key switching functions.
        Modified the declarations of dis-/enable_indexes() for the new argument.
        Added the declaration of the new function to ask for the key state.
      sql/sql_select.cc:
        WL#1687 - Optimize UNION DISTINCT ... UNION ALL (again).
        In create_myisam_from_heap() take notice of disabled keys
        and disable them in the new table before copying the data.
      sql/sql_table.cc:
        WL#1687 - Optimize UNION DISTINCT ... UNION ALL (again).
        Modified the calls of dis-/enable_indexes() for the new argument.
      bfe2425a
  14. 08 Apr, 2004 1 commit
    • unknown's avatar
      always call start_bulk_insert, clarify this behaviour in comment block · e51447b1
      unknown authored
      change 10 to a #define'd constant
      
      
      myisam/myisamdef.h:
        use a constant with a difficult-to-type name instead of two-digit number :)
      sql/ha_myisam.cc:
        use a constant with a difficult-to-type name instead of two-digit number :)
      sql/sql_insert.cc:
        always call start_bulk_insert (it performs all checks itself)
        removed spurious semicolon at the end of the "if" :)
        added a clarifying comment
      e51447b1
  15. 02 Apr, 2004 1 commit
  16. 20 Jan, 2004 1 commit
  17. 20 Nov, 2003 1 commit
    • unknown's avatar
      Merge key cache structures to one · 35da5e43
      unknown authored
      Fixed compiler warnings (IRIX C compiler and VC++)
      
      
      VC++Files/client/mysqlclient.dsp:
        Add missing file to project
      VC++Files/libmysql/libmysql.dsp:
        Add missing file to project
      VC++Files/myisam/myisam.dsp:
        Add missing file to project
      VC++Files/mysys/mysys.dsp:
        Add missing file to project
      heap/hp_test1.c:
        Fixed wrong call to heap_rkey()
      heap/hp_test2.c:
        Fixed wrong call to heap_rkey()
      include/hash.h:
        Move not used (internal) struct to hash.c
      include/my_pthread.h:
        Made some structs 'const char*' to avoid warnings
      include/my_sys.h:
        Moved key cache structs and functions to keycache.h
      include/myisam.h:
        Merge key cache structures to one
      include/mysql.h:
        Remove STDCALL from internal functions
      include/sql_common.h:
        Remove STDCALL from internal functions
      include/violite.h:
        Fixed compiler warning
      isam/_locking.c:
        Merge key cache structures to one
      isam/_page.c:
        Merge key cache structures to one
      isam/close.c:
        Merge key cache structures to one
      isam/extra.c:
        Merge key cache structures to one
      isam/isamchk.c:
        Merge key cache structures to one
      isam/isamdef.h:
        Merge key cache structures to one
      isam/isamlog.c:
        Merge key cache structures to one
      isam/panic.c:
        Merge key cache structures to one
      isam/test2.c:
        Merge key cache structures to one
      isam/test3.c:
        Merge key cache structures to one
      libmysql/client_settings.h:
        Remove STDCALL from internal functions
      libmysql/libmysql.c:
        Remove STDCALL from internal functions
      myisam/ft_boolean_search.c:
        Fixed compiler warning
      myisam/ft_dump.c:
        Fixed compiler warnings (%qx is not portable)
      myisam/ft_update.c:
        Fixed compiler warnings
      myisam/mi_check.c:
        Merge key cache structures to one
      myisam/mi_close.c:
        Merge key cache structures to one
      myisam/mi_delete_all.c:
        Merge key cache structures to one
      myisam/mi_extra.c:
        Merge key cache structures to one
      myisam/mi_keycache.c:
        Merge key cache structures to one
      myisam/mi_locking.c:
        Merge key cache structures to one
      myisam/mi_page.c:
        Merge key cache structures to one
      myisam/mi_panic.c:
        Merge key cache structures to one
      myisam/mi_preload.c:
        Merge key cache structures to one
      myisam/mi_test1.c:
        Merge key cache structures to one
      myisam/mi_test2.c:
        Merge key cache structures to one
      myisam/mi_test3.c:
        Merge key cache structures to one
      myisam/myisamchk.c:
        Merge key cache structures to one
      myisam/myisamdef.h:
        Merge key cache structures to one
      myisam/myisamlog.c:
        Merge key cache structures to one
        Removed not used option
      myisam/sort.c:
        Fixed compiler warnings
      myisam/sp_test.c:
        Fixed compiler warnings
      mysql-test/r/case.result:
        Updated results after fix of correct NULL detection in WHEN
      mysql-test/r/date_formats.result:
        Updated results after fixing date handling
      mysql-test/r/symlink.result:
        Updated results after adding DEFAULT CHARSET
      mysql-test/t/case.test:
        New test
      mysql-test/t/symlink.test:
        Updated error numbers
      mysys/hash.c:
        Made HASH_LINK struct local
      mysys/mf_keycache.c:
        Merge key cache structures to one
        Fixed key_cache_read() and key_cache_write() to be resize-safe.
      mysys/mf_keycaches.c:
        Merge key cache structures to one
      mysys/thr_mutex.c:
        Added test if mutex is initalized
      sql-common/client.c:
        Remove STDCALL from internal functions
      sql/derror.cc:
        Added comment
      sql/field.cc:
        Removed not used variables
      sql/ha_innodb.cc:
        Fixed compiler warnings (removed not used variables)
      sql/ha_myisam.cc:
        Merge key cache structures to one
      sql/ha_myisammrg.cc:
        Removed not used variables
      sql/handler.cc:
        Merge key cache structures to one
      sql/handler.h:
        Merge key cache structures to one
      sql/item.cc:
        Fixed compiler warning
      sql/item_cmpfunc.cc:
        Remove not used variables
      sql/item_func.cc:
        Remove not used variables
      sql/item_strfunc.cc:
        Removed not used variables
      sql/item_sum.cc:
        Removed not used variables
        Moved setting of item_thd to fix_fields()
      sql/item_timefunc.cc:
        Removed not used variables
      sql/mysql_priv.h:
        Merge key cache structures to one
      sql/mysqld.cc:
        Merge key cache structures to one
        init_thread_environment() is not called before mysql_init_variables(). This fixes a case where a mutex was not initialized before it was used
      sql/opt_sum.cc:
        Remove not used variables
      sql/protocol.cc:
        Don't send errors after ok has been sent
      sql/protocol_cursor.cc:
        Remove not used variable
        Simple optimization
      sql/repl_failsafe.cc:
        Remove not used variables
      sql/set_var.cc:
        Merge key cache structures to one
      sql/set_var.h:
        Merge key cache structures to one
      sql/sql_acl.cc:
        Remove not used variables
      sql/sql_base.cc:
        Remove not used function
      sql/sql_db.cc:
        Remove not used variables
      sql/sql_handler.cc:
        Remove not used variables
      sql/sql_insert.cc:
        More DBUG statements
        Simple code cleanup
      sql/sql_lex.cc:
        Remove not used variables
      sql/sql_parse.cc:
        Remove not used variables
      sql/sql_prepare.cc:
        Remove not used variables
      sql/sql_repl.cc:
        Remove not used variables
      sql/sql_select.cc:
        Remove not used variables
      sql/sql_show.cc:
        Remove not used variables
      sql/sql_table.cc:
        Merge key cache structures to one
        Removed not used variables
      sql/sql_test.cc:
        Merge key cache structures to one
      sql/strfunc.cc:
        Fixed that find_type() returns correct value for partly matched words.
        (This fixed the error found by date_formats.test)
      sql/time.cc:
        Remove not used variables
      strings/my_strtoll10.c:
        Fixed compiler warnings
      35da5e43
  18. 18 Nov, 2003 1 commit
    • unknown's avatar
      CLIENT_MULTI_QUERIES -> CLIENT_MULTI_STATEMENTS · e72124c4
      unknown authored
      New multi-key-cache handling. This was needed becasue the old one didn't work reliable with MERGE tables.
      ALTER TABLE table_name ... CHARACTER SET  ... now changes all char/varchar/text columns to the given character set
      (One must use ALTER TABLE ... DEFAULT CHARACTER SET ... to change the default character set)
      Fixed that have_compress is detected properly (fixes problems with func_compress.test on platforms without zlib)
      New syntax for CACHE INDEX ('keys' is optional if no index name is given and one mentions the key cache name only ones)
      Removed compiler warnings
      Added mysql_set_server_option() to allow clients like PHP to easaily set/reset the multi-statement flag.
      
      
      BUILD/compile-pentium-valgrind-max:
        Add test of isam
      client/mysql.cc:
        CLIENT_MULTI_QUERIES -> CLIENT_MULTI_STATEMENTS
      include/my_base.h:
        Remove HA_EXTRA_SET_KEY_CACHE
      include/my_no_pthread.h:
        Add defines to ignore rw-locks when running without threads
      include/my_sys.h:
        Added function for multi-key-caches
      include/myisam.h:
        Added function to handle multi-key-caches
      include/mysql.h:
        Added mysql_set_server_option
      include/mysql_com.h:
        CLIENT_MULTI_QUERIES -> CLIENT_MULTI_STATEMENTS
        Added enum_mysql_set_option
      include/mysqld_error.h:
        Added error message for unknown key cache
      innobase/srv/srv0start.c:
        Removed warning that is confused for MySQL users
      libmysql/libmysql.c:
        Added mysql_set_server_option()
      libmysql/libmysql.def:
        Added mysql_set_server_option()
      myisam/ft_nlq_search.c:
        Removed compiler warning
      myisam/ft_static.c:
        Removed compiler warning and fixed wrong return value
      myisam/mi_check.c:
        Clean up multi-key-cache usage
      myisam/mi_checksum.c:
        Removed not used variable
      myisam/mi_close.c:
        keycache -> key_cache
      myisam/mi_delete_all.c:
        keycache -> key_cache
      myisam/mi_extra.c:
        keycache -> key_cache
        Removed HA_EXTRA_SET_KEY_CACHE
      myisam/mi_keycache.c:
        Changed logic so that it's MyISAM that is responsible for assign tables to different key caches instead of the upper level
      myisam/mi_locking.c:
        Don't change key cache on unlock (must be done before)
      myisam/mi_open.c:
        Fetch key cache to use from multi_key_cache_search()
      myisam/mi_page.c:
        keycache -> key_cache
      myisam/mi_panic.c:
        keycache -> key_cache
      myisam/mi_preload.c:
        keycache -> key_cache
      myisam/mi_test1.c:
        Use KEY_CACHE_BLOCK_SIZE
      myisam/mi_test2.c:
        Always test resize_key_cache()
      myisam/mi_test3.c:
        Use KEY_CACHE_BLOCK_SIZE instead of 512
      myisam/myisamchk.c:
        update for multiple key caches
      myisam/myisamdef.h:
        Remove reg_keycache
        Add unique_name_length for storing length of unique_file_name
      myisam/myisamlog.c:
        Change how end_key_cache() is called
      mysql-test/mysql-test-run.sh:
        Fixed web link
        Added name of failed test to abort row.
      mysql-test/r/alter_table.result:
        Testing of ALTER TABLE ... [DEFAULT] CHARACTER SET
      mysql-test/r/case.result:
        Update result for DEFAULT CHARSET...
      mysql-test/r/cast.result:
        Update result for DEFAULT CHARSET...
      mysql-test/r/create.result:
        Update result for DEFAULT CHARSET...
      mysql-test/r/ctype_collate.result:
        Update result for DEFAULT CHARSET...
      mysql-test/r/ctype_latin1_de.result:
        Update result for DEFAULT CHARSET...
      mysql-test/r/ctype_many.result:
        Update result for DEFAULT CHARSET...
      mysql-test/r/ctype_mb.result:
        Update result for DEFAULT CHARSET...
      mysql-test/r/ctype_recoding.result:
        Update result for DEFAULT CHARSET...
      mysql-test/r/ctype_ucs.result:
        Update result for DEFAULT CHARSET...
      mysql-test/r/derived.result:
        Use STRAIGHT_JOIN to make join order predictable
      mysql-test/r/fulltext.result:
        Update result for DEFAULT CHARSET...
      mysql-test/r/func_str.result:
        Update result for DEFAULT CHARSET...
      mysql-test/r/func_system.result:
        Update result for DEFAULT CHARSET...
      mysql-test/r/gis-rtree.result:
        Update result for DEFAULT CHARSET...
      mysql-test/r/innodb.result:
        Update result for DEFAULT CHARSET...
      mysql-test/r/key_cache.result:
        Update test for new key cache syntax.
        Added more tests
      mysql-test/r/merge.result:
        Update result for DEFAULT CHARSET...
      mysql-test/r/preload.result:
        New syntax
      mysql-test/r/show_check.result:
        Update result for DEFAULT CHARSET...
      mysql-test/r/sql_mode.result:
        Update result for DEFAULT CHARSET...
      mysql-test/r/subselect.result:
        Update result for DEFAULT CHARSET...
      mysql-test/r/type_blob.result:
        Update result for DEFAULT CHARSET...
      mysql-test/r/type_enum.result:
        Update result for DEFAULT CHARSET...
      mysql-test/r/type_nchar.result:
        Update result for DEFAULT CHARSET...
      mysql-test/r/type_set.result:
        Update result for DEFAULT CHARSET...
      mysql-test/r/union.result:
        Use STRAIGHT_JOIN to make join order predictable
      mysql-test/t/alter_table.test:
        Testing of ALTER TABLE ... [DEFAULT] CHARACTER SET
      mysql-test/t/ctype_many.test:
        Update result for DEFAULT CHARSET...
      mysql-test/t/derived.test:
        Use STRAIGHT_JOIN to make join order predictable
      mysql-test/t/isam.test:
        Use disable warnings for test loop
      mysql-test/t/join.test:
        Update test now when we only support 61 tables in join
      mysql-test/t/key_cache.test:
        Update test for new key cache syntax.
        Added more tests
      mysql-test/t/preload.test:
        Update for new syntax
      mysql-test/t/union.test:
        Use STRAIGHT_JOIN to make join order predictable
      mysys/Makefile.am:
        Added mf_keycaches.c
      mysys/hash.c:
        TRUE -> 1
      mysys/mf_keycache.c:
        Removed compiler warnings
        Striped end space
        Fixed indentation and improved function comments
        TRUE -> 1
        Changed parameters to end_key_cache() to make it easer to use
        Fixed bug when using key blocks size > 1024 bytes (First part of index file could be overwritten with wrong data)
        Split function flush_key_blocks into two functions to not get mutex used twice when called from flush_all_key_blocks()
      mysys/my_bitmap.c:
        More debugging
        Safe bitmap_free()
        Fixed indentation
      mysys/my_getopt.c:
        Ensure that we initialize option->value, option->max_value and value from GET_ASK_ADDR
      mysys/my_thr_init.c:
        Remove not used mutex THR_LOCK_keycache
      mysys/typelib.c:
        Fixed function comments
      sql-common/client.c:
        CLIENT_MULTI_QUERIES -> CLIENT_MULTI_STATEMENTS
        Fixed the multi_result flag is set also on SELECT;s
      sql/ha_myisam.cc:
        Fixed multiple key_cache handling
        (Now done on MyISAM level)
      sql/ha_myisammrg.cc:
        Fixed multiple key_cache handling
        (Now done on MyISAM level)
      sql/handler.cc:
        New multi key cache handling
      sql/handler.h:
        New multi key cache handling
        Added support for default character set
      sql/item.h:
        Added function cleanup() (Needed for prepared statements / cursors)
      sql/item_cmpfunc.h:
        Added cleanup function
      sql/item_func.cc:
        Indentation cleanup
      sql/mysql_priv.h:
        New multi-key-cache functions
        Removed LOCK_assign
      sql/mysqld.cc:
        New multi-key-cache handling
        Fixed that variable have_compress is set correctly
      sql/protocol.cc:
        SELECT didn't work reliable in multi-statements
      sql/set_var.cc:
        Support for new key cache variables
      sql/set_var.h:
        Support for new key cache variables
      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/serbian/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 all key_cache handling (this is now done on MyISAM level)
        Change table_charset -> default_table_charset
      sql/sql_db.cc:
        table_charset -> default_table_charset
      sql/sql_delete.cc:
        table_charset -> default_table_charset
      sql/sql_lex.cc:
        CLIENT_MULTI_QUERIES -> CLIENT_MULTI_STATEMENTS
      sql/sql_lex.h:
        New option to store a name and length
      sql/sql_parse.cc:
        Support for mysql_set_server_option()
        Reset "default" keycache status variables in 'FLUSH STATUS' (Need to be improved later)
      sql/sql_show.cc:
        Add DEFAULT before CHARSET (for table character sets)
        Fetch key cache variables from 'sql_key_cache'
      sql/sql_table.cc:
        table_charset -> default_table_charset
        New multi-key-cache handling
      sql/sql_test.cc:
        Write information from all key caches
      sql/sql_yacc.yy:
        Changed syntax for CACHE INDEX ...
        Force user to use DEFAULT before database/table level character sets
      sql/structs.h:
        Added SHOW_KEY_CACHE_LONG (to get values from sql_key_cache)
      sql/table.cc:
        table_charset -> default_table_charset
      sql/table.h:
        New key cache handling (this is now done in mysys/mf_keycaches.c)
      sql/unireg.h:
        A
      e72124c4
  19. 04 Nov, 2003 1 commit
    • unknown's avatar
      fix for r-tree code (memory overlap reported by valgrind) · a1fcc351
      unknown authored
      new comments.
      
      
      myisam/mi_open.c:
        fix for r-tree code (memory overlap reported by valgrind)
      myisam/myisamdef.h:
        fix for r-tree code (memory overlap reported by valgrind)
      myisam/rt_index.c:
        fix for r-tree code (memory overlap reported by valgrind)
      BitKeeper/etc/logging_ok:
        Logging to logging@openlogging.org accepted
      a1fcc351
  20. 02 Oct, 2003 1 commit
  21. 24 Sep, 2003 1 commit
  22. 09 Aug, 2003 1 commit
    • unknown's avatar
      set_var.cc, mysqld.cc, handler.cc, set_var.h, handler.h: · cbd85f9d
      unknown authored
        Added key cache parameters for midpoint insertion strategy
      Many files:
        Added midpoint insertion strategy for key cache
      mi_test2.c:
        Added a parameter to resize_key_cache
      
      
      mysys/mf_keycache.c:
        Added midpoint insertion strategy for key cache
      myisam/mi_check.c:
        Added midpoint insertion strategy for key cache
      myisam/mi_page.c:
        Added midpoint insertion strategy for key cache
      myisam/mi_range.c:
        Added midpoint insertion strategy for key cache
      myisam/rt_index.c:
        Added midpoint insertion strategy for key cache
      myisam/rt_split.c:
        Added midpoint insertion strategy for key cache
      myisam/mi_delete.c:
        Added midpoint insertion strategy for key cache
      myisam/mi_preload.c:
        Added midpoint insertion strategy for key cache
      myisam/mi_search.c:
        Added midpoint insertion strategy for key cache
      myisam/mi_write.c:
        Added midpoint insertion strategy for key cache
      myisam/rt_key.c:
        Added midpoint insertion strategy for key cache
      myisam/mi_test2.c:
        Added a parameter to resize_key_cache
      isam/_page.c:
        Added midpoint insertion strategy for key cache
      include/my_sys.h:
        Added midpoint insertion strategy for key cache
      myisam/myisamdef.h:
        Added midpoint insertion strategy for key cache
      sql/handler.h:
        Added key cache parameters for midpoint insertion strategy.
      sql/set_var.h:
        Added key cache parameters for midpoint insertion strategy.
      sql/handler.cc:
        Added key cache parameters for midpoint insertion strategy.
      sql/mysqld.cc:
        Added key cache parameters for midpoint insertion strategy.
      sql/set_var.cc:
        Added key cache parameters for midpoint insertion strategy.
      cbd85f9d
  23. 02 Aug, 2003 1 commit
    • unknown's avatar
      Many files: · b6d27e20
      unknown authored
        Added key cache assignment
      mi_locking.c:
        Added key cache assignment: correction
      my_sys.h:
        Added key cache variable structure
      
      
      include/my_sys.h:
        Added key cache variable structure
      include/my_base.h:
        Added key cache assignment
      include/myisam.h:
        Added key cache assignment
      include/my_global.h:
        Added key cache assignment
      isam/_page.c:
        Added key cache assignment
      isam/close.c:
        Added key cache assignment
      isam/isamchk.c:
        Added key cache assignment
      isam/isamlog.c:
        Added key cache assignment
      isam/panic.c:
        Added key cache assignment
      isam/_locking.c:
        Added key cache assignment
      isam/test2.c:
        Added key cache assignment
      isam/test3.c:
        Added key cache assignment
      myisam/myisamdef.h:
        Added key cache assignment
      myisam/mi_check.c:
        Added key cache assignment
      myisam/mi_close.c:
        Added key cache assignment
      myisam/mi_extra.c:
        Added key cache assignment
      myisam/mi_page.c:
        Added key cache assignment
      myisam/mi_panic.c:
        Added key cache assignment
      myisam/mi_preload.c:
        Added key cache assignment
      myisam/mi_test1.c:
        Added key cache assignment
      myisam/mi_test2.c:
        Added key cache assignment
      myisam/mi_test3.c:
        Added key cache assignment
      myisam/myisamchk.c:
        Added key cache assignment
      myisam/myisamlog.c:
        Added key cache assignment
      myisam/mi_delete_all.c:
        Added key cache assignment
      myisam/mi_locking.c:
        Added key cache assignment: correction
      myisam/mi_keycache.c:
        Added key cache assignment
      sql/handler.h:
        Added key cache assignment
      sql/mysql_priv.h:
        Added key cache assignment
      sql/set_var.h:
        Added key cache assignment
      sql/table.h:
        Added key cache assignment
      sql/ha_myisam.cc:
        Added key cache assignment
      sql/ha_myisammrg.cc:
        Added key cache assignment
      sql/handler.cc:
        Added key cache assignment
      sql/mysqld.cc:
        Added key cache assignment
      sql/set_var.cc:
        Added key cache assignment
      sql/sql_base.cc:
        Added key cache assignment
      sql/sql_table.cc:
        Added key cache assignment
      sql/sql_test.cc:
        Added key cache assignment
      sql/sql_yacc.yy:
        Added key cache assignment
      mysys/mf_keycache.c:
        Added key cache assignment
      mysql-test/t/key_cache.test:
        Added key cache assignment
      mysql-test/r/key_cache.result:
        Added key cache assignment
      b6d27e20
  24. 19 Jul, 2003 1 commit
    • unknown's avatar
      Fix for #712 with Serg's suggestions · 5aef292a
      unknown authored
      myisam/mi_locking.c:
        Here we use F_EXTRA_LCK
      myisam/myisamchk.c:
        lines of "locking - emulation" replaced with mi_lock_database call
      myisam/myisamdef.h:
        no need for MI_TEMPORARY_TABLE
      sql/ha_myisam.cc:
        We use F_WRLCK instead MI_TEMPORARY_TABLE
      5aef292a
  25. 14 Jul, 2003 1 commit
    • unknown's avatar
      Proposed bugfix for #712 · 02808985
      unknown authored
      Monty revoked any locks for temporary tables in
      ha_myisam::external_lock()
      But further code bans using write cache on nonlocked tables
      this makes operations much slower
      
      
      myisam/mi_locking.c:
        Handling of MI_TEMPORARY_TABLE lock
      myisam/myisamdef.h:
        defining of MI_TEMPORARY_TABLE
      sql/ha_myisam.cc:
        now we lock temporary tables using MI_TEMPORARY_TABLE lock
      02808985
  26. 12 Jun, 2003 1 commit
    • unknown's avatar
      Many files: · f7aed024
      unknown authored
        New feature: preload indexes into key cache.
      mi_preload.c:
        new file
      Many files:
        Added preload statement.
      
      
      sql/ha_myisam.h:
        Added preload statement.
      sql/handler.cc:
        Added preload statement.
      sql/lex.h:
        Added preload statement.
      sql/mysql_priv.h:
        Added preload statement.
      sql/sql_lex.h:
        Added preload statement.
      sql/sql_base.cc:
        Added preload statement.
      sql/sql_table.cc:
        New feature: preload indexes into key cache.
      sql/sql_parse.cc:
        New feature: preload indexes into key cache.
      sql/mysqld.cc:
        New feature: preload indexes into key cache.
      sql/set_var.cc:
        New feature: preload indexes into key cache.
      sql/sql_yacc.yy:
        New feature: preload indexes into key cache.
      sql/ha_myisam.cc:
        New feature: preload indexes into key cache.
      sql/table.h:
        New feature: preload indexes into key cache.
      mysys/mf_keycache.c:
        New feature: preload indexes into key cache.
      myisam/myisamdef.h:
        New feature: preload indexes into key cache.
      myisam/mi_extra.c:
        New feature: preload indexes into key cache.
      myisam/Makefile.am:
        New feature: preload indexes into key cache.
      include/my_base.h:
        New feature: preload indexes into key cache.
      include/my_sys.h:
        New feature: preload indexes into key cache.
      include/myisam.h:
        New feature: preload indexes into key cache.
      f7aed024
  27. 21 May, 2003 1 commit
    • unknown's avatar
      After merge fixes · f72611b4
      unknown authored
      Added initialization of all important global variables
      
      
      BUILD/SETUP.sh:
        build with readline
      client/mysqltest.c:
        Added variable SERVER_VERSION
      myisam/mi_key.c:
        Indentation change
      myisam/mi_open.c:
        After merge fix
      myisam/mi_range.c:
        After merge fix
      myisam/mi_rkey.c:
        After merge fix
      myisam/mi_search.c:
        After merge fix
      myisam/myisamdef.h:
        After merge fix
      mysql-test/include/not_embedded.inc:
        Fix test (because of wrong utf8 test)
      mysql-test/r/alter_table.result:
        Updated results after merge
      mysql-test/r/create.result:
        Updated results after merge
      mysql-test/r/ctype_recoding.result:
        Updated results after merge
      mysql-test/r/fulltext.result:
        Updated results after merge
      mysql-test/r/func_group.result:
        Updated results after merge
      mysql-test/r/group_by.result:
        Updated results after merge
      mysql-test/r/innodb.result:
        Updated results after merge
      mysql-test/r/join_outer.result:
        Updated results after merge
      mysql-test/r/null_key.result:
        Updated results after merge
      mysql-test/r/order_by.result:
        Updated results after merge
      mysql-test/r/query_cache.result:
        Updated results after merge
      mysql-test/r/repair.result:
        Updated results after merge
      mysql-test/r/rpl_flush_tables.result:
        Updated results after merge
      mysql-test/r/union.result:
        Updated results after merge
      mysql-test/r/update.result:
        Updated results after merge
      mysql-test/t/ansi.test:
        After merge fixes
      mysql-test/t/create.test:
        After merge fixes
      mysql-test/t/ctype_recoding.test:
        After merge fixes
      mysql-test/t/ctype_ujis.test:
        After merge fixes
      mysql-test/t/fulltext.test:
        After merge fixes
      mysql-test/t/innodb.test:
        After merge fixes
      mysql-test/t/join_outer.test:
        After merge fixes
      mysql-test/t/loaddata.test:
        After merge fixes
      mysql-test/t/order_by.test:
        After merge fixes
      mysql-test/t/rpl_flush_tables.test:
        After merge fixes
      mysql-test/t/status.test:
        After merge fixes
      mysql-test/t/subselect.test:
        After merge fixes
      sql/convert.cc:
        Code cleanup
      sql/field.cc:
        After merge fixes
      sql/filesort.cc:
        Remove compiler warning
      sql/item.cc:
        More efficient set_name() (no mallocs)
      sql/item_cmpfunc.cc:
        Code Code cleanup
        Item_bool_func2::fix_fields() added to get error handling right for cmp_charset
      sql/item_cmpfunc.h:
        New prototypes
      sql/item_func.cc:
        After merge fix
      sql/item_strfunc.cc:
        Faster check for BINARY
      sql/log_event.cc:
        Comment cleanup
      sql/mysql_priv.h:
        New prototypes and variables
      sql/mysqld.cc:
        Added initialization of all important global variables.
        Cleanup of variable declarations
        This is needed ot make the embedded version restartable
      sql/opt_sum.cc:
        After merge fix
      sql/set_var.cc:
        Code cleanup
      sql/sql_acl.cc:
        After merge fix
        Better error message
      sql/sql_db.cc:
        After merge fix
      sql/sql_derived.cc:
        After merge fix
      sql/sql_insert.cc:
        Indentation cleanups
      sql/sql_list.h:
        Added empty() to base_ilist
      sql/sql_parse.cc:
        After merge fix
      sql/sql_select.cc:
        After merge fix
        Fixed derived name handling in EXPLAIN
      sql/sql_show.cc:
        After merge fix
      sql/sql_string.cc:
        Made copy_and_convert global
      sql/sql_string.h:
        Made copy_and_convert global
      sql/sql_update.cc:
        After merge fix
      sql/sql_yacc.yy:
        After merge fix
      sql/thr_malloc.cc:
        Added sql_strmake_with_convert()
      sql/unireg.h:
        Added MAX_ALIAS_NAME
      strings/ctype-ujis.c:
        Fixed bug in converting to ujis
      f72611b4
  28. 05 May, 2003 1 commit
    • unknown's avatar
      Removed compiler warnings · b96aaea7
      unknown authored
      Fixed memory leak in new filesort code
      Optimzed sub selects to use keys with outer references.
      Increased max tables in join to 62
      
      
      client/Makefile.am:
        Remve test programs
      myisam/mi_check.c:
        Remove compiler warnings
      myisam/mi_delete.c:
        Remove 'rnd' variable to make usage repeatable
      myisam/mi_open.c:
        Remove 'rnd' variable to make usage repeatable
      myisam/mi_write.c:
        Remove 'rnd' variable to make usage repeatable
      myisam/myisamdef.h:
        Remove 'rnd' variable to make usage repeatable
      myisam/myisamlog.c:
        Remove 'rnd' variable to make usage repeatable
      mysql-test/r/subselect.result:
        new test
      mysql-test/t/join.test:
        Updated test
      mysql-test/t/subselect.test:
        new test
      sql/filesort.cc:
        Added function to free buffers allocated by filesort
      sql/item.cc:
        Sub select optimization
      sql/item_cmpfunc.cc:
        Sub select optimization
      sql/item_subselect.cc:
        Sub select optimization
      sql/item_sum.cc:
        Removed compiler warnings
      sql/item_sum.h:
        Simple code cleanup
      sql/log.cc:
        Removed compiler warning
      sql/mysql_priv.h:
        Made table_map ulonglong to allow 62 tables in join
      sql/records.cc:
        Moved free of filesort buffers to own function
      sql/sql_select.cc:
        subselect optimization
        Call filesort_free_buffers() to free memory from filesort
      sql/unireg.h:
        Sub select optimization
      b96aaea7
  29. 27 Apr, 2003 1 commit
    • unknown's avatar
      Fixed problem when comparing a key for a multi-byte-character set. (bug 152) · f22be777
      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.
      f22be777
  30. 23 Apr, 2003 1 commit
  31. 08 Apr, 2003 1 commit
    • unknown's avatar
      SCRUM · 131d9000
      unknown authored
      two KILL versions
      code trimming with headquarter's suggestions 
      
      
      myisam/mi_check.c:
        killed_ptr function changed backward
      myisam/myisamchk.c:
        killed_ptr function changed backward
      myisam/myisamdef.h:
        killed_ptr function changed backward
      myisam/sort.c:
        killed_ptr function changed backward
      sql/ha_myisam.cc:
        killed_ptr function changed backward
      sql/lock.cc:
        error sending trimmed
      sql/log_event.cc:
        error sending trimmed
      sql/records.cc:
        error sending trimmed
      sql/slave.cc:
        error sending trimmed
      sql/sql_class.h:
        inline functions to send right message about killing added
      sql/sql_delete.cc:
        error sending trimmed
      sql/sql_load.cc:
        error sending trimmed
      sql/sql_parse.cc:
        error sending trimmed
      sql/sql_prepare.cc:
        error sending trimmed
      sql/sql_select.cc:
        error sending trimmed
      sql/sql_table.cc:
        error sending trimmed
      sql/sql_update.cc:
        error sending trimmed
      131d9000
  32. 31 Mar, 2003 1 commit
    • unknown's avatar
      SCRUM · 3814f2a8
      unknown authored
      two KILL commands implementation (version 2)
      
      
      include/mysqld_error.h:
        Error message about query interruption added
      myisam/mi_check.c:
        killed_ptr now retutns only value - not pointer
      myisam/myisamchk.c:
        killed_ptr returns value now
      myisam/myisamdef.h:
        killed_ptr returns value now
      myisam/sort.c:
        killed_ptr returns value now
      sql/filesort.cc:
        THD::killed now has enum type
      sql/ha_berkeley.cc:
        THD::killed has enum type
      sql/ha_myisam.cc:
        killed_ptr returns value now
      sql/lock.cc:
        two different errors possible here now
      sql/log_event.cc:
        two ways of killing possible here now
      sql/mysqld.cc:
        THD::killed has enum type now
      sql/records.cc:
        two errors are possible here now
      sql/share/czech/errmsg.txt:
        new error message
      sql/share/danish/errmsg.txt:
        new error message
      sql/share/dutch/errmsg.txt:
        new error message
      sql/share/english/errmsg.txt:
        new error message
      sql/share/estonian/errmsg.txt:
        new error message
      sql/share/french/errmsg.txt:
        new error message
      sql/share/german/errmsg.txt:
        new error message
      sql/share/greek/errmsg.txt:
        new error message
      sql/share/hungarian/errmsg.txt:
        new error message
      sql/share/italian/errmsg.txt:
        new error message
      sql/share/japanese/errmsg.txt:
        new error message
      sql/share/korean/errmsg.txt:
        new error message
      sql/share/norwegian-ny/errmsg.txt:
        new error message
      sql/share/norwegian/errmsg.txt:
        new error message
      sql/share/polish/errmsg.txt:
        new error message
      sql/share/portuguese/errmsg.txt:
        new error message
      sql/share/romanian/errmsg.txt:
        new error message
      sql/share/russian/errmsg.txt:
        new error message
      sql/share/serbian/errmsg.txt:
        new error message
      sql/share/slovak/errmsg.txt:
        new error message
      sql/share/spanish/errmsg.txt:
        new error message
      sql/share/swedish/errmsg.txt:
        new error message
      sql/share/ukrainian/errmsg.txt:
        new error message
      sql/slave.cc:
        two errors are possible here now
      sql/sql_base.cc:
        THD::killed has enum type now
      sql/sql_cache.cc:
        THD::killed has enum type now
      sql/sql_class.cc:
        THD::awake implementation changed to handle KILL_QUERY
      sql/sql_class.h:
        class THD changed to handle KILL_QUERY
      sql/sql_delete.cc:
        two errors are possible here now
      sql/sql_insert.cc:
        THD::killed has enum type now
      sql/sql_load.cc:
        two errors are possible here now
      sql/sql_parse.cc:
        kill_one_thread function changed to handle KILL_QUERY
      sql/sql_prepare.cc:
        two errors are possible here now
      sql/sql_repl.cc:
        the parameter to awake is of THD::killed_state type now
      sql/sql_repl.h:
        awake parameter changed
      sql/sql_select.cc:
        two errors are possible here now
      sql/sql_show.cc:
        notification adopted to changes in class THD
      sql/sql_table.cc:
        two errors are possible here now
      sql/sql_update.cc:
        two errors are possible here now
      3814f2a8
  33. 19 Feb, 2003 1 commit
  34. 18 Feb, 2003 1 commit
  35. 30 Jan, 2003 1 commit
  36. 21 Jan, 2003 1 commit
    • unknown's avatar
      Two-level index structure for FULLTEXT indexes · 76078f2c
      unknown authored
      myisam/ftdefs.h:
        intermediate cleanup checkin
      myisam/mi_create.c:
        intermediate cleanup checkin
      myisam/myisamchk.c:
        intermediate cleanup checkin
      myisam/ft_parser.c:
        intermediate cleanup checkin
      myisam/ft_update.c:
        intermediate cleanup checkin
      myisam/mi_update.c:
        intermediate cleanup checkin
      mysql-test/r/fulltext.result:
        stopword test
      mysql-test/t/fulltext.test:
        stopword test
      mysys/mulalloc.c:
        function comments clarified
      include/my_handler.h:
        get_key_length_rdonly utility macro
      include/myisam.h:
        this kind of hacks bites :)
      myisam/ft_dump.c:
        bugfix
      myisam/mi_open.c:
        bugfix
      myisam/sort.c:
        bugfixing
      myisam/mi_rnext.c:
        not a solution at all, but a temporary fix to make
        mi_rnext to work on ft2 index. (only ft_dump uses mi_rnext
        on fulltext indexes for now).
      myisam/ft_boolean_search.c:
        ft_sintXkorr, ft_intXstore
      myisam/ft_nlq_search.c:
        ft_sintXkorr, ft_intXstore
      myisam/fulltext.h:
        ft_sintXkorr, ft_intXstore
      myisam/mi_check.c:
        ft_sintXkorr, ft_intXstore
      myisam/ft_static.c:
        two-level tree support in wi_write()
      myisam/mi_write.c:
        two-level tree support in wi_write()
      myisam/myisamdef.h:
        two-level tree support in wi_write()
      myisam/mi_delete.c:
        support for ft2 in mi_delete
      mysql-test/r/fulltext2.result:
        support for ft2 in mi_delete
      mysql-test/t/fulltext2.test:
        support for ft2 in mi_delete
      76078f2c
  37. 09 Jan, 2003 1 commit
    • unknown's avatar
      Don't count NULL values in cardinalty for MyISAM tables. · b5e37b24
      unknown authored
      Free row buffer cache after each query for MyISAM tables.
      Added table join option FORCE INDEX
      Fixed core dump bug when connecting with hostname that could not be resolved.
      
      
      include/my_base.h:
        Don't count NULL values in cardinalty
      myisam/mi_check.c:
        Don't count NULL values in cardinalty
      myisam/mi_extra.c:
        Free row buffer cache after each query
      myisam/mi_open.c:
        Avoid realloc if cache size doesn't change
      myisam/mi_search.c:
        Don't count NULL values in cardinalty
      myisam/myisamdef.h:
        Change buffer length from uint to uint32 to make it more portable/predictable
      mysql-test/r/myisam.result:
        Test case for cardinality with NULL keys and FORCE INDEX
      mysql-test/t/myisam.test:
        Test case for cardinality with NULL keys and FORCE INDEX
      sql/lex.h:
        Added table join option FORCE INDEX
      sql/mysql_priv.h:
        Added table join option FORCE INDEX
      sql/opt_range.cc:
        Added table join option FORCE INDEX
      sql/sql_base.cc:
        Added table join option FORCE INDEX
      sql/sql_lex.h:
        Added table join option FORCE INDEX
      sql/sql_parse.cc:
        Added table join option FORCE INDEX
        Don't use strlen() on hostname without first checking if it's not NULL
      sql/sql_select.cc:
        Added table join option FORCE INDEX
      sql/sql_yacc.yy:
        Added table join option FORCE INDEX
      sql/table.h:
        Added table join option FORCE INDEX
      b5e37b24
  38. 07 Dec, 2002 1 commit
    • unknown's avatar
      bulk insert code optimized · 6271ea35
      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
      6271ea35
  39. 25 Nov, 2002 1 commit