1. 15 Mar, 2005 7 commits
    • unknown's avatar
      ndb - valgrind/compile fix Transporter.cpp: missing return · 8486e5f5
      unknown authored
      
      ndb/src/common/transporter/Transporter.cpp:
        missing return
      8486e5f5
    • unknown's avatar
      Merge pgalbraith@bk-internal.mysql.com:/home/bk/mysql-5.0 · 8d435091
      unknown authored
      into krsna.:/home/patg/test/mysql-5.0
      
      
      BitKeeper/etc/logging_ok:
        auto-union
      8d435091
    • unknown's avatar
      This changeset contains changes approved in code review by · b45de257
      unknown authored
      Konstja and Georg, change sets 1.1806, 1.1805. These changes has been successfully 
      tested on both my own workstation (Suse 9.0) and production.mysql.com.
      
      
      mysql-test/r/federated.result:
        new test results for error handling tests.
      mysql-test/t/federated.test:
        new error handling tests
      sql/ha_federated.cc:
        - check_foreign_data source added
        - table names now enclosed in '`' to allow for '%' or other characters
        - better error handling
        - mysql_init now checked to see if it returns true/false, error out if false (Georg)
      BitKeeper/etc/logging_ok:
        Logging to logging@openlogging.org accepted
      b45de257
    • unknown's avatar
      Updated tests results for BUG#8510 · 2c07de6b
      unknown authored
      2c07de6b
    • unknown's avatar
      Merge mysql.com:/home/psergey/mysql-4.1-bug8510 · c6225d95
      unknown authored
      into mysql.com:/home/psergey/mysql-5.0-bug8510
      
      
      mysql-test/r/ansi.result:
        Auto merged
      sql/set_var.cc:
        Auto merged
      c6225d95
    • unknown's avatar
      Merge spetrunia@bk-internal.mysql.com:/home/bk/mysql-4.1 · 76caf793
      unknown authored
      into mysql.com:/home/psergey/mysql-4.1-bug8510
      
      
      sql/set_var.cc:
        Auto merged
      76caf793
    • unknown's avatar
      WL#926 "AVG(DISTINCT) and other distincts", part 2 (out of 3): clean up · 97816c1f
      unknown authored
      Item_sum_count_distinct, and
      deploy Unique for use with COUNT(DISTINCT) if there is no blob
      column in the list of DISTINCT arguments.
      
      
      mysql-test/r/count_distinct2.result:
        Test results fixed.
      mysql-test/r/func_group.result:
        Updated.
      mysql-test/r/sum_distinct.result:
        Updated.
      mysql-test/t/func_group.test:
        Add a test for COUNT(DISTINCT) and true varchar and case-insensitive
        collation. The table in the test contains only two distinct values.
      mysql-test/t/sum_distinct.test:
        Since now we support INSERT INTO t1 (a) SELECT a+1 FROM t1, shorten
        the test.
        Add a nominal test for AVG(DISTINCT)
      sql/item_sum.cc:
        Implementation of cleaned up Item_sum_count_distinct.
        Fixed a bug with COUNT(DISTINCT) and new VARCHAR and collations.
        Fixed a bug wiht AVG(DISTINCT) and wrong number of output digits
        after decimal point.
      sql/item_sum.h:
        Cleanup for Item_sum_count_distinct.
        Now if the list of distinct arguments doesn't contain a blob column,
        we always use Unique and merge-sort to find distinct values.
      sql/sql_class.h:
        Added a short-cut to find number of elements in Unique if all elements fit
        into memory.
      97816c1f
  2. 14 Mar, 2005 17 commits
  3. 13 Mar, 2005 11 commits
    • unknown's avatar
      Item_func_isnotnull::not_null_tables - return 0 if not top-level item · d2c943b0
      unknown authored
      
      mysql-test/r/join_outer.result:
        test for some obscure usage of IS NOT NULL
      mysql-test/t/join_outer.test:
        test for some obscure usage of IS NOT NULL
      d2c943b0
    • unknown's avatar
      Merge bk-internal.mysql.com:/home/bk/mysql-5.0 · a67e6d53
      unknown authored
      into mysql.com:/media/sda1/mysql/mysql-5.0-926
      
      a67e6d53
    • unknown's avatar
      print xa recovery progress · c99dfbd8
      unknown authored
      add names to handlertons
      trans_need_2pc() macro
      
      
      sql/examples/ha_archive.cc:
        add names to handlertons
      sql/ha_berkeley.cc:
        add names to handlertons
      sql/ha_innodb.cc:
        add names to handlertons
      sql/ha_ndbcluster.cc:
        add names to handlertons
      sql/handler.cc:
        print xa recovery progress
      sql/handler.h:
        add names to handlertons
        trans_need_2pc() macro
      sql/log.cc:
        add names to handlertons
      c99dfbd8
    • unknown's avatar
      Merge bk-internal.mysql.com:/home/bk/mysql-5.0 · c9796185
      unknown authored
      into mysql.com:/media/sda1/mysql/mysql-5.0-926
      
      
      sql/field.cc:
        Auto merged
      sql/item.cc:
        Auto merged
      sql/sql_select.cc:
        Auto merged
      c9796185
    • unknown's avatar
      WL#926 "SUM(DISTINCT) and AVG(DISTINCT)": improvement of SUM(DISTINCT) and · 56012000
      unknown authored
       implementation of AVG(DISTINCT) which utilizes the approach with Fields.
      The patch implemented in October is portede to the up-to-date tree 
      containing DECIMAL type.
      Tests for AVG(DISTINCT) (although there is not much to test provided
      that SUM(DISTINCT) works), cleanups for COUNT(DISTINCT) and GROUP_CONCAT()
      will follow in another changeset.
      
      
      sql/field.cc:
        A handy way to init create_field used for use with virtual tmp tables.
        Feel free to extend it for your own needs.
      sql/field.h:
        Declaration for create_field::init_for_tmp_table()
      sql/item.cc:
        Implementation for a framework used to easily handle different result
        types of SQL expressions. Instead of having instances of each possible 
        result type (integer, decimal, double) in every item, variables
        of all used types are moved to struct Hybrid_type.
        Hybrid_type can change its dynamic type in runtime, and become,
        for instance, DECIMAL from INTEGER.
        All type-specific Item operations are moved to the class hierarchy
        Hybrid_type_traits. Item::decimals and Item::max_length can
        be moved to Hybrid_type as well.
      sql/item.h:
        Declaration for Hybrid_type framework. See also comments for item.cc
        in this changeset.
      sql/item_sum.cc:
        Rewritten implementation for Item_sum_sum_distinct (SUM(DISTINCT))
        and added implementation for Item_sum_avg_distinct (AVG(DISTINCT)).
        The classes utilize Hybrid_type class hierarchy and Fields to
        convert SUM/AVG arguments to binary representation and store in a RB-tree.
      sql/item_sum.h:
        Declarations for Item_sum_distinct (the new intermediate class used
        for SUM and AVG distinct), Item_sum_sum_distinct, Item_sum_avg_distinct.
      sql/sql_select.cc:
        Implementatio of create_virtual_tmp_table().
      sql/sql_select.h:
        Declaration for create_virtual_tmp_table.
      sql/sql_yacc.yy:
        Grammar support for Item_sum_avg_distinct.
      56012000
    • unknown's avatar
      row0mysql.c: · b47ac187
      unknown authored
        Correct web links
      fil0fil.c:
        Correct (?) English grammar
      
      
      innobase/fil/fil0fil.c:
        Correct (?) English grammar
      innobase/row/row0mysql.c:
        Correct web links
      b47ac187
    • unknown's avatar
      correct not_null_tables() for XOR and AND · 416f0686
      unknown authored
      correct top_level_item for XOR
      
      
      mysql-test/r/join_outer.result:
        one more test
      mysql-test/t/join_outer.test:
        one more test
      416f0686
    • unknown's avatar
      set_var.cc, mysqld.cc, ha_innodb.cc, sql_class.h: · 7f6658db
      unknown authored
        Add a settable session variable innodb_support_xa; setting it to 0 can save up to 10 % of CPU time and 150 bytes of space in each undo log
      trx0trx.h, trx0undo.c, trx0trx.c, trx0roll.c:
        Enable XA if innodb_support_xa is not set to 0; make prepare to do log fsync's according to innodb_flush_log_at_trx_commit
      
      
      innobase/trx/trx0roll.c:
        Enable XA if innodb_support_xa is not set to 0; make prepare to do log fsync's according to innodb_flush_log_at_trx_commit
      innobase/trx/trx0trx.c:
        Enable XA if innodb_support_xa is not set to 0; make prepare to do log fsync's according to innodb_flush_log_at_trx_commit
      innobase/trx/trx0undo.c:
        Enable XA if innodb_support_xa is not set to 0; make prepare to do log fsync's according to innodb_flush_log_at_trx_commit
      innobase/include/trx0trx.h:
        Enable XA if innodb_support_xa is not set to 0; make prepare to do log fsync's according to innodb_flush_log_at_trx_commit
      sql/sql_class.h:
        Add a settable session variable innodb_support_xa; setting it to 0 can save up to 10 % of CPU time and 150 bytes of space in each undo log
      sql/ha_innodb.cc:
        Add a settable session variable innodb_support_xa; setting it to 0 can save up to 10 % of CPU time and 150 bytes of space in each undo log
      sql/mysqld.cc:
        Add a settable session variable innodb_support_xa; setting it to 0 can save up to 10 % of CPU time and 150 bytes of space in each undo log
      sql/set_var.cc:
        Add a settable session variable innodb_support_xa; setting it to 0 can save up to 10 % of CPU time and 150 bytes of space in each undo log
      7f6658db
    • unknown's avatar
      join_outer.test: · d83bb4ed
      unknown authored
        Correction after manual merge.
      
      
      mysql-test/t/join_outer.test:
        Correction after manual merge.
      d83bb4ed
    • unknown's avatar
      Manual merge · 9c892564
      unknown authored
      
      sql/item_cmpfunc.h:
        Auto merged
      9c892564
    • unknown's avatar
      join_outer.result, join_outer.test: · 017f7897
      unknown authored
        Added a test case for bug #9017.
      item_cmpfunc.h:
        A wrong not_null_tables method for Item_cond_xor
        caused a conversion of a left join into an inner join
        that was not valid.
      
      
      sql/item_cmpfunc.h:
        A wrong not_null_tables method for Item_cond_xor
        caused a conversion of a left join into an inner join
        that was not valid.
      mysql-test/t/join_outer.test:
        Added a test case for bug #9017.
      mysql-test/r/join_outer.result:
        Added a test case for bug #9017.
      017f7897
  4. 12 Mar, 2005 2 commits
    • unknown's avatar
      Merge bk-internal:/home/bk/mysql-5.0 · a598ceaf
      unknown authored
      into serg.mylan:/usr/home/serg/Abk/mysql-5.0
      
      
      sql/mysql_priv.h:
        Auto merged
      a598ceaf
    • unknown's avatar
      if no xa recovery (or after it): · 40beb7cd
      unknown authored
        warning on startup if prepared foreign xids
        error on startup if prepared our xids
        temporarily: always rollback prepared our xids instead of an error
      
      
      sql/mysql_priv.h:
        opt_tc_log_file made extern
      sql/mysqld.cc:
        opt_tc_log_file made extern
        always call ha_recover() even if no previous crash was detected
      40beb7cd
  5. 11 Mar, 2005 3 commits
    • unknown's avatar
      Update tests and test results after merge, disable broken NDB tests · 79ccef07
      unknown authored
      
      mysql-test/r/information_schema.result:
        Update test result
      mysql-test/r/query_cache.result:
        Reset query_cache_type for test
      mysql-test/t/query_cache.test:
        Update test result
      mysql-test/t/ndb_alter_table.disabled:
        ***MISSING WEAVE***
      mysql-test/t/ndb_autodiscover.disabled:
        ***MISSING WEAVE***
      mysql-test/t/ndb_autodiscover2.disabled:
        ***MISSING WEAVE***
      mysql-test/t/ndb_cache_multi.disabled:
        ***MISSING WEAVE***
      mysql-test/t/ndb_cache_multi2.disabled:
        ***MISSING WEAVE***
      mysql-test/t/ndb_multi.disabled:
        ***MISSING WEAVE***
      mysql-test/t/ndb_restore.disabled:
        ***MISSING WEAVE***
      79ccef07
    • unknown's avatar
      Merge bk-internal:/home/bk/mysql-5.0 · 7425503c
      unknown authored
      into mysql.com:/home/jimw/my/mysql-5.0-clean
      
      
      mysql-test/r/join_outer.result:
        Auto merged
      mysql-test/t/join_outer.test:
        Auto merged
      sql/item_cmpfunc.h:
        Auto merged
      7425503c
    • unknown's avatar
      Merge mysql.com:/home/jimw/my/mysql-5.0-8902 · 0104e6cb
      unknown authored
      into mysql.com:/home/jimw/my/mysql-5.0-clean
      
      
      sql/mysql_priv.h:
        Auto merged
      0104e6cb