1. 11 Jan, 2006 1 commit
    • unknown's avatar
      simple Windows compile fixes. · 89149cc7
      unknown authored
      
      include/config-win.h:
        use the ll and ull postfix codes for create longlong and ulonglong
        symbols.  This allows ULL(a) and LL(a) to be used in more complex
        macro definitions than the previous definitions.  This may work on
        other compilers but we just tested on Visual 7.1 and 8.0
        
        Also, define HAVE_STRNLEN for all windows platforms.  Our own strnlen
        offers no performance improvements over the CRT version.
      89149cc7
  2. 10 Jan, 2006 12 commits
  3. 09 Jan, 2006 15 commits
  4. 08 Jan, 2006 2 commits
    • unknown's avatar
      Merge rurik.mysql.com:/home/igor/dev/mysql-4.1-0 · 19338b3c
      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.
      19338b3c
    • unknown's avatar
      Fixed bug #14274: a query with a having clause containing only set function... · 7bb07fd4
      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.
      7bb07fd4
  5. 07 Jan, 2006 1 commit
    • unknown's avatar
      Fixed bug #16016: MIN/MAX optimization was not applied to views. · 1901be17
      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.
      1901be17
  6. 06 Jan, 2006 3 commits
  7. 05 Jan, 2006 6 commits
    • unknown's avatar
      Merge bk-internal.mysql.com:/home/bk/mysql-5.0 · a0979fe1
      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
      a0979fe1
    • unknown's avatar
      Review fixes of new pushed code · 43886f1d
      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())
      43886f1d
    • unknown's avatar
      Merge mysql.com:/usr/local/mysql/mysql-5.0-win-fixes · afc24467
      unknown authored
      into  mysql.com:/usr/local/mysql/mysql-5.0
      
      
      include/config-win.h:
        Auto merged
      afc24467
    • unknown's avatar
      Port to Win64/x64 in Visual Studio 2005 · 91d74c55
      unknown authored
      
      include/config-win.h:
        Port to Win64/x64 in Visual Studio 2005.
        Avoid endless deprecation warnings.
      91d74c55
    • unknown's avatar
      Merge mysql.com:/home/jimw/my/mysql-5.0-15185 · c8f02876
      unknown authored
      into  mysql.com:/home/jimw/my/mysql-5.0-clean
      
      
      sql/handler.cc:
        Auto merged
      c8f02876
    • unknown's avatar
      Merge mysql.com:/usr/local/mysql/mysql-5.0-win-fixes · 4425eb69
      unknown authored
      into  mysql.com:/usr/local/mysql/mysql-5.0
      
      4425eb69