1. 15 Mar, 2005 14 commits
    • unknown's avatar
      dict0load.c: · 7d638314
      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.
      7d638314
    • unknown's avatar
      After merge fixes · 50a6be7d
      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
      50a6be7d
    • unknown's avatar
      Merge hundin.mysql.fi:/home/marko/k/mysql-4.0 · bcabdc22
      unknown authored
      into hundin.mysql.fi:/home/marko/mysql-4.1
      
      
      innobase/dict/dict0load.c:
        SCCS merged
      bcabdc22
    • unknown's avatar
      Merge pgalbraith@bk-internal.mysql.com:/home/bk/mysql-5.0 · 01df5a15
      unknown authored
      into krsna.:/home/patg/test/mysql-5.0
      
      
      BitKeeper/etc/logging_ok:
        auto-union
      01df5a15
    • unknown's avatar
      This changeset contains changes approved in code review by · 2b1a8acd
      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
      2b1a8acd
    • unknown's avatar
      Updated tests results for BUG#8510 · 1defb94d
      unknown authored
      1defb94d
    • unknown's avatar
      buf0flu.c: · f5688932
      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
      f5688932
    • unknown's avatar
      Merge spetrunia@bk-internal.mysql.com:/home/bk/mysql-4.1 · 7e517f73
      unknown authored
      into mysql.com:/home/psergey/mysql-4.1-bug8510
      
      
      7e517f73
    • unknown's avatar
      Merge mysql.com:/home/psergey/mysql-4.1-bug8510 · 54baac55
      unknown authored
      into mysql.com:/home/psergey/mysql-5.0-bug8510
      
      
      mysql-test/r/ansi.result:
        Auto merged
      sql/set_var.cc:
        Auto merged
      54baac55
    • unknown's avatar
      Merge paul@bk-internal.mysql.com:/home/bk/mysql-4.1 · 786b52e1
      unknown authored
      into snake-hub.snake.net:/src/extern/MySQL/bk/mysql-4.1
      
      
      786b52e1
    • unknown's avatar
      Merge snake-hub.snake.net:/src/extern/MySQL/bk/mysql-4.0 · 62ce8731
      unknown authored
      into snake-hub.snake.net:/src/extern/MySQL/bk/merge-4.1
      
      
      BitKeeper/etc/logging_ok:
        auto-union
      62ce8731
    • unknown's avatar
      mysql.1.in: · 6d0ec316
      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
      6d0ec316
    • unknown's avatar
      Merge spetrunia@bk-internal.mysql.com:/home/bk/mysql-4.1 · 155cfb39
      unknown authored
      into mysql.com:/home/psergey/mysql-4.1-bug8510
      
      
      sql/set_var.cc:
        Auto merged
      155cfb39
    • unknown's avatar
      WL#926 "AVG(DISTINCT) and other distincts", part 2 (out of 3): clean up · 897849e5
      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.
      897849e5
  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 · 7a105aff
      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
      7a105aff
    • unknown's avatar
      Merge bk-internal.mysql.com:/home/bk/mysql-5.0 · 2a0b2e93
      unknown authored
      into mysql.com:/media/sda1/mysql/mysql-5.0-926
      
      
      2a0b2e93
    • unknown's avatar
      print xa recovery progress · ec372b09
      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
      ec372b09
    • unknown's avatar
      Merge bk-internal.mysql.com:/home/bk/mysql-5.0 · 7652a389
      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
      7652a389
    • unknown's avatar
      WL#926 "SUM(DISTINCT) and AVG(DISTINCT)": improvement of SUM(DISTINCT) and · 1534ed8e
      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.
      1534ed8e
    • unknown's avatar
      row0mysql.c: · 53ffcff7
      unknown authored
        Correct web links
      fil0fil.c:
        Correct (?) English grammar
      
      
      innobase/fil/fil0fil.c:
        Correct (?) English grammar
      innobase/row/row0mysql.c:
        Correct web links
      53ffcff7
    • unknown's avatar
      correct not_null_tables() for XOR and AND · 2427f369
      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
      2427f369
    • unknown's avatar
      set_var.cc, mysqld.cc, ha_innodb.cc, sql_class.h: · a569b083
      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
      a569b083