1. 15 Sep, 2001 1 commit
  2. 08 Sep, 2001 1 commit
    • unknown's avatar
      More debug info · 4f08177e
      unknown authored
      Fix DBUG_ASSERT()
      Optimization for BDB tables
      Fix for BDB under Win98
      
      
      Docs/manual.texi:
        Removed wrong info
      bdb/os_win32/os_rename.c:
        Fix for windows 98
      configure.in:
        Better options for MAC OS X
      include/dbug.h:
        Fix DBUG_ASSERT()
      mysys/thr_lock.c:
        More DBUG messages
      sql/ha_berkeley.cc:
        Use cursor in remove_key
      sql/lock.cc:
        Fix possible problem when pre-unlocking tables in SELECT
      sql/sql_select.cc:
        More DBUG messages
      sql/violite.c:
        Fix DBUG messages
      4f08177e
  3. 02 Sep, 2001 1 commit
    • unknown's avatar
      Changed DB_TYPE_INNOBASE to DB_TYPE_INNODB · 1ceee5ce
      unknown authored
      Fix that DROP DATABASE works with all table types
      Use BULK_INSERT when inserting more than one row
      Better TRUNCATE TABLE
      
      
      BitKeeper/deleted/.del-compilation_finished.au.gz~70bd14095a918139:
        Delete: sounds/compilation_finished.au.gz
      BUILD/FINISH.sh:
        Removed 'finished' sound as this isn't a general solution.
      Docs/manual.texi:
        Added upgrading from 3.23
      configure.in:
        Fixed version number
      sql/ha_innobase.cc:
        Default creation of InnoDB tables.
      sql/ha_myisam.cc:
        Disable BULK_INSERT of using safe mode
      sql/handler.cc:
        Changed DB_TYPE_INNOBASE to DB_TYPE_INNODB
      sql/handler.h:
        Changed DB_TYPE_INNOBASE to DB_TYPE_INNODB
      sql/lock.cc:
        Added lock_and_wait_for_table_name
      sql/mysql_priv.h:
        Better TRUNCATE TABLE
      sql/sql_db.cc:
        Fix that DROP DATABASE works with all table types
      sql/sql_delete.cc:
        Better TRUNCATE TABLE
      sql/sql_insert.cc:
        Use BULK_INSERT when inserting more than one row
      sql/sql_load.cc:
        Small bug fix.
      sql/sql_parse.cc:
        Better TRUNCATE TABLE
      sql/sql_select.cc:
        Change INNOBASE -> INNODB
      sql/sql_table.cc:
        Better TRUNCATE TABLE
      sql/sql_yacc.yy:
        INNOBASE -> INNODB
      sql/thr_malloc.cc:
        Fix for replication
      1ceee5ce
  4. 24 Aug, 2001 1 commit
    • unknown's avatar
      EXPLAIN on UNION"s · 9fc66454
      unknown authored
      mysql-test/r/union.result:
        New result for EXPLAIN UNION's
      mysql-test/t/union.test:
        No error when EXPLAIN is done on UNION's
      9fc66454
  5. 21 Aug, 2001 1 commit
    • unknown's avatar
      Portability fixes. · 4e46aa46
      unknown authored
      Patches required by Gemini
      Fix to properly detect if there is an active transaction in InnoDB
      Fix to not lock thread structure when doing automatic rollback when thread ends
      Allow -O lower_case_names=0 on UNIX
      
      
      Docs/manual.texi:
        Some updates from mailing list.
        Changelog
      client/mysqlbinlog.cc:
        Removed variables declared in net.c
      configure.in:
        Added test for strtoll and fixed test for gethostname_r for AIX
      mysql-test/t/innodb.test:
        Added test of active transactions
      sql/field.cc:
        Patch required by Gemini
      sql/field.h:
        Patch required by Gemini
      sql/filesort.cc:
        Patch required by Gemini
      sql/gen_lex_hash.cc:
        Update to support new syntax
      sql/ha_gemini.cc:
        Patch required by Gemini
      sql/ha_gemini.h:
        Patch required by Gemini
      sql/ha_innobase.cc:
        Fix to properly detect if there is an active transaction in InnoDB
      sql/handler.cc:
        Fix to properly detect if there is an active transaction in InnoDB
      sql/handler.h:
        Fix to properly detect if there is an active transaction in InnoDB...
      4e46aa46
  6. 14 Aug, 2001 1 commit
    • unknown's avatar
      Remove warnings and portability fixes · 2e1b37af
      unknown authored
      New global read lock code
      Fixed bug in DATETIME with WHERE optimization
      Made UNION code more general.
      
      
      include/global.h:
        Remove warning on Linux Alpha
      include/mysql_com.h:
        Move some C variables inside extern "C" block.
      include/mysqld_error.h:
        New error mesages
      myisam/mi_write.c:
        cleanup
      mysql-test/r/select.result:
        Fix because of table lists now always has a database argument.
      mysql-test/r/type_datetime.result:
        Test for bug with datetime and where optimization
      mysql-test/r/union.result:
        Updated result
      mysql-test/t/type_datetime.test:
        New test for datetime
      mysql-test/t/union.test:
        More testing of error conditions
      sql/item_sum.cc:
        Remove warnings on Linux Alpha
      sql/item_sum.h:
        Cleanup
      sql/lock.cc:
        Cleaned up global lock handling
      sql/log_event.cc:
        Removed default arguments from declarations (not allowed in cxx)
      sql/mysql_priv.h:
        New prototypes
      sql/mysqld.cc:
        Fix for global locks
      sql/opt_range.cc:
        Cleanup
      sql/share/czech/errmsg.txt:
        New errors
      sql/share/danish/errmsg.txt:
        New errors
      sql/share/dutch/errmsg.txt:
        New errors
      sql/share/english/errmsg.txt:
        New errors
      sql/share/estonian/errmsg.txt:
        New errors
      sql/share/french/errmsg.txt:
        New errors
      sql/share/german/errmsg.txt:
        New errors
      sql/share/greek/errmsg.txt:
        New errors
      sql/share/hungarian/errmsg.txt:
        New errors
      sql/share/italian/errmsg.txt:
        New errors
      sql/share/japanese/errmsg.txt:
        New errors
      sql/share/korean/errmsg.txt:
        New errors
      sql/share/norwegian-ny/errmsg.txt:
        New errors
      sql/share/norwegian/errmsg.txt:
        New errors
      sql/share/polish/errmsg.txt:
        New errors
      sql/share/portuguese/errmsg.txt:
        New errors
      sql/share/romanian/errmsg.txt:
        New errors
      sql/share/russian/errmsg.txt:
        New errors
      sql/share/slovak/errmsg.txt:
        New errors
      sql/share/spanish/errmsg.txt:
        New errors
      sql/share/swedish/errmsg.OLD:
        New errors
      sql/share/swedish/errmsg.txt:
        New errors
      sql/sql_acl.cc:
        Use thd->host_or_ip
      sql/sql_class.cc:
        Use new global lock code
      sql/sql_class.h:
        host_or_ip
      sql/sql_db.cc:
        host_or_ip
      sql/sql_delete.cc:
        Use now global lock code
      sql/sql_lex.h:
        Cleanup of not used states and variables
      sql/sql_parse.cc:
        Use now global locks.
        Made UNION code more general.
        Change to use thd->hosts_or_ip.
        TABLE_LIST now always has 'db' set.
      sql/sql_repl.cc:
        Portability fixes.
        Changed wrong usage of my_vsnprintf -> my_snprintf
      sql/sql_select.cc:
        Changes for UNION
      sql/sql_show.cc:
        Cleanup
      sql/sql_union.cc:
        Handle 'select_result' outside of mysql_union().
      sql/sql_yacc.yy:
        Fixes for union
      2e1b37af
  7. 10 Aug, 2001 1 commit
    • unknown's avatar
      Fixed bug in ALTER TABLE for MERGE tables · 8700c563
      unknown authored
      Portability fixes
      Fixed problem when giving wrong arguments to myisam_recover
      Fix to remove warnings when using purify
      
      
      BUILD/compile-solaris-sparc-purify:
        Added innodb and berkeleydb to test
      mysql-test/install_test_db.sh:
        Portability fix.
      sql/ha_myisam.cc:
        Fixed problem when giving wrong arguments to myisam_recover
      sql/ha_myisammrg.cc:
        Fixed bug in ALTER TABLE for MERGE tables
      sql/sql_list.h:
        Fix to remove warnings when using purify
      sql/sql_select.cc:
        Fix to remove warnings from purify
      BitKeeper/etc/logging_ok:
        Logging to logging@openlogging.org accepted
      8700c563
  8. 09 Aug, 2001 1 commit
    • unknown's avatar
      Added new optino --sql-mode to mysqld. · 48827070
      unknown authored
      Docs/manual.texi:
        New option, --sql-mode=option[,option[,option]]
      sql/ha_myisam.cc:
        Fixed a segmentation fault -bug with myisam-recover which
        occurred if option specified was not a legal one.
      sql/mysql_priv.h:
        New option --sql-mode
      sql/mysqld.cc:
        New option --sql-mode
      sql/sql_class.cc:
        New option --sql-mode
      sql/sql_class.h:
        New option --sql-mode
      sql/sql_lex.cc:
        option --sql-mode, ansi_quotes and ignore_space
      sql/sql_parse.cc:
        option --sql-mode, ignore_space
      sql/sql_select.cc:
        option --sql-mode, mode only_full_group_by
      sql/sql_yacc.yy:
        option --sql-mode, modes pipes_as_concat and real_as_float
      BitKeeper/etc/logging_ok:
        Logging to logging@openlogging.org accepted
      48827070
  9. 08 Aug, 2001 1 commit
  10. 02 Aug, 2001 1 commit
    • unknown's avatar
      Fix UNION · c22138ba
      unknown authored
      New faster list iterators
      Change list code to be simpler and faster
      Optimize count(distinct)
      New error messages for UNION
      Make create_tmp_table more general to be usable by UNION
      
      
      Docs/manual.texi:
        Changelog
      include/mysqld_error.h:
        Add new error messages needed for UNION
      mysql-test/r/union.result:
        New tests for UNION
      mysql-test/t/analyse.test:
        Add missing drop table
      mysql-test/t/union.test:
        new tests for UNION
      sql/Makefile.am:
        Change name of sql_unions.cc to sql_union.cc
      sql/item.cc:
        Use List_iterator_fast
      sql/item_cmpfunc.cc:
        Use List_iterator_fast
      sql/item_func.cc:
        Use List_iterator_fast
      sql/item_sum.cc:
        Use List_iterator_fast
        Optimize count(distinct)
        Cleanup of indentation and comments
      sql/item_sum.h:
        Optimize count(distinct)
      sql/key.cc:
        Use List_iterator_fast
      sql/mysql_priv.h:
        Add new option bits
      sql/opt_sum.cc:
        Use List_iterator_fast
      sql/share/Makefile.am:
        Add 'fix_errors' label
      sql/share/czech/errmsg.txt:
        Add new error messages needed for UNION
      sql/share/danish/errmsg.txt:
        Add new error messages needed for UNION
      sql/share/dutch/errmsg.txt:
        Add new error messages needed for UNION
      sql/share/english/errmsg.txt:
        Add new error messages needed for UNION
      sql/share/estonian/errmsg.txt:
        Add new error messages needed for UNION
      sql/share/french/errmsg.txt:
        Add new error messages needed for UNION
      sql/share/german/errmsg.txt:
        Add new error messages needed for UNION
      sql/share/greek/errmsg.txt:
        Add new error messages needed for UNION
      sql/share/hungarian/errmsg.txt:
        Add new error messages needed for UNION
      sql/share/italian/errmsg.txt:
        Add new error messages needed for UNION
      sql/share/japanese/errmsg.txt:
        Add new error messages needed for UNION
      sql/share/korean/errmsg.txt:
        Add new error messages needed for UNION
      sql/share/norwegian-ny/errmsg.txt:
        Add new error messages needed for UNION
      sql/share/norwegian/errmsg.txt:
        Add new error messages needed for UNION
      sql/share/polish/errmsg.txt:
        Add new error messages needed for UNION
      sql/share/portuguese/errmsg.txt:
        Add new error messages needed for UNION
      sql/share/romanian/errmsg.txt:
        Add new error messages needed for UNION
      sql/share/russian/errmsg.txt:
        Add new error messages needed for UNION
      sql/share/slovak/errmsg.txt:
        Add new error messages needed for UNION
      sql/share/spanish/errmsg.txt:
        Add new error messages needed for UNION
      sql/share/swedish/errmsg.txt:
        Add new error messages needed for UNION
      sql/sql_analyse.cc:
        Use List_iterator_fast
      sql/sql_base.cc:
        Use List_iterator_fast
        Add new argument to setup_fields
      sql/sql_class.cc:
        Use List_iterator_fast
      sql/sql_class.h:
        Create new class for UNION
      sql/sql_handler.cc:
        Use List_iterator_fast
      sql/sql_insert.cc:
        Use List_iterator_fast
      sql/sql_lex.h:
        Cleanup
      sql/sql_list.cc:
        Faster iteration of lists
      sql/sql_list.h:
        Faster iterations of lists
      sql/sql_load.cc:
        Use List_iterator_fast
      sql/sql_parse.cc:
        Fix UNION code
      sql/sql_select.cc:
        Use List_iterator_fast
        Make create_tmp_table more general to be usable by UNION
      sql/sql_select.h:
        Changes to speed up copy_fields()
      sql/sql_show.cc:
        Use List_iterator_fast
      sql/sql_table.cc:
        Use List_iterator_fast
      sql/sql_union.cc:
        Fix UNION code
      sql/sql_update.cc:
        Use List_iterator_fast
      sql/sql_yacc.yy:
        Fix UNION code
      c22138ba
  11. 30 Jul, 2001 1 commit
    • unknown's avatar
      Fixed optimizer bug in ORDER BY where some ORDER BY parts where ignored. · 2acc10f5
      unknown authored
      Extended default arguments to be up to 4095 characters
      
      
      Docs/manual.texi:
        Update lof LOCK TABLES
      mysql-test/r/order_by.result:
        Test for optimizer bug in ORDER BY
      mysql-test/t/order_by.test:
        Test for optimizer bug in ORDER BY
      mysys/default.c:
        Extended default arguments to be up to 4095 characters
      sql/sql_select.cc:
        Fixed optimizer bug in ORDER BY
      2acc10f5
  12. 01 Jul, 2001 1 commit
    • unknown's avatar
      Making multi-table delete BETA !! · d78d83a4
      unknown authored
      mysql-test/t/multi_update.test:
        Making a test change the order of the tables, so that initalize_tables 
        would be tested properly
      mysys/my_compress.c:
        Just changed my e-mail address .... ;o)
      sql/filesort.cc:
        Making sure that merge_buffers can not be killed
      sql/sql_class.h:
        Added initialize_tables
      sql/sql_delete.cc:
        Making final changes for multi table delete, beta version !!
      sql/sql_select.cc:
        same as above
      BitKeeper/etc/ignore:
        Added locked to the ignore list
      d78d83a4
  13. 29 Jun, 2001 1 commit
    • unknown's avatar
      Fix ORDER BY ... DESC optimization · d603fed1
      unknown authored
      Docs/manual.texi:
        Update with changes from old version of the 4.0 manual.
      mysql-test/r/order_by.result:
        New tests for ORDER BY ... DESC
      mysql-test/t/order_by.test:
        New tests for ORDER BY ... DESC
      sql/sql_delete.cc:
        Removed DEBUG code
      d603fed1
  14. 28 Jun, 2001 1 commit
    • unknown's avatar
      Implement ORDER BY DESC optimization, which reads values in descending · 3e6f87ce
      unknown authored
      order directly from the index instead of using a filesort.
      
      
      mysql-test/mysql-test-run.sh:
        [ -n $SKIP_TEST ] --> [ -n "$SKIP_TEST" ]; portability fix
      mysql-test/r/order_by.result:
        Added test for ORDER BY DESC optimization
      mysql-test/t/order_by.test:
        Added test for ORDER BY DESC optimization
      sql/opt_range.cc:
        Added QUICK_SELECT_DESC class which implements ORDER BY DESC optimization.
      sql/opt_range.h:
        Added QUICK_SELECT_DESC class which implements ORDER BY DESC optimization.
      sql/sql_select.cc:
        Added QUICK_SELECT_DESC class which implements ORDER BY DESC optimization.
      BitKeeper/etc/ignore:
        Added .gdbinit .vimrc to the ignore list
      BitKeeper/etc/logging_ok:
        Logging to logging@openlogging.org accepted
      3e6f87ce
  15. 25 Jun, 2001 1 commit
    • unknown's avatar
      Fixed bug when sorting big files (introduced with multi-table-delete) · 743c2411
      unknown authored
      Changed mysql-test to use --language
      Cleaned up parameters to filesort()
      
      
      configure.in:
        Fixed typo
      mysql-test/install_test_db.sh:
        Changed test case to use --language
      mysql-test/mysql-test-run.sh:
        Changed test case to use --language
        Fixed that test names are not 'cut'-ed.
      mysql-test/r/select_found.result:
        Fixed test case to make it repeatable
      mysql-test/t/insert.test:
        Added test of unique key handling
      mysql-test/t/order_fill_sortbuf.test:
        Cleaned up test
      mysql-test/t/select_found.test:
        Fixed test case to make it repeatable
      sql/filesort.cc:
        Fixed bug when sorting big files (introduced with multi-table-delete)
        cleaned up parameters.
      sql/mysql_priv.h:
        Cleaned up parameters to filesort()
      sql/mysqld.cc:
        Fixed typo on enum
      sql/sql_delete.cc:
        Cleanup
      sql/sql_select.cc:
        Cleanup
      sql/sql_table.cc:
        Cleanup
      sql/sql_test.cc:
        Cleanup
      sql/sql_update.cc:
        Cleanup
      743c2411
  16. 19 Jun, 2001 1 commit
    • unknown's avatar
      Fixed bug in mysqlcheck when using --fast · 6f6c95ef
      unknown authored
      Fixed problem when converting bigint to double.
      Fixed bug in count(distinct null)
      Fixed bug with empty BDB tables.
      
      
      BitKeeper/deleted/.del-ATIS-mysql-Linux_2.4.0_64GB_SMP_i686-cmp-mysql,pg~dd306b2e583ebde4:
        Delete: sql-bench/Results/ATIS-mysql-Linux_2.4.0_64GB_SMP_i686-cmp-mysql,pg
      BitKeeper/deleted/.del-RUN-mysql-Linux_2.4.0_64GB_SMP_i686-cmp-mysql,pg~11038a44f73070e7:
        Delete: sql-bench/Results/RUN-mysql-Linux_2.4.0_64GB_SMP_i686-cmp-mysql,pg
      BitKeeper/deleted/.del-alter-table-mysql-Linux_2.4.0_64GB_SMP_i686-cmp-mysql,pg~662b96bc66bc91b6:
        Delete: sql-bench/Results/alter-table-mysql-Linux_2.4.0_64GB_SMP_i686-cmp-mysql,pg
      BitKeeper/deleted/.del-big-tables-mysql-Linux_2.4.0_64GB_SMP_i686-cmp-mysql,pg~788ad492867b1226:
        Delete: sql-bench/Results/big-tables-mysql-Linux_2.4.0_64GB_SMP_i686-cmp-mysql,pg
      BitKeeper/deleted/.del-connect-mysql-Linux_2.4.0_64GB_SMP_i686-cmp-mysql,pg~5316add301edb60:
        Delete: sql-bench/Results/connect-mysql-Linux_2.4.0_64GB_SMP_i686-c...
      6f6c95ef
  17. 15 Jun, 2001 1 commit
    • unknown's avatar
      Fixed multi-table-delete · 4fb64047
      unknown authored
      Optimize fixed length MyISAM rows to use pread/pwrite.
      
      
      BUILD/compile-pentium-debug-max:
        Also build embedded server
      libmysqld/lib_vio.c:
        Add vio_poll_read()
      myisam/mi_statrec.c:
        Use pread()/pwrite() instead of seek+read/write
      mysql-test/r/multi_update.result:
        Fix multi-table-delete test
      mysql-test/t/multi_update.test:
        Fix multi-table-delete test
      sql/filesort.cc:
        Fix multi-table-delete
      sql/mysql_priv.h:
        Fix multi-table-delete
      sql/sql_class.h:
        Fix multi-table-delete
      sql/sql_delete.cc:
        Fix multi-table-delete
      sql/sql_parse.cc:
        Fix multi-table-delete
      sql/sql_select.cc:
        Fix multi-table-delete
      sql/sql_table.cc:
        cleanup
      sql/sql_unions.cc:
        cleanup
      sql/sql_yacc.yy:
        cleanup/ optimize
      sql/structs.h:
        Fix multi-table-delete
      sql/uniques.cc:
        Fix multi-table-delete
      4fb64047
  18. 03 Jun, 2001 1 commit
    • unknown's avatar
      These are actually two changesets. One for splitting LEX in two and · 10da0aee
      unknown authored
      the other for multi-table delete
      
      
      sql/filesort.cc:
        Fixed some bugs for Unique class
      sql/item.cc:
        Changes caused by splitting lex into two parts, in order to 
        implement UNION's etc
      sql/item_sum.cc:
        Changes caused by splitting lex into two parts, in order to 
        implement UNION's etc
      sql/mysql_priv.h:
        Changes caused by splitting lex into two parts, in order to 
        implement UNION's etc
      sql/sql_class.h:
        Adding multi table delete
      sql/sql_delete.cc:
        Added multi-table delete
      sql/sql_lex.cc:
        Changes caused by splitting lex into two parts, in order to 
        implement UNION's etc
      sql/sql_lex.h:
        Changes caused by splitting lex into two parts, in order to 
        implement UNION's etc
      sql/sql_parse.cc:
        Changes caused by splitting lex into two parts, in order to 
        implement UNION's etc, plus added multi-table delete
      sql/sql_select.cc:
        Changes caused by splitting lex into two parts, in order to 
        implement UNION's etc
      sql/sql_update.cc:
        Changes caused by splitting lex into two parts, in order to 
        implement UNION's etc
      sql/sql_yacc.yy:
        Changes caused by splitting lex into two parts, in order to 
        implement UNION's etc, plus added multi-table delete
      sql/uniques.cc:
        Fixed some bugs in duplicate stripping
      BitKeeper/etc/logging_ok:
        Logging to logging@openlogging.org accepted
      10da0aee
  19. 23 May, 2001 1 commit
    • unknown's avatar
      Added Unique class to be used for duplicate removal in multi-table delete. · 925dd5da
      unknown authored
      mysys/ptr_cmp.c:
        Removed old comments
      pstack/bucomm.c:
        Change to use mkstemp.
      sql/Makefile.am:
        Added Unique class
      sql/filesort.cc:
        Changes to let the Unique class use the old filesort code.
      sql/sql_class.h:
        Added Unique class
      sql/sql_handler.cc:
        Removed warning.
      sql/sql_select.cc:
        Cleaned up typo.
      925dd5da
  20. 22 May, 2001 1 commit
    • unknown's avatar
      Don't write rows in MyISAM tables when using count(distinct) · 74408de0
      unknown authored
      Don't read MyISAM header when running without locking
      
      
      include/myisam.h:
        Don't read header when running without locking.
      myisam/mi_locking.c:
        Don't update changed flag for temporary files.
      myisam/mi_open.c:
        Don't read header when running without locking.
      myisam/mi_static.c:
        Don't read header when running without locking.
      sql/item_sum.cc:
        Don't write rows in MyISAM tables when using count(distinct)
      sql/mysqld.cc:
        Don't read MyISAM header when running without locking.
        Remove -Sg option.
      sql/sql_analyse.h:
        Remove duplicate header.
      sql/sql_select.cc:
        Cleaned up prototypes.
        Don't write rows to count(DISTINCT) MyISAM tables.
      sql/sql_select.h:
        Cleaned up prototypes.
      sql/table.h:
        A
      BitKeeper/etc/logging_ok:
        Logging to logging@openlogging.org accepted
      74408de0
  21. 16 May, 2001 1 commit
    • unknown's avatar
      Fixed bug when using MERGE on files > 4G · b12ff6f0
      unknown authored
      Fixed bug in SELECT db1.table.* FROM db1.table,db2.table
      Fixed bug in INSERT DELAYED when doing shutdown and a table was locked
      Changed that tmp_table_size =4G-1 means unlimited.
      
      
      Docs/manual.texi:
        Added new section about crashed MyISAM tables.
        Cleaned up subsections for InnoDB
      client/mysql.cc:
        Cleanup
      myisam/mi_rkey.c:
        Cleanup
      myisam/mi_search.c:
        Fixed wrong casts in debug messages
      myisammrg/myrg_rrnd.c:
        Fixed bug when using files > 4G
      mysys/getvar.c:
        Changed to use longlong to support arguments up to 4G
      mysys/thr_lock.c:
        Fix for delay insert
      sql/mysqld.cc:
        Increased default size for temporary tables
      sql/sql_base.cc:
        Fixed bug in SELECT db1.table.* FROM db1.table,db2.table
      sql/sql_insert.cc:
        Fixed bug in INSERT DELAYED when doing shutdown and a table was locked
      sql/sql_select.cc:
        Changed that tmp_table_size =4G-1 means unlimited.
      b12ff6f0
  22. 12 May, 2001 1 commit
    • unknown's avatar
      Only mark MERGE readonly if all tables are readonly · 50da4864
      unknown authored
      Optimize some queries when using LIMIT
      
      
      merge/open.c:
        Only mark MERGE readonly if all tables are readonly
      myisammrg/myrg_open.c:
        Only mark MERGE readonly if all tables are readonly
      sql/sql_select.cc:
        Optimize some queries when using LIMIT
      50da4864
  23. 11 May, 2001 1 commit
    • unknown's avatar
      cleanup · 26a61555
      unknown authored
      Docs/manual.texi:
        Updated gdb / trace information
      innobase/pars/pars0grm.c:
        Removed warning on windows
      mysys/mf_keycache.c:
        Changed "exec" to "check_keycache"
      sql/mysqld.cc:
        Added suffix for windows binaries
      26a61555
  24. 10 May, 2001 1 commit
  25. 09 May, 2001 1 commit
    • unknown's avatar
      Applied patches for BDB tables · 53011a88
      unknown authored
      Fixes to InnoDB to compile on Windows
      Fix for temporary InnoDB tables
      Fixed bug in REPLACE()
      Fixed sub char keys for InnoDB
      
      
      Docs/manual.texi:
        Changelog + update of table types
      bdb/include/log.h:
        Patch from Sleepycat
      bdb/log/log.c:
        Patch from Sleepycat
      bdb/log/log_rec.c:
        Patch from Sleepycat
      client/mysqladmin.c:
        Cleanup
      innobase/include/univ.i:
        Fix for compilation on Windows
      innobase/os/os0file.c:
        cleanup
      innobase/pars/pars0grm.y:
        Fix for compilation on Windows
      mysql-test/r/innodb.result:
        New test case
      mysql-test/t/innodb.test:
        New test case
      sql/ha_innobase.cc:
        cleanup
      sql/ha_innobase.h:
        Fix for prefix keys
      sql/handler.h:
        Fix for temporary Innodb tables
      sql/item_strfunc.cc:
        Fixed bug in REPLACE()
      sql/lock.cc:
        Fix for temporary Innodb tables
      sql/mysqld.cc:
        Added --skip-stack-trace
      sql/share/english/errmsg.txt:
        Better error messages
      sql/sql_base.cc:
        Fix for temporary Innodb tables
      sql/sql_select.cc:
        Fix for temporary Innodb tables
      sql/sql_table.cc:
        Fixed sub char keys for InnoDB
      sql/table.h:
        Fix for temporary Innodb tables
      53011a88
  26. 03 May, 2001 1 commit
  27. 02 May, 2001 1 commit
  28. 29 Apr, 2001 1 commit
    • unknown's avatar
      Cleanup · 448716b0
      unknown authored
      sql/log_event.cc:
        cleanup
      sql/mysqld.cc:
        Portability fix for AIX 4.2
        Fix for services on Windows
      448716b0
  29. 25 Apr, 2001 1 commit
    • unknown's avatar
      Portability fixes for Ia64 and Sgi compiler · 6052a195
      unknown authored
      DROP DATABASE in mysqladmin asks for confirmation (again)
      Added examined_rows to slow query log
      SHOW CREATE for TEMPORARY table
      
      
      BitKeeper/deleted/.del-shw000001.result~8b20b03d8319b9a5:
        Delete: mysql-test/r/shw000001.result
      BitKeeper/deleted/.del-shw000001.test~770d96a2c1c65b20:
        Delete: mysql-test/t/shw000001.test
      Docs/manual.texi:
        Added information about InnoDB and TEMPORARY tables
      acinclude.m4:
        Portability fixes
      client/errmsg.c:
        merge with libmysqd/errmsg.c
      client/mysqladmin.c:
        DROP DATABASE asks for confirmation (again)
      client/mysqltest.c:
        Portability fixes
      configure.in:
        Portability fixes for SGI compiler on Ia64
      extra/resolve_stack_dump.c:
        Portability fixes
      include/global.h:
        Portability fixes
      isam/_dbug.c:
        Portability fixes
      mysql-test/mysql-test-run.sh:
        Portability fixes
      mysql-test/r/show_check.result:
        New test for SHOW CREATE
      mysql-test/t/show_check.test:
        New test for SHOW CREATE
      scripts/make_binary_distribution.sh:
        Added miss...
      6052a195
  30. 24 Apr, 2001 1 commit
    • unknown's avatar
      Fixes for embedded MySQL · 50ce7076
      unknown authored
      Some limit optimization
      
      
      BitKeeper/deleted/.del-ib_config.h.in~9e57db8504e55b7:
        Delete: innobase/ib_config.h.in
      BitKeeper/deleted/.del-ib_config.h~7539e26ffc614439:
        Delete: innobase/ib_config.h
      client/errmsg.c:
        Moved error messages from libmysqld/
      client/mysql.cc:
        Removed warnings
      include/errmsg.h:
        New info for embedded versions
      include/mysql_com.h:
        Fixes for embedded MySQL
      libmysql/errmsg.c:
        Fixes for embedded MySQL
      libmysqld/Makefile.am:
        Added HANDLER code
      libmysqld/lib_sql.cc:
        Fixes for embedded MySQL
      libmysqld/lib_vio.c:
        Fixes for embedded MySQL
      BitKeeper/etc/ignore:
        Added libmysqld/sql_handler.cc to the ignore list
      libmysqld/libmysqld.c:
        Fixes for embedded MySQL
      mysql-test/r/null_key.result:
        Fixed result for 4.0
      sql/net_serv.cc:
        Fixes for embedded MySQL
      sql/sql_parse.cc:
        Fixes for embedded MySQL where the query could be a const char*
      sql/sql_select.cc:
        Added limit optimization
      sql/sql_select.h:
        Added limit optimization
      50ce7076
  31. 22 Apr, 2001 1 commit
    • unknown's avatar
      Fix for release · a3122050
      unknown authored
      Docs/manual.texi:
        new links
      scripts/make_binary_distribution.sh:
        Added missing files
      sql/sql_select.cc:
        Added accidently removed line
      a3122050
  32. 21 Apr, 2001 1 commit
    • unknown's avatar
      Fixed probelm with count(*) and normal functions when no matchin rows. · fa6c9774
      unknown authored
      Changed 'lib' to 'master-data'
      Fix for slow slaves
      
      
      Docs/manual.texi:
        Changelog
      include/mysql.h:
        Fixes for Cygwin
      libmysql/libmysql.c:
        Fixes for Cygwin
      mysql-test/Makefile.am:
        Include missing test files
      mysql-test/include/master-slave.inc:
        Fixes for slow slaves
      mysql-test/install_test_db.sh:
        Change 'lib' to 'master-data'
      mysql-test/mysql-test-run.sh:
        Change 'lib' to 'master-data'
      mysql-test/r/group_by.result:
        Test case for count(*) problem
      mysql-test/t/group_by.test:
        Test case for count(*) problem
      mysql-test/t/rpl000018-master.sh:
        Change 'lib' to 'master-data'
      sql/sql_select.cc:
        Fix for count(*) problem
      fa6c9774
  33. 19 Apr, 2001 1 commit
    • unknown's avatar
      Fix for BDB and LOCK TABLES · 123e31ce
      unknown authored
      BitKeeper/deleted/.del-ib_config.h.in~9e57db8504e55b7:
        Delete: innobase/ib_config.h.in
      BitKeeper/deleted/.del-ib_config.h~7539e26ffc614439:
        Delete: innobase/ib_config.h
      Docs/manual.texi:
        Changelog
      myisam/mi_locking.c:
        Cleanup
      mysql-test/r/bdb.result:
        Test for LOCK TABLES
      mysql-test/r/innodb.result:
        Test for LOCK TABLES
      mysql-test/t/bdb.test:
        Test for LOCK TABLES
      mysql-test/t/innodb.test:
        Test for LOCK TABLES
      sql-bench/test-insert.sh:
        Allow loop to be small
      sql/ha_berkeley.cc:
        Fixed bug when using LOCK TABLES with BDB
      sql/ha_berkeley.h:
        Fixed bug when using LOCK TABLES with BDB
      sql/handler.h:
        Fixed bug when using LOCK TABLES with BDB
      sql/sql_base.cc:
        Fixed bug when using LOCK TABLES with BDB
      sql/sql_parse.cc:
        UNLOCK TABLES ends transaction
      sql/sql_select.cc:
        Fix to not call index_end() twice
      123e31ce
  34. 18 Apr, 2001 1 commit
    • unknown's avatar
      Added test for PTHREAD_YIELD · c38762c2
      unknown authored
      Removed test of default master parameter
      Don't lock locked tables in REPAIR
      Changed optimzation for SELECT * from table,table ORDER BY keypart LIMIT
      
      
      BitKeeper/deleted/.del-have_default_master.inc~a54c86e65a6c4af:
        Delete: mysql-test/include/have_default_master.inc
      BitKeeper/deleted/.del-have_default_master.require~1465255ffdaf82f:
        Delete: mysql-test/r/have_default_master.require
      Docs/manual.texi:
        Changelog for 3.23.38
      acconfig.h:
        Added test for PTHREAD_YIELD
      acinclude.m4:
        Added test for PTHREAD_YIELD
      configure.in:
        Added test for PTHREAD_YIELD
      innobase/os/os0thread.c:
        Added test for PTHREAD_YIELD
      mysql-test/r/lock.result:
        Added test of lock bug
      mysql-test/t/lock.test:
        Added test of lock bug
      mysql-test/t/rpl000014.test:
        Removed test of default master parameter
      mysql-test/t/rpl000015.test:
        Removed test of default master parameter
      mysql-test/t/rpl000016.test:
        Removed test of default master parameter
      sql/ha_myisam.cc:
        Don't lock locked tables in REPAIR
      sql/sql_select.cc:
        Changed optimzation for SELECT * from table,table ORDER BY keypart LIMIT
      c38762c2
  35. 17 Apr, 2001 2 commits
  36. 11 Apr, 2001 1 commit
    • unknown's avatar
      Added SQL_CALC_FOUND_ROWS and FOUND_ROWS() · c255ceca
      unknown authored
      myisam/ft_boolean_search.c:
        Cleanup
      myisam/ft_parser.c:
        Cleanup
      myisam/ft_update.c:
        Cleanup
      myisam/sort.c:
        Cleanup
      BitKeeper/etc/logging_ok:
        Logging to logging@openlogging.org accepted
      c255ceca
  37. 24 Mar, 2001 2 commits
    • unknown's avatar
      Fixed bug in send in mysqltest · aa20d16f
      unknown authored
      Removed usage of @r/result as this made life hard when testing different
      table handlers.
      Allow concurrent inserts if no update/binary log.
      Don't remove key_cache at flush tables.
      Fixed bug in SELECT DISTINCT SUM()...
      
      
      BitKeeper/deleted/.del-rpl000012.status.result~bbbd650b5beea32f:
        Delete: mysql-test/r/rpl000012.status.result
      BitKeeper/deleted/.del-rpl000013.status.result~6bee190c298cc9fd:
        Delete: mysql-test/r/rpl000013.status.result
      Docs/manual.texi:
        Changelog
      client/mysqltest.c:
        Fixed bug in 'send' that Sasha had introduced.
        Make database, port and socket optional parameters to connect()
      mysql-test/r/rpl000005.result:
        Removed usage of @r/result as this made life hard when doing
        test for multiple table handlers.
      mysql-test/r/rpl000006.result:
        Removed usage of @r/result as this made life hard when doing
        test for multiple table handlers.
      mysql-test/r/rpl000012.result:
        Removed usage of @r/result as this made life hard when doing
        test for multiple table ha...
      aa20d16f
    • unknown's avatar
      Added defines for fast mutex in glibc 2.2 (should be safe) · 06828d17
      unknown authored
      Fixed crash in SELECT DISTINCT SUM(...)
      Fix return value of mysortncmp() for innobase
      Fix join_crash bug
      
      
      Docs/manual.texi:
        Changelog
      include/my_pthread.h:
        Added defines for fast mutex in glibc 2.2
      mysql-test/t/join_crash.test:
        Changed table names to t1,t2...
      mysys/my_bitmap.c:
        Use fast mutex
      mysys/my_open.c:
        Use fast mutex
      mysys/my_pthread.c:
        Use fast mutex
      mysys/my_thr_init.c:
        Use fast mutex
      mysys/my_winthread.c:
        Use fast mutex
      mysys/thr_mutex.c:
        Use new mutexattr with error checking
      sql/ha_innobase.cc:
        Fix return value of mysortncmp() for innobase
      sql/sql_select.cc:
        Fix join_crash bug
      BitKeeper/etc/logging_ok:
        Logging to logging@openlogging.org accepted
      06828d17
  38. 21 Mar, 2001 1 commit
    • unknown's avatar
      Split setup_fields to setup_tables and setup_fields · 4f7e756c
      unknown authored
      Fixed problem with UPDATE TABLE when keys wheren't always used.
      
      
      Docs/manual.texi:
        Added comment to ALTER TABLE
      scripts/mysql_install_db.sh:
        Added test for mysqld in libexec
      sql/ha_innobase.cc:
        Removed compiler warning
      sql/mysql_priv.h:
        Split setup_fields to setup_tables and setup_fields
      sql/sql_base.cc:
        Split setup_fields to setup_tables and setup_fields
      sql/sql_insert.cc:
        Split setup_fields to setup_tables and setup_fields
      sql/sql_load.cc:
        Split setup_fields to setup_tables and setup_fields
      sql/sql_parse.cc:
        Fixed missing 'mysql_info" with now clients.
      sql/sql_select.cc:
        Split setup_fields to setup_tables and setup_fields
      sql/sql_update.cc:
        Fixed problem with UPDATE TABLE when keys wheren't always used.
      sql/sql_yacc.yy:
        Small isolation change
      4f7e756c