1. 14 Mar, 2005 7 commits
  2. 13 Mar, 2005 10 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
      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
    • unknown's avatar
      join_outer.test: · dad8e1f5
      unknown authored
        Correction after manual merge.
      
      
      mysql-test/t/join_outer.test:
        Correction after manual merge.
      dad8e1f5
    • unknown's avatar
      Manual merge · 7bf4a418
      unknown authored
      
      sql/item_cmpfunc.h:
        Auto merged
      7bf4a418
    • unknown's avatar
      join_outer.result, join_outer.test: · 7cecea52
      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.
      7cecea52
  3. 12 Mar, 2005 2 commits
    • unknown's avatar
      Merge bk-internal:/home/bk/mysql-5.0 · deabb450
      unknown authored
      into serg.mylan:/usr/home/serg/Abk/mysql-5.0
      
      
      sql/mysql_priv.h:
        Auto merged
      deabb450
    • unknown's avatar
      if no xa recovery (or after it): · 6b98e786
      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
      6b98e786
  4. 11 Mar, 2005 17 commits
  5. 10 Mar, 2005 4 commits
    • unknown's avatar
      Merge mysql.com:/home/psergey/mysql-4.1-bug8711 · 324a5668
      unknown authored
      into mysql.com:/home/psergey/mysql-5.0-bug8711
      
      
      mysql-test/r/join_outer.result:
        Auto merged
      mysql-test/t/join_outer.test:
        Auto merged
      sql/item_cmpfunc.h:
        Auto merged
      324a5668
    • unknown's avatar
      Merge · ff2fcba3
      unknown authored
      
      sql/item_cmpfunc.h:
        Auto merged
      mysql-test/r/join_outer.result:
        SCCS merged
      mysql-test/t/join_outer.test:
        SCCS merged
      ff2fcba3
    • unknown's avatar
      Fix for BUG#8711: "<=>" may have true value for NULL arguments, so make · 7c90fa7b
      unknown authored
      Item_func_equal::not_null_tables() always return 0.
      
      
      mysql-test/r/join_outer.result:
        Testcase for BUG#8711
      mysql-test/t/join_outer.test:
        Testcase for BUG#8711
      sql/item_cmpfunc.h:
        Fix for BUG#8711: "<=>" may have true value for NULL arguments, i.e. it can accept NULL-complemented 
        table rows. This differs from assumptions made in Item_func::not_null_tables(), so add 
        Item_func_equal::not_null_tables().
        Item_func_equal::not_null_tables_cache value doesn't make sense now, but we still let it be
        calculated (and ignore it)
      7c90fa7b
    • unknown's avatar
      Correct "make_win_src_distribution" to not introduce additional directory layers, · 33f9d926
      unknown authored
      adapt the Windows build files accordingly.
      
      
      VC++Files/tests/mysql_client_test.dsp:
        As the directory structure on Windows now resembles that on Unix (no more
        "tests/tests", by the correction in "make_win_src_distribution.sh"), the location
        of "mysql_client_test.*" has changed. Adapt the build tools accordingly.
      VC++Files/tests/mysql_client_test_ia64.dsp:
        As the directory structure on Windows now resembles that on Unix (no more
        "tests/tests", by the correction in "make_win_src_distribution.sh"), the location
        of "mysql_client_test.*" has changed. Adapt the build tools accordingly.
      scripts/make_win_src_distribution.sh:
        1) The semantics of "cp -R src targ" depend on the (non)existence of "targ".
        By simply doing "$CP -R $i $BASE/$i", the directory hierarchy below $BASE differed
        from the source for each "$i" that already existed as a target directory.
        This is now prevented by checking the existence and adapting the command.
        
        2) Comment where "$BASE" (the target directory) comes into existence.
        
        3) Introduce an "abort" function as a start point for more sanity checks, use it.
      33f9d926