1. 15 Mar, 2005 14 commits
    • unknown's avatar
      dict0load.c: · 45ab7747
      unknown authored
        dict_load_table(): Remove unused label that was accidentally introduced
        in a 4.0->4.1->5.0 merge.
      
      
      innobase/dict/dict0load.c:
        dict_load_table(): Remove unused label that was accidentally introduced
        in a 4.0->4.1->5.0 merge.
      45ab7747
    • unknown's avatar
      After merge fixes · 60032843
      unknown authored
      
      BitKeeper/etc/logging_ok:
        auto-union
      innobase/buf/buf0flu.c:
        Manual merge
      innobase/dict/dict0load.c:
        Manual merge: do not refuse to open ROW_FORMAT=COMPACT tables
      60032843
    • unknown's avatar
      Merge hundin.mysql.fi:/home/marko/k/mysql-4.0 · 3915c964
      unknown authored
      into hundin.mysql.fi:/home/marko/mysql-4.1
      
      
      innobase/dict/dict0load.c:
        SCCS merged
      3915c964
    • 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
      buf0flu.c: · adcbc0b2
      unknown authored
        Add diagnostics to track why ut_a(block->state == BUF_BLOCK_FILE_PAGE) failed in buf_flush_ready_for_replace() for a user
      
      
      innobase/buf/buf0flu.c:
        Add diagnostics to track why ut_a(block->state == BUF_BLOCK_FILE_PAGE) failed in buf_flush_ready_for_replace() for a user
      adcbc0b2
    • unknown's avatar
      Merge spetrunia@bk-internal.mysql.com:/home/bk/mysql-4.1 · a8581b77
      unknown authored
      into mysql.com:/home/psergey/mysql-4.1-bug8510
      
      a8581b77
    • 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 paul@bk-internal.mysql.com:/home/bk/mysql-4.1 · e6a239cf
      unknown authored
      into snake-hub.snake.net:/src/extern/MySQL/bk/mysql-4.1
      
      e6a239cf
    • unknown's avatar
      Merge snake-hub.snake.net:/src/extern/MySQL/bk/mysql-4.0 · d3441b78
      unknown authored
      into snake-hub.snake.net:/src/extern/MySQL/bk/merge-4.1
      
      
      BitKeeper/etc/logging_ok:
        auto-union
      d3441b78
    • unknown's avatar
      mysql.1.in: · 49f27976
      unknown authored
        Fix path that needs no parameterization.
      
      
      man/mysql.1.in:
        Fix path that needs no parameterization.
      BitKeeper/etc/logging_ok:
        Logging to logging@openlogging.org accepted
      49f27976
    • 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 18 commits
  3. 13 Mar, 2005 8 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