An error occurred fetching the project authors.
  1. 15 Sep, 2003 1 commit
    • unknown's avatar
      Fixed bug in the optimiser for FULL TABLE SCAN case: · db03c7e8
      unknown authored
      to estimate correctly cost of full table scan we should take into
      account rows read and skipped on each iteration.
      
      
      mysql-test/r/distinct.result:
        Fixed test suite: now full scan is used
        less often
      mysql-test/r/join_outer.result:
        Fixed test suite: now full scan is used
        less often
      mysql-test/r/select_safe.result:
        Fixed test suite: now full scan is used
        less often
      db03c7e8
  2. 05 Jul, 2003 1 commit
  3. 27 Jun, 2003 1 commit
    • unknown's avatar
      Added thread variable max_seeks_for_key · c2cb9b97
      unknown authored
      Change optimizer to prefer key lookups before table scan
      Change table scans to be done after tables with constrains on scanned table 
      
      
      mysql-test/r/distinct.result:
        Update results
      mysql-test/r/group_by.result:
        Update results
      mysql-test/r/heap.result:
        Update results
      mysql-test/r/join.result:
        Update results
      mysql-test/r/key_diff.result:
        Update results
      mysql-test/r/myisam.result:
        Update results
      mysql-test/r/order_by.result:
        Update results
      mysql-test/r/select_safe.result:
        Update results
      mysql-test/t/distinct.test:
        Change test to be repeatable
      mysql-test/t/join.test:
        Change test to be repeatable
      mysql-test/t/select_safe.test:
        Add tests for MAX_SEEKS_FOR_KEY
      sql/handler.h:
        Optimize structure for 64 bit machines (and to avoid problems with gdb)
      sql/item_cmpfunc.cc:
        Initialize not_null_tables_cache properly
      sql/mysqld.cc:
        Added max_seeks_for_key
      sql/set_var.cc:
        Added max_seeks_for_key
      sql/sql_class.h:
        Added max_seeks_for_key
      sql/sql_select.cc:
        Added max_seeks_for_key
        Change optimizer to prefer key lookups before table scan.
        Change table scans to be done after tables with constrains on scanned table
      c2cb9b97
  4. 06 Feb, 2003 1 commit
    • unknown's avatar
      Added START TRANSACTION syntax · dacf7f8f
      unknown authored
      Added ALL as parameter option for all group functions.
      Make join handling uniform. This allows us to use ',', JOIN and INNER JOIN the same way.
      Sort NULL last if DESC is used (ANSI SQL 99 requirement)
      
      
      include/my_global.h:
        Moved LL from mysql_priv (as this is also in config-win.h)
      mysql-test/r/distinct.result:
        Updated results
      mysql-test/r/func_group.result:
        Updated results
      mysql-test/r/innodb.result:
        Updated results
      mysql-test/r/join.result:
        Updated results
      mysql-test/r/order_by.result:
        Updated results
      mysql-test/t/func_group.test:
        Added test for SUM(ALL ...)
      mysql-test/t/innodb.test:
        Added test for START TRANSACTION
      mysql-test/t/join.test:
        Test different join syntaxes
      mysql-test/t/order_by.test:
        Added new test of NULL ordering.
      sql/filesort.cc:
        Sort NULL last if DESC is used
      sql/lex.h:
        Added OLD_PASSWORD() as synonym for PASSWORD.
      sql/mysql_priv.h:
        Removed LL()
      sql/opt_range.cc:
        Sort NULL last if DESC is used
      sql/opt_range.h:
        Sort NULL last if DESC is used
      sql/slave.cc:
        Indentation changes
      sql/sql_parse.cc:
        After merge fix
      sql/sql_select.cc:
        Added comment
      sql/sql_yacc.yy:
        Added START TRANSACTION syntax
        Added ALL as parameter option for all group functions.
        Make join handling uniform.
      dacf7f8f
  5. 14 Dec, 2002 1 commit
    • unknown's avatar
      Transactions in AUTOCOMMIT=0 mode didn't rotate binary log · b512c8b8
      unknown authored
      Don't enable any bulk insert or record caching code if inserting less than MIN_ROWS_TO_USE_BULK_INSERT rows (100)
      
      
      myisam/mi_check.c:
        Fixed bug in copying statistics for disabled index
      mysql-test/r/distinct.result:
        Fix result after not doing key statistics for first insert.
      mysql-test/r/fulltext.result:
        Fix result after not doing key statistics for first insert.
      mysql-test/r/insert.result:
        Fix result after not doing key statistics for first insert.
      mysql-test/r/key_diff.result:
        Fix result after not doing key statistics for first insert.
      mysql-test/r/order_by.result:
        Fix result after not doing key statistics for first insert.
      mysql-test/r/select.result:
        Fix result after not doing key statistics for first insert.
      mysql-test/r/show_check.result:
        Fix result after not doing key statistics for first insert.
      sql/ha_myisam.cc:
        Don't disable index when inserting only a few rows
      sql/log.cc:
        Transactions in AUTOCOMMIT=0 mode didn't rotate binary log.
      sql/sql_insert.cc:
        Don't enable any bulk insert or record caching code if inserting less than MIN_ROWS_TO_USE_BULK_INSERT
      b512c8b8
  6. 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
  7. 03 Dec, 2002 1 commit
    • unknown's avatar
      Change of internal key_field=NULL handling to avoid error messages. · 80b143c1
      unknown authored
      Optimized SELECT DISTINCT ... ORDER BY ... LIMIT
      Fixed reference to uninitalized variable
      
      
      mysql-test/r/distinct.result:
        Updated results for new tests
      mysql-test/r/func_math.result:
        Fixed test of RND()
      mysql-test/r/innodb.result:
        Updated results for new tests
      mysql-test/r/null.result:
        Updated results for new tests
      mysql-test/t/distinct.test:
        New distinct test
      mysql-test/t/func_math.test:
        Fixed test of RND()
      mysql-test/t/innodb.test:
        Test for bugs
      mysql-test/t/null.test:
        TEst for bugs
      sql/field.h:
        Change of NULL handling to avoid error messages
      sql/field_conv.cc:
        Change of NULL handling to avoid error messages
      sql/item.cc:
        Change of NULL handling to avoid error messages
      sql/item.h:
        Change of NULL handling to avoid error messages
      sql/item_cmpfunc.cc:
        Change of NULL handling to avoid error messages
      sql/item_func.cc:
        Change of NULL handling to avoid error messages
      sql/item_func.h:
        Cleaned up RND() handling
      sql/item_timefunc.cc:
        Change of NULL handling to avoid error messages
      sql/item_timefunc.h:
        Change of NULL handling to avoid error messages
      sql/opt_range.cc:
        Fixed bug in <=> NULL
      sql/password.c:
        Indentation cleanup
      sql/sql_base.cc:
        Change of NULL handling to avoid error messages
      sql/sql_class.cc:
        Fixed reference to uninitalized variable
      sql/sql_handler.cc:
        Change of NULL handling to avoid error messages
      sql/sql_select.cc:
        Change of NULL handling to avoid error messages
        Optimized SELECT DISTINCT ... ORDER BY ... LIMIT
      sql/sql_select.h:
        Change of NULL handling to avoid error messages
      sql/unireg.cc:
        Change of NULL handling to avoid error messages
      80b143c1
  8. 29 Oct, 2002 1 commit
    • unknown's avatar
      Added --skip-safemalloc to mysqltest · 31ba88c0
      unknown authored
      Added bug fix from 3.23 for AIX 4.3.3 and gcc 3.x
      Small change in EXCHANGE output
      Propagate open-files-limit from mysqld_safe -> mysqld
      Fixed speed bug in GROUP BY
      Added quotes around database name in CREATE DATABASE db_name (for binary log)
      
      
      BitKeeper/etc/ignore:
        added stamp-h1
      Docs/manual.texi:
        Added 4.1 manual section
        Updated changelog
      client/mysqltest.c:
        Added --skip-safemalloc
      include/my_global.h:
        Added bug fix from 3.23 for AIX 4.3.3 and gcc 3.x
      mysql-test/mysql-test-run.sh:
        Start mysqltest with --skip-safemalloc (To get it faster)
      mysql-test/r/bdb.result:
        Update for new EXPLAIN output
      mysql-test/r/compare.result:
        Update for new EXPLAIN output
      mysql-test/r/create.result:
        Update for new EXPLAIN output
      mysql-test/r/distinct.result:
        Update for new EXPLAIN output
      mysql-test/r/explain.result:
        Update for new EXPLAIN output
      mysql-test/r/group_by.result:
        Update for new EXPLAIN output
      mysql-test/r/heap.result:
        Update for new EXPLAIN output
      mysql-test/r/innodb.result:
        Update for new EXPLAIN output
      mysql-test/r/join_outer.result:
        Update for new EXPLAIN output
      mysql-test/r/key_diff.result:
        Update for new EXPLAIN output
      mysql-test/r/merge.result:
        Update for new EXPLAIN output
      mysql-test/r/null_key.result:
        Update for new EXPLAIN output
      mysql-test/r/order_by.result:
        Update for new EXPLAIN output
      mysql-test/r/select.result:
        Update for new EXPLAIN output
      mysql-test/r/temp_table.result:
        Fixed speed bug in GROUP BY
      mysql-test/r/type_datetime.result:
        Update for new EXPLAIN output
      mysql-test/r/user_var.result:
        Update for new EXPLAIN output
      mysql-test/r/variables.result:
        Removed variable safe_show_database
      mysql-test/t/temp_table.test:
        Fixed speed bug in GROUP BY
      mysql-test/t/variables.test:
        Removed not used variable safe_show_databases
      scripts/mysqld_safe.sh:
        Propagate open-files-limit from mysqld_safe -> mysqld
      sql/mysqld.cc:
        Removed variable safe_show_database
      sql/set_var.cc:
        Removed variable safe_show_database
      sql/slave.cc:
        Updated error message
      sql/sql_db.cc:
        Added quotes around database name in CREATE DATABASE db_name
      sql/sql_select.cc:
        Fixed speed bug in GROUP BY
      31ba88c0
  9. 14 Oct, 2002 1 commit
    • unknown's avatar
      Fixed a bug in key optimizing handling where the expression · a86c172f
      unknown authored
      WHERE column_name = key_column_name was calculated as true
      for NULL values.
      
      
      Docs/manual.texi:
        Changelog
      mysql-test/r/distinct.result:
        Updated results caused by bug fix.
      mysql-test/r/null_key.result:
        New tests
      mysql-test/t/null_key.test:
        New tests
      sql/sql_select.cc:
        Additional change for previous changeset for using BLOB in GROUP BY
      a86c172f
  10. 10 Sep, 2002 1 commit
  11. 04 Sep, 2002 1 commit
  12. 03 Sep, 2002 3 commits
    • unknown's avatar
      a fix for a bug with all_fields.elements not being changed by · bdf91563
      unknown authored
      expansion of the wildcards
      
      
      bdf91563
    • unknown's avatar
      Fixed bug introduces by last changeset · 3307f955
      unknown authored
      (Fixing of problem with ALTER TABLE on BDB tables)
      
      
      mysql-test/r/distinct.result:
        Fixed results after bug fix
      sql/mysql_priv.h:
        Split close_thread_tables() into two functions.
        (Needed for bug fix from 4.0)
      sql/sql_base.cc:
        Split close_thread_tables() into two functions.
        (Needed for bug fix from 4.0)
      3307f955
    • unknown's avatar
      Some trivial optimzations · 0f2ab68c
      unknown authored
      Check if AND/OR expression can be NULL; Fixed bug in GROUP BY and-or-expression where expression could be NULL
      Bug fix for SHOW OPEN TABLES when user didn't have privilege to access all open tables.
      Better fix for ALTER TABLE on BDB tables.
      
      
      Docs/manual.texi:
        Changelog
      client/mysql.cc:
        Simple optimization
      libmysql/libmysql.c:
        Removed initialization of varibles that are already set to zero
      myisam/myisamchk.c:
        Fixed comment for extend-check
      mysql-test/r/bdb-alter-table-1.result:
        Updated results
      mysql-test/r/bdb-alter-table-2.result:
        Updated results
      mysql-test/r/distinct.result:
        Updated results after bug fix
      mysql-test/r/handler.result:
        Updated results
      mysql-test/r/innodb_handler.result:
        Updated results
      mysql-test/r/select.result:
        Updated results
      mysql-test/r/varbinary.result:
        Updated results
      mysql-test/t/bdb-alter-table-1.test:
        Added comments
      mysql-test/t/bdb-alter-table-2.test:
        Added comments
      mysql-test/t/select.test:
        Remove OPTION in SET OPTION
        Added tests for ORDER BY key LIMIT
      sql/item_cmpfunc.cc:
        Check if AND/OR expression can be NULL
      sql/mysqld.cc:
        mysqld --help now shows value of datadir
      sql/share/english/errmsg.txt:
        Better error message for syntax error
      sql/sql_base.cc:
        Bug fix for SHOW OPEN TABLES
      sql/sql_class.cc:
        Moved virtual function to .cc file to avoid that we have to include assert.h everywhere.
      sql/sql_class.h:
        Moved virtual function to .cc file to avoid that we have to include assert.h everywhere.
      sql/sql_parse.cc:
        Removed old dead code from 3.23
      sql/sql_select.cc:
        Improved optimization of ORDER BY key LIMIT
      sql/sql_table.cc:
        More comments,
        Better fix for ALTER TABLE on BDB tables.
      0f2ab68c
  13. 16 Aug, 2002 1 commit
    • unknown's avatar
      Fixed bug in blocking handling when compiling with OPENSSL (caused hangup in client code) · 96f2e21e
      unknown authored
      Fixed bug in SELECT DISTINCT ... ORDER BY not-used-column.
      Fixed bug in pthread_mutex_trylock with HPUX 11.0
      
      
      Docs/manual.texi:
        Changelog
      include/my_pthread.h:
        Fix for pthread_mutex_trylock when used with SAFEMUTEX
      include/violite.h:
        Fixed bug in blocking handling when compiling with OPENSSL (caused hangup in client code)
      innobase/buf/buf0buf.c:
        Fixed wrong format string
      libmysqld/lib_sql.cc:
        Fixed hangup in embedded server.
      mysql-test/r/distinct.result:
        Fixed bug in SELECT DISTINCT ... ORDER BY not-used-column
      mysql-test/t/distinct.test:
        Fixed bug in SELECT DISTINCT ... ORDER BY not-used-column
      mysys/my_pthread.c:
        Cleanup of pthread_xxx rewrite code.
        Fixed bug in pthread_mutex_trylock with HPUX 11.0
      sql/gen_lex_hash.cc:
        Smaller hash array
      sql/mysqld.cc:
        Fixed hangup in embedded server.
      sql/sql_select.cc:
        Fixed bug in SELECT DISTINCT ... ORDER BY not-used-column
      vio/vio.c:
        Added vio_ssl_blocking
      vio/viossl.c:
        Added vio_ssl_blocking
      96f2e21e
  14. 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
  15. 28 Sep, 2001 1 commit
    • unknown's avatar
      client/mysqlmanagerc.c · 29f148bd
      unknown authored
          added support for quiet
          increased line buffer size
      client/mysqltest.c
          fixed memory leak
          added query logging to result file
          added error message logging to result file
          added enable_query_log/disable_query_log
      mysql-test/mysql-test-run.sh
          converted tests to use mysqlmanager
      
      Updated test results
      
      
      BitKeeper/etc/ignore:
        added *.reject
      client/mysqlmanagerc.c:
        added support for quiet
        increased line buffer size
      client/mysqltest.c:
        fixed memory leak
        added query logging to result file
        added error message logging to result file
        added enable_query_log/disable_query_log
      mysql-test/mysql-test-run.sh:
        converted tests to use mysqlmanager
      mysql-test/r/alias.result:
        log queries
      mysql-test/r/alter_table.result:
        log queries
      mysql-test/r/analyse.result:
        log queries
      mysql-test/r/auto_increment.result:
        log queries
      mysql-test/r/backup.result:
        log queries
      mysql-test/r/bdb-crash.result:
        log queries
      mysql-test/r/bench_count_distinct.result:
        log queries
      mysql-test/r/bigint.result:
        log queries
      mysql-test/r/binary.result:
        log queries
      mysql-test/r/bulk_replace.result:
        log queries
      mysql-test/r/case.result:
        log queries
      mysql-test/r/check.result:
        log queries
      mysql-test/r/comments.result:
        log queries
      mysql-test/r/compare.result:
        log queries
      mysql-test/r/count_distinct.result:
        log queries
      mysql-test/r/count_distinct2.result:
        log queries
      mysql-test/r/create.result:
        log queries
      mysql-test/r/ctype_latin1_de.result:
        log queries
      mysql-test/r/delayed.result:
        log queries
      mysql-test/r/dirty-close.result:
        log queries
      mysql-test/r/distinct.result:
        log queries
      mysql-test/r/drop.result:
        log queries
      mysql-test/r/empty_table.result:
        log queries
      mysql-test/r/explain.result:
        log queries
      mysql-test/r/flush.result:
        log queries
      mysql-test/r/fulltext.result:
        log queries
      mysql-test/r/fulltext_cache.result:
        log queries
      mysql-test/r/fulltext_distinct.result:
        log queries
      mysql-test/r/fulltext_left_join.result:
        log queries
      mysql-test/r/fulltext_multi.result:
        log queries
      mysql-test/r/fulltext_order_by.result:
        log queries
      mysql-test/r/fulltext_update.result:
        log queries
      mysql-test/r/fulltext_var.result:
        log queries
      mysql-test/r/func_crypt.result:
        log queries
      mysql-test/r/func_date_add.result:
        log queries
      mysql-test/r/func_equal.result:
        log queries
      mysql-test/r/func_group.result:
        log queries
      mysql-test/r/func_in.result:
        log queries
      mysql-test/r/func_like.result:
        log queries
      mysql-test/r/func_math.result:
        log queries
      mysql-test/r/func_misc.result:
        log queries
      mysql-test/r/func_op.result:
        log queries
      mysql-test/r/func_regexp.result:
        log queries
      mysql-test/r/func_set.result:
        log queries
      mysql-test/r/func_str.result:
        log queries
      mysql-test/r/func_system.result:
        log queries
      mysql-test/r/func_test.result:
        log queries
      mysql-test/r/func_time.result:
        log queries
      mysql-test/r/func_timestamp.result:
        log queries
      mysql-test/r/group_by.result:
        log queries
      mysql-test/r/handler.result:
        log queries
      mysql-test/r/having.result:
        log queries
      mysql-test/r/heap.result:
        log queries
      mysql-test/r/identity.result:
        log queries
      mysql-test/r/ins000001.result:
        log queries
      mysql-test/r/insert.result:
        log queries
      mysql-test/r/insert_select.result:
        log queries
      mysql-test/r/isam.result:
        log queries
      mysql-test/r/join.result:
        log queries
      mysql-test/r/join_crash.result:
        log queries
      mysql-test/r/join_outer.result:
        log queries
      mysql-test/r/key.result:
        log queries
      mysql-test/r/key_diff.result:
        log queries
      mysql-test/r/key_primary.result:
        log queries
      mysql-test/r/keywords.result:
        log queries
      mysql-test/r/kill.result:
        log queries
      mysql-test/r/limit.result:
        log queries
      mysql-test/r/lock.result:
        log queries
      mysql-test/r/merge.result:
        log queries
      mysql-test/r/multi_update.result:
        log queries
      mysql-test/r/myisam.result:
        log queries
      mysql-test/r/null.result:
        log queries
      mysql-test/r/null_key.result:
        log queries
      mysql-test/r/odbc.result:
        log queries
      mysql-test/r/openssl_1.result:
        log queries
      mysql-test/r/openssl_2.result:
        log queries
      mysql-test/r/order_by.result:
        log queries
      mysql-test/r/order_fill_sortbuf.result:
        log queries
      mysql-test/r/raid.result:
        log queries
      mysql-test/r/range.result:
        log queries
      mysql-test/r/rename.result:
        log queries
      mysql-test/r/replace.result:
        log queries
      mysql-test/r/rollback.result:
        log queries
      mysql-test/r/rpl000001.result:
        log queries
      mysql-test/r/rpl000002.result:
        log queries
      mysql-test/r/rpl000003.result:
        log queries
      mysql-test/r/rpl000004.result:
        log queries
      mysql-test/r/rpl000005.result:
        log queries
      mysql-test/r/rpl000006.result:
        log queries
      mysql-test/r/rpl000007.result:
        log queries
      mysql-test/r/rpl000008.result:
        log queries
      mysql-test/r/rpl000009.result:
        log queries
      mysql-test/r/rpl000010.result:
        log queries
      mysql-test/r/rpl000011.result:
        log queries
      mysql-test/r/rpl000012.result:
        log queries
      mysql-test/r/rpl000013.result:
        log queries
      mysql-test/r/rpl000014.result:
        log queries
      mysql-test/r/rpl000015.result:
        log queries
      mysql-test/r/rpl000016.result:
        log queries
      mysql-test/r/rpl000017.result:
        log queries
      mysql-test/r/rpl000018.result:
        log queries
      mysql-test/r/rpl_get_lock.result:
        log queries
      mysql-test/r/rpl_log.result:
        log queries
      mysql-test/r/rpl_magic.result:
        log queries
      mysql-test/r/rpl_mystery22.result:
        log queries
      mysql-test/r/rpl_sporadic_master.result:
        log queries
      mysql-test/r/sel000001.result:
        log queries
      mysql-test/r/sel000002.result:
        log queries
      mysql-test/r/sel000003.result:
        log queries
      mysql-test/r/sel000031.result:
        log queries
      mysql-test/r/sel000032.result:
        log queries
      mysql-test/r/sel000033.result:
        log queries
      mysql-test/r/sel000100.result:
        log queries
      mysql-test/r/select.result:
        log queries
      mysql-test/r/select_found.result:
        log queries
      mysql-test/r/select_safe.result:
        log queries
      mysql-test/r/show_check.result:
        log queries
      mysql-test/r/slave-running.result:
        log queries
      mysql-test/r/slave-stopped.result:
        log queries
      mysql-test/r/status.result:
        log queries
      mysql-test/r/symlink.result:
        log queries
      mysql-test/r/tablelock.result:
        log queries
      mysql-test/r/temp_table.result:
        log queries
      mysql-test/r/truncate.result:
        log queries
      mysql-test/r/type_blob.result:
        log queries
      mysql-test/r/type_date.result:
        log queries
      mysql-test/r/type_datetime.result:
        log queries
      mysql-test/r/type_decimal.result:
        log queries
      mysql-test/r/type_enum.result:
        log queries
      mysql-test/r/type_float.result:
        log queries
      mysql-test/r/type_ranges.result:
        log queries
      mysql-test/r/type_time.result:
        log queries
      mysql-test/r/type_timestamp.result:
        log queries
      mysql-test/r/type_uint.result:
        log queries
      mysql-test/r/type_year.result:
        log queries
      mysql-test/r/union.result:
        log queries
      mysql-test/r/update.result:
        log queries
      mysql-test/r/user_var.result:
        log queries
      mysql-test/r/varbinary.result:
        log queries
      mysql-test/r/variables.result:
        log queries
      mysql-test/t/bench_count_distinct.test:
        log queries
      mysql-test/t/check.test:
        log queries
      mysql-test/t/count_distinct2.test:
        log queries
      mysql-test/t/flush.test:
        log queries
      mysql-test/t/isam.test:
        log queries
      mysql-test/t/multi_update.test:
        log queries
      mysql-test/t/myisam.test:
        log queries
      mysql-test/t/order_fill_sortbuf.test:
        log queries
      mysql-test/t/rpl000016.test:
        log queries
      tools/managertest1.nc:
        test for def_exec overwrite
      tools/mysqlmanager.c:
        support def_exec overwrite and queries on running server
      29f148bd
  16. 10 Aug, 2001 1 commit
  17. 06 Mar, 2001 1 commit
    • unknown's avatar
      Merged some functions and removed some unused client functions. · 869c89fe
      unknown authored
      Remember UNION for ALTER TABLE
      Added test for if we are supporting transactions.
      Don't allow REPLACE to replace a row when we have generated an auto_increment key
      Fixed bug when using BLOB keys
      Fixed bug in SET @variable=user.
      
      
      Docs/manual.texi:
        Added some examples and moved the Error access denied section to the
        error section.
      client/mysqltest.c:
        Changed to use the new mysql_send_query()
      include/mysql.h:
        Changed mysql_reap_query() to mysql_send_query().
      libmysql/libmysql.c:
        Changed mysql_reap_query() to mysql_send_query()
        Merged some functions and removed some unused functions.
      mysql-test/r/bdb.result:
        New test case
      mysql-test/r/distinct.result:
        New test case
      mysql-test/r/key.result:
        New test case
      mysql-test/r/merge.result:
        New test case
      mysql-test/r/replace.result:
        New test case
      mysql-test/t/bdb.test:
        New test case
      mysql-test/t/key.test:
        New test case
      mysql-test/t/merge.test:
        New test case
      mysql-test/t/replace.test:
        New test case
      mysys/my_lock.c:
        Moved global lock variable to static
      sql-bench/test-insert.sh:
        Added test case for index-read only
      sql/field.h:
        Fixed that one can optimize ORDER BY with ISAM and GEMINI
      sql/ha_berkeley.cc:
        Added type casts needed for Windows
      sql/ha_innobase.cc:
        Removed reference to manual from comment.
      sql/ha_myisammrg.cc:
        Remember UNION for ALTER TABLE
      sql/ha_myisammrg.h:
        Remember UNION for ALTER TABLE
      sql/handler.cc:
        Added test for if we are supporting transactions.
        Don't allow REPLACE to replace a row when we have generated an auto_increment key.
      sql/handler.h:
        Remember UNION for ALTER TABLE
      sql/key.cc:
        Fixed bug when using BLOB keys
      sql/mysql_priv.h:
        Added new variables
      sql/mysqld.cc:
        Added new variables
      sql/opt_range.cc:
        Fixed problem with BLOB keys
      sql/opt_sum.cc:
        Fix for BLOB keys
      sql/sql_class.cc:
        Added test if we need to init/clean transaction variables
      sql/sql_insert.cc:
        Fix for REPLACE and auto_increment keys
      sql/sql_parse.cc:
        Fixed bug in max_user_connections
      sql/sql_select.cc:
        Fixed problem with key on BLOB
      sql/sql_yacc.yy:
        Fixed bug in SET @variable=user.
      sql/table.cc:
        Fixed problem with keys on BLOB
      869c89fe
  18. 28 Jan, 2001 1 commit
    • unknown's avatar
      Fixed ALTER TABLE on MERGE tables · 184e24b2
      unknown authored
      Fixed bug in DISTINCT
      
      
      Docs/manual.texi:
        Updated Changelog
        Cleaned up adding character sets
      merge/open.c:
        skip comments
      myisam/mi_check.c:
        Fixed bug when sorting index on Windows
      myisammrg/myrg_info.c:
        Use only portable printf arguments
      myisammrg/myrg_rrnd.c:
        Use only portable printf arguments
      mysql-test/r/distinct.result:
        Added test case for bug in distinct
      mysql-test/r/merge.result:
        Added test for ALTER TABLE
      mysql-test/t/distinct.test:
        Added test case for bug in distinct
      mysql-test/t/merge.test:
        Added test for ALTER TABLE
      sql-bench/crash-me.sh:
        Fixed portability issues
      sql/ha_myisammrg.cc:
        Fixed for ALTER TABLE on MERGE tables
      sql/item_sum.cc:
        Fixed bug in DISTINCT
      sql/sql_db.cc:
        Added test of namelen in check_db_name
      sql/sql_select.cc:
        Fixed bug in DISTINCT
      sql/sql_select.h:
        Fixed bug in DISTINCT
      sql/sql_table.cc:
        Fixed ALTER TABLE on MERGE tables
      sql/table.cc:
        Added test of namelen in check_db_name
      sql/table.h:
        Fixed ALTER TABLE on MERGE tables
      184e24b2
  19. 28 Dec, 2000 1 commit
    • unknown's avatar
      Added support for hex strings to mysqlimport · f537319d
      unknown authored
      A lot of new tests to mysqltest
      Fixed bug with BDB tables and autocommit
      
      
      BitKeeper/deleted/.del-delete.test~389410e29f2cebe5:
        Delete: mysql-test/t/delete.test
      BitKeeper/deleted/.del-delete.result~e866a6678e29f186:
        Delete: mysql-test/r/delete.result
      BitKeeper/deleted/.del-sel000014.test~74cb8c70f1d73fcc:
        Delete: mysql-test/t/sel000014.test
      BitKeeper/deleted/.del-sel000015.test~7442bf9cbc96fe07:
        Delete: mysql-test/t/sel000015.test
      BitKeeper/deleted/.del-sel000016.test~f495235f14c47ec:
        Delete: mysql-test/t/sel000016.test
      BitKeeper/deleted/.del-sel000017.test~7c39f2b45a6aa780:
        Delete: mysql-test/t/sel000017.test
      BitKeeper/deleted/.del-sel000018.test~16207f3ad74de75e:
        Delete: mysql-test/t/sel000018.test
      BitKeeper/deleted/.del-sel000014.result~fc8de0ec89d9e35:
        Delete: mysql-test/r/sel000014.result
      BitKeeper/deleted/.del-sel000015.result~cadbc52051d47bac:
        Delete: mysql-test/r/sel000015.result
      BitKeeper/deleted/.del-sel000016.result~6177851869bd5b07:
        Delete: mysql-test/r/sel000016.result
      BitKeeper/deleted/.del-sel000017.result~84ebf147850ff31c:
        Delete: mysql-test/r/sel000017.result
      BitKeeper/deleted/.del-sel000018.result~562ac9094cf53aba:
        Delete: mysql-test/r/sel000018.result
      BitKeeper/deleted/.del-sel000005.test~982fde89a4d6d886:
        Delete: mysql-test/t/sel000005.test
      BitKeeper/deleted/.del-sel000006.test~291cc6c8d85e51df:
        Delete: mysql-test/t/sel000006.test
      BitKeeper/deleted/.del-sel000005.result~d5410bb765199cc5:
        Delete: mysql-test/r/sel000005.result
      BitKeeper/deleted/.del-sel000006.result~d38004d1acfc11a5:
        Delete: mysql-test/r/sel000006.result
      BitKeeper/deleted/.del-sel000004.test~daf9ad4a1a31cd3c:
        Delete: mysql-test/t/sel000004.test
      BitKeeper/deleted/.del-sel000007.test~f431e4f4739a24c3:
        Delete: mysql-test/t/sel000007.test
      BitKeeper/deleted/.del-sel000008.test~b338ef585cadf7ae:
        Delete: mysql-test/t/sel000008.test
      BitKeeper/deleted/.del-sel000009.test~a455c38f5c942cd1:
        Delete: mysql-test/t/sel000009.test
      BitKeeper/deleted/.del-sel000010.test~ca07085ae92255f1:
        Delete: mysql-test/t/sel000010.test
      BitKeeper/deleted/.del-sel000011.test~c2a971726c9d18d6:
        Delete: mysql-test/t/sel000011.test
      BitKeeper/deleted/.del-sel000012.test~ae64bff363c42e92:
        Delete: mysql-test/t/sel000012.test
      BitKeeper/deleted/.del-sel000013.test~ce8aa504ba4f74ba:
        Delete: mysql-test/t/sel000013.test
      BitKeeper/deleted/.del-sel000019.test~8fd63c8dc6be8dbc:
        Delete: mysql-test/t/sel000019.test
      BitKeeper/deleted/.del-sel000020.test~c5758ad18a6dff1e:
        Delete: mysql-test/t/sel000020.test
      BitKeeper/deleted/.del-sel000021.test~94dd47de2872264a:
        Delete: mysql-test/t/sel000021.test
      BitKeeper/deleted/.del-sel000022.test~6e3e5435e66875e9:
        Delete: mysql-test/t/sel000022.test
      BitKeeper/deleted/.del-sel000023.test~7bdfcfaa278f837d:
        Delete: mysql-test/t/sel000023.test
      BitKeeper/deleted/.del-sel000024.test~849f47e6cbdc4fe3:
        Delete: mysql-test/t/sel000024.test
      BitKeeper/deleted/.del-sel000025.test~65b32b4b67e4c77:
        Delete: mysql-test/t/sel000025.test
      BitKeeper/deleted/.del-sel000026.test~d8aa2d614f23b1:
        Delete: mysql-test/t/sel000026.test
      BitKeeper/deleted/.del-sel000027.test~ab44bb57a580de9:
        Delete: mysql-test/t/sel000027.test
      BitKeeper/deleted/.del-sel000028.test~db9bfc0a808fb629:
        Delete: mysql-test/t/sel000028.test
      BitKeeper/deleted/.del-sel000029.test~6aae34dbb3ee86d9:
        Delete: mysql-test/t/sel000029.test
      BitKeeper/deleted/.del-sel000030.test~a29683eac3e7b706:
        Delete: mysql-test/t/sel000030.test
      BitKeeper/deleted/.del-sel000004.result~1f8d1265be521c17:
        Delete: mysql-test/r/sel000004.result
      BitKeeper/deleted/.del-sel000007.result~df455e49f9727c4f:
        Delete: mysql-test/r/sel000007.result
      BitKeeper/deleted/.del-sel000008.result~67a459ff62c84d6a:
        Delete: mysql-test/r/sel000008.result
      BitKeeper/deleted/.del-sel000009.result~e042b35ab131fb3:
        Delete: mysql-test/r/sel000009.result
      BitKeeper/deleted/.del-sel000010.result~eee5b9631a1e0066:
        Delete: mysql-test/r/sel000010.result
      BitKeeper/deleted/.del-sel000011.result~6907fe356973ed25:
        Delete: mysql-test/r/sel000011.result
      BitKeeper/deleted/.del-sel000012.result~be18991fc28954c2:
        Delete: mysql-test/r/sel000012.result
      BitKeeper/deleted/.del-sel000013.result~513389e06c96af73:
        Delete: mysql-test/r/sel000013.result
      BitKeeper/deleted/.del-sel000019.result~2870fe1c4998d929:
        Delete: mysql-test/r/sel000019.result
      BitKeeper/deleted/.del-sel000020.result~faa670294ef5fa91:
        Delete: mysql-test/r/sel000020.result
      BitKeeper/deleted/.del-sel000021.result~8f0ce4ec26e0c21d:
        Delete: mysql-test/r/sel000021.result
      BitKeeper/deleted/.del-sel000022.result~34828a43753ee767:
        Delete: mysql-test/r/sel000022.result
      BitKeeper/deleted/.del-sel000023.result~13e112d77573bf17:
        Delete: mysql-test/r/sel000023.result
      BitKeeper/deleted/.del-sel000024.result~b10d449624f48d07:
        Delete: mysql-test/r/sel000024.result
      BitKeeper/deleted/.del-sel000025.result~f31e08fcca805f35:
        Delete: mysql-test/r/sel000025.result
      BitKeeper/deleted/.del-sel000026.result~854fa951666b7982:
        Delete: mysql-test/r/sel000026.result
      BitKeeper/deleted/.del-sel000027.result~cfd73fe738f27da:
        Delete: mysql-test/r/sel000027.result
      BitKeeper/deleted/.del-sel000028.result~13ff5add6ac24908:
        Delete: mysql-test/r/sel000028.result
      BitKeeper/deleted/.del-sel000029.result~c6d071781808aa26:
        Delete: mysql-test/r/sel000029.result
      BitKeeper/deleted/.del-sel000030.result~98d496948e15064d:
        Delete: mysql-test/r/sel000030.result
      BitKeeper/deleted/.del-alt000001.test~633aed61c4bad94c:
        Delete: mysql-test/t/alt000001.test
      BitKeeper/deleted/.del-alt000001.result~393103dbf15f35c9:
        Delete: mysql-test/r/alt000001.result
      BitKeeper/deleted/.del-mrg000001.dummy.result~bf7e6d609f22b897:
        Delete: mysql-test/r/mrg000001.dummy.result
      BitKeeper/deleted/.del-mrg000001.result~db2ef2e717ab8332:
        Delete: mysql-test/r/mrg000001.result
      BitKeeper/deleted/.del-mrg000002.result~745be0854aaaaf5e:
        Delete: mysql-test/r/mrg000002.result
      BitKeeper/deleted/.del-mrg000001.test~e0327f9d1e6cb4e:
        Delete: mysql-test/t/mrg000001.test
      BitKeeper/deleted/.del-mrg000002.test~16b3a176adc0f311:
        Delete: mysql-test/t/mrg000002.test
      Docs/manual.texi:
        Changelog
      client/mysqlimport.c:
        Added support for hex strings
      client/mysqltest.c:
        Added linenumbers in output
        Only allow '{' first on a row (Conflicts with ODBC {} syntax).
        Handle bigger queries.
        Handle double ''
        Truncate result files.
      mysql-test/mysql-test-run.sh:
        Added --verbose
        cleanup
      mysql-test/r/bdb.result:
        Updating of test
      mysql-test/r/func_crypt.result:
        Updating of test
      mysql-test/r/func_equal.result:
        Updating of test
      mysql-test/r/func_str.result:
        Updating of test
      mysql-test/r/ins000001.result:
        Updating of test
      mysql-test/t/bdb.test:
        Updating of test
      mysql-test/t/err000001.test:
        Updating of test
      mysql-test/t/func_crypt.test:
        Updating of test
      mysql-test/t/func_equal.test:
        Updating of test
      mysql-test/t/func_str.test:
        Updating of test
      mysql-test/t/ins000001.test:
        Updating of test
      sql/gen_lex_hash.cc:
        Smaller table
      sql/handler.cc:
        Fixed bug in auto_commit
      f537319d