An error occurred fetching the project authors.
  1. 15 Sep, 2005 1 commit
    • unknown's avatar
      bad merge fixed · 4a86a5e6
      unknown authored
      mysql-test/r/insert_select.result:
        duplicated test removed
      mysql-test/t/insert_select.test:
        duplicated test removed
      4a86a5e6
  2. 19 Aug, 2005 1 commit
    • unknown's avatar
      distinct.test, distinct.result: · 87190222
      unknown authored
        Added test cases for bug #12625.
      sql_select.cc:
        Fixed bug #12625.
        Fixed invalid removal of constant items from the DISTINCT
        list in the function create_distinct_group.
      
      
      sql/sql_select.cc:
        Fixed bug #12625.
      mysql-test/r/distinct.result:
        Added test cases for bug #12625.
      mysql-test/t/distinct.test:
        Added test cases for bug #12625.
      87190222
  3. 08 Jun, 2005 1 commit
    • unknown's avatar
      Fix for bug #9764 (DISTINCT IFNULL truncates data) · 312b84d6
      unknown authored
      mysql-test/r/create.result:
        test result fixed
      mysql-test/r/distinct.result:
        test result fixed
      mysql-test/t/distinct.test:
        test case added
      sql/item_cmpfunc.cc:
        max_length should be calculated differently for DECIMAL_RESULT and others
      312b84d6
  4. 05 May, 2005 1 commit
    • unknown's avatar
      Tests and results fixed with last precision/decimal related modifications · e1c6c977
      unknown authored
      mysql-test/r/case.result:
        test result fixed
      mysql-test/r/create.result:
        test result fixed
      mysql-test/r/distinct.result:
        test result fixed
      mysql-test/r/func_group.result:
        test result fixed
      mysql-test/r/func_op.result:
        test result fixed
      mysql-test/r/group_by.result:
        test result fixed
      mysql-test/r/metadata.result:
        test result fixed
      mysql-test/r/olap.result:
        test result fixed
      mysql-test/r/ps_2myisam.result:
        test result fixed
      mysql-test/r/ps_3innodb.result:
        test result fixed
      mysql-test/r/ps_4heap.result:
        test result fixed
      mysql-test/r/ps_5merge.result:
        test result fixed
      mysql-test/r/ps_6bdb.result:
        test result fixed
      mysql-test/r/ps_7ndb.result:
        test result fixed
      mysql-test/r/select.result:
        test result fixed
      mysql-test/r/sp.result:
        test result fixed
      mysql-test/r/type_decimal.result:
        test result fixed
      mysql-test/r/type_newdecimal.result:
        test result fixed
      mysql-test/r/union.result:
        test result fixed
      mysql-test/r/variables.result:
        test result fixed
      mysql-test/t/func_group.test:
        test modified
      mysql-test/t/olap.test:
        test modified
      mysql-test/t/type_decimal.test:
        test modified
      e1c6c977
  5. 11 Feb, 2005 1 commit
    • unknown's avatar
      distinct.result: · 2167a87f
      unknown authored
        Adjustment of the result file after the revision of the fix for bug #7520.
      
      
      mysql-test/r/distinct.result:
        Adjustment of the result file after the revision of the fix for bug #7520.
      2167a87f
  6. 08 Feb, 2005 1 commit
    • unknown's avatar
      Precision Math implementation · c346d5c3
      unknown authored
      BitKeeper/etc/ignore:
        Added client/decimal.c client/my_decimal.cc client/my_decimal.h to the ignore list
      c346d5c3
  7. 31 Dec, 2004 1 commit
  8. 11 Oct, 2004 1 commit
  9. 27 Aug, 2004 1 commit
    • unknown's avatar
      WL#1724 "Min/Max Optimization for Queries with Group By Clause" · 72b06d45
      unknown authored
      - after-review changes
      - merged with the source tree from 204-08-27
      
      
      mysql-test/r/distinct.result:
        Different plans due to group-by optimization.
      sql/ha_myisam.cc:
        More general interface to key_copy.
      sql/handler.cc:
        More general interface to key_copy.
      sql/item.cc:
        New method to collect all Item_field objects. Used by Item::walk.
      sql/item.h:
        Several methods to collect different kinds of items from expression trees.
        Used by Item::walk.
      sql/item_sum.cc:
        Added helper to collect Item_sum objects.
      sql/item_sum.h:
        Methods to collect and test Item_sum objects.
      sql/key.cc:
        More general interface to key_copy and key_restore.
      sql/mysql_priv.h:
        More general interface to key_copy and key_restore.
      sql/opt_range.cc:
        Complete implementaion of WL#1724 "Min/Max Optimization for Queries with Group By Clause".
      sql/opt_range.h:
        Complete implementaion of WL#1724 "Min/Max Optimization for Queries with Group By Clause".
      sql/opt_sum.cc:
        simple_pred is re-used in opt_range.cc
      sql/sql_acl.cc:
        More general interface to key_copy and key_restore.
      sql/sql_handler.cc:
        More general interface to key_copy.
      sql/sql_insert.cc:
        More general interface to key_copy.
      sql/sql_select.cc:
        Changes to hook the new QUICK_GROUP_MIN_MAX_SELECT due to two differences from all other
        quick selects:
        1)
        This quick select may be created (and used) even if there is no WHERE clause.
        Several places assumed that a QUICK_SELECT is constructed only if there is a WHERE clause,
        which had to be changed so that QUICK_GROUP_MIN_MAX can be used.
        2)
        Unlike all other quick selects, this QUICK_GROUP_MIN_MAX_SELECT operates for GROUP BY queries.
        Since for the caller the quick select already produces one result tuple per group, there is
        no need to call end_send_group, instead we have to call end_send as for a regular quick select.
      sql/sql_select.h:
        simple_pred is re-used in opt_range.cc
      72b06d45
  10. 10 May, 2004 1 commit
    • unknown's avatar
      Complete implementation of WL#1469 "Greedy algorithm to search for an optimal execution plan", · 188cd434
      unknown authored
      consisting of pos-review fixes and improvements.
      
      
      mysql-test/r/distinct.result:
        Adjusted to account for pre-sorting of tables before optimiziation.
      mysql-test/r/func_group.result:
        Adjusted to account for pre-sorting of tables before optimiziation.
      mysql-test/r/greedy_optimizer.result:
        - Adjusted to account for pre-sorting of tables before optimiziation.
        - Removed unnecessary test.
        - More comments.
      mysql-test/r/select.result:
        - Adjusted to account for pre-sorting of tables before optimiziation.
      mysql-test/t/greedy_optimizer.test:
        - Adjusted to account for pre-sorting of tables before optimiziation.
        - Removed unnecessary test.
        - More comments.
      sql/mysql_priv.h:
        Moved function print_plan() to sql_test.cc
      sql/sql_select.cc:
        - Simplified the recursion in best_extension_by_limited_search()
          and aligned it with its pseudo-code.
        - Renamed functions to better reflect their semantics.
        - Post-review changes of function specifications.
        - Moved function print_plan() to sql_test.cc.
      sql/sql_test.cc:
        Moved function print_plan() to sql_test.cc
      188cd434
  11. 10 Dec, 2003 1 commit
    • unknown's avatar
      WorkLog#1323 · 833f85fb
      unknown authored
      Deprecate the use of TYPE=... Preferred syntax is ENGINE=
      
      
      include/mysqld_error.h:
        New warning for deprecated syntax
      sql/lex.h:
        Introduce ENGINE keyword
        Sort order of symbols
      sql/share/czech/errmsg.txt:
        New warning for deprecated syntax
      sql/share/danish/errmsg.txt:
        New warning for deprecated syntax
      sql/share/dutch/errmsg.txt:
        New warning for deprecated syntax
      sql/share/english/errmsg.txt:
        New warning for deprecated syntax
      sql/share/estonian/errmsg.txt:
        New warning for deprecated syntax
      sql/share/french/errmsg.txt:
        New warning for deprecated syntax
      sql/share/german/errmsg.txt:
        New warning for deprecated syntax
      sql/share/greek/errmsg.txt:
        New warning for deprecated syntax
      sql/share/hungarian/errmsg.txt:
        New warning for deprecated syntax
      sql/share/italian/errmsg.txt:
        New warning for deprecated syntax
      sql/share/japanese/errmsg.txt:
        New warning for deprecated syntax
      sql/share/korean/errmsg.txt:
        New warning for deprecated syntax
      sql/share/norwegian-ny/errmsg.txt:
        New warning for deprecated syntax
      sql/share/norwegian/errmsg.txt:
        New warning for deprecated syntax
      sql/share/polish/errmsg.txt:
        New warning for deprecated syntax
      sql/share/portuguese/errmsg.txt:
        New warning for deprecated syntax
      sql/share/romanian/errmsg.txt:
        New warning for deprecated syntax
      sql/share/russian/errmsg.txt:
        New warning for deprecated syntax
      sql/share/serbian/errmsg.txt:
        New warning for deprecated syntax
      sql/share/slovak/errmsg.txt:
        New warning for deprecated syntax
      sql/share/spanish/errmsg.txt:
        New warning for deprecated syntax
      sql/share/swedish/errmsg.txt:
        New warning for deprecated syntax
      sql/share/ukrainian/errmsg.txt:
        New warning for deprecated syntax
      sql/sql_show.cc:
        Change TYPE= with ENGINE=
      sql/sql_yacc.yy:
        Introduce ENGINE keyword,
        Deprecate TYPE= syntax,
        Introduce SHOW ENGINE syntax,
        Deprecate SHOW INNODB/BDB syntax.
      mysql-test/r/alias.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/alter_table.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/auto_increment.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/bdb-alter-table-1.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/bdb-crash.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/bdb-deadlock.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/bdb.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/bdb_cache.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/case.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/cast.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/constraints.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/create.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/ctype_collate.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/ctype_latin1_de.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/ctype_many.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/ctype_mb.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/ctype_recoding.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/ctype_ucs.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/delete.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/distinct.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/fulltext.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/fulltext2.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/fulltext_distinct.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/fulltext_left_join.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/func_compress.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/func_date_add.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/func_group.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/func_if.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/func_str.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/func_system.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/func_test.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/func_time.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/gis-rtree.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/group_by.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/handler.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/heap.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/heap_auto_increment.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/heap_btree.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/heap_hash.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/help.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/innodb-deadlock.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/innodb.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/innodb_cache.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/innodb_handler.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/insert_select.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/isam.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/join.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/join_crash.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/join_outer.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/key.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/lock.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/lock_tables_lost_commit.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/merge.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/mix_innodb_myisam_binlog.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/multi_update.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/myisam.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/null.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/null_key.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/order_by.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/query_cache.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/range.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/repair_part1.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/replace.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/rollback.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/rpl000006.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/rpl_flush_tables.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/rpl_insert_id.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/rpl_relayrotate.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/select.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/select_found.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/show_check.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/sql_mode.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/status.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/subselect.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/subselect2.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/subselect_innodb.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/symlink.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/temp_table.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/type_blob.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/type_datetime.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/type_enum.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/type_nchar.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/type_set.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/union.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/update.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/warnings.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/alias.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/alter_table.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/auto_increment.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/bdb-alter-table-1.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/bdb-crash.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/bdb-deadlock.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/bdb.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/bdb_cache.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/create.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/ctype_ucs.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/delete.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/distinct.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/fulltext.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/fulltext2.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/fulltext_distinct.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/fulltext_left_join.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/func_compress.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/func_date_add.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/func_group.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/func_if.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/func_str.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/func_test.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/func_time.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/gis-rtree.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/group_by.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/handler.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/heap.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/heap_auto_increment.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/heap_btree.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/heap_hash.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/help.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/innodb-deadlock.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/innodb.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/innodb_cache.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/innodb_handler.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/insert_select.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/isam.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/join.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/join_crash.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/join_outer.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/key.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/lock.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/lock_tables_lost_commit.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/merge.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/mix_innodb_myisam_binlog.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/multi_update.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/myisam.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/null.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/null_key.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/order_by.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/outfile.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/query_cache.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/query_cache_merge.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/range.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/repair_part1.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/replace.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/rollback.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/rpl000006.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/rpl_flush_tables.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/rpl_insert_id.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/rpl_relayrotate.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/select.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/select_found.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/show_check.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/sql_mode.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/status.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/subselect.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/subselect2.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/subselect_innodb.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/symlink.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/temp_table.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/type_datetime.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/type_set.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/union.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/update.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/warnings.test:
        Change occurances of TYPE= to ENGINE=
        New test for deprecated syntax
      833f85fb
  12. 08 Oct, 2003 1 commit
    • unknown's avatar
      Fixes after merge · a8d0df3a
      unknown authored
      mysql-test/std_data/trunc_binlog.000001:
        Rename: mysql-test/std_data/trunc_binlog.001 -> mysql-test/std_data/trunc_binlog.000001
      client/mysqltest.c:
        Fixed merge problem
      mysql-test/mysql-test-run.sh:
        Fixed merge problem
      mysql-test/r/distinct.result:
        Fix after merge
      mysql-test/r/drop_temp_table.result:
        Fix after merge
      mysql-test/r/join_outer.result:
        Fix after merge
      mysql-test/r/mysqldump.result:
        Fix after merge
      mysql-test/r/null_key.result:
        Fix after merge
      mysql-test/r/order_by.result:
        Fix after merge
      mysql-test/r/rpl_alter.result:
        Fix after merge
      mysql-test/r/rpl_loaddata.result:
        Fix after merge
      mysql-test/r/rpl_loaddata_rule_m.result:
        Fix after merge
      mysql-test/r/rpl_trunc_binlog.result:
        Fix after merge
      mysql-test/r/select_safe.result:
        Fix after merge
      mysql-test/t/insert.test:
        Fix after merge
      mysql-test/t/mysqlbinlog.test:
        Fix after merge
      mysql-test/t/rpl000009.test:
        Fix after merge
      mysql-test/t/rpl_alter.test:
        Fix after merge
      mysql-test/t/rpl_loaddata_rule_m.test:
        Fix after merge
      mysql-test/t/rpl_trunc_binlog.test:
        Fix after merge
      sql-common/client.c:
        Fix after merge
      sql/item_subselect.cc:
        Fix after merge
      sql/repl_failsafe.cc:
        Fix after merge
      sql/slave.cc:
        Fix after merge
      sql/sql_insert.cc:
        Fix after merge
      a8d0df3a
  13. 24 Sep, 2003 1 commit
  14. 17 Sep, 2003 2 commits
    • unknown's avatar
      Applied Monty corrections to the FULL SCAN · 2711025b
      unknown authored
      optimiser bug patch.
      
      
      mysql-test/r/distinct.result:
        test results reverted
      mysql-test/r/order_by.result:
        test results reverted
      sql/sql_select.cc:
        found_constrain renamed to found_constraint
        We don't perform full cartesian product in 
        case when JOIN BUFFER is used: it was taken
        into account.
        s->read_time may contain range index read time,
        so to get full table scan time is necessary to
        call s->table->file->scan_time().
      2711025b
    • unknown's avatar
      8e70f841
  15. 15 Sep, 2003 1 commit
    • unknown's avatar
      Fixed bug in the optimiser for FULL TABLE SCAN case: · e6a53458
      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
      e6a53458
  16. 12 Sep, 2003 1 commit
    • unknown's avatar
      Optimize thai character handling · ebd4b0be
      unknown authored
      Remove sel000xxxx tests
      After merge fixes
      
      
      BitKeeper/deleted/.del-sel000033.test~3971fbe746eec069:
        Delete: mysql-test/t/sel000033.test
      BitKeeper/deleted/.del-sel000033.result~56d1d02d72b94602:
        Delete: mysql-test/r/sel000033.result
      BitKeeper/deleted/.del-sel000100.result~84ed46856cb3a69f:
        Delete: mysql-test/r/sel000100.result
      BitKeeper/deleted/.del-sel000100.test~548501cad19a1a59:
        Delete: mysql-test/t/sel000100.test
      mysql-test/r/distinct.result:
        Merge test with sel000100
      mysql-test/r/grant.result:
        Update result after merge
      mysql-test/r/range.result:
        After merge fix
        Merge test with sel000033
      mysql-test/t/distinct.test:
        Merge test with sel000100
      mysql-test/t/range.test:
        Merge test with sel000033
      sql/log_event.cc:
        Remove duplicate allocation
      sql/sql_select.cc:
        After merge fixes
      strings/ctype-tis620.c:
        Remove usage of strnlen
        Optimize code and make it \0 safe
      ebd4b0be
  17. 18 Aug, 2003 1 commit
    • unknown's avatar
      After merge fixes · 89ad93a8
      unknown authored
      Use server character set if --default-character-set is not used
      Added convert_string() for more efficient alloc+character-set convert of strings
      
      
      BitKeeper/deleted/.del-convert.result~a3b56e1db6f498e9:
        Delete: mysql-test/r/convert.result
      BitKeeper/deleted/.del-convert.test~f4ceb743194dfe72:
        Delete: mysql-test/t/convert.test
      BitKeeper/deleted/.del-make_win_src_distribution.old~5c9ebdc4a852b43b:
        Delete: scripts/make_win_src_distribution.old
      client/mysql.cc:
        Use server character set if --default-character-set is not used
      client/mysqltest.c:
        Code cleanup (merge identical code)
        More debug messages
      heap/hp_create.c:
        After merge fix
      include/m_ctype.h:
        After merge fix
      include/my_global.h:
        Remove size_str (we already have size_s)
      include/mysql_com.h:
        After merge fix
      libmysql/libmysql.c:
        After merge fix
      libmysqld/Makefile.am:
        After merge fix
      mysql-test/r/auto_increment.result:
        After merge fix
      mysql-test/r/create.result:
        After merge fix
      mysql-test/r/ctype_latin1_de.result:
        After merge fix
      mysql-test/r/distinct.result:
        After merge fix
      mysql-test/r/drop.result:
        After merge fix
      mysql-test/r/fulltext.result:
        After merge fix
      mysql-test/r/func_gconcat.result:
        After merge fix
      mysql-test/r/func_str.result:
        After merge fix
      mysql-test/r/func_test.result:
        After merge fix
      mysql-test/r/grant.result:
        After merge fix
      mysql-test/r/group_by.result:
        After merge fix
      mysql-test/r/handler.result:
        After merge fix
      mysql-test/r/heap.result:
        After merge fix
      mysql-test/r/heap_btree.result:
        After merge fix
      mysql-test/r/heap_hash.result:
        After merge fix
      mysql-test/r/innodb.result:
        After merge fix
      mysql-test/r/insert.result:
        After merge fix
      mysql-test/r/insert_select.result:
        After merge fix
      mysql-test/r/join_outer.result:
        After merge fix
      mysql-test/r/key.result:
        After merge fix
      mysql-test/r/key_cache.result:
        After merge fix
      mysql-test/r/loaddata.result:
        After merge fix
      mysql-test/r/myisam.result:
        After merge fix
      mysql-test/r/null.result:
        After merge fix
      mysql-test/r/null_key.result:
        After merge fix
      mysql-test/r/order_by.result:
        After merge fix
      mysql-test/r/rpl_do_grant.result:
        After merge fix
      mysql-test/r/rpl_error_ignored_table.result:
        After merge fix
      mysql-test/r/rpl_ignore_grant.result:
        After merge fix
      mysql-test/r/rpl_loaddata.result:
        After merge fix
      mysql-test/r/rpl_log.result:
        After merge fix
      mysql-test/r/rpl_log_pos.result:
        After merge fix
      mysql-test/r/rpl_max_relay_size.result:
        After merge fix
      mysql-test/r/rpl_replicate_do.result:
        After merge fix
      mysql-test/r/rpl_reset_slave.result:
        After merge fix
      mysql-test/r/rpl_rotate_logs.result:
        After merge fix
      mysql-test/r/rpl_user_variables.result:
        After merge fix
      mysql-test/r/select.result:
        After merge fix
      mysql-test/r/select_safe.result:
        After merge fix
      mysql-test/r/subselect.result:
        After merge fix
      mysql-test/r/type_blob.result:
        After merge fix
      mysql-test/r/type_decimal.result:
        After merge fix
      mysql-test/r/type_float.result:
        After merge fix
      mysql-test/r/type_ranges.result:
        After merge fix
      mysql-test/r/type_time.result:
        After merge fix
      mysql-test/r/type_uint.result:
        After merge fix
      mysql-test/r/union.result:
        After merge fix
      mysql-test/r/warnings.result:
        After merge fix
      mysql-test/t/auto_increment.test:
        After merge fix
      mysql-test/t/case.test:
        After merge fix
      mysql-test/t/ctype_collate.test:
        After merge fix
      mysql-test/t/ctype_latin1_de.test:
        After merge fix
      mysql-test/t/drop.test:
        After merge fix
      mysql-test/t/func_in.test:
        After merge fix
      mysql-test/t/func_set.test:
        After merge fix
      mysql-test/t/func_str.test:
        After merge fix
      mysql-test/t/func_test.test:
        After merge fix
      mysql-test/t/grant.test:
        After merge fix
      mysql-test/t/group_by.test:
        After merge fix
      mysql-test/t/handler.test:
        After merge fix
      mysql-test/t/heap.test:
        After merge fix
      mysql-test/t/heap_btree.test:
        After merge fix
      mysql-test/t/heap_hash.test:
        After merge fix
      mysql-test/t/innodb.test:
        After merge fix
      mysql-test/t/insert_select.test:
        After merge fix
      mysql-test/t/key.test:
        After merge fix
      mysql-test/t/key_cache.test:
        After merge fix
      mysql-test/t/lock_tables_lost_commit-master.opt:
        After merge fix
      mysql-test/t/lock_tables_lost_commit.test:
        After merge fix
      mysql-test/t/myisam.test:
        After merge fix
      mysql-test/t/row.test:
        After merge fix
      mysql-test/t/subselect.test:
        After merge fix
      mysql-test/t/type_decimal.test:
        After merge fix
      mysql-test/t/type_ranges.test:
        After merge fix
      mysql-test/t/type_uint.test:
        After merge fix
      mysql-test/t/variables.test:
        After merge fix
      mysql-test/t/warnings.test:
        After merge fix
      scripts/make_win_src_distribution.sh:
        after merge fixes
      sql-common/client.c:
        After merge fix
        Change my_connect() to use poll()
        If character set is not given, use servers character set.
      sql/field.cc:
        After merge fix
        Don't give warnings when storing data in fields in optimizer.
      sql/ha_myisammrg.h:
        After merge fix
      sql/log.cc:
        After merge fix
      sql/log_event.cc:
        After merge fix
      sql/mysqld.cc:
        After merge fix
      sql/opt_range.cc:
        After merge fix
      sql/set_var.cc:
        Code cleanup
        Fixed wrong usage of base_names (like medium.key_buffer) that caused core dumps
      sql/set_var.h:
        Fixed wrong usage of base_names (like medium.key_buffer) that caused core dumps
      sql/slave.cc:
        After merge fix
      sql/sql_acl.cc:
        After merge fix
        Code cleanup
      sql/sql_class.cc:
        Added convert_string() for more efficient alloc+character-set convert of strings
        Add cached flags to avoid calling mysql_charset_same() during parsing.
      sql/sql_class.h:
        Added convert_string() for more efficient alloc+character-set convert of strings
        Add cached flags to avoid calling mysql_charset_same() during parsing.
      sql/sql_handler.cc:
        After merge fix
      sql/sql_lex.h:
        After merge fix
      sql/sql_parse.cc:
        Optimize and fix memory reference errors reported by valgrind
      sql/sql_repl.cc:
        After merge fix
      sql/sql_yacc.yy:
        After merge fix
        Avoid calling mysql_charset_same() when parsing identifiers
      strings/ctype-latin1.c:
        Port latin_de conversion code from 4.0
      89ad93a8
  18. 05 Jul, 2003 1 commit
  19. 30 Jun, 2003 1 commit
    • unknown's avatar
      Remove FORCE_INIT_OF_VARS when compiling for valgrind/purify to spot wrong LINT_INIT() options · 94d05b12
      unknown authored
      Fixed bug in ALTER TABLE ... MODIFY integer-column
      Added ref_or_null optimization (needed for subqueries)
      
      
      BUILD/compile-pentium-valgrind-max:
        Remove FORCE_INIT_OF_VARS to spot wrong LINT_INIT() options
      mysql-test/r/distinct.result:
        Update of test results (new optimizer)
      mysql-test/r/null_key.result:
        Update after ref_or_null optimization
      mysql-test/r/subselect.result:
        Update after ref_or_null optimization
      mysql-test/t/null_key.test:
        New tests for ref_or_null optimization
      sql/sql_select.cc:
        Added ref_or_null optimization
        Optimized find_best_combinations() and read-functions
      sql/sql_select.h:
        Added ref_or_null optimization
      sql/sql_yacc.yy:
        Fixed bug in ALTER TABLE ... MODIFY integer-column
      sql/table.cc:
        Safety fix for ALTER TABLE .. MODIFY
      sql/unireg.cc:
        Safety fix for ALTER TABLE .. MODIFY
      94d05b12
  20. 27 Jun, 2003 1 commit
    • unknown's avatar
      Added thread variable max_seeks_for_key · 8d224783
      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
      8d224783
  21. 04 Jun, 2003 1 commit
    • unknown's avatar
      Added SQLSTATE to client/server protocol · f2131b44
      unknown authored
      bmove_allign -> bmove_align
      Added OLAP function ROLLUP
      Split mysql_fix_privilege_tables to a script and a .sql data file
      Added new (MEMROOT*) functions to avoid calling current_thd() when creating some common objects.
      Added table_alias_charset, for easier --lower-case-table-name handling
      Better SQL_MODE handling (Setting complex options also sets sub options)
      New (faster) assembler string functions for x86
      
      
      BitKeeper/etc/ignore:
        added libmysqld/sql_state.c
      client/mysql.cc:
        Added SQLSTATE to error messages
        Added new function put_error() to be able to clean up some old code.
      client/mysqltest.c:
        Write ERROR SQLSTATE for all errors
      dbug/dbug.c:
        Portability fixes
      include/m_string.h:
        Rename bmove_allign as bmove_align
      include/mysql.h:
        Added SQLSTATE (for embedded version)
      include/mysql_com.h:
        Send correct SQLSTATE for the error to the client
      libmysql/libmysql.c:
        Changed default error state to HY000
        Applied code cleanup patch
      libmysqld/Makefile.am:
        Added sql_state.cc
      libmysqld/libmysqld.c:
        Added sqlstate
      mysql-test/r/analyse.result:
        Updated results
      mysql-test/r/ansi.result:
        Updated results
      mysql-test/r/auto_increment.result:
        Updated results
      mysql-test/r/bdb-deadlock.result:
        Updated results
      mysql-test/r/bdb.result:
        Updated results
      mysql-test/r/comments.result:
        Updated results
      mysql-test/r/create.result:
        Updated results
      mysql-test/r/ctype_collate.result:
        Updated results
      mysql-test/r/delayed.result:
        Updated results
      mysql-test/r/delete.result:
        Updated results
      mysql-test/r/derived.result:
        Updated results
      mysql-test/r/distinct.result:
        Updated results
      mysql-test/r/drop.result:
        Updated results
      mysql-test/r/err000001.result:
        Updated results
      mysql-test/r/explain.result:
        Updated results
      mysql-test/r/flush.result:
        Updated results
      mysql-test/r/fulltext.result:
        Updated results
      mysql-test/r/func_gconcat.result:
        Updated results
      mysql-test/r/func_system.result:
        Updated results
      mysql-test/r/grant_cache.result:
        Updated results
      mysql-test/r/group_by.result:
        Updated results
      mysql-test/r/handler.result:
        Updated results
      mysql-test/r/heap.result:
        Updated results
      mysql-test/r/heap_btree.result:
        Updated results
      mysql-test/r/heap_hash.result:
        Updated results
      mysql-test/r/innodb.result:
        Updated results
      mysql-test/r/innodb_handler.result:
        Updated results
      mysql-test/r/insert_select.result:
        Updated results
      mysql-test/r/insert_update.result:
        Updated results
      mysql-test/r/join.result:
        Updated results
      mysql-test/r/join_outer.result:
        Updated results
      mysql-test/r/key.result:
        Updated results
      mysql-test/r/lock.result:
        Updated results
      mysql-test/r/lock_multi.result:
        Updated results
      mysql-test/r/merge.result:
        Updated results
      mysql-test/r/multi_update.result:
        Updated results
      mysql-test/r/myisam.result:
        Updated results
      mysql-test/r/null.result:
        Updated results
      mysql-test/r/olap.result:
        Updated results
      mysql-test/r/order_by.result:
        Updated results
      mysql-test/r/packet.result:
        Updated results
      mysql-test/r/query_cache.result:
        Updated results
      mysql-test/r/row.result:
        Updated results
      mysql-test/r/rpl000001.result:
        Updated results
      mysql-test/r/rpl000009.result:
        Updated results
      mysql-test/r/rpl_empty_master_crash.result:
        Updated results
      mysql-test/r/rpl_log.result:
        Updated results
      mysql-test/r/rpl_replicate_do.result:
        Updated results
      mysql-test/r/rpl_rotate_logs.result:
        Updated results
      mysql-test/r/select.result:
        Updated results
      mysql-test/r/select_safe.result:
        Updated results
      mysql-test/r/show_check.result:
        Updated results
      mysql-test/r/sql_mode.result:
        Updated results
      mysql-test/r/subselect.result:
        Updated results
      mysql-test/r/temp_table.result:
        Updated results
      mysql-test/r/truncate.result:
        Updated results
      mysql-test/r/type_blob.result:
        Updated results
      mysql-test/r/type_decimal.result:
        Updated results
      mysql-test/r/type_float.result:
        Updated results
      mysql-test/r/type_ranges.result:
        Updated results
      mysql-test/r/union.result:
        Updated results
      mysql-test/r/update.result:
        Updated results
      mysql-test/r/user_var.result:
        Updated results
      mysql-test/r/varbinary.result:
        Updated results
      mysql-test/r/variables.result:
        Updated results
      mysql-test/t/ansi.test:
        Test of sql_mode
      mysql-test/t/derived.test:
        Updated results
      mysql-test/t/func_system.test:
        Make this independen of the MySQL server name
      mysql-test/t/lowercase_table.test:
        Cleanup
      mysql-test/t/olap.test:
        A lot of new tests
      mysql-test/t/sql_mode.test:
        More test for sql_mode
      mysql-test/t/subselect.test:
        Added a few new tests (to find a bug in the item_ref code)
      scripts/Makefile.am:
        Added mysql_fix_privilege_tables.sql
      scripts/mysql_fix_privilege_tables.sh:
        Totally new script.  This bascily just pipes mysql_fix_privilege_tables.sql through 'mysql' to 'mysqld'
      sql/Makefile.am:
        Added sql_state.cc
      sql/item.cc:
        Extended Item_field::eq() to be able to better match GROUP BY fields on the command line.
        Needed for ROLLUP
      sql/item.h:
        Added function to be able to avoid calling current_thd() when doing new Item.
      sql/item_sum.cc:
        Moved copy_or_same() and some reset() functions from item_sum.h
        Needed to be able to access thd->mem_root.
      sql/item_sum.h:
        Moved some functions to item_sum.cc
        Added make_unique() for ROLLUP
      sql/item_uniq.h:
        Fixed return value
      sql/mysql_priv.h:
        Updated MODE flags
      sql/mysqld.cc:
        Added ANSI as it's own mode
        Moved charset_info variables here
        Cleaned up handler_count handling (for NT)
        Added table_alias_charset, for easier --lower-case-table-name handling
      sql/net_serv.cc:
        New comment
      sql/protocol.cc:
        Send SQLSTATE to client
      sql/set_var.cc:
        Better SQL_MODE handling (Setting complex options also sets sub options)
      sql/set_var.h:
        Better SQL_MODE handling
      sql/sql_base.cc:
        Make alias depend on --lower-case-table-names
        Make find_item_in_list also check database name
      sql/sql_cache.cc:
        Indentation cleanup
      sql/sql_list.h:
        Added safety assert
        Addes support of alloc without current_thd()
      sql/sql_prepare.cc:
        Update after prototype change
      sql/sql_select.cc:
        Added ROLLUP
      sql/sql_select.h:
        structures for rollup
      sql/sql_show.cc:
        Easier SQL_MODE handling
      sql/sql_string.cc:
        Move CHARSET_INFO to mysqld (to be together with all other global variables)
      sql/sql_string.h:
        Added function to be able to avoid calling current_thd() when doing new Item.
      sql/sql_table.cc:
        Simpler --lower-case-table-name handling
      sql/sql_union.cc:
        Update after prototype change
      sql/sql_yacc.yy:
        ROLLUP
      sql/unireg.h:
        bmove_allign ->bmove_align
      strings/Makefile.am:
        Fix to be able to compile str_test.c
      strings/ctype.c:
        Removed empty lines
      strings/str_test.c:
        Added test of bmove_align
      strings/strings-x86.s:
        Faster bmove_align, bmove_upp and strmake
      strings/strings.asm:
        move_allg
      f2131b44
  22. 06 Feb, 2003 1 commit
    • unknown's avatar
      Added START TRANSACTION syntax · 37383bea
      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.
      37383bea
  23. 05 Jan, 2003 1 commit
    • unknown's avatar
      Changed mysql-test to print warnings for not existing table to DROP TABLE · bf4a5392
      unknown authored
      Cleaned up test; Removed wrong DROP TABLE commands and use standard table and database names.
      changed store_warning() -> push_warning_print()
      
      
      
      BitKeeper/deleted/.del-rpl000016-slave.opt~ef76f85ddcc13b87:
        Delete: mysql-test/t/rpl000016-slave.opt
      BitKeeper/deleted/.del-sel000001.test~9567c1646058cc:
        Delete: mysql-test/t/sel000001.test
      BitKeeper/deleted/.del-sel000002.test~9f500639572e18e1:
        Delete: mysql-test/t/sel000002.test
      BitKeeper/deleted/.del-sel000003.test~63a5512d18cd20a2:
        Delete: mysql-test/t/sel000003.test
      BitKeeper/deleted/.del-sel000001.result~383913ae4505ec86:
        Delete: mysql-test/r/sel000001.result
      BitKeeper/deleted/.del-sel000002.result~d1787e6fd5dbc1cc:
        Delete: mysql-test/r/sel000002.result
      BitKeeper/deleted/.del-sel000003.result~d7b657b1e3a286a7:
        Delete: mysql-test/r/sel000003.result
      BitKeeper/deleted/.del-sel000031.result~d49aeac63ad7db4d:
        Delete: mysql-test/r/sel000031.result
      BitKeeper/deleted/.del-sel000031.test~50a19a8e204e99bc:
        Delete: mysql-test/t/sel000031.test
      BitKeeper/deleted/.del-sel000032.result~6cb30e23cbca9fb0:
        Delete: mysql-test/r/sel000032.result
      BitKeeper/deleted/.del-sel000032.test~e32da7c3fc4b7ace:
        Delete: mysql-test/t/sel000032.test
      BitKeeper/deleted/.del-rpl000003.result~68d6ee00beaa011:
        Delete: mysql-test/r/rpl000003.result
      BitKeeper/deleted/.del-rpl000003.test~b7cfc4c5576fbafd:
        Delete: mysql-test/t/rpl000003.test
      client/mysql.cc:
        Don't yet print information about SQL help
      client/mysqltest.c:
        Added test options:
        --enable_warnings
        --disable_warnings
        --enable_info
        --disable_info
      configure.in:
        changed version number of shared libraries
      mysql-test/include/master-slave.inc:
        Don't write warnings on init
      mysql-test/r/backup.result:
        Updated results
      mysql-test/r/bdb.result:
        Updated results
      mysql-test/r/bigint.result:
        Updated results
      mysql-test/r/bool.result:
        Updated results
      mysql-test/r/create.result:
        Updated results
      mysql-test/r/delete.result:
        Updated results
      mysql-test/r/derived.result:
        Updated results
      mysql-test/r/distinct.result:
        Updated results
      mysql-test/r/drop.result:
        Updated results
      mysql-test/r/flush.result:
        Updated results
      mysql-test/r/fulltext.result:
        Updated results
      mysql-test/r/fulltext_multi.result:
        Updated results
      mysql-test/r/fulltext_order_by.result:
        Updated results
      mysql-test/r/func_equal.result:
        Updated results
      mysql-test/r/func_in.result:
        Updated results
      mysql-test/r/func_set.result:
        Updated results
      mysql-test/r/gcc296.result:
        Updated results
      mysql-test/r/group_by.result:
        Updated results
      mysql-test/r/innodb-deadlock.result:
        Updated results
      mysql-test/r/innodb.result:
        Updated results
      mysql-test/r/innodb_cache.result:
        Updated results
      mysql-test/r/innodb_handler.result:
        Updated results
      mysql-test/r/insert.result:
        Updated results
      mysql-test/r/insert_select.result:
        Updated results
      mysql-test/r/isam.result:
        Updated results
      mysql-test/r/join_outer.result:
        Updated results
      mysql-test/r/key.result:
        Updated results
      mysql-test/r/merge.result:
        Updated results
      mysql-test/r/multi_update.result:
        Updated results
      mysql-test/r/myisam.result:
        Updated results
      mysql-test/r/null.result:
        Updated results
      mysql-test/r/null_key.result:
        Updated results
      mysql-test/r/odbc.result:
        Updated results
      mysql-test/r/olap.result:
        Updated results
      mysql-test/r/order_by.result:
        Updated results
      mysql-test/r/query_cache.result:
        Updated results
      mysql-test/r/rename.result:
        Updated results
      mysql-test/r/row.result:
        Updated results
      mysql-test/r/rpl000001.result:
        Updated results
      mysql-test/r/rpl000002.result:
        Updated results
      mysql-test/r/rpl000004.result:
        Updated results
      mysql-test/r/rpl000005.result:
        Updated results
      mysql-test/r/rpl000006.result:
        Updated results
      mysql-test/r/rpl000008.result:
        Updated results
      mysql-test/r/rpl000009.result:
        Updated results
      mysql-test/r/rpl000010.result:
        Updated results
      mysql-test/r/rpl000011.result:
        Updated results
      mysql-test/r/rpl000012.result:
        Updated results
      mysql-test/r/rpl000013.result:
        Updated results
      mysql-test/r/rpl_alter.result:
        Updated results
      mysql-test/r/rpl_empty_master_crash.result:
        Updated results
      mysql-test/r/rpl_redirect.result:
        Updated results
      mysql-test/r/rpl_replicate_do.result:
        Updated results
      mysql-test/r/rpl_rotate_logs.result:
        Updated results
      mysql-test/r/rpl_skip_error.result:
        Updated results
      mysql-test/r/rpl_temporary.result:
        Updated results
      mysql-test/r/select.result:
        Updated results
      mysql-test/r/subselect.result:
        Updated results
      mysql-test/r/temp_table.result:
        Updated results
      mysql-test/r/type_date.result:
        Updated results
      mysql-test/r/type_float.result:
        Updated results
      mysql-test/r/union.result:
        Updated results
      mysql-test/r/update.result:
        Updated results
      mysql-test/r/user_var.result:
        Updated results
      mysql-test/r/varbinary.result:
        Updated results
      mysql-test/r/variables.result:
        Updated results
      mysql-test/r/warnings.result:
        Updated results
      mysql-test/t/alias.test:
        Don't write warnings when initializing test
      mysql-test/t/alter_table.test:
        Don't write warnings when initializing test
      mysql-test/t/analyse.test:
        Don't write warnings when initializing test
      mysql-test/t/auto_increment.test:
        Don't write warnings when initializing test
      mysql-test/t/backup.test:
        Don't write warnings when initializing test
      mysql-test/t/bdb-alter-table-1.test:
        Don't write warnings when initializing test
      mysql-test/t/bdb-crash.test:
        Don't write warnings when initializing test
      mysql-test/t/bdb-deadlock.test:
        Don't write warnings when initializing test
      mysql-test/t/bdb.test:
        Don't write warnings when initializing test
        cleaned up test
      mysql-test/t/bdb_cache.test:
        Don't write warnings when initializing test
      mysql-test/t/bench_count_distinct.test:
        Don't write warnings when initializing test
      mysql-test/t/bigint.test:
        Don't write warnings when initializing test
      mysql-test/t/binary.test:
        Don't write warnings when initializing test
      mysql-test/t/bool.test:
        Don't write warnings when initializing test
        Changed to use standard table names
      mysql-test/t/bulk_replace.test:
        Don't write warnings when initializing test
      mysql-test/t/case.test:
        Don't write warnings when initializing test
      mysql-test/t/check.test:
        Don't write warnings when initializing test
      mysql-test/t/compare.test:
        Don't write warnings when initializing test
      mysql-test/t/connect.test:
        Removed empty line
      mysql-test/t/constraints.test:
        Don't write warnings when initializing test
      mysql-test/t/count_distinct.test:
        Don't write warnings when initializing test
      mysql-test/t/count_distinct2.test:
        Don't write warnings when initializing test
      mysql-test/t/create.test:
        Don't write warnings when initializing test
        Cleaned up test
      mysql-test/t/ctype_latin1_de.test:
        Don't write warnings when initializing test
      mysql-test/t/ctype_many.test:
        Don't write warnings when initializing test
      mysql-test/t/delayed.test:
        Don't write warnings when initializing test
      mysql-test/t/delete.test:
        Don't write warnings when initializing test
        Cleaned up test
      mysql-test/t/derived.test:
        Don't write warnings when initializing test
        Cleaned up test
      mysql-test/t/dirty_close.test:
        Don't write warnings when initializing test
      mysql-test/t/distinct.test:
        Don't write warnings when initializing test
        Cleaned up test
      mysql-test/t/drop.test:
        Don't write warnings when initializing test
      mysql-test/t/empty_table.test:
        Don't write warnings when initializing test
      mysql-test/t/err000001.test:
        Don't write warnings when initializing test
        Cleaned up test
      mysql-test/t/explain.test:
        Don't write warnings when initializing test
      mysql-test/t/flush.test:
        Don't write warnings when initializing test
      mysql-test/t/foreign_key.test:
        Don't write warnings when initializing test
      mysql-test/t/fulltext.test:
        Don't write warnings when initializing test
      mysql-test/t/fulltext_cache.test:
        Don't write warnings when initializing test
      mysql-test/t/fulltext_distinct.test:
        Don't write warnings when initializing test
      mysql-test/t/fulltext_left_join.test:
        Don't write warnings when initializing test
      mysql-test/t/fulltext_multi.test:
        Don't write warnings when initializing test
      mysql-test/t/fulltext_order_by.test:
        Don't write warnings when initializing test
      mysql-test/t/fulltext_update.test:
        Don't write warnings when initializing test
      mysql-test/t/func_concat.test:
        Don't write warnings when initializing test
      mysql-test/t/func_date_add.test:
        Don't write warnings when initializing test
      mysql-test/t/func_encrypt.test:
        Don't write warnings when initializing test
      mysql-test/t/func_equal.test:
        Don't write warnings when initializing test
      mysql-test/t/func_group.test:
        Don't write warnings when initializing test
      mysql-test/t/func_if.test:
        Don't write warnings when initializing test
      mysql-test/t/func_in.test:
        Don't write warnings when initializing test
      mysql-test/t/func_isnull.test:
        Don't write warnings when initializing test
      mysql-test/t/func_like.test:
        Don't write warnings when initializing test
      mysql-test/t/func_regexp.test:
        Don't write warnings when initializing test
      mysql-test/t/func_set.test:
        Don't write warnings when initializing test
        Merged test with other tests
      mysql-test/t/func_str.test:
        Don't write warnings when initializing test
      mysql-test/t/func_time.test:
        Don't write warnings when initializing test
      mysql-test/t/func_timestamp.test:
        Don't write warnings when initializing test
      mysql-test/t/gcc296.test:
        Don't write warnings when initializing test
        Cleaned up test
      mysql-test/t/grant_cache.test:
        Don't write warnings when initializing test
      mysql-test/t/group_by.test:
        Don't write warnings when initializing test
        Cleaned up test
      mysql-test/t/handler.test:
        Don't write warnings when initializing test
      mysql-test/t/having.test:
        Don't write warnings when initializing test
      mysql-test/t/heap.test:
        Don't write warnings when initializing test
      mysql-test/t/heap_auto_increment.test:
        Don't write warnings when initializing test
      mysql-test/t/heap_btree.test:
        Don't write warnings when initializing test
      mysql-test/t/heap_hash.test:
        Don't write warnings when initializing test
      mysql-test/t/innodb-deadlock.test:
        Don't write warnings when initializing test
      mysql-test/t/innodb.test:
        Don't write warnings when initializing test
      mysql-test/t/innodb_cache.test:
        Don't write warnings when initializing test
      mysql-test/t/innodb_handler.test:
        Don't write warnings when initializing test
      mysql-test/t/ins000001.test:
        Don't write warnings when initializing test
      mysql-test/t/insert.test:
        Don't write warnings when initializing test
        cleaned up test.
        Changed to use standard database and table names
      mysql-test/t/insert_select.test:
        Don't write warnings when initializing test
        Changed to use standard table names
      mysql-test/t/insert_update.test:
        Don't write warnings when initializing test
      mysql-test/t/isam.test:
        Don't write warnings when initializing test
        cleaned up test
      mysql-test/t/join.test:
        Don't write warnings when initializing test
      mysql-test/t/join_crash.test:
        Don't write warnings when initializing test
      mysql-test/t/join_outer.test:
        Don't write warnings when initializing test
      mysql-test/t/key.test:
        Don't write warnings when initializing test
      mysql-test/t/key_diff.test:
        Don't write warnings when initializing test
      mysql-test/t/key_primary.test:
        Don't write warnings when initializing test
      mysql-test/t/keywords.test:
        Don't write warnings when initializing test
      mysql-test/t/kill.test:
        Don't write warnings when initializing test
      mysql-test/t/limit.test:
        Don't write warnings when initializing test
      mysql-test/t/lock.test:
        Don't write warnings when initializing test
      mysql-test/t/lock_multi.test:
        Don't write warnings when initializing test
      mysql-test/t/lowercase_table.test:
        Don't write warnings when initializing test
      mysql-test/t/merge.test:
        Don't write warnings when initializing test
        cleaned up test
      mysql-test/t/multi_update.test:
        Don't write warnings when initializing test
      mysql-test/t/myisam.test:
        Don't write warnings when initializing test
      mysql-test/t/null.test:
        Don't write warnings when initializing test
      mysql-test/t/null_key.test:
        Don't write warnings when initializing test
      mysql-test/t/odbc.test:
        Don't write warnings when initializing test
      mysql-test/t/olap.test:
        Don't write warnings when initializing test
      mysql-test/t/order_by.test:
        Don't write warnings when initializing test
      mysql-test/t/order_fill_sortbuf.test:
        Don't write warnings when initializing test
      mysql-test/t/query_cache.test:
        Don't write warnings when initializing test
      mysql-test/t/raid.test:
        Don't write warnings when initializing test
      mysql-test/t/range.test:
        Don't write warnings when initializing test
      mysql-test/t/rename.test:
        Don't write warnings when initializing test
      mysql-test/t/repair.test:
        Don't write warnings when initializing test
      mysql-test/t/replace.test:
        Don't write warnings when initializing test
      mysql-test/t/rollback.test:
        Don't write warnings when initializing test
      mysql-test/t/row.test:
        Don't write warnings when initializing test
      mysql-test/t/rpl000001.test:
        Don't write warnings when initializing test
      mysql-test/t/rpl000002.test:
        Don't write warnings when initializing test
      mysql-test/t/rpl000004.test:
        Don't write warnings when initializing test
      mysql-test/t/rpl000005.test:
        Don't write warnings when initializing test
      mysql-test/t/rpl000006.test:
        Don't write warnings when initializing test
      mysql-test/t/rpl000008-slave.opt:
        Don't write warnings when initializing test
      mysql-test/t/rpl000008.test:
        Don't write warnings when initializing test
      mysql-test/t/rpl000009-slave.opt:
        Don't write warnings when initializing test
      mysql-test/t/rpl000009.test:
        Don't write warnings when initializing test
      mysql-test/t/rpl000010.test:
        Don't write warnings when initializing test
      mysql-test/t/rpl000011.test:
        Don't write warnings when initializing test
      mysql-test/t/rpl000012.test:
        Don't write warnings when initializing test
      mysql-test/t/rpl000013.test:
        Don't write warnings when initializing test
      mysql-test/t/rpl000015.test:
        Don't write warnings when initializing test
      mysql-test/t/rpl000017.test:
        Don't write warnings when initializing test
      mysql-test/t/rpl000018.test:
        Don't write warnings when initializing test
      mysql-test/t/rpl_alter.test:
        Don't write warnings when initializing test
      mysql-test/t/rpl_empty_master_crash.test:
        Don't write warnings when initializing test
      mysql-test/t/rpl_redirect.test:
        Don't write warnings when initializing test
      mysql-test/t/rpl_replicate_do.test:
        Don't write warnings when initializing test
      mysql-test/t/rpl_rotate_logs.test:
        Don't write warnings when initializing test
      mysql-test/t/rpl_skip_error.test:
        Don't write warnings when initializing test
      mysql-test/t/rpl_temporary.test:
        Don't write warnings when initializing test
      mysql-test/t/sel000033.test:
        Don't write warnings when initializing test
      mysql-test/t/sel000100.test:
        Don't write warnings when initializing test
      mysql-test/t/select.test:
        Don't write warnings when initializing test
      mysql-test/t/select_found.test:
        Don't write warnings when initializing test
      mysql-test/t/select_safe.test:
        Don't write warnings when initializing test
      mysql-test/t/show_check.test:
        Don't write warnings when initializing test
      mysql-test/t/status.test:
        Don't write warnings when initializing test
      mysql-test/t/subselect.test:
        Don't write warnings when initializing test
      mysql-test/t/symlink.test:
        Don't write warnings when initializing test
      mysql-test/t/tablelock.test:
        Don't write warnings when initializing test
      mysql-test/t/temp_table.test:
        Don't write warnings when initializing test
      mysql-test/t/truncate.test:
        Don't write warnings when initializing test
      mysql-test/t/type_blob.test:
        Don't write warnings when initializing test
      mysql-test/t/type_date.test:
        Don't write warnings when initializing test
      mysql-test/t/type_datetime.test:
        Don't write warnings when initializing test
      mysql-test/t/type_decimal.test:
        Don't write warnings when initializing test
      mysql-test/t/type_enum.test:
        Don't write warnings when initializing test
      mysql-test/t/type_float.test:
        Don't write warnings when initializing test
      mysql-test/t/type_ranges.test:
        Don't write warnings when initializing test
      mysql-test/t/type_set.test:
        Don't write warnings when initializing test
      mysql-test/t/type_time.test:
        Don't write warnings when initializing test
      mysql-test/t/type_timestamp.test:
        Don't write warnings when initializing test
      mysql-test/t/type_uint.test:
        Don't write warnings when initializing test
      mysql-test/t/type_year.test:
        Don't write warnings when initializing test
      mysql-test/t/union.test:
        Don't write warnings when initializing test
      mysql-test/t/update.test:
        Don't write warnings when initializing test
      mysql-test/t/user_var.test:
        Don't write warnings when initializing test
      mysql-test/t/varbinary.test:
        Don't write warnings when initializing test
      mysql-test/t/variables.test:
        Don't write warnings when initializing test
      mysql-test/t/warnings.test:
        Don't write warnings when initializing test
      mysys/my_vsnprintf.c:
        Safety fix
      readline/terminal.c:
        Removed compiler warnings
      sql/ha_berkeley.cc:
        Indentation changes
      sql/mysql_priv.h:
        Change store_warning -> push_warning_printf
      sql/sql_db.cc:
        Change store_warning -> push_warning_printf
      sql/sql_error.cc:
        Change store_warning -> push_warning_printf
      sql/sql_table.cc:
        Change store_warning -> push_warning_printf
      bf4a5392
  24. 14 Dec, 2002 1 commit
    • unknown's avatar
      Transactions in AUTOCOMMIT=0 mode didn't rotate binary log · 3bf84777
      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
      3bf84777
  25. 07 Dec, 2002 1 commit
    • unknown's avatar
      bulk insert code optimized · f7604940
      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
      f7604940
  26. 06 Dec, 2002 1 commit
    • unknown's avatar
      After merge fixes · 8bc178a4
      unknown authored
      Added THD to add_to_xxx_list() functions for faster parsing.
      
      
      heap/_check.c:
        After merge fix
      mysql-test/r/distinct.result:
        After merge fix
      mysql-test/r/multi_update.result:
        Make timestamp test portable
      mysql-test/t/multi_update.test:
        Make timestamp test portable
      sql/field.cc:
        After merge fix
      sql/item_sum.cc:
        After merge fix
      sql/log_event.cc:
        Remove compiler warning
      sql/mysql_priv.h:
        Added THD to add_to_list (Faster parsing)
      sql/sql_derived.cc:
        Fixed parameters to create_tmp_table()
      sql/sql_lex.cc:
        Added THD to add_to_list (Faster parsing)
      sql/sql_lex.h:
        Added THD to add_to_list (Faster parsing)
      sql/sql_parse.cc:
        Added THD to add_to_list (Faster parsing)
      sql/sql_select.cc:
        After merge fixes
        Fixed return values from JOIN::optimize()
        Replaced test_function_query with '!tables_list'
        Optimized arguments to create_tmp_table()
      sql/sql_select.h:
        Removed test_function_query variable
        Updated prototypes
      sql/sql_union.cc:
        Updated argument lists.
      sql/sql_update.cc:
        After merge fixes
      sql/sql_yacc.yy:
        Added THD to all add_xxx_to_list() functions
      sql/table.h:
        After merge fix
      8bc178a4
  27. 03 Dec, 2002 1 commit
    • unknown's avatar
      Change of internal key_field=NULL handling to avoid error messages. · 47a3d6af
      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
      47a3d6af
  28. 29 Oct, 2002 1 commit
    • unknown's avatar
      Added --skip-safemalloc to mysqltest · eb1bbe1c
      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
      eb1bbe1c
  29. 14 Oct, 2002 1 commit
    • unknown's avatar
      Fixed a bug in key optimizing handling where the expression · f510752e
      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
      f510752e
  30. 03 Oct, 2002 1 commit
  31. 26 Sep, 2002 1 commit
    • unknown's avatar
      new EXPLAIN · 404e879b
      unknown authored
      fixed bug in mysql-test/create-test-result
      fixed bug in union-subselect engine
      
      
      mysql-test/create-test-result:
        fixed bug in reject file name assembling
      mysql-test/r/compare.result:
        new EXPLAIN
      mysql-test/r/create.result:
        new EXPLAIN
      mysql-test/r/distinct.result:
        new EXPLAIN
      mysql-test/r/explain.result:
        new EXPLAIN
      mysql-test/r/group_by.result:
        new EXPLAIN
      mysql-test/r/heap.result:
        new EXPLAIN
      mysql-test/r/heap_btree.result:
        new EXPLAIN
      mysql-test/r/heap_hash.result:
        new EXPLAIN
      mysql-test/r/innodb.result:
        new EXPLAIN
      mysql-test/r/join_outer.result:
        new EXPLAIN
      mysql-test/r/key_diff.result:
        new EXPLAIN
      mysql-test/r/key_primary.result:
        new EXPLAIN
      mysql-test/r/merge.result:
        new EXPLAIN
      mysql-test/r/myisam.result:
        new EXPLAIN
      mysql-test/r/null_key.result:
        new EXPLAIN
      mysql-test/r/odbc.result:
        new EXPLAIN
      mysql-test/r/order_by.result:
        new EXPLAIN
      mysql-test/r/range.result:
        new EXPLAIN
      mysql-test/r/select.result:
        new EXPLAIN
      mysql-test/r/subselect.result:
        new EXPLAIN
      mysql-test/r/type_datetime.result:
        new EXPLAIN
      mysql-test/r/union.result:
        new EXPLAIN
      mysql-test/r/user_var.result:
        new EXPLAIN
      mysql-test/r/varbinary.result:
        new EXPLAIN
      mysql-test/t/subselect.test:
        new EXPLAIN
      mysql-test/t/union.test:
        new EXPLAIN
      sql/mysql_priv.h:
        new EXPLAIN
      sql/sql_class.cc:
        new EXPLAIN
      sql/sql_class.h:
        new EXPLAIN
      sql/sql_derived.cc:
        new EXPLAIN
      sql/sql_lex.h:
        new EXPLAIN
      sql/sql_parse.cc:
        new EXPLAIN
      sql/sql_select.cc:
        new EXPLAIN
      sql/sql_union.cc:
        fixed bug in subselect-UNION engine
      sql/table.h:
        new EXPLAIN
      404e879b
  32. 10 Sep, 2002 1 commit
  33. 04 Sep, 2002 1 commit
  34. 03 Sep, 2002 4 commits
    • unknown's avatar
      a fix for a bug with all_fields.elements not being changed by · a08c9875
      unknown authored
      expansion of the wildcards
      
      a08c9875
    • unknown's avatar
      Fixed bug introduces by last changeset · 4b7b7a62
      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)
      4b7b7a62
    • unknown's avatar
      Some trivial optimzations · 9266dcd6
      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.
      9266dcd6
    • unknown's avatar
      subselect with union · c0c822d4
      unknown authored
      new error handling
      Item_ref bug fixed
      
      
      include/mysql_com.h:
        new error handling
        query cache pointer description
      mysql-test/r/distinct.result:
        new result's after Monty's bug fixing
      mysql-test/r/subselect.result:
        subselect with union test
      mysql-test/t/subselect.test:
        subselect with union test
      sql/item.cc:
        subselect with union
        Item_ref bug fixed
      sql/item_cmpfunc.cc:
        Monty's bug fixing
      sql/item_subselect.cc:
        TODO changing
        subselect with union
      sql/item_subselect.h:
        subselect with union
      sql/mysql_priv.h:
        Item_ref bug fixed
      sql/mysqld.cc:
        new error handling
      sql/net_pkg.cc:
        new error handling
      sql/net_serv.cc:
        new error handling
      sql/sql_base.cc:
        Item_ref bug fixed
      sql/sql_class.cc:
        new error handling
      sql/sql_class.h:
        new error handling
      sql/sql_derived.cc:
        subselect with union
      sql/sql_insert.cc:
        new error handling (only with mysql_select now)
      sql/sql_lex.cc:
        subselect with union
      sql/sql_lex.h:
        subselect with union
      sql/sql_parse.cc:
        new error handling
      sql/sql_select.cc:
        new error handling
        subselect with union
        removed thd->where=0 hack
      sql/sql_select.h:
        subselect with union
      sql/sql_union.cc:
        subselect with union
      sql/sql_update.cc:
        new error handling (only with mysql_select now)
      sql/sql_yacc.yy:
        subselect with union
      c0c822d4
  35. 16 Aug, 2002 1 commit
    • unknown's avatar
      Fixed bug in blocking handling when compiling with OPENSSL (caused hangup in client code) · 31065adc
      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
      31065adc
  36. 02 Mar, 2002 1 commit
    • unknown's avatar
      Fix sorting of NULL values (Should always be first) · 6cfc5e0e
      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.
      6cfc5e0e