1. 09 May, 2006 5 commits
    • unknown's avatar
      Merge mysql.com:/home/kgeorge/mysql/5.0/B18068 · b4e093e2
      unknown authored
      into  mysql.com:/home/kgeorge/mysql/5.1/B18068
      
      
      sql/sql_select.cc:
        Auto merged
      b4e093e2
    • unknown's avatar
      results fixed · 854e1fea
      unknown authored
      854e1fea
    • unknown's avatar
      BUG#18068: SELECT DISTINCT (with duplicates and covering index) · 52ae8e1e
      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
      52ae8e1e
    • unknown's avatar
      Fix InnoDB building on MacOSX when autorun.sh is used · 861bd436
      unknown authored
      
      BUILD/autorun.sh:
        Add libtoolize/glibtoolize hook for InnoDB auto-stuff too
      861bd436
    • unknown's avatar
      5a0af764
  2. 08 May, 2006 11 commits
  3. 06 May, 2006 3 commits
  4. 05 May, 2006 10 commits
    • unknown's avatar
      Bug #19492 --binlog-do-db option cuases tables create issues for ndb master · 6dd4a381
      unknown authored
      - ndb system tables not created because of filter, moved chack of filter
      
      6dd4a381
    • unknown's avatar
      Merge bk-internal.mysql.com:/home/bk/mysql-5.1-new · 637a4c8b
      unknown authored
      into  mysql.com:/home/my/mysql-5.1
      
      
      mysql-test/mysql-test-run.pl:
        Auto merged
      sql/ha_ndbcluster.cc:
        Auto merged
      637a4c8b
    • unknown's avatar
      Don't use row level logging on optimize or repair table. · 78fcb9a8
      unknown authored
      (Fixes core dump in rpl_failed_optimize.test)
      Ensure we end active transcations if we do an admin command (like optimize, repair etc)
      
      
      mysql-test/extra/rpl_tests/rpl_failed_optimize.test:
        Added extra test + drop of table at end of test
      mysql-test/lib/mtr_report.pl:
        Fail if mysqld asserts or prints stack
      mysql-test/mysql-test-run.sh:
        Fail if mysqld asserts or prints stack
      mysql-test/r/exampledb.result:
        Cleanup of events_tests (as this caused a lot of problems if it didn't work)
      mysql-test/r/innodb.result:
        Extra test to see that we can do an optimize table on an active transaction
      mysql-test/r/rpl_failed_optimize.result:
        Added extra test + drop of table at end of test
      mysql-test/t/exampledb.test:
        Cleanup of events_tests (as this caused a lot of problems if it didn't work)
      mysql-test/t/innodb.test:
        Extra test to see that we can do an optimize table on an active transaction
      sql/handler.cc:
        Don't use row level logging on optimize or repair table.
      sql/log.cc:
        Simplify code (no logic changes)
      sql/mysql_priv.h:
        Added prototype
      sql/sql_base.cc:
        Better name for define
      sql/sql_class.cc:
        Indentation fix
      sql/sql_parse.cc:
        Make end_active_trans() global
      sql/sql_table.cc:
        Ensure we end active transcations if we do an admin command (like optimize, repair etc)
      78fcb9a8
    • unknown's avatar
      Merge jmiller@bk-internal.mysql.com:/home/bk/mysql-5.1-new · fb76d1c1
      unknown authored
      into  mysql.com:/home/ndbdev/jmiller/clones/mysql-5.1-new
      
      fb76d1c1
    • unknown's avatar
      do not install ndb slave if no slaves · 776d8d01
      unknown authored
          fixed memleak in ndbcluster_end
      
      
      mysql-test/mysql-test-run.pl:
        do not install ndb slave if no slaves
      sql/ha_ndbcluster.cc:
        fixed memleak in ndbcluster_end
      776d8d01
    • unknown's avatar
      Bug #18798: mysqld cores on update in ha_ndbcluster call if cluster has failed... · 42d986f7
      unknown authored
      Bug #18798: mysqld cores on update in ha_ndbcluster call if cluster has failed before, added extra check that transaction is started
      
      
      42d986f7
    • unknown's avatar
      Fixed wrong merge · 23c0e79c
      unknown authored
      23c0e79c
    • unknown's avatar
      Merge bk-internal.mysql.com:/home/bk/mysql-5.1-new · fc57480f
      unknown authored
      into  mysql.com:/home/my/mysql-5.1
      
      
      sql/ha_ndbcluster.cc:
        Auto merged
      mysql-test/t/disabled.def:
        Manual merge
      fc57480f
    • unknown's avatar
      Merge mysql.com:/home/mydev/mysql-5.1 · 1beda216
      unknown authored
      into  mysql.com:/home/mydev/mysql-5.1-bug10405
      
      1beda216
    • unknown's avatar
      After merge fix · 1aeffdca
      unknown authored
      1aeffdca
  5. 04 May, 2006 11 commits