1. 18 Jul, 2007 5 commits
  2. 17 Jul, 2007 4 commits
  3. 15 Jul, 2007 4 commits
    • unknown's avatar
      item_cmpfunc.cc: · d1dd69f5
      unknown authored
        A typo fixed.
      
      
      sql/item_cmpfunc.cc:
        A typo fixed.
      d1dd69f5
    • unknown's avatar
      item_cmpfunc.cc: · cb6cac53
      unknown authored
        Fixed compiler warning.
      
      
      sql/item_cmpfunc.cc:
        Fixed compiler warning.
      cb6cac53
    • unknown's avatar
      item_cmpfunc.cc: · 5f2a94b8
      unknown authored
        A comment changed.
      
      
      sql/item_cmpfunc.cc:
        A comment changed.
      5f2a94b8
    • unknown's avatar
      Extended fix for the bug#29555. · 376073e1
      unknown authored
      The get_time_value function is added. It is used to obtain TIME values both
      from items the can return time as an integer and from items that can return
      time only as a string.
      The Arg_comparator::compare_datetime function now uses pointer to a getter
      function to obtain values to compare. Now this function is also used for
      comparison of TIME values.
      The get_value_func variable is added to the Arg_comparator class.
      It points to a getter function for the DATE/DATETIME/TIME comparator.
      
      
      mysql-test/t/type_time.test:
        Extended test case for the bug#29555.
      mysql-test/r/type_time.result:
        Extended test case for the bug#29555.
      sql/item_cmpfunc.cc:
        Extended fix for the bug#29555.
        The get_time_value function is added. It is used to obtain TIME values both
        from items the can return time as an integer and from items that can return
        time only as a string.
        The Arg_comparator::compare_datetime function now uses pointer to a getter
        function to obtain values to compare. Now this function is also used for
        comparison of TIME values.
      sql/item_cmpfunc.h:
        Extended fix for the bug#29555.
        The get_value_func variable is added to the Arg_comparator class.
        It points to a getter function for the DATE/DATETIME/TIME comparator.
      376073e1
  4. 14 Jul, 2007 6 commits
  5. 13 Jul, 2007 8 commits
    • unknown's avatar
      symlink.test, symlink.result: · edef3795
      unknown authored
        Minor fix for test case of bug #29325 to make emb test happy.
      
      
      mysql-test/t/symlink.test:
        Minor fix for test case of bug #29325 to make emb test happy.
      mysql-test/r/symlink.result:
        Minor fix for test case of bug #29325 to make emb test happy.
      edef3795
    • unknown's avatar
      Merge gleb.loc:/home/uchum/work/bk/5.0-opt · 14310708
      unknown authored
      into  gleb.loc:/home/uchum/work/bk/5.1-opt
      
      14310708
    • unknown's avatar
      Merge gleb.loc:/home/uchum/work/bk/5.1 · e7b2cdd9
      unknown authored
      into  gleb.loc:/home/uchum/work/bk/5.1-opt
      
      
      sql/sql_class.h:
        Auto merged
      e7b2cdd9
    • unknown's avatar
      Merge gleb.loc:/home/uchum/work/bk/5.0 · 2ea76c25
      unknown authored
      into  gleb.loc:/home/uchum/work/bk/5.0-opt
      
      2ea76c25
    • unknown's avatar
      BUG#29740: Wrong query results for index_merge/union over HEAP table. · 169549d1
      unknown authored
      - return HA_KEY_SCAN_NOT_ROR flag for HASH indexes;
      - Fix ha_heap::cmp_ref() to work with BTREE index scans.
      
      
      mysql-test/r/index_merge.result:
        BUG#29740: testcase
      mysql-test/t/index_merge.test:
        BUG#29740: testcase
      sql/ha_heap.h:
        BUG#29740: Wrong query results for index_merge/union over HEAP table.
        - make HEAP table engine return HA_KEY_SCAN_NOT_ROR flag for HASH 
          indexes,as HASH index does not guarantee any ordering for rows
          within the hash bucket.
        - Fix BTREE indexes: make ha_heap::cmp_ref() compare the rowids in the 
          same way as ha_key_cmp() does.
      sql/opt_range.cc:
        BUG#29740: Fix comment about ROR scans.
      169549d1
    • unknown's avatar
      Merge gleb.loc:/home/uchum/work/bk/5.0-opt · 0ed4d7e8
      unknown authored
      into  gleb.loc:/home/uchum/work/bk/5.1-opt
      
      
      mysql-test/r/create_not_windows.result:
        Auto merged
      mysql-test/r/join_nested.result:
        Auto merged
      mysql-test/r/symlink.result:
        Auto merged
      mysql-test/r/type_ranges.result:
        Auto merged
      mysql-test/r/type_time.result:
        Auto merged
      mysql-test/t/create.test:
        Auto merged
      mysql-test/t/create_not_windows.test:
        Auto merged
      mysql-test/t/symlink.test:
        Auto merged
      sql/item_cmpfunc.cc:
        Auto merged
      sql/sql_select.cc:
        Auto merged
      mysql-test/r/create.result:
        Merge with 5.0-opt.
      mysql-test/r/type_enum.result:
        Merge with 5.0-opt.
      mysql-test/t/type_enum.test:
        Merge with 5.0-opt.
      sql/field_conv.cc:
        Merge with 5.0-opt.
      0ed4d7e8
    • unknown's avatar
      539ce171
    • unknown's avatar
      ca480ad5
  6. 12 Jul, 2007 4 commits
    • unknown's avatar
      Bug#29739: Incorrect time comparison in BETWEEN. · 793e4442
      unknown authored
      Time values were compared by the BETWEEN function as strings. This led to a
      wrong result in cases when some of arguments are less than 100 hours and other
      are greater.
      
      Now if all 3 arguments of the BETWEEN function are of the TIME type then
      they are compared as integers.
      
      
      mysql-test/t/type_time.test:
        Added a tes tcase for the bug#29739: Incorrect time comparison in BETWEEN.
      mysql-test/r/type_time.result:
        Added a tes tcase for the bug#29739: Incorrect time comparison in BETWEEN.
      sql/item_cmpfunc.cc:
        Bug#29739: Incorrect time comparison in BETWEEN.
        Now if all 3 arguments of the BETWEEN function are of the TIME type then
        they are compared as integers.
      793e4442
    • unknown's avatar
      e4d6b9e5
    • unknown's avatar
      Merge olga.mysql.com:/home/igor/mysql-5.0-opt · eaba3341
      unknown authored
      into  olga.mysql.com:/home/igor/dev-opt/mysql-5.0-opt-bug29604
      
      eaba3341
    • unknown's avatar
      Fixed bug #29604. · 07c0e6af
      unknown authored
      A bug in the restore_prev_nj_state function allowed interleaving 
      inner tables of outer join operations with outer tables. With the
      current implementation of the nested loops algorithm it could lead
      to wrong result sets for queries with nested outer joins.
      Another bug in this procedure effectively blocked evaluation of some
      valid execution plans for queries with nested outer joins. 
      
      
      mysql-test/r/join_nested.result:
        Added a test case for bug #29604.
      mysql-test/t/join_nested.test:
        Added a test case for bug #29604.
      07c0e6af
  7. 11 Jul, 2007 9 commits
    • unknown's avatar
      Merge spetrunia@bk-internal.mysql.com:/home/bk/mysql-5.1-opt · 8b55336f
      unknown authored
      into  mysql.com:/home/psergey/mysql-5.1-bug29610
      
      8b55336f
    • unknown's avatar
      Merge gshchepa@bk-internal.mysql.com:/home/bk/mysql-5.0-opt · 4e98d043
      unknown authored
      into  gleb.loc:/home/uchum/work/bk/5.0-opt
      
      4e98d043
    • unknown's avatar
      Merge gleb.loc:/home/uchum/work/bk/5.0-opt · 3cc4928f
      unknown authored
      into  gleb.loc:/home/uchum/work/bk/5.0-opt-29360
      
      3cc4928f
    • unknown's avatar
      field_conv.cc: · 0d4add75
      unknown authored
        Additional fix for bug #29360.
      
      
      sql/field_conv.cc:
        Additional fix for bug #29360.
      0d4add75
    • unknown's avatar
      Merge epotemkin@bk-internal.mysql.com:/home/bk/mysql-5.0-opt · c6b64d5c
      unknown authored
      into  moonbone.local:/mnt/gentoo64/work/29555-bug-5.0-opt-mysql
      
      c6b64d5c
    • unknown's avatar
      Bug#29555: Comparing time values as strings may lead to a wrong result. · b0a5febe
      unknown authored
      Time values were compared as strings. This led to a wrong comparison
      result when comparing values one of which is under 100 hours and another is
      over 100 hours.
      
      Now when the Arg_comparator::set_cmp_func function sees that both items to
      compare are of the TIME type it sets the comparator to the
      Arg_comparator::compare_e_int or the Arg_comparator::compare_int_unsigned
      functions.
      
      
      sql/item_cmpfunc.cc:
        Bug#29555: Comparing time values as strings may lead to a wrong result.
        Now when the Arg_comparator::set_cmp_func function sees that both items to
        compare are of the TIME type it sets the comparator to the
        Arg_comparator::compare_e_int or the Arg_comparator::compare_int_unsigned
        functions.
      mysql-test/r/type_time.result:
        Added a test case for the bug#29555: Comparing time values as strings may
        lead to a wrong result.
      mysql-test/t/type_time.test:
        Added a test case for the bug#29555: Comparing time values as strings may
        lead to a wrong result.
      b0a5febe
    • unknown's avatar
      Merge gleb.loc:/home/uchum/work/bk/5.0-opt-29360 · b796bddf
      unknown authored
      into  gleb.loc:/home/uchum/work/bk/5.0-opt
      
      b796bddf
    • unknown's avatar
      Fixed bug #29360. · 54286cd5
      unknown authored
      The special `zero' enum value was coerced to the normal
      empty string enum value during a field-to-field copy.
      This bug affected CREATE ... SELECT statements and
      SELECT aggregate GROUP BY enum field statements.
      
      Also this bug made unnecessary warnings during
      the execution of CREATE ... SELECT statements:
      Warning       1265    Data truncated for column...
      
      
      sql/field_conv.cc:
        Fixed bug #29360.
        The field_conv function has been modified to properly convert
        the special `zero' enum value between enum fields.
      mysql-test/t/type_enum.test:
        Updated test case for bug #29360.
      mysql-test/r/type_enum.result:
        Updated test case for bug #29360.
      mysql-test/r/type_ranges.result:
        Updated test case for bug #29360.
      54286cd5
    • unknown's avatar
      Addendum to bug 29325: · 768db64b
      unknown authored
      test if TRUNCATE TABLE works with keep_files_on_create
      
      768db64b