1. 08 Jan, 2006 2 commits
    • unknown's avatar
      Merge rurik.mysql.com:/home/igor/dev/mysql-4.1-0 · 48c82418
      unknown authored
      into  rurik.mysql.com:/home/igor/dev/mysql-5.0-0
      
      
      mysql-test/t/having.test:
        Auto merged
      mysql-test/r/having.result:
        Manual merge.
      sql/sql_select.cc:
        Manual merge.
      48c82418
    • unknown's avatar
      Fixed bug #14274: a query with a having clause containing only set function... · 770e0e81
      unknown authored
      Fixed bug #14274: a query with a having clause containing only set function returned a wrong result set.
      
      
      mysql-test/r/having.result:
        Added a test case for bug #14274.
      mysql-test/t/having.test:
        Added a test case for bug #14274.
      sql/sql_select.cc:
        Fixed bug #14274: a query with a having clause containing only set function returned a wrong result set.
        It happened because processing of the set functions in having started with a call of the split_sum_func
        method, instead of the split_sum_func2 method.
      770e0e81
  2. 07 Jan, 2006 1 commit
    • unknown's avatar
      Fixed bug #16016: MIN/MAX optimization was not applied to views. · 312c2f47
      unknown authored
      
      mysql-test/r/view.result:
        Added a test case for bug #16016.
      mysql-test/t/view.test:
        Added a test case for bug #16016.
      sql/opt_sum.cc:
        Fixed bug #16016: MIN/MAX optimization was not applied to views.
        The fix employs the standard way of handling direct references to view fields.
      312c2f47
  3. 06 Jan, 2006 3 commits
  4. 05 Jan, 2006 6 commits
    • unknown's avatar
      Merge bk-internal.mysql.com:/home/bk/mysql-5.0 · 29fde528
      unknown authored
      into  mysql.com:/home/my/mysql-5.0
      
      
      mysql-test/r/create.result:
        Auto merged
      mysql-test/r/trigger.result:
        Auto merged
      mysql-test/r/view.result:
        Auto merged
      mysql-test/t/create.test:
        Auto merged
      mysql-test/t/trigger.test:
        Auto merged
      mysql-test/t/view.test:
        Auto merged
      sql/field.cc:
        Auto merged
      sql/ha_ndbcluster.cc:
        Auto merged
      sql/item.cc:
        Auto merged
      sql/item.h:
        Auto merged
      sql/log_event.cc:
        Auto merged
      sql/opt_range.cc:
        Auto merged
      sql/sp.cc:
        Auto merged
      sql/sp_head.h:
        Auto merged
      sql/sql_acl.cc:
        Auto merged
      sql/sql_base.cc:
        Auto merged
      sql/sql_insert.cc:
        Auto merged
      sql/sql_parse.cc:
        Auto merged
      sql/sql_select.cc:
        Auto merged
      mysql-test/t/disabled.def:
        Manual merge
      sql/mysqld.cc:
        Manual merge
      sql/sp_head.cc:
        Manual merge
      sql/sql_trigger.cc:
        Manual merge
      29fde528
    • unknown's avatar
      Review fixes of new pushed code · 64206b18
      unknown authored
      - Fixed tests
      - Optimized new code
      - Fixed some unlikely core dumps
      - Better bug fixes for:
        - #14397 - OPTIMIZE TABLE with an open HANDLER causes a crash
        - #14850 (ERROR 1062 when a quering a view using a Group By on a column that can be null
      
      
      mysql-test/r/create.result:
        Update results after removing wrong warnings for CREATE ... SELECT
        New tests
      mysql-test/r/handler.result:
        Drop used tables
      mysql-test/r/kill.result:
        Make test portable
      mysql-test/r/mysqlshow.result:
        Drop tables used by previous test
      mysql-test/r/trigger.result:
        Reuse old procedure name
      mysql-test/r/view.result:
        Extra tests
      mysql-test/t/create.test:
        New tests to test fix of removing wrong warnings for CREATE ... SELECT
      mysql-test/t/disabled.def:
        Enable 'kill' test (should now be portable)
      mysql-test/t/handler.test:
        Drop used tables
      mysql-test/t/kill.test:
        Make test portable even if kill doesn't work at once
      mysql-test/t/mysqlshow.test:
        Drop tables used by previous test
      mysql-test/t/trigger.test:
        Reuse old procedure name
      mysql-test/t/view.test:
        Extra tests
      sql/field.cc:
        Removed compiler warning
      sql/ha_federated.cc:
        my_snprintf -> strmake()
        (Simple optimization)
      sql/ha_ndbcluster.cc:
        Indentation cleanups and trival optimization
      sql/item.cc:
        Moved save_org_in_field() to item.cc to make it easier to test
        Remove setting of null_value as this is not needed
      sql/item.h:
        Moved save_org_in_field() to item.cc to make it easier to test
      sql/log_event.cc:
        Remove inline of slave_load_file_stem()
        Added 'extension' parameter to slave_load_file_stem() to get smaller code
        Removed not critical (or needed) DBUG_ASSERT()'s
        Cleaned up usage of slave_load_file_stem() to not depend on constant string lengths
        Indentation fixes
      sql/opt_range.cc:
        Moved code from declaration to function body
        (To make it more readable)
      sql/parse_file.cc:
        Fixed DBUG_PRINT
      sql/sp.cc:
        Simple cleanups
        - Removed not needed {} level
        - Ensure saved variables starts with old_
      sql/sp_head.cc:
        Indentation fixes
        Remove core dump when using --debug when m_next_cached_sp == 0
        Fixed compiler warnings
        Trivial optimizations
      sql/sp_head.h:
        Changed argument to set_definer() to const
        Added THD argument to recursion_level_error() to avoid call to current_thd
      sql/sql_acl.cc:
        Removed not needed test (first_not_own_table is the guard)
      sql/sql_base.cc:
        Removed extra empty line
      sql/sql_handler.cc:
        Don't test table version in mysql_ha_read() as this is already tested in lock_tables()
        Moved call to insert_fields to be after lock_table() to guard aganst reopen of tables
        (Better fix for Bug#14397 - OPTIMIZE TABLE with an open HANDLER causes a crash)
      sql/sql_insert.cc:
        Mark fields that are set in CREATE ... SELECT as used
        (Removed wrong warnings about field not having a default value)
      sql/sql_parse.cc:
        Removed not needed test of 'tables' (first_not_own_table is the guard)
        Simplify code
      sql/sql_select.cc:
        Use group->field to check if value is null instead of item called by 'save_org_in_field'
        This is a better bug fix for #14850 (ERROR 1062 when a quering a view using a Group By on a column that can be null)
      sql/sql_trigger.cc:
        Move sql_modes_parameters outside of function
        Indentation fixes
        Fixed compiler warning
        Ensure that thd->lex->query_tables_own_last is set properly before calling check_table_access()
        (This allows us to remove the extra test in check_grant() and check_table_access())
      64206b18
    • unknown's avatar
      Merge mysql.com:/usr/local/mysql/mysql-5.0-win-fixes · f133b065
      unknown authored
      into  mysql.com:/usr/local/mysql/mysql-5.0
      
      
      include/config-win.h:
        Auto merged
      f133b065
    • unknown's avatar
      Port to Win64/x64 in Visual Studio 2005 · f6bcc388
      unknown authored
      
      include/config-win.h:
        Port to Win64/x64 in Visual Studio 2005.
        Avoid endless deprecation warnings.
      f6bcc388
    • unknown's avatar
      Merge mysql.com:/home/jimw/my/mysql-5.0-15185 · 724f46c2
      unknown authored
      into  mysql.com:/home/jimw/my/mysql-5.0-clean
      
      
      sql/handler.cc:
        Auto merged
      724f46c2
    • unknown's avatar
      Merge mysql.com:/usr/local/mysql/mysql-5.0-win-fixes · 23331172
      unknown authored
      into  mysql.com:/usr/local/mysql/mysql-5.0
      
      
      23331172
  5. 04 Jan, 2006 10 commits
    • unknown's avatar
      Merge bk-internal.mysql.com:/home/bk/mysql-5.0 · 7bf8a9e6
      unknown authored
      into  mysql.com:/opt/local/work/mysql-5.0-merge
      
      
      7bf8a9e6
    • unknown's avatar
      Post-merge fixes. · 58d4830c
      unknown authored
      
      sql/sql_acl.cc:
        A post-merge fix.
      sql/sql_base.cc:
        A post-merge fix.
      58d4830c
    • unknown's avatar
      EADDRINUSE is not defined on Windows. · a6b0029f
      unknown authored
      a6b0029f
    • unknown's avatar
      Merge mysql.com:/usr/local/mysql/mysql-5.0-qnxfix · 0d9edb36
      unknown authored
      into  mysql.com:/usr/local/mysql/mysql-5.0
      
      
      0d9edb36
    • unknown's avatar
      Fix QNX test abort in release builds and pushbuild, avoid killing our · b6e0d940
      unknown authored
      parent when we are not the process group leader.
      
      
      b6e0d940
    • unknown's avatar
      Merge mysql.com:/opt/local/work/mysql-4.1-7209-new · 3456c4be
      unknown authored
      into  mysql.com:/opt/local/work/mysql-5.0-merge
      
      
      mysys/hash.c:
        Auto merged
      ndb/src/kernel/blocks/dbtup/DbtupCommit.cpp:
        Auto merged
      sql/lock.cc:
        Auto merged
      sql/sql_cache.cc:
        Auto merged
      sql/sql_acl.cc:
        Manual merge.
      sql/sql_base.cc:
        Manual merge.
      3456c4be
    • unknown's avatar
      A fix for Bug#7209 "Client error with "Access Denied" on updates · f577d864
      unknown authored
      when high concurrency": remove HASH::current_record and make it
      an external search parameter, so that it can not be the cause of a 
      race condition under high concurrent load.
      The bug was in a race condition in table_hash_search,
      when column_priv_hash.current_record was overwritten simultaneously
      by multiple threads, causing the search for a suitable grant record
      to fail.
      No test case as the bug is repeatable only under concurrent load.
      
      
      include/hash.h:
        - remove current_record from HASH, instead modify hash_first,
        hash_next to accept HASH_SEARCH_STATE as an IN/OUT parameter
      mysys/hash.c:
        - remove HASH::current_record
        - change declarations of functions that use HASH in read-only mode
          to accept const HASH * instead of HASH *. 
        - implement hash_search; move the old implementation of hash_search
        to hash_first
      mysys/testhash.c:
        - adjust the test case to changed function declarations
      sql/lock.cc:
        - adjust to changed declarations of hash_search, hash_next
      sql/sql_acl.cc:
        - adjust to changed declarations of hash_search, hash_next
      sql/sql_base.cc:
        - adjust to changed declarations of hash_search, hash_nex
      sql/sql_cache.cc:
        - adjust to a changed declaration of hash_replace
      f577d864
    • unknown's avatar
      BUG#14931: Temporarily add synchronization to avoid sporadic test failures until · 95cecbf8
      unknown authored
      the bug is fixed.
      
      
      mysql-test/r/rpl_sp.result:
        BUG#14931: Temporarily add synchronization to avoid sporadic failures until
        the bug is fixed.
      mysql-test/t/rpl_sp.test:
        BUG#14931: Temporarily add synchronization to avoid sporadic failures until
        the bug is fixed.
      95cecbf8
    • unknown's avatar
      Merge mysql.com:/usr/local/mysql/mysql-5.0-qnxtestsock · 314f0fbf
      unknown authored
      into  mysql.com:/usr/local/mysql/mysql-5.0
      
      
      314f0fbf
    • unknown's avatar
      e1fdf8b4
  6. 03 Jan, 2006 1 commit
    • unknown's avatar
      Fix for bug#15533 crash, information_schema, function, view · 5e7cbbcb
      unknown authored
        enable view prepared mode during getting metedata for I_S table
      
      
      mysql-test/r/information_schema.result:
        Fix for bug#15533 crash, information_schema, function, view
          test case
      mysql-test/t/information_schema.test:
        Fix for bug#15533 crash, information_schema, function, view
          test case
      5e7cbbcb
  7. 31 Dec, 2005 1 commit
  8. 29 Dec, 2005 5 commits
  9. 28 Dec, 2005 10 commits
    • unknown's avatar
      Bug#15591 Occasional test suite abort due to port in use · 57b20336
      unknown authored
      If the server is started with --port-open-timeout=# 
      retry to bind the TCP port if it fails with EADDRINUSE.
      Use the new option in mysql-test-run.sh.
      
      
      mysql-test/mysql-test-run.sh:
        Bug#15591 Occasional test suite abort due to port in use
        Use the new option --port-open-timeout=# for server starts.
        This should fix occasionally late closed TCP ports.
      sql/mysqld.cc:
        Bug#15591 Occasional test suite abort due to port in use
        If the server is started with --port-open-timeout=# 
        retry to bind the TCP port if it fails with EADDRINUSE.
      57b20336
    • unknown's avatar
      config-win.h: · 82d5d2a9
      unknown authored
        Backported Windows MAX_INDEXES handling from 5.1
      
      
      include/config-win.h:
        Backported Windows MAX_INDEXES handling from 5.1
      82d5d2a9
    • unknown's avatar
      Merge msvensson@msvensson.mysql.internal:/home/msvensson/mysql/bug15775_part2/my50-bug15775_part2 · bf0c5e6f
      unknown authored
      into  devsrv-b.mysql.com:/space/magnus/my50-bug15775_part2
      
      
      bf0c5e6f
    • unknown's avatar
      Manual merge · 8f29cc3e
      unknown authored
      
      mysql-test/t/ctype_ucs.test:
        Auto merged
      sql/sql_update.cc:
        Auto merged
      BitKeeper/deleted/.del-ha_blackhole.cc~727c69ef7846623a:
        Auto merged
      8f29cc3e
    • unknown's avatar
      Bug #15775 "drop user" command does not refresh acl_check_hosts · 93bedc1f
      unknown authored
       - Update patch for 5.0 
       - Added common function to be called when 'acl_users' has been modified
      
      
      mysql-test/r/grant2.result:
        Use "create user" to avoid warnings about missing fields
      mysql-test/t/grant2.test:
        Use "create user" to avoid warnings about missing fields
      sql/sql_acl.cc:
        Add new function "rebuild_check_host" that is to be called when the 'acl_users'
        list has changed.
        Call function "rebuild_check_host" from mysql_drop_user, mysql_rename_user and acl_insert_user.
        Use "acl_user->host.hostname" as key when searching the acl_check_hosts in init_check_host.
      93bedc1f
    • unknown's avatar
      Merge epotemkin@bk-internal.mysql.com:/home/bk/mysql-4.1 · c37389cf
      unknown authored
      into moonbone.local:/work/14583-bug-4.1-mysql
      
      
      c37389cf
    • unknown's avatar
      Merge rkalimullin@bk-internal.mysql.com:/home/bk/mysql-5.0 · e46602f5
      unknown authored
      into  mysql.com:/usr/home/ram/work/5.0.b15108
      
      
      e46602f5
    • unknown's avatar
      Merge neptunus.(none):/home/msvensson/mysql/bug15775_part2/my41-bug15775_part2 · 50545a18
      unknown authored
      into  neptunus.(none):/home/msvensson/mysql/bug15775_part2/my50-bug15775_part2
      
      
      mysql-test/r/grant2.result:
        Merge test results
      mysql-test/t/grant2.test:
        Merge tests
      sql/sql_acl.cc:
        Removing the 4.1 version patch
      50545a18
    • unknown's avatar
      BUG#15775 "drop user" command does not refresh acl_check_hosts · 9a8dde9b
      unknown authored
         - DROP USER command didn't reload the acl_check_hosts cache causing subsequent 
           connect's via TCP to fail randomly.
         - 4.1 version
      
      
      mysql-test/r/grant2.result:
        Update test results
      mysql-test/t/grant2.test:
        Add test for to check that connect via TCP work after "drop user"
      sql/sql_acl.cc:
        Reload acl_check_hosts as its memory is mapped to acl_user
        Use acl_user->host.hostname when searching the acl_check_hosts list
      9a8dde9b
    • unknown's avatar
      Merge mysql.com:/home/mydev/mysql-5.0 · 4f5664f3
      unknown authored
      into  mysql.com:/home/mydev/mysql-5.0-bug5390
      
      
      4f5664f3
  10. 27 Dec, 2005 1 commit