1. 19 Oct, 2006 2 commits
    • unknown's avatar
      Merge mysql.com:/usr/home/ram/work/bug20732/my41-bug20732 · 68c2a008
      unknown authored
      into  mysql.com:/usr/home/ram/work/bug20732/my50-bug20732
      
      
      sql/opt_range.cc:
        Auto merged
      sql/opt_range.h:
        Auto merged
      sql/sql_select.cc:
        Auto merged
      sql/table.cc:
        Auto merged
      mysql-test/r/range.result:
        SCCS merged
      mysql-test/t/range.test:
        SCCS merged
      68c2a008
    • unknown's avatar
      Fix for bug #20732: Partial index and long sjis search with '>' fails sometimes · da7af481
      unknown authored
      We miss some records sometimes using RANGE method if we have
      partial key segments.
      Example:
        Create table t1(a char(2), key(a(1)));
        insert into t1 values ('a'), ('xx');
        select a from t1 where a > 'x';
      We call index_read() passing 'x' key and HA_READ_AFTER_KEY flag
      in the handler::read_range_first() wich is wrong because we have
      a partial key segment for the field and might miss records like 'xx'.
      
      Fix: don't use open segments in such a case.
      
      
      mysql-test/r/range.result:
        Fix for bug #20732: Partial index and long sjis search with '>' fails sometimes
          - test result.
      mysql-test/t/range.test:
        Fix for bug #20732: Partial index and long sjis search with '>' fails sometimes
          - test case.
      sql/opt_range.cc:
        Fix for bug #20732: Partial index and long sjis search with '>' fails sometimes
          - check if we have a partial key segment for a Item_func::GT_FUNC;
            if so, don't set NEAR_MIN flag in order to use HA_READ_KEY_OR_NEXT
            instead of HA_READ_AFTER_KEY.
      sql/opt_range.h:
        Fix for bug #20732: Partial index and long sjis search with '>' fails sometimes
          - key segment 'flag' slot added.
      sql/sql_select.cc:
        Fix for bug #20732: Partial index and long sjis search with '>' fails sometimes
          - test (HA_PART_KEY_SEG | HA_NULL_PART) as we split it in the sql/table.cc
      sql/table.cc:
        Fix for bug #20732: Partial index and long sjis search with '>' fails sometimes
          - set HA_NULL_PART flag instead of HA_PART_KEY_SEG in order not to mix them.
      da7af481
  2. 17 Oct, 2006 1 commit
    • unknown's avatar
      Fix previous bad patch for Bug#14262. · 48dfeb4d
      unknown authored
      Remove table engine qualification where it's unnecessary.
      
      
      mysql-test/r/view.result:
        Remove requirement for innodb where not needed.  (Running this test alone
        raised warnings that it was using myisam.)
      mysql-test/t/view.test:
        Remove requirement for innodb where not needed.  (Running this test alone
        raised warnings that it was using myisam.)
      sql/sql_parse.cc:
        Fix previous bad re-patch.
      sql/sql_view.cc:
        Fix previous bad re-patch.
      48dfeb4d
  3. 14 Oct, 2006 8 commits
  4. 13 Oct, 2006 15 commits
  5. 12 Oct, 2006 14 commits