1. 18 May, 2006 1 commit
  2. 17 May, 2006 1 commit
  3. 11 May, 2006 5 commits
  4. 10 May, 2006 19 commits
  5. 09 May, 2006 8 commits
    • unknown's avatar
      fix HA_ERR_RECORD_DELETED for falcon · ba71026e
      unknown authored
      ba71026e
    • unknown's avatar
      Merge mysql.com:/home/kgeorge/mysql/5.0/B18068 · fb2477b3
      unknown authored
      into  mysql.com:/home/kgeorge/mysql/5.1/B18068
      
      
      sql/sql_select.cc:
        Auto merged
      fb2477b3
    • unknown's avatar
      results fixed · 7b111efc
      unknown authored
      7b111efc
    • unknown's avatar
      BUG#18068: SELECT DISTINCT (with duplicates and covering index) · baae7a97
      unknown authored
      When converting DISTINCT to GROUP BY where the columns are from the covering
      index and they are quoted twice in the SELECT list the optimizer is creating
      improper processing sequence. This is because of the fact that the columns
      of the covering index are not recognized as such and treated as non-index
      columns.
      
      Generally speaking duplicate columns can safely be removed from the GROUP
      BY/DISTINCT list because this will not add or remove new rows in the
      resulting set. Duplicates can be removed even if they are not consecutive
      (as is the case for ORDER BY, where the duplicate columns can be removed
      only if they are consecutive).
      
      So we can safely transform "SELECT DISTINCT a,a FROM ... ORDER BY a" to
      "SELECT a,a FROM ... GROUP BY a ORDER BY a" instead of 
      "SELECT a,a FROM .. GROUP BY a,a ORDER BY a". We can even transform 
      "SELECT DISTINCT a,b,a FROM ... ORDER BY a,b" to
      "SELECT a,b,a FROM ... GROUP BY a,b ORDER BY a,b".
      
      The fix to this bug consists of checking for duplicate columns in the SELECT
      list when constructing the GROUP BY list in transforming DISTINCT to GROUP
      BY and skipping the ones that are already in.
      
      
      mysql-test/r/distinct.result:
        test case for the bug without loose index scan
      mysql-test/r/group_min_max.result:
        test case for the bug
      mysql-test/t/distinct.test:
        test case for the bug without loose index scan
      mysql-test/t/group_min_max.test:
        test case for the bug
      sql/sql_select.cc:
        duplicates check and removal
      baae7a97
    • unknown's avatar
      Merge bk-internal:/home/bk/mysql-5.1-new · f3549695
      unknown authored
      into  neptunus.(none):/home/msvensson/mysql/mysql-5.1
      
      
      f3549695
    • unknown's avatar
      Fix InnoDB building on MacOSX when autorun.sh is used · 6e50ee2a
      unknown authored
      
      BUILD/autorun.sh:
        Add libtoolize/glibtoolize hook for InnoDB auto-stuff too
      6e50ee2a
    • unknown's avatar
      55f7266b
    • unknown's avatar
      Merge bk-internal:/home/bk/mysql-5.1-new · 644bd6e2
      unknown authored
      into  neptunus.(none):/home/msvensson/mysql/mysql-5.1
      
      
      mysql-test/mysql-test-run.pl:
        Auto merged
      sql/sql_parse.cc:
        Auto merged
      644bd6e2
  6. 08 May, 2006 6 commits