An error occurred fetching the project authors.
  1. 02 Apr, 2002 1 commit
  2. 22 Mar, 2002 1 commit
    • unknown's avatar
      Fix for bug in WHERE key='j' or key='J' · 8f2f1597
      unknown authored
      Docs/manual.texi:
        Changelog
      myisam/myisampack.c:
        Delete tmp file on error.
      mysql-test/r/range.result:
        Updated test case
      mysql-test/t/range.test:
        Updated test case
      8f2f1597
  3. 15 Mar, 2002 2 commits
  4. 05 Mar, 2002 1 commit
    • unknown's avatar
      several bug fixes and tests · a02a98c4
      unknown authored
      mysql-test/mysql-test-run.sh:
        Fix for LOAD DATA LOCAL ...
      mysql-test/r/select_found.result:
        Added result for a new test of combo of options for FOUND_ROWS and
        BUFFER_RESULT
      mysql-test/t/select_found.test:
        Added test for combo of options for BUFFER_RESULT and FOUND_ROWS
      sql/sql_select.cc:
        Added fix for combo of options for BUFFER_RESULT and FOUND_ROWS
      a02a98c4
  5. 02 Mar, 2002 1 commit
    • unknown's avatar
      Fix sorting of NULL values (Should always be first) · ad4fcb8a
      unknown authored
      Fix problem with HAVING and MAX() IS NOT NULL
      
      
      Docs/manual.texi:
        Changelog & NULL usage with ORDER BY
      client/mysqldump.c:
        Cleanup disable keys
      mysql-test/r/distinct.result:
        Fix results after ORDER BY with NULL fix
      mysql-test/r/group_by.result:
        Fix results after ORDER BY with NULL fix
      mysql-test/r/having.result:
        Testcase for bug with HAVING
      mysql-test/t/distinct.test:
        Test for DISTINCT + ORDER BY DESC bug
      mysql-test/t/having.test:
        Test of HAVING and MAX IS NOT NULL
      sql/filesort.cc:
        Fix sorting of NULL values (Should always be first)
      sql/item.h:
        Fix problem with HAVING and MAX() IS NOT NULL
      sql/item_sum.h:
        Fix problem with HAVING and MAX() IS NOT NULL
      sql/opt_range.cc:
        Fix problem with HAVING and MAX() IS NOT NULL
      sql/opt_range.h:
        Fix sorting of NULL values
      sql/sql_select.cc:
        Fix sorting of ORDER BY ... DESC on NULL values.
      ad4fcb8a
  6. 01 Mar, 2002 1 commit
    • unknown's avatar
      fulltext+const_table bug fixed · 43a1ef6c
      unknown authored
      mysql-test/r/fulltext.result:
        test added
      mysql-test/t/fulltext.test:
        test added
      sql/item_func.cc:
        fulltext+const_table problem fixed once and forever
      sql/item_func.h:
        fulltext+const_table problem fixed once and forever
      sql/sql_select.cc:
        fulltext+const_table problem fixed once and forever
      sql/table.h:
        fulltext+const_table problem fixed once and forever
      43a1ef6c
  7. 28 Feb, 2002 1 commit
    • unknown's avatar
      Surgical changes in sql_select and sql_union code in order to · bf0b0d3e
      unknown authored
      accomodate EXPLAIN properly for all possible variant of UNION's
      derived tables etc ...
      
      This also fixes all reported (and unreported) bugs when EXPLAIN is
      run on UNION's.
      
      select_describe() now has a very dirty hack to avoid some problems
      with transactional tables on table unlocking.
      
      Code speedup is possible. For the moment all that was important was
      that all tests are passed.
      
      
      bf0b0d3e
  8. 21 Feb, 2002 1 commit
  9. 10 Feb, 2002 1 commit
  10. 08 Feb, 2002 1 commit
    • unknown's avatar
      Fix some bugs introduced with the new my_getopt · 0f9932a1
      unknown authored
      Added counting of rollback's and commits
      Fixed bug in 'SELECT 0 LIMIT 0'
      Fixed bug in 'SELECT SQL_CALC_FOUND_ROWS'
      
      
      Docs/manual.texi:
        Changelog
      configure.in:
        Cleanup
      myisam/myisamchk.c:
        Fix some bugs introduced with the new my_getopt
      mysql-test/r/limit.result:
        Test for bugfix
      mysql-test/r/rpl000001.result:
        fix wrong result
      mysql-test/r/select.result:
        Fix things after fixing ignore index()
      mysql-test/r/select_found.result:
        Test of bug in SQL_CALC_FOUND_ROWS
      mysql-test/t/limit.test:
        Test bug in LIMIT 0
      mysql-test/t/rpl000001.test:
        fix wrong result
      mysql-test/t/select_found.test:
        Test of bug in SQL_CALC_FOUND_ROWS
      sql/handler.cc:
        Added counting of rollback's and commits
      sql/mysql_priv.h:
        Added counting of rollback's and commits
      sql/mysqld.cc:
        Added counting of rollback's and commits
      sql/sql_select.cc:
        Fixed bug in 'SELECT 0 LIMIT 0'
        Fixed bug in 'SELECT SQL_CALC_FOUND_ROWS'
      0f9932a1
  11. 31 Jan, 2002 1 commit
    • unknown's avatar
      Fixes for new getopt · 83c83a02
      unknown authored
      Bug fix when using --no-deaults
      Sets ref_length to right value (faster rnd_pos() handling in InnoDB).
      Fixed problem with multi-table-delete and InnoDB
      Fixed problem with truncate table, which required a COMMIT before.
      Fixed multi-table-delete bug with InnoDB.
      Remove not used index from EXPLAIN
      
      
      Docs/manual.texi:
        ChangeLog
      include/my_getopt.h:
        Removed compiler warnings
      myisam/myisamchk.c:
        Fixes for new getopt
      mysql-test/r/explain.result:
        Updated test results
      mysql-test/r/innodb.result:
        Updated test results
      mysql-test/r/join.result:
        Updated test results
      mysql-test/t/innodb.test:
        Updated test results
      mysys/default.c:
        Bug fix when using --no-defaults
      mysys/my_getopt.c:
        Fixes for new getopt
      sql/ha_innodb.cc:
        Sets ref_length to right value (faster rnd_pos() handling).
        Fixed problem with multi-table-delete.
        Fixed problem with truncate table, which required a COMMIT before.
      sql/opt_sum.cc:
        Remove not used index from EXPLAIN
      sql/sql_cache.cc:
        Fixed core dump bug when not using query cache
      sql/sql_select.cc:
        Remove not used index from EXPLAIN
      83c83a02
  12. 30 Jan, 2002 1 commit
  13. 29 Jan, 2002 1 commit
    • unknown's avatar
      New error messages · d6a43626
      unknown authored
      Test of unsigned BIGINT values
      Fixes for queries-per-hour
      Cleanup of replication code (comments and portability fixes)
      Make most of the binary log code 4G clean
      Changed syntax for GRANT ... QUERIES PER HOUR
      
      
      Docs/manual.texi:
        Fixed Changelog, upgrading to 4.0 and 4.1 TODO sections.
      Docs/mysqld_error.txt:
        Added error message.
      configure.in:
        Fix for autoconf 2.52
      include/my_getopt.h:
        Portability fix.
      include/my_global.h:
        Portablity fix.
      include/mysqld_error.h:
        New error messages
      mysql-test/r/bigint.result:
        Test of unsigned BIGINT values.
      mysql-test/r/func_op.result:
        Test of unsigned BIGINT values.
      mysql-test/r/varbinary.result:
        Test of unsigned BIGINT values.
      mysql-test/t/bigint.test:
        Test of unsigned BIGINT values.
      sql/item_func.h:
        Optimized Item_int_func() usage.
      sql/lock.cc:
        Cleanup comments
      sql/log.cc:
        Cleanup
      sql/log_event.cc:
        Cleanup and portability fixes.
      sql/log_event.h:
        Cleanup and portability fixes.
      sql/mini_client.cc:
        Cleanup and portability fixes.
      sql/mysqld.cc:
        Fix for queries-per-hour
      sql/repl_failsafe.cc:
        Prepare for making binary log 2G clean.
      sql/share/czech/errmsg.txt:
        New error messages
      sql/share/danish/errmsg.txt:
        New error messages
      sql/share/dutch/errmsg.txt:
        New error messages
      sql/share/english/errmsg.txt:
        New error messages
      sql/share/estonian/errmsg.txt:
        New error messages
      sql/share/french/errmsg.txt:
        New error messages
      sql/share/german/errmsg.txt:
        New error messages
      sql/share/greek/errmsg.txt:
        New error messages
      sql/share/hungarian/errmsg.txt:
        New error messages
      sql/share/italian/errmsg.txt:
        New error messages
      sql/share/japanese/errmsg.txt:
        New error messages
      sql/share/korean/errmsg.txt:
        New error messages
      sql/share/norwegian-ny/errmsg.txt:
        New error messages
      sql/share/norwegian/errmsg.txt:
        New error messages
      sql/share/polish/errmsg.txt:
        New error messages
      sql/share/portuguese/errmsg.txt:
        New error messages
      sql/share/romanian/errmsg.txt:
        New error messages
      sql/share/russian/errmsg.txt:
        New error messages
      sql/share/slovak/errmsg.txt:
        New error messages
      sql/share/spanish/errmsg.txt:
        New error messages
      sql/share/swedish/errmsg.txt:
        New error messages
      sql/share/ukrainian/errmsg.txt:
        New error messages
      sql/slave.cc:
        Cleanup
      sql/slave.h:
        Cleanup
      sql/sql_acl.cc:
        Cleanup and removal of possible reserved words
      sql/sql_base.cc:
        More DBUG
      sql/sql_cache.cc:
        Cleanup & portability fixes
      sql/sql_class.h:
        Make binary log 4G clean
      sql/sql_delete.cc:
        More DBUG
      sql/sql_handler.cc:
        Cleanup & portability fixes
      sql/sql_parse.cc:
        Cleanup of queries-per-hours code
      sql/sql_rename.cc:
        Add missing DBUG_RETURN
      sql/sql_repl.cc:
        Cleanup & portability fixes
      sql/sql_select.cc:
        Cleanup & portability fixes
      sql/sql_show.cc:
        Cleanup & portability fixes
      sql/sql_update.cc:
        Small cleanup of multi-update-code (need second pass)
      sql/sql_yacc.yy:
        Changed syntax for GRANT ... QUERIES PER HOUR
      strings/str2int.c:
        Cleanup & portability fixes
      d6a43626
  14. 23 Jan, 2002 1 commit
    • unknown's avatar
      Increase max package length to 512M for mysql and mysqldump. · 7b72c14b
      unknown authored
      Faster 'read_first_row' (Fixes slow 'preparing' state)
      Read constant tables earlier, which provides better optimzations when using tables with <=1 row.
      This also fixes a complicated bug involving const tables.
      
      
      Docs/manual.texi:
        Changelog
      client/mysql.cc:
        Increase max package length to 512M
      client/mysqldump.c:
        Increase max package length to 512M
      dbug/dbug.c:
        Fixed wrong printf() format string.
      mysql-test/t/innodb.test:
        Test for multi-table delete
      sql/handler.cc:
        Faster 'read_first_row' (Fixes slow 'preparing' state)
      sql/handler.h:
        Faster 'read_first_row' (Fixes slow 'preparing' state)
      sql/opt_range.cc:
        More debug info.
      sql/sql_select.cc:
        Read constant tables earlier, which provides better optimzations when using tables with <=1 row.
        This also fixes a complicated bug involving const tables.
      sql/sql_select.h:
        Read const tables earlier
      7b72c14b
  15. 17 Jan, 2002 1 commit
  16. 16 Jan, 2002 1 commit
    • unknown's avatar
      Move HA_EXTRA_NO_READCHECK to ha_open · 08858203
      unknown authored
      Fixed bug in multi-table-delete
      
      
      Docs/manual.texi:
        Changelog
      include/mysql_com.h:
        Define MAX_CHAR_WIDTH
      myisam/mi_extra.c:
        Cleanup
      mysql-test/r/bdb.result:
        Bug test
      mysql-test/r/group_by.result:
        Bug test
      mysql-test/t/bdb.test:
        Bug test
      mysql-test/t/group_by.test:
        Bug test
      sql/ha_berkeley.cc:
        More debug statements
      sql/handler.cc:
        Move HA_EXTRA_NO_READCHECK to ha_open
      sql/records.cc:
        More DBUG statements
      sql/sql_analyse.cc:
        Cleanup
      sql/sql_base.cc:
        Move HA_EXTRA_NO_READCHECK to ha_open
      sql/sql_delete.cc:
        Fixed bug in multi-table-delete
        Cleanup
      sql/sql_select.cc:
        Move HA_EXTRA_NO_READCHECK to ha_open
      sql/sql_update.cc:
        Move HA_EXTRA_NO_READCHECK to ha_open
      08858203
  17. 15 Jan, 2002 1 commit
    • unknown's avatar
      Add support for NULL=NULL in keys (Used in GROUP BY optimization) · f015cbdc
      unknown authored
      Add ISAM to Windows version
      Fix of test results
      Fixes for NULL keys in HEAP tables.
      
      
      Docs/manual.texi:
        Changelog
      heap/hp_open.c:
        Add support for NULL=NULL in keys (for GROUP BY)
      heap/hp_rkey.c:
        Cleanup
      heap/hp_write.c:
        Cleanup
      include/config-win.h:
        Add ISAM to Windows version
      include/my_base.h:
        Add support for NULL=NULL in keys (for GROUP BY)
      libmysqld/Makefile.am:
        Rename of innobase to innodb
      myisam/mi_write.c:
        Add support for NULL=NULL in keys (for GROUP BY)
      BitKeeper/etc/ignore:
        Added libmysqld/ha_innodb.cc to the ignore list
      mysql-test/r/group_by.result:
        Test of NULL keys in HEAP tables
      mysql-test/r/heap.result:
        Test of NULL keys in HEAP tables
      mysql-test/r/null.result:
        Cleanup
      mysql-test/r/order_by.result:
        Fix for result of new ORDER BY optimization
      mysql-test/t/group_by.test:
        Test of NULL keys in HEAP tables
      mysql-test/t/heap.test:
        Test of NULL keys in HEAP tables
      mysql-test/t/null.test:
        Cleanup
      sql/ha_heap.cc:
        Add support of NULL keys
      sql/item_strfunc.h:
        Fix for BINARY and CAST functions
      sql/item_timefunc.h:
        Fix for BINARY and CAST functions
      sql/sql_parse.cc:
        Cleanup
      sql/sql_select.cc:
        Add support for NULL=NULL in keys (for GROUP BY)
      f015cbdc
  18. 12 Jan, 2002 1 commit
    • unknown's avatar
      Added support of null keys in HEAP tables · 71a5af5b
      unknown authored
      Added ORDER BY optimization
      
      
      Docs/manual.texi:
        Added ORDER BY optimisation section
      heap/_check.c:
        Cleanup
      heap/heapdef.h:
        Added support of null keys in HEAP tables
      heap/hp_hash.c:
        Added support of null keys in HEAP tables
      heap/hp_open.c:
        Added support of null keys in HEAP tables
      heap/hp_test2.c:
        Added support of null keys in HEAP tables
      heap/hp_write.c:
        Added support of null keys in HEAP tables
      include/heap.h:
        Added support of null keys in HEAP tables
      include/my_base.h:
        Support for hash algoritm
      isam/static.c:
        Cleanup
      myisam/mi_static.c:
        Cleanup
      sql/Makefile.am:
        Rename innobase -> innodb
      sql/ha_berkeley.cc:
        Added ORDER BY optimization
      sql/ha_berkeley.h:
        Added ORDER BY optimization
      sql/ha_heap.cc:
        Added support for NULL keys
      sql/ha_heap.h:
        Added support for NULL keys
      sql/ha_isam.cc:
        Added ORDER BY optimization
      sql/ha_isam.h:
        Added ORDER BY optimization
      sql/ha_isammrg.h:
        Added ORDER BY optimization
      sql/ha_myisam.cc:
        Added ORDER BY optimization
      sql/ha_myisam.h:
        Added ORDER BY optimization
      sql/ha_myisammrg.cc:
        Added ORDER BY optimization
      sql/ha_myisammrg.h:
        Added ORDER BY optimization
      sql/handler.cc:
        Rename innobase -> innodb
      sql/handler.h:
        Rename innobase -> innodb
      sql/ha_innodb.cc:
        Rename innobase -> innodb
      sql/ha_innodb.h:
        Rename innobase -> innodb
      sql/mysqld.cc:
        Rename innobase -> innodb
      sql/sql_delete.cc:
        Rename innobase -> innodb
      sql/sql_select.cc:
        Added ORDER BY optimization
      sql/sql_select.h:
        Added ORDER BY optimization
      71a5af5b
  19. 27 Dec, 2001 1 commit
  20. 26 Dec, 2001 1 commit
    • unknown's avatar
      This is a large push. Included are : · 71ce58a3
      unknown authored
      * multi-table updates
      * new paid feature for limiting number of queries per hour for users
      * optional syntax for multi-table deletes
      * optimization for SQL_CALC_FOUND_ROWS
      * a small addition for CREATE .. SELECT that will be of future use
      
      I know that all this will require many additions to documentation, 
      which I have not done, but I am at Arjen's disposal to help him document
      all this.
      
      
      
      libmysqld/lib_sql.cc:
        This is a small change required due to new paid feature of limiting 
        number of queries per hour for each user.
      mysql-test/r/multi_update.result:
        Change of the result to accomodate multi-table updates
      mysql-test/t/multi_update.test:
        Change in multi-table tests to accomodate multi-table updates
      BitKeeper/etc/ignore:
        Added 50 sql/new.cc to the ignore list
      scripts/mysql_install_db.sh:
        This is a small change required due to new paid feature of limiting 
        number of queries per hour for each user.
      sql/item_timefunc.h:
        This is a small feature that will be of use later in the proper 
        creation of the tables out of CREATE ... SELECT...
        
        Further changes will come after this resolve/push/test passes ..
      sql/lex.h:
        This is a small change required due to new paid feature of limiting 
        number of queries per hour for each user.
      sql/mysql_priv.h:
        This is a small change required due to new paid feature of limiting 
        number of queries per hour for each user.
      sql/mysqld.cc:
        This is a small change required due to new paid feature of limiting 
        number of queries per hour for each user.
      sql/sql_acl.cc:
        This is a small change required due to new paid feature of limiting 
        number of queries per hour for each user.
      sql/sql_acl.h:
        This is a small change required due to new paid feature of limiting 
        number of queries per hour for each user.
      sql/sql_class.h:
        These are changes required for multi-table updates.
      sql/sql_lex.h:
        Changes required for both multi-table updates and limiting number of 
        queries per hour (paid feature).
      sql/sql_parse.cc:
        Ha ! So many changes. 
        
        * multi-table updates
        * limiting number of queries per hour for users
      sql/sql_select.cc:
        Optimisation for SQL_CALC_FOUND_ROWS, when a query involves a single
        table, without WHERE or GROUP clause
      sql/sql_update.cc:
        multi-table updates
      sql/sql_yacc.yy:
        Many things :
        * multi-table updates
        * limiting number of queries per hour for users
        * new optional syntax for multi-table deletes. This one is different 
          from the one demanded by user. USING clause MUST include ALL tables, 
          not just the ones that are used and not deleted from.
      71ce58a3
  21. 11 Dec, 2001 1 commit
    • unknown's avatar
      Fix for MyISAM records > 16M · 72ec7dfc
      unknown authored
      Docs/manual.texi:
        ChangeLog
      innobase/os/os0file.c:
        Removed compiler warnings
      myisam/mi_check.c:
        Fix for records > 16M
      myisam/mi_dynrec.c:
        Fix for records > 16M
      myisam/myisamdef.h:
        Fix for records > 16M
      sql/sql_select.cc:
        Cleanup
      sql/sql_yacc.yy:
        F
      72ec7dfc
  22. 05 Dec, 2001 2 commits
    • unknown's avatar
      Fixed bug in LEFT JOIN · e8d81970
      unknown authored
      Docs/manual.texi:
        ChangeLog
      myisam/mi_locking.c:
        Remove wrong optimistic locking. (Doesn't affect MySQL)
      mysys/my_init.c:
        Release character sets at end
      scripts/mysqlhotcopy.sh:
        RAID tables are now copied
      e8d81970
    • unknown's avatar
      Update of query cache code. · eca2a1a3
      unknown authored
      Changed some sql_alloc() -> thd->alloc()
      Removed a lot of compiler warnings on Linux Alpha (64 bit)
      Fixed some core dumps on 64 bit systems (wrong type for packet_len)
      
      
      Docs/manual.texi:
        Added base information about the query cache.
      include/hash.h:
        Export hash_replace
      include/myisam.h:
        Update of query cache code
      libmysql/net.c:
        Add casts to make things safe on 64 bit systems.
      myisam/mi_write.c:
        Update of query cache code
      myisammrg/myrg_extra.c:
        Update of query cache code
      mysys/hash.c:
        Added safety check to hash_replace
      sql/field.cc:
        Removed compiler warnings.
      sql/field.h:
        Removed compiler warnings
      sql/ha_myisam.cc:
        Fixed wrong type of packet_len
      sql/item.h:
        Remove warnings
      sql/log_event.cc:
        Cleanup
      sql/log_event.h:
        Cleanup to make code more readable
      sql/mf_iocache.cc:
        Fixed wrong type
      sql/mysql_priv.h:
        Update of query cache code
      sql/mysqld.cc:
        Update of query cache code
      sql/net_serv.cc:
        Remove compiler warnings
      sql/opt_range.h:
        Remove compiler warnings
      sql/sql_cache.cc:
        Update of query cache code
      sql/sql_cache.h:
        Update of query cache code
      sql/sql_class.h:
        Cleanup
      sql/sql_insert.cc:
        Use thd->alloc() instead of sql_alloc()
      sql/sql_parse.cc:
        Fixed compiler warnings.
        Changed some sql_alloc() -> thd->alloc()
      sql/sql_select.cc:
        Changed sql_alloc() -> thd_alloc()
      sql/sql_select.h:
        Faster alloc()
      sql/sql_show.cc:
        Update of query cache code
      sql/sql_table.cc:
        Faster alloc()
      sql/table.cc:
        Faster alloc()
      eca2a1a3
  23. 02 Dec, 2001 1 commit
    • unknown's avatar
      Query cache. · 7c999bb0
      unknown authored
      Remove some warnings
      
      
      Docs/manual.texi:
        Solaris and gcc
      include/ft_global.h:
        Remove warnings
      include/myisam.h:
        Query cache
      include/myisammrg.h:
        Query cache
      include/mysql_com.h:
        Query cache
      libmysqld/lib_sql.cc:
        Query cache
      myisam/ft_boolean_search.c:
        Remove warnings
      myisam/ft_dump.c:
        Remove warnings
      myisam/ft_parser.c:
        Remove warnings
      myisam/ft_static.c:
        Remove warnings
      myisam/ft_update.c:
        Remove warnings
      myisam/ftdefs.h:
        Remove warnings
      myisam/mi_delete.c:
        Query cache
      myisam/mi_locking.c:
        Query cache
      myisam/mi_update.c:
        Query cache
      myisam/myisamdef.h:
        Optimize for Ia64
      myisammrg/myrg_extra.c:
        Query cache
      mysys/mf_keycache.c:
        DBUG statements
      regex/cclass.h:
        Remove warnings
      regex/cname.h:
        Remove warnings
      regex/main.c:
        Remove warnings
      regex/regcomp.c:
        Remove warnings
      regex/regcomp.ih:
        Remove warnings
      regex/regerror.c:
        Remove warnings
      regex/reginit.c:
        Remove warnings
      regex/split.c:
        Remove warnings
      sql-bench/test-connect.sh:
        Make tests query-cache safe.
      sql-bench/test-transactions.sh:
        Fix for old perl versions
      sql/convert.cc:
        Query cache
      sql/ha_myisammrg.cc:
        Query cache
      sql/ha_myisammrg.h:
        Query cache
      sql/handler.cc:
        Query cache
      sql/item_create.cc:
        Query cache
      sql/item_func.cc:
        Remove warnings
      sql/item_func.h:
        Remove warnings
      sql/lex.h:
        Query cache
      sql/mysql_priv.h:
        Query cache
      sql/mysqld.cc:
        Query cache
      sql/net_serv.cc:
        Query cache
      sql/sql_cache.cc:
        Query cache
      sql/sql_class.cc:
        Query cache
      sql/sql_class.h:
        Query cache
      sql/sql_db.cc:
        Query cache
      sql/sql_delete.cc:
        Query cache
      sql/sql_insert.cc:
        Query cache
      sql/sql_parse.cc:
        Query cache
      sql/sql_select.cc:
        Query cache
      sql/sql_table.cc:
        Query cache
      sql/sql_update.cc:
        Query cache
      sql/sql_yacc.yy:
        Query cache
      7c999bb0
  24. 29 Nov, 2001 1 commit
    • unknown's avatar
      Better optimization for InnoDB and BDB tables for ORDER BY · ace64918
      unknown authored
      Build-tools/Do-compile:
        Merge with 4.0
      Docs/manual.texi:
        Changelog
      mysql-test/r/innodb.result:
        New tests cases for ORDER BY
      mysql-test/r/myisam.result:
        New tests cases for ORDER BY
      mysql-test/t/innodb.test:
        New tests cases for ORDER BY
      mysql-test/t/myisam.test:
        New tests cases for ORDER BY
      ace64918
  25. 28 Nov, 2001 3 commits
    • unknown's avatar
      boolean fulltext search without an index · f3918c84
      unknown authored
      myisam/ft_dump.c:
        some help added
      f3918c84
    • unknown's avatar
      Fix of testcases after merge. · caa13ea3
      unknown authored
      Small improvement to write caching.
      
      
      Docs/manual.texi:
        Updated Changelog
      mysql-test/r/rpl000013.result:
        Fix after merge
      mysql-test/r/rpl000016.result:
        Fix after merge
      mysys/mf_iocache2.c:
        Small improvement to write caching.
      sql/sql_select.cc:
        Removed warning
      caa13ea3
    • unknown's avatar
      New improved IO_CACHE · 06e1e275
      unknown authored
      include/my_global.h:
        Remove dbug_assert()  (One should use DBUG_ASSERT() instead)
      mysql-test/mysql-test-run.sh:
        Fixed that xterm works on Solaris 2.8.
        Fixed printing of errors
      mysql-test/r/isam.result:
        Removed MyISAM test from ISAM test
      mysql-test/t/isam.test:
        Removed MyISAM test from ISAM test
      mysys/my_alloc.c:
        Removed warnings
      mysys/my_bitmap.c:
        Use DBUG_ASSERT
      mysys/my_pthread.c:
        Use DBUG_ASSERT
      mysys/my_seek.c:
        More DBUG
      sql/ha_berkeley.cc:
        Use DBUG_ASSERT
      sql/ha_innobase.cc:
        Use DBUG_ASSERT
      sql/log.cc:
        Use DBUG_ASSERT
      sql/opt_range.cc:
        Use DBUG_ASSERT
      sql/sql_base.cc:
        Use DBUG_ASSERT
      sql/sql_handler.cc:
        Use DBUG_ASSERT
      sql/sql_load.cc:
        Cleanup
      sql/sql_parse.cc:
        Use DBUG_ASSERT
      sql/sql_repl.cc:
        Cleanup
      sql/sql_select.cc:
        Use DBUG_ASSERT
      tools/mysqlmanager.c:
        Cleanup
      06e1e275
  26. 27 Nov, 2001 1 commit
    • unknown's avatar
      Fixed bug when joining with caching. · 312e5e82
      unknown authored
      Fixed race condition when using the binary log and INSERT DELAYED which could cause the binary log to have rows that was not yet written to MyISAM tables.
      
      
      Docs/manual.texi:
        Changelog
      mysql-test/r/null_key.result:
        Fix of testcase after changing optimizer to only use range keys if it would use a long part of the SAME key.
      sql/sql_insert.cc:
        Fixed race condition with binary log and INSERT DELAYED
      sql/sql_select.cc:
        Fixed bug when joining with caching
      312e5e82
  27. 26 Nov, 2001 1 commit
  28. 25 Nov, 2001 1 commit
    • unknown's avatar
      Fixes for embedded version. · 2239aa17
      unknown authored
      BitKeeper/deleted/.del-WHITEPAPER~da1226799debcf3f:
        Delete: libmysqld/WHITEPAPER
      Docs/manual.texi:
        Changelog
      client/mysqltest.c:
        Fix things that crashed embedded MySQL
      libmysqld/examples/test-run:
        Cleanup of old BDB files.
      mysql-test/r/innodb.result:
        Fix for embedded library
      mysql-test/t/innodb.test:
        Fix for embedded library
      mysys/mf_keycache.c:
        Safety
      sql/ha_berkeley.cc:
        Added DBUG statements
      sql/ha_innobase.cc:
        Fixed bug for embedded version
      sql/ha_innobase.h:
        Fix to use index when doing an ORDER BY on a whole InnoDB table
      sql/handler.h:
        Fix to use index when doing an ORDER BY on a whole InnoDB table
      sql/mysqld.cc:
        Safety fix
      sql/sql_base.cc:
        cleanup
      sql/sql_select.cc:
        Fix to use index when doing an ORDER BY on a whole InnoDB table
      2239aa17
  29. 22 Nov, 2001 1 commit
    • unknown's avatar
      Fixed fulltext after merge from 3.23.45 · 38357b30
      unknown authored
      First (incomplete) version of transaction and as3ap tests.
      
      
      BitKeeper/etc/ignore:
        Added sql-bench/test-transactions to the ignore list
      mysql-test/r/fulltext.result:
        Update fulltext results after merge
      sql-bench/Makefile.am:
        Added transaction test
      sql-bench/run-all-tests.sh:
        Added transaction test
      sql-bench/server-cfg.sh:
        Added transaction test
      sql-bench/test-ATIS.sh:
        Cleanup
      sql/item_func.cc:
        Fix bad merge
      sql/mysqld.cc:
        Cleanup
      sql/sql_base.cc:
        Fix bad merge
      sql/sql_delete.cc:
        Cleanup
      sql/sql_parse.cc:
        Fix bad merge
      sql/sql_select.cc:
        Fix bad merge
      sql/sql_union.cc:
        Fix bad merge
      tools/mysqlmanager.c:
        C
      38357b30
  30. 21 Nov, 2001 2 commits
    • unknown's avatar
      bad merge fixed · 1bdd1963
      unknown authored
      1bdd1963
    • unknown's avatar
      removed ftfuncs argument for mysql_select · 680d0219
      unknown authored
      it uses now thd->lex.ftfunc_list
      moved ft-initialization to a separate function
      re-disabled implicit ft initialization
      
      
      sql/item_func.cc:
        re-disabled implicit initialization that was re-enabled (by me)
        for reasons unknown (at least the code passed all the tests)
      sql/mysql_priv.h:
        removed ftfuncs argument for mysql_select
        it uses now thd->lex.ftfunc_list
        moved ft-initialization to a separate function
      sql/sql_base.cc:
        removed ftfuncs argument for mysql_select
        it uses now thd->lex.ftfunc_list
        moved ft-initialization to a separate function
      sql/sql_parse.cc:
        removed ftfuncs argument for mysql_select
        it uses now thd->lex.ftfunc_list
        moved ft-initialization to a separate function
      sql/sql_select.cc:
        removed ftfuncs argument for mysql_select
        it uses now thd->lex.ftfunc_list
        moved ft-initialization to a separate function
      680d0219
  31. 06 Nov, 2001 1 commit
    • unknown's avatar
      Portability fix · 8547d05c
      unknown authored
      Cleanup typos (like SKIPP -> SKIP)
      
      
      BUILD/compile-alpha-cxx:
        Fix when using InnoDB
      Docs/manual.texi:
        FreeBSD note
      client/mysqlmanager-pwgen.c:
        Portability fix
      include/my_base.h:
        Cleanup typos
      isam/_dynrec.c:
        Cleanup typos
      isam/_packrec.c:
        Cleanup typos
      isam/create.c:
        Cleanup typos
      isam/pack_isam.c:
        Cleanup typos
      isam/test1.c:
        Cleanup typos
      isam/test2.c:
        Cleanup typos
      libmysql/manager.c:
        Portability fix
      myisam/ft_eval.c:
        Cleanup typos
      myisam/ft_test1.c:
        Cleanup typos
      myisam/mi_create.c:
        Cleanup typos
      myisam/mi_dynrec.c:
        Cleanup typos
      myisam/mi_packrec.c:
        Cleanup typos
      myisam/mi_test1.c:
        Cleanup typos
      myisam/mi_test2.c:
        Cleanup typos
      myisam/myisampack.c:
        Cleanup typos
      sql/field.cc:
        Cleanup typos
      sql/field.h:
        Cleanup typos
      sql/filesort.cc:
        Cleanup typos
      sql/gen_lex_hash.cc:
        Cleanup typos
      sql/ha_isam.cc:
        Cleanup typos
      sql/ha_myisam.cc:
        Cleanup typos
      sql/handler.h:
        Cleanup typos
      sql/hash_filo.h:
        Cleanup typos
      sql/item.h:
        Cleanup typos
      sql/item_cmpfunc.cc:
        Cleanup typos
      sql/item_strfunc.cc:
        Cleanup typos
      sql/key.cc:
        Cleanup typos
      sql/mysqld.cc:
        Cleanup typos
      sql/opt_range.cc:
        Cleanup typos
      sql/opt_sum.cc:
        Cleanup typos
      sql/sql_acl.cc:
        Cleanup typos
      sql/sql_class.h:
        Cleanup typos
      sql/sql_insert.cc:
        Cleanup typos
      sql/sql_lex.cc:
        Cleanup typos
      sql/sql_list.h:
        Cleanup typos
      sql/sql_load.cc:
        Cleanup typos
      sql/sql_parse.cc:
        Cleanup typos
      sql/sql_rename.cc:
        Cleanup typos
      sql/sql_select.cc:
        Cleanup typos
      sql/sql_string.cc:
        Cleanup typos
      sql/sql_yacc.yy:
        Fix bug in last changeset
      sql/structs.h:
        Cleanup typos
      sql/table.cc:
        Cleanup typos
      sql/time.cc:
        Cleanup typos
      sql/unireg.h:
        Cleanup typos
      8547d05c
  32. 03 Nov, 2001 2 commits
    • unknown's avatar
      Added STDCALL to mysql_sever and mysql_thread variables · 8b91ed2c
      unknown authored
      Merged error messages with 3.23.44
      Fixed bug with DATA DIRECTORY on windows
      
      
      Docs/internals.texi:
        Update coding policies
      Docs/manual.texi:
        Minor general corrections
      acinclude.m4:
        Fixed wrong cpu-test
      configure.in:
        Remove CPU test, because this makes unportable binaries.
      include/mysql.h:
        Added STDCALL to mysql_sever and mysql_thread variables
      include/mysqld_error.h:
        Merged error messages with 3.23.44
      libmysql/libmysql.c:
        Added STDCALL to mysql_sever and mysql_thread variables
      libmysqld/lib_sql.cc:
        Added STDCALL to mysql_sever and mysql_thread variables
      sql-bench/limits/db2.cfg:
        New limits file
      sql-bench/test-select.sh:
        Fixed bug in cache test
      sql/share/czech/errmsg.txt:
        Merged error messages with 3.23.44
      sql/share/danish/errmsg.txt:
        Merged error messages with 3.23.44
      sql/share/dutch/errmsg.txt:
        Merged error messages with 3.23.44
      sql/share/english/errmsg.txt:
        Merged error messages with 3.23.44
      sql/share/estonian/errmsg.txt:
        Merged error messages with 3.23.44
      sql/share/french/errmsg.txt:
        Merged error messages with 3.23.44
      sql/share/german/errmsg.txt:
        Merged error messages with 3.23.44
      sql/share/greek/errmsg.txt:
        Merged error messages with 3.23.44
      sql/share/hungarian/errmsg.txt:
        Merged error messages with 3.23.44
      sql/share/italian/errmsg.txt:
        Merged error messages with 3.23.44
      sql/share/japanese/errmsg.txt:
        Merged error messages with 3.23.44
      sql/share/korean/errmsg.txt:
        Merged error messages with 3.23.44
      sql/share/norwegian-ny/errmsg.txt:
        Merged error messages with 3.23.44
      sql/share/norwegian/errmsg.txt:
        Merged error messages with 3.23.44
      sql/share/polish/errmsg.txt:
        Merged error messages with 3.23.44
      sql/share/portuguese/errmsg.txt:
        Merged error messages with 3.23.44
      sql/share/romanian/errmsg.txt:
        Merged error messages with 3.23.44
      sql/share/russian/errmsg.txt:
        Merged error messages with 3.23.44
      sql/share/slovak/errmsg.txt:
        Merged error messages with 3.23.44
      sql/share/spanish/errmsg.txt:
        Merged error messages with 3.23.44
      sql/share/swedish/errmsg.txt:
        Merged error messages with 3.23.44
      sql/share/ukrainian/errmsg.txt:
        Merged error messages with 3.23.44
      sql/sql_parse.cc:
        Fix bug with DATA DIRECTORY on windows.
      sql/sql_select.cc:
        Cleanup
      8b91ed2c
    • unknown's avatar
      Fixed problem with t1 LEFT_JOIN t2 ... WHERE t2.date_column IS NULL when... · 0176dacd
      unknown authored
      Fixed problem with t1 LEFT_JOIN t2 ... WHERE t2.date_column IS NULL when date_column is declared as NOT NULL.
      
      
      BUILD/SETUP.sh:
        Use -O1 to avoid problem with INLINE functions
      Docs/manual.texi:
        Changelog
      mysql-test/r/join.result:
        Test for bugfix
      mysql-test/t/join.test:
        Test for bugfix
      sql/sql_select.cc:
        Fixed problem with t1 LEFT_JOIN t2 ... WHERE t2.date_column IS NULL when date_column was declared as NOT NULL.
      BitKeeper/etc/ignore:
        Added bdb/include/db_ext.h bdb/include/mutex_ext.h to the ignore list
      0176dacd
  33. 31 Oct, 2001 2 commits
    • unknown's avatar
      Changed time -> query_time in slow query log. · 78b58fca
      unknown authored
      Fixed Rows_examined in slow query log.
      
      
      Docs/manual.texi:
        Changlog
      sql/log.cc:
        Changed time -> query_time in slow query log.
      sql/sql_select.cc:
        Fixed Rows_examined count in slow query log.
      78b58fca
    • unknown's avatar
      Portability fixes · 03f6fdd5
      unknown authored
      Fix for consistent 0000-00-00 date handling
      Close + open binary logs on flush tables
      Fix for AVG() in HAVING.
      
      
      BUILD/SETUP.sh:
        Compile MySQL with -O0 to make debugging easier.
      Docs/manual.texi:
        Changelog
      configure.in:
        Version change
      innobase/buf/buf0lru.c:
        Fix for windows
      mysql-test/r/func_time.result:
        Updated tests
      mysql-test/r/having.result:
        Updated tests
      mysql-test/t/func_time.test:
        Updated tests
      mysql-test/t/having.test:
        Updated tests
      mysys/mf_casecnv.c:
        Portability fix
      mysys/mf_qsort.c:
        Portability fix
      mysys/my_compress.c:
        Portability fix
      mysys/my_tempnam.c:
        More comments
      sql/field.cc:
        Fix for consistent 0000-00-00 date handling
      sql/item.h:
        Fix for AVG() in HAVING
      sql/log.cc:
        Close + open update logs on flush tables
      sql/sql_select.cc:
        More debugging info
      sql/time.cc:
        Fix for consistent 0000-00-00 date handling
      strings/ctype.c:
        Portability fix
      strings/strto.c:
        Portability fix
      03f6fdd5