1. 01 Feb, 2007 1 commit
  2. 31 Jan, 2007 3 commits
  3. 30 Jan, 2007 1 commit
  4. 29 Jan, 2007 4 commits
    • unknown's avatar
      Merge mhansson@bk-internal:/home/bk/mysql-5.1-opt · c0ef6641
      unknown authored
      into  linux-st28.site:/home/martin/mysql/src/5.1o-bug20604-tp
      
      
      mysql-test/t/key.test:
        Auto merged
      c0ef6641
    • unknown's avatar
      BUG#20604: FORCE INDEX uses keys disabled by ALTER TABLE · 5ccbcbe1
      unknown authored
       
      The function that checks whether we can use keys for aggregates,
      find_key_for_maxmin(), assumes that keys disabled by ALTER TABLE
      ... DISABLE KEYS are not in the set table->keys_in_use_for_query.
      I.E., if a key is in this set, the optimizer assumes it is free to 
      use it.
        
      The bug is that keys disabled with ALTER TABLE ... DISABLE KEYS still
      appear in table->keys_in_use_for_query When the TABLE object has been 
      initialized with setup_tables(). Before setup_tables is called, however, 
      keys that are disabled in the aforementioned way are not included in
      TABLE::keys_in_use_for_query. 
        
      The provided patch changes the code that updates keys_is_use_for_query so 
      that it assumes that keys_is_use_for_query already takes into account all 
      disabled keys, and generally all keys that should be used by the query.
      
      
      mysql-test/r/key.result:
        Test for BUG#20604.
        The important part of the test is the explain output that 
        tests what indexes are used.
      mysql-test/t/key.test:
        The minimal test case that reveals the bug. The optimizer for 
        aggregates relies on keys disabled with ALTER TABLE ... DISABLE KEYS
        not being in the set TABLE::keys_in_use_for_query. 
        When the execution engine tries to use a disabled index, MyISAM 
        returns an error.
      sql/sql_base.cc:
        Exclude the keys disabled by ALTER TABLE ... DISABLE_KEYS 
        from TABLE::keys_in_use_for_query, and in general, don't 
        introduce any new keys. We may not know why keys have been 
        removed at previous stages.
      sql/sql_select.cc:
        The intersection operation between table->s->keys_in_use and 
        table->keys_in_use_for_query is no longer necessary. 
        We can trust that the latter is a subset of the former.
      sql/table.h:
        Added comments to TABLE_SHARE::keys_in_use and 
        TABLE::keys_in_use_for_query.
      5ccbcbe1
    • unknown's avatar
      bug #25895 (compiling the embedded server fails on some 64-bit platforms) · 905866af
      unknown authored
      it can't be compile everywhere if we just cast pointer to pthread_t
      So now we use correct pthread_self() value as the pthread_t and
      pointer where we need to identify the thread exactly.
      
      
      libmysqld/lib_sql.cc:
        pthread_self() can be used here as we use pointer to thread
        when we need to identify the thread exactly
      sql/item_func.cc:
        now we use pthread_t value for thread identification in 'standalone'
        server only, in the embedded server we can use the pointer to THD
        structure
      905866af
    • unknown's avatar
      bug #25890 (mysqltest_embedded crashes on start) · 9293210a
      unknown authored
      binlog_filter and rpl_filter are initialized in server's 'main' function
      which doesn't work in the embedded server. So this code moved to
      function working in both cases.
      
      
      sql/mysqld.cc:
        rpl_filter/binlog_filter initializations moved to
        init_common_variables() function.
        That will be called by both 'standalone' and 'embedded' servers
      9293210a
  5. 26 Jan, 2007 3 commits
    • unknown's avatar
      Merge mysql.com:/home/gluh/MySQL/Merge/5.0 · eda2e5c7
      unknown authored
      into  mysql.com:/home/gluh/MySQL/Merge/5.1
      
      
      sql/item.h:
        Auto merged
      sql/sql_table.cc:
        Auto merged
      sql/sql_update.cc:
        Auto merged
      eda2e5c7
    • unknown's avatar
      Merge mysql.com:/home/gluh/MySQL/Merge/5.1-opt · 959f1689
      unknown authored
      into  mysql.com:/home/gluh/MySQL/Merge/5.1
      
      
      mysql-test/r/view.result:
        Auto merged
      mysql-test/t/innodb.test:
        Auto merged
      mysql-test/t/view.test:
        Auto merged
      sql/item.h:
        Auto merged
      sql/mysqld.cc:
        Auto merged
      sql/sql_class.cc:
        Auto merged
      sql/sql_insert.cc:
        Auto merged
      sql/sql_table.cc:
        Auto merged
      sql/sql_update.cc:
        Auto merged
      959f1689
    • unknown's avatar
      Merge mysql.com:/home/gluh/MySQL/Merge/5.0-opt · 8b12f20a
      unknown authored
      into  mysql.com:/home/gluh/MySQL/Merge/5.0
      
      
      sql/item.h:
        Auto merged
      sql/sql_table.cc:
        Auto merged
      sql/sql_update.cc:
        Auto merged
      8b12f20a
  6. 25 Jan, 2007 13 commits
  7. 24 Jan, 2007 15 commits
    • unknown's avatar
      Merge mysql.com:/home/psergey/mysql-5.0-bug8804-r12 · 22d26082
      unknown authored
      into  mysql.com:/home/psergey/mysql-5.1-bug8804-r12-merge
      
      
      sql/mysqld.cc:
        Auto merged
      sql/sql_select.cc:
        Auto merged
      22d26082
    • unknown's avatar
      Merge spetrunia@bk-internal.mysql.com:/home/bk/mysql-5.0-opt · 0406df7c
      unknown authored
      into  mysql.com:/home/psergey/mysql-5.0-bug8804-r12
      
      
      sql/mysqld.cc:
        Auto merged
      0406df7c
    • unknown's avatar
      BUG#24127: wrong result for (null,not-null) IN (SELECT a,b ...): · a9f60b5b
      unknown authored
      Fixed typo problem that surfaced after the merge
      
      a9f60b5b
    • unknown's avatar
      Merge mysql.com:/home/svoj/devel/mysql/merge/mysql-5.0-engines · 1984327e
      unknown authored
      into  mysql.com:/home/svoj/devel/mysql/merge/mysql-5.1-engines
      
      
      mysql-test/r/symlink.result:
        Auto merged
      mysql-test/t/symlink.test:
        Auto merged
      sql/ha_ndbcluster.cc:
        Auto merged
      sql/mysqld.cc:
        Auto merged
      sql/sql_class.cc:
        Auto merged
      sql/table.cc:
        Auto merged
      mysql-test/r/myisam.result:
        Use local.
      mysql-test/t/myisam.test:
        Use local.
      1984327e
    • unknown's avatar
      Merge mysql.com:/home/svoj/devel/bk/mysql-5.1 · 8adaaca5
      unknown authored
      into  mysql.com:/home/svoj/devel/mysql/merge/mysql-5.1-engines
      
      
      mysql-test/r/symlink.result:
        Auto merged
      mysql-test/t/symlink.test:
        Auto merged
      sql/lock.cc:
        Auto merged
      sql/opt_range.cc:
        Auto merged
      sql/sql_class.h:
        Auto merged
      sql/sql_insert.cc:
        Auto merged
      sql/sql_parse.cc:
        Auto merged
      sql/table.cc:
        Auto merged
      storage/federated/ha_federated.cc:
        Auto merged
      storage/myisam/mi_check.c:
        Auto merged
      storage/myisam/mi_packrec.c:
        Auto merged
      mysql-test/r/myisam.result:
        Manually merged.
      mysql-test/t/myisam.test:
        Manually merged.
      8adaaca5
    • unknown's avatar
      Merge malff@bk-internal.mysql.com:/home/bk/mysql-5.1-runtime · 51b80ca6
      unknown authored
      into  weblab.(none):/home/marcsql/TREE/mysql-5.1-21029
      
      
      Makefile.am:
        Auto merged
      sql/Makefile.am:
        Auto merged
      sql/sql_yacc.yy:
        Auto merged
      51b80ca6
    • unknown's avatar
      Bug#21029 (Dependencies between sql_yacc.cc and dependent headers not detected) · 2875875b
      unknown authored
      The build scripts in general, using automake, autoconf, etc, contain several
      special commands and work around all related to the way the bison code in the
      parser is built, for sql/sql_yacc.yy. These work arounds, accumulated over
      time during development, ultimately cause the build scripts to be unstable
      and cause build defects by not enforcing dependencies.
      
      This fix simplifies the build process and aligns it with the automake tooling,
      which provides native support for bison and *.yy files.
      
      In particular, the following problem have been fixed:
      - dependencies with sql_yacc.cc were not honored (Bug 21029), leading to
        corrupted builds,
      - the work around introduced by Bug 24557, to cleanup the generated files
        sql_yacc.h and sql_yacc.cc, has been removed,
      - the generated makefile, in a source distribution, used to destroy the files
        sql_yacc.h and sql_yacc.cc on a 'make clean' target. This has been fixed:
        these files are now removed by make maintainer-clean.
      - The root cause of the problem found with gcc 4.1 (see Bug 24619) has been
        clearly documented, and the "sed" hack has been replaced by a cleaner
        work around, when building the code with bison 1.875.
      - Removed the file sql/sql_yacc.yy.bak, added by WL 3031 by accident.
      - Removed the unnecessary AM_YFLAG= --debug introduced by WL 3432, since
        the compiling option DBUG_OFF takes precedence when setting YYDEBUG.
      
      
      BitKeeper/deleted/.del-sql_yacc.yy.bak:
        Rename: sql/sql_yacc.yy.bak -> BitKeeper/deleted/.del-sql_yacc.yy.bak
      Makefile.am:
        General cleanup of the build process for sql_yacc.yy
      sql/Makefile.am:
        General cleanup of the build process for sql_yacc.yy
      sql/sql_yacc.yy:
        General cleanup of the build process for sql_yacc.yy
      2875875b
    • unknown's avatar
      Merge mysql.com:/home/svoj/devel/bk/mysql-5.0 · 32b5b4a7
      unknown authored
      into  mysql.com:/home/svoj/devel/mysql/merge/mysql-5.0-engines
      
      
      mysql-test/t/myisam.test:
        Auto merged
      32b5b4a7
    • unknown's avatar
      Merge mysql.com:/home/svoj/devel/bk/mysql-5.0 · 9b1e5c9d
      unknown authored
      into  mysql.com:/home/svoj/devel/mysql/merge/mysql-5.0-engines
      
      
      mysql-test/r/symlink.result:
        Auto merged
      mysql-test/t/symlink.test:
        Auto merged
      sql/table.cc:
        Auto merged
      mysql-test/r/myisam.result:
        Manually merged.
      mysql-test/t/myisam.test:
        Manually merged.
      9b1e5c9d
    • unknown's avatar
      Merge mysql.com:/home/psergey/mysql-5.0-bug8804-r12 · fbc9539f
      unknown authored
      into  mysql.com:/home/psergey/mysql-5.1-bug8804-r12-merge
      
      
      sql/item_cmpfunc.cc:
        Auto merged
      sql/item_cmpfunc.h:
        Auto merged
      sql/item_subselect.h:
        Auto merged
      sql/mysql_priv.h:
        Auto merged
      sql/mysqld.cc:
        Auto merged
      sql/sql_lex.h:
        Auto merged
      sql/sql_select.cc:
        Auto merged
      sql/sql_select.h:
        Auto merged
      mysql-test/r/ndb_subquery.result:
        Manual merge
      mysql-test/r/subselect.result:
        Manual merge
      mysql-test/r/subselect3.result:
        Manual merge
      sql/item_subselect.cc:
        Manual merge
      fbc9539f
    • unknown's avatar
      BUG#24127: merge fixes: If subselect is a union, dont allocate several · e058dfb1
      unknown authored
      identical pushed_cond_guards arrays. Allocate only one always.
      
      
      mysql-test/r/subselect.result:
        BUG#24127: merge
      mysql-test/t/subselect3.test:
        BUG#24127: merge
      e058dfb1
    • unknown's avatar
      Merge mockturtle.local:/home/dlenev/src/mysql-5.0-merge · 91f018b0
      unknown authored
      into  mockturtle.local:/home/dlenev/src/mysql-5.1-merge
      
      
      mysql-test/t/ps.test:
        Auto merged
      sql/mysqld.cc:
        Auto merged
      sql/sql_class.cc:
        Auto merged
      mysql-test/t/disabled.def:
        Manual merge.
      91f018b0
    • unknown's avatar
      Disabling back im_daemon_life_cycle.test, which was temporarily enabled in · 8cd8ff4c
      unknown authored
      the team tree for additional investigation.
      
      8cd8ff4c
    • unknown's avatar
      Merge bk-internal.mysql.com:/home/bk/mysql-5.0 · 949ee915
      unknown authored
      into  mockturtle.local:/home/dlenev/src/mysql-5.0-merge
      
      
      mysql-test/t/disabled.def:
        Auto merged
      mysql-test/t/ps.test:
        Auto merged
      949ee915
    • unknown's avatar
      Merge bk-internal.mysql.com:/home/bk/mysql-5.1 · 076455ac
      unknown authored
      into  mockturtle.local:/home/dlenev/src/mysql-5.1-merge
      
      
      mysql-test/t/disabled.def:
        Auto merged
      mysql-test/t/ps.test:
        Auto merged
      sql/sql_view.cc:
        Auto merged
      076455ac