An error occurred fetching the project authors.
  1. 18 Jan, 2005 1 commit
    • unknown's avatar
      Fix for BUG#7885 · 2e50981a
      unknown authored
      mysql-test/r/subselect.result:
        Testcase for BUG#7885
      mysql-test/t/subselect.test:
        Testcase for BUG#7885
      sql/item_subselect.cc:
        Fix for BUG#7885: In Item_subselect::fix_fields, return error if engine->prepare fails.
        Also removed redundant code line.
      2e50981a
  2. 26 Dec, 2004 2 commits
    • unknown's avatar
      subselect.result, subselect.test: · a9eef185
      unknown authored
        Added a couple of new test cases for bug #7351.
      
      
      mysql-test/t/subselect.test:
        Added a couple of new test cases for bug #7351.
      mysql-test/r/subselect.result:
        Added a couple of new test cases for bug #7351.
      a9eef185
    • unknown's avatar
      subselect.result, subselect.test: · a4d840a0
      unknown authored
        Added test cases for bug #7351.
      item_cmpfunc.cc:
        Fixed bug #7351: incorrect result for a query with a
        subquery returning empty set.
        If in the predicate v IN (SELECT a FROM t WHERE cond)
        v is null, then the result of the predicate is either
        INKNOWN or FALSE. It is FALSE if the subquery returns
        an empty set.
      item_subselect.cc:
        Fixed bug #7351: incorrect result for a query with a
        subquery returning empty set.
        The problem was due to not a quite legal transformation
        for 'IN' subqueries. A subquery containing a predicate
        of the form
        v IN (SELECT a FROM t WHERE cond)
        was transformed into
        EXISTS(SELECT a FROM t WHERE cond AND (a=v OR a IS NULL)).
        Yet, this transformation is valid only if v is not null.
        If v is null, then, in the case when
        (SELECT a FROM t WHERE cond) returns an empty set the value
        of the predicate is FALSE, otherwise the result of the
        predicate is INKNOWN.
        The fix resolves this problem by changing the result
        of the transformation to
        EXISTS(SELECT a FROM t WHERE cond AND (v IS NULL OR (a=v OR a IS NULL)))
        in the case when v is nullable.
        The new transformation prevents applying the lookup
        optimization for IN subqueries. To make it still
        applicable we have to introduce guarded access methods.
      
      
      sql/item_subselect.cc:
        Fixed bug #7351: incorrect result for a query with a
        subquery returning empty set.
        The problem was due to not a quite legal transformation
        for 'IN' subqueries. A subquery containing a predicate
        of the form
        v IN (SELECT a FROM t WHERE cond)
        was transformed into
        EXISTS(SELECT a FROM t WHERE cond AND (a=v OR a IS NULL)).
        Yet, this transformation is valid only if v is not null.
        If v is null, then, in the case when
        (SELECT a FROM t WHERE cond) returns an empty set the value
        of the predicate is FALSE, otherwise the result of the
        predicate is INKNOWN.
        The fix resolves this problem by changing the result
        of the transformation to
        EXISTS(SELECT a FROM t WHERE cond AND (v IS NULL OR (a=v OR a IS NULL)))
        in the case when v is nullable.
        The new transformation prevents applying the lookup
        optimization for IN subqueries. To make it still
        applicable we have to introduce guarded access methods.
      sql/item_cmpfunc.cc:
        Fixed bug #7351: incorrect result for a query with a
        subquery returning empty set.
        If in the predicate v IN (SELECT a FROM t WHERE cond)
        v is null, then the result of the predicate is either
        INKNOWN or FALSE. It is FALSE if the subquery returns
        an empty set.
      mysql-test/t/subselect.test:
        Added test cases for bug #7351.
      mysql-test/r/subselect.result:
        Added test cases for bug #7351.
      a4d840a0
  3. 14 Dec, 2004 1 commit
    • unknown's avatar
      Clean-up. · e938cfce
      unknown authored
      TYPE=MyISAM replaced with ENGINE=MyISAM.
      
      
      e938cfce
  4. 11 Dec, 2004 1 commit
    • unknown's avatar
      new reference which refer to current value not to result used for resolving outer · 3ce0df59
      unknown authored
      refernces if subqueri is not in HAVING clause (BUG#7079)
        and the same used for subquery transformetion
      
      
      mysql-test/r/subselect.result:
        reference on changable fields from subquery
      mysql-test/t/subselect.test:
        reference on changable fields from subquery
      sql/item.cc:
        new reference which refer to current value not to result used
      sql/item.h:
        new reference which refer to current value not to result used
      sql/item_subselect.cc:
        new reference which refer to current value not to result used
      3ce0df59
  5. 25 Nov, 2004 1 commit
  6. 22 Nov, 2004 1 commit
    • unknown's avatar
      Fix for bug #6462 "Same request on same data returns different · 4389be75
      unknown authored
      results." a.k.a. "Proper cleanup of subqueries is missing for SET and DO
      statements". (Version #2 with after-review fixes).
      
      To perform proper cleanup for statements that can contain subqueries 
      but don't have main select we must call free_undelaid_joins().
      
      
      mysql-test/r/subselect.result:
        Added test for bug #6462 "Same request on same data returns different
        results." a.k.a. "Proper cleanup of subqueries is missing for SET and DO
        statements".
      mysql-test/t/subselect.test:
        Added test for bug #6462 "Same request on same data returns different
        results." a.k.a. "Proper cleanup of subqueries is missing for SET and DO
        statements".
      sql/set_var.cc:
        Added missing cleanup of joins used in subqueries to SET statement.
      sql/sql_do.cc:
        Added missing cleanup of joins used in subqueries to DO statement.
      4389be75
  7. 18 Nov, 2004 1 commit
    • unknown's avatar
      reporting empty result added in case of max/min optimisation of ALL/ANY/SOME subqueries · 9438c2ca
      unknown authored
      fixed null processing in NOT operation used in ALL subquery (Bug #6247)
      
      
      mysql-test/r/subselect.result:
        new tests of ALL/ANY wiews
      mysql-test/t/subselect.test:
        new tests of ALL/ANY wiews
      sql/item_cmpfunc.cc:
        fixed special NOT ALL processing
        fixed processing max/min optimized subqueries with empty results (added methods to detect empty results) and special NOP operation to process them for SOME/ANY sobqueries
      sql/item_cmpfunc.h:
        fixed processing max/min optimized subqueries with empty results (added methods to detect empty results) and special NOP operation to process them for SOME/ANY sobqueries
      sql/item_subselect.cc:
        reporting empty result added for max/min subqueries
      sql/item_subselect.h:
        reporting empty result added for max/min subqueries
      sql/item_sum.cc:
        reporting empty result added fox max/min aggregate functions
      sql/item_sum.h:
        reporting empty result added fox max/min aggregate functions
      sql/sql_class.cc:
        reporting empty result added for max/min subqueries
      sql/sql_parse.cc:
        reporting empty result added for max/min subqueries
      sql/sql_union.cc:
        reporting empty result added for max/min subqueries
      9438c2ca
  8. 16 Nov, 2004 1 commit
    • unknown's avatar
      backport Serg's fix of FT interface (BUG#6523) · 70ed3160
      unknown authored
      mysql-test/r/subselect.result:
        subqueries with full text search
      mysql-test/t/subselect.test:
        subqueries with full text search
      sql/ha_myisam.h:
        backport Serg's fix of FT interface
      sql/handler.h:
        backport Serg's fix of FT interface
      sql/opt_range.h:
        backport Serg's fix of FT interface
      sql/sql_select.cc:
        comment for previous patch
      70ed3160
  9. 15 Nov, 2004 2 commits
    • unknown's avatar
      fixed joincleunup to avoid double deletin tables, and too earlyfull cleanup in case of EXPLAIN · dd93baa0
      unknown authored
      fixed cleunup of TMP_TABLE_PARAM
      (BUG#6406)
      
      
      mysql-test/r/subselect.result:
        primary query with temporary table and subquery with groupping
      mysql-test/t/subselect.test:
        primary query with temporary table and subquery with groupping
      sql/sql_class.h:
        fixed cleunup of TMP_TABLE_PARAM
      sql/sql_select.cc:
        uncacheable test made simplier
        fixed joincleunup to avoid double deletin tables, and too earlyfull cleanup in case of EXPLAIN
      dd93baa0
    • unknown's avatar
      moved procedure list initialization (BUG#6517) · b685909d
      unknown authored
      mysql-test/r/subselect.result:
        Subselect in non-select command just after connection
      mysql-test/t/subselect.test:
        Subselect in non-select command just after connection
      sql/sql_lex.cc:
        moved procedure initialization
      sql/sql_parse.cc:
        moved procedure initialization
      b685909d
  10. 27 Oct, 2004 1 commit
    • unknown's avatar
      removed incorrect error message about aggregate functions · 464da8f1
      unknown authored
      improved mechanisn of detection posibility to be NULL for single row queries
      switched off substitution optimisation for single row subqueries in PS due to problem in resolving substituted expressions
      (changes to make subselects test working with PS protocol)
      
      
      mysql-test/r/subselect.result:
        removed incorrect error message about aggregate functions
        improved mechanisn of detection posibility to be NULL for single row queries
      mysql-test/t/subselect.test:
        removed incorrect error message about aggregate functions
      sql/item_subselect.cc:
        removed incorrect error message about aggregate functions
        switched off substitution optimisation for single row subqueries in PS due to problem in resolving substituted expressions
        improved mechanisn of detection posibility to be NULL for single row queries
      sql/item_subselect.h:
        new method to help in NULL ability detection
      464da8f1
  11. 17 Sep, 2004 1 commit
    • unknown's avatar
      fixed error handling if creating derived table failed · 580f12cc
      unknown authored
      single row subquery always can return NULL (no rows found) (BUG#5590)
      
      
      mysql-test/r/subselect.result:
        maybe_null flag returning by subquwery for temporary table creation
      mysql-test/t/subselect.test:
        maybe_null flag returning by subquwery for temporary table creation
      sql/item.cc:
        storing maybe_null in type holder
      sql/item_subselect.cc:
        single row subquery always can return NULL (no rows found)
      sql/sql_derived.cc:
        fixed error handling if creating derived table failed
      580f12cc
  12. 06 Sep, 2004 1 commit
    • unknown's avatar
      fixed temporary table processing expresions of subqueries and removed wrong... · 77ee831d
      unknown authored
      fixed temporary table processing expresions of subqueries and removed wrong restrictions of field resolving (BUG#5326)
      
      
      mysql-test/r/subselect.result:
        tests of fields resolving
      mysql-test/t/subselect.test:
        tests of fields resolving
      sql/item.cc:
        fixed fild resolving
      sql/item_subselect.cc:
        removed aneed call
      sql/sql_base.cc:
        fixed case whan we scan un-fixfielded fields
      sql/sql_select.cc:
        fixed temporary table processing expresions of subqueries
      77ee831d
  13. 24 Aug, 2004 1 commit
  14. 23 Aug, 2004 1 commit
    • unknown's avatar
      after review fixes: · 13f7338a
      unknown authored
       allowed parsing of table fields inside aggregate functions
       added new tests of fields resolving in grouping
      
      
      mysql-test/r/func_gconcat.result:
        allowed parsing of table fields inside aggregate functions
      mysql-test/r/subselect.result:
        added new tests of fields resolving in grouping
      mysql-test/t/func_gconcat.test:
        allowed parsing of table fields inside aggregate functions
      mysql-test/t/subselect.test:
        added new tests of fields resolving in grouping
      sql/item_subselect.cc:
        allowed parsing of table fields inside aggregate functions
      13f7338a
  15. 21 Aug, 2004 1 commit
    • unknown's avatar
      Proposed fix for bug #5003 (subselect with MIN() and LIKE crashes server) · ac4c0538
      unknown authored
      We have next problem here:
      active_index is wrong in the subselect's handler on the second val_int() call.
      Optimizer sees that we can use index-read for that kind of condition,
      and matching_cond() (sql/opt_sum.cc) doesn't. I suspect, proper solution is
      to add appropriate code to the matching_cond() but now just added
      missed initialization.
      
      
      mysql-test/r/subselect.result:
        Appropriate test result
      mysql-test/t/subselect.test:
        Test case added
      sql/records.cc:
        index's initialization added
      ac4c0538
  16. 19 Aug, 2004 1 commit
  17. 13 Aug, 2004 1 commit
    • unknown's avatar
      skip resolving field in table list if table list is not accessable due to groupping (BUG#4814) · d0c87702
      unknown authored
      mysql-test/r/func_gconcat.result:
        fix of test queries
      mysql-test/r/subselect.result:
        resolving fields of grouped outer SELECT
      mysql-test/t/func_gconcat.test:
        fix of test queries
      mysql-test/t/subselect.test:
        resolving fields of grouped outer SELECT
      sql/item.cc:
        skip resolving field in table list if table list is not accessable due to groupping
        layout fixed
      sql/item_subselect.cc:
        detection of place of subquery
      sql/item_subselect.h:
        detection of place of subquery
      sql/mysql_priv.h:
        enum_parsing_place made global type
      sql/sql_lex.cc:
        enum_parsing_place made global type
      sql/sql_lex.h:
        enum_parsing_place made global type
      sql/sql_yacc.yy:
        enum_parsing_place made global type
      d0c87702
  18. 12 Aug, 2004 1 commit
  19. 04 Jul, 2004 1 commit
    • unknown's avatar
      aggregate functions check during substitution made only for single row subselects (BUG#4400) · cc74326b
      unknown authored
      restoring current senect pointer before PS rexecution (backport from 5.0)
      removed spaces at  lines ends
      
      
      mysql-test/r/subselect.result:
        Aggregate function comparation with ALL/ANY/SOME subselect test
      mysql-test/t/subselect.test:
        Aggregate function comparation with ALL/ANY/SOME subselect test
      sql/item_subselect.cc:
        removed spaces at  lines ends
        aggregate functions check during substitution made only for single row subselects
      sql/item_subselect.h:
        removed spaces at  lines ends
      sql/sql_prepare.cc:
        restoring current senect pointer before PS rexecution (backport from 5.0)
      cc74326b
  20. 22 Jun, 2004 1 commit
    • unknown's avatar
      post-review changes (Bug#4090) · e2a57933
      unknown authored
      mysql-test/r/subselect.result:
        prepare statement test added
      mysql-test/t/subselect.test:
        prepare statement test added
      e2a57933
  21. 18 Jun, 2004 1 commit
    • unknown's avatar
      Fixed some byte order bugs with prepared statements on machines with high-byte-first. (Bug #4173) · 7d52eabb
      unknown authored
      Fixed problem with NULL and derived tables (Bug #4097)
      Cleanup of new pushed code
      
      
      BitKeeper/etc/ignore:
        added mysql-test/ndb/ndbcluster
      client/mysqltest.c:
        simple cleanup
      innobase/os/os0file.c:
        fix for netware
      libmysql/libmysql.c:
        Fixed some byte order bugs with prepared statements on machines with
        high-byte-first. (Bug #4173)
      myisam/ft_boolean_search.c:
        Comment cleanup
      myisam/mi_check.c:
        Removed not needed check (check is done in check_index())
      myisam/mi_unique.c:
        crc must be of type ha_checksum.
      myisam/myisamchk.c:
        Portability fix.
      mysql-test/mysql-test-run.sh:
        Simple cleanup
      mysql-test/r/subselect.result:
        Test problem with NULL and derived tables (Bug #4097)
      mysql-test/t/subselect.test:
        Test problem with NULL and derived tables (Bug #4097)
      sql/mysqld.cc:
        Remove not used defines
      sql/sql_select.cc:
        Fixed problem with NULL and derived tables (Bug #4097)
        Indentation fixes
      sql/sql_string.cc:
        Code cleanup
      sql/sql_yacc.yy:
        Allow one to use DROP PREPARE ...
      7d52eabb
  22. 17 Jun, 2004 1 commit
  23. 13 Jun, 2004 1 commit
    • unknown's avatar
      fixed field resolving mode fo INSERT/REPLACE and CRETE with SELECT (BUG#4090) · 6f364111
      unknown authored
      mysql-test/r/subselect.result:
        outer fields resolving in INSERT/REPLACE and CRETE with SELECT
      mysql-test/t/subselect.test:
        outer fields resolving in INSERT/REPLACE and CRETE with SELECT
      sql/sql_parse.cc:
        fixed field resolving mode fo INSERT/REPLACE and CRETE with SELECT
      sql/sql_prepare.cc:
        fixed field resolving mode fo INSERT/REPLACE and CRETE with SELECT
      6f364111
  24. 10 Jun, 2004 1 commit
    • unknown's avatar
      EXISTS(SELECT * ...) · d9b81f3a
      unknown authored
      close table before opening in optimize
      
      
      mysql-test/r/subselect.result:
        test of EXISTS(SELECT * ...)
      mysql-test/t/subselect.test:
        test of EXISTS(SELECT * ...)
      sql/sql_base.cc:
        EXISTS(SELECT * ...)
      sql/sql_table.cc:
        close table before opening one
      d9b81f3a
  25. 28 May, 2004 1 commit
    • unknown's avatar
      if exists should not be used inside test · bfaaee53
      unknown authored
      removed influence of some tests on other tests
      
      
      mysql-test/r/multi_update.result:
        removed influence on other tests
      mysql-test/r/subselect.result:
        if exists should not be used inside test
      mysql-test/t/multi_update.test:
        removed influence on other tests
      mysql-test/t/subselect.test:
        if exists should not be used inside test
      mysql-test/t/system_mysql_db_fix.test:
        removed influence on other tests
      bfaaee53
  26. 07 May, 2004 1 commit
    • unknown's avatar
      keep old engine & JOIN if we changed subquery Item (Bug #3646) · e54ca13b
      unknown authored
      mysql-test/r/subselect.result:
        ALL/ANY test
      mysql-test/t/subselect.test:
        ALL/ANY test
      sql/item_subselect.cc:
        keep old engine & JOIN if we changed subquery Item, which allow avoid second all SELECT items fix_fields call with pervios clean up (because of second setup_tables which remove table->key_use and maybe something else)
        keep list when we change Item in SELECT list
        processing inserted max/min function (now JOIN::prepare will be called only once)
        methods of changing item for subselect engines
      sql/item_subselect.h:
        change item & results procedure
      sql/item_sum.cc:
        Item_sum_hybrid::clear moved to .cc file (to keep .h clean and to make inserving/removing debug info easy)
      sql/item_sum.h:
        Item_sum_hybrid::clear moved to .cc file (to keep .h clean and to make inserving/removing debug info easy)
      sql/sql_lex.cc:
        note about new method
      sql/sql_lex.h:
        method for changing result of UNION JOINs
      sql/sql_select.cc:
        method for changing result in JOIN
      sql/sql_select.h:
        method for changing result in JOIN
      sql/sql_union.cc:
        method for changing result in JOIN
      e54ca13b
  27. 06 May, 2004 1 commit
    • unknown's avatar
      EXPLAIN UNION using same routing which used for execution which allow return... · 1a4f499c
      unknown authored
      EXPLAIN UNION using same routing which used for execution which allow return correct bug messages (Bug #3639)
      EXPLAIN of hidden SELECT of UNION
      
      
      mysql-test/r/derived.result:
        explain of hidden select
      mysql-test/r/subselect.result:
        explain of hidden select
      mysql-test/r/union.result:
        explain of hidden select
        correct error messages on explain
      mysql-test/t/subselect.test:
        show eliminated costants in WHERE clause
      mysql-test/t/union.test:
        correct error messages on EXPLAIN with union
      sql/item.cc:
        fixed name constructing for global ORDER BY items
      sql/sql_class.h:
        select ID can be negative (for hidden SELECTs)
        removed unused field
      sql/sql_lex.cc:
        new flag of UNION EXPLAIN
      sql/sql_lex.h:
        new flag of UNION EXPLAIN
        select ID can be negative (for hidden SELECTs)
      sql/sql_select.cc:
        EXPLAIN UNION using same routing which used for execution
        explain for hidden SELECT of UNION
      sql/sql_union.cc:
        EXPLAIN UNION using same routing which used for execution
      1a4f499c
  28. 05 May, 2004 1 commit
  29. 02 May, 2004 1 commit
    • unknown's avatar
      fixed zero result case for group functions in subquery (Bug #3505) · 748db216
      unknown authored
      fixed LIMIT 0 for zero rows optimisation
      
      
      mysql-test/r/subselect.result:
        test case for bugreport
      mysql-test/t/subselect.test:
        test case for bugreport
      sql/sql_select.cc:
        cleanup sum function on reinit
        take in account LIMIT if zero result optimisation case
        do not forgot sum function in zero result case for subqueries
      748db216
  30. 23 Mar, 2004 1 commit
    • unknown's avatar
      small addition to the fix for #3188 · 152df24f
      unknown authored
      dropping of tables added to the testcase
      
      
      mysql-test/r/subselect.result:
        result fixed
      mysql-test/t/subselect.test:
        dropping added
      152df24f
  31. 18 Mar, 2004 1 commit
    • unknown's avatar
      Fix for #3188 · 257d8ede
      unknown authored
      mysql-test/r/subselect.result:
        appropriate test result
      mysql-test/t/subselect.test:
        test case
      sql/item.cc:
        we can get NULL here if the field isn't unique
      257d8ede
  32. 16 Mar, 2004 1 commit
  33. 17 Feb, 2004 1 commit
    • unknown's avatar
      revision of fix_fields() calls (BUG2838) · ae7eec92
      unknown authored
      mysql-test/r/subselect.result:
        test suite for BUG#2838
      mysql-test/t/subselect.test:
        test suite for BUG#2838
      sql/item.cc:
        revision of fix_fields() calls
        removed unnecessary variabl, and used correct last parameter of fix_fields()
      sql/item_cmpfunc.cc:
        revision of fix_fields() calls (BUG#2838)
      sql/item_func.cc:
        revision of fix_fields() calls
      sql/item_row.cc:
        changed for efficience (and to be similar for Item_func::fix_fields)
      sql/item_subselect.cc:
        fixed last arguments for fix_fields call
      sql/item_sum.cc:
        layout fixed
        revision of fix_fields() calls
      sql/log_event.cc:
        revision of fix_fields() calls
      sql/set_var.cc:
        revision of fix_fields() calls
      sql/sql_base.cc:
        revision of fix_fields() calls
      sql/sql_class.cc:
        revision of fix_fields() calls
      sql/sql_handler.cc:
        revision of fix_fields() calls
      ae7eec92
  34. 16 Feb, 2004 1 commit
    • unknown's avatar
      After merge fixes · a07e48ec
      unknown authored
      Added more DBUG statements
      Ensure that we are comparing end space with BINARY strings
      Use 'any_db' instead of '' to mean any database. (For HANDLER command)
      Only strip ' ' when comparing CHAR, not other space-like characters (like \t)
      
      
      BitKeeper/deleted/.del-ctype_tis620.result-old~3578ceb0b8284685:
        Delete: mysql-test/r/ctype_tis620.result-old
      BitKeeper/deleted/.del-ctype_tis620.test-old~ffb1bbd2935d1aba:
        Delete: mysql-test/t/ctype_tis620.test-old
      client/mysqlbinlog.cc:
        Added DBUG statements
        Added call of my_end() to free all used memory on exit
      heap/hp_info.c:
        After merge fixes
      heap/hp_open.c:
        After merge fixes
      include/heap.h:
        After merge fixes
      include/m_ctype.h:
        Use pchar instead of 'int' for character parameters.
        Added 'my_binary_compare()'
      include/m_string.h:
        Fixed wrong define
      innobase/ibuf/ibuf0ibuf.c:
        After merge fixes
      innobase/srv/srv0start.c:
        After merge fixes
      mysql-test/r/alter_table.result:
        Fixed results after merge
      mysql-test/r/auto_increment.result:
        Fixed results after merge
      mysql-test/r/bdb.result:
        Fixed results after merge
      mysql-test/r/binary.result:
        Fixed results after merge
      mysql-test/r/create.result:
        Fixed results after merge
      mysql-test/r/ctype_mb.result:
        Fixed results after merge
      mysql-test/r/ctype_tis620.result:
        Fixed results after merge
      mysql-test/r/ctype_utf8.result:
        Fixed results after merge
      mysql-test/r/delete.result:
        Fixed results after merge
      mysql-test/r/func_compress.result:
        Fixed results after merge
      mysql-test/r/func_gconcat.result:
        Fixed results after merge
      mysql-test/r/func_group.result:
        Fixed results after merge
      mysql-test/r/func_str.result:
        Fixed results after merge
      mysql-test/r/innodb.result:
        Fixed results after merge
      mysql-test/r/insert.result:
        Fixed results after merge
      mysql-test/r/insert_select.result:
        Fixed results after merge
      mysql-test/r/key.result:
        Fixed results after merge
      mysql-test/r/loaddata.result:
        Fixed results after merge
      mysql-test/r/lock.result:
        Fixed results after merge
      mysql-test/r/myisam.result:
        Fixed results after merge
      mysql-test/r/null.result:
        Fixed results after merge
      mysql-test/r/null_key.result:
        Fixed results after merge
      mysql-test/r/order_by.result:
        Fixed results after merge
      mysql-test/r/query_cache.result:
        Fixed results after merge
      mysql-test/r/range.result:
        Fixed results after merge
      mysql-test/r/rpl_multi_delete.result:
        Fixed results after merge
      mysql-test/r/rpl_until.result:
        Fixed results after merge
      mysql-test/r/subselect.result:
        Fixed results after merge
      mysql-test/r/subselect_innodb.result:
        Fixed results after merge
      mysql-test/r/type_blob.result:
        Fixed results after merge
      mysql-test/r/type_datetime.result:
        Fixed results after merge
      mysql-test/r/type_decimal.result:
        Fixed results after merge
      mysql-test/r/type_enum.result:
        Fixed results after merge
      mysql-test/r/type_float.result:
        Fixed results after merge
      mysql-test/r/type_ranges.result:
        Fixed results after merge
      mysql-test/r/type_time.result:
        Fixed results after merge
      mysql-test/r/type_timestamp.result:
        Fixed results after merge
      mysql-test/r/type_uint.result:
        Fixed results after merge
      mysql-test/r/type_year.result:
        Fixed results after merge
      mysql-test/r/variables.result:
        Fixed results after merge
      mysql-test/r/warnings.result:
        Fixed results after merge
      mysql-test/t/case.test:
        Fixed shifted error messages
      mysql-test/t/create.test:
        Fixed shifted error messages
      mysql-test/t/ctype_collate.test:
        Fixed shifted error messages
      mysql-test/t/ctype_tis620.test:
        Merge with 4.0 ctype_tis620 test
      mysql-test/t/delete.test:
        Fixed shifted error messages
      mysql-test/t/derived.test:
        Fixed shifted error messages
      mysql-test/t/fulltext.test:
        Fixed shifted error messages
      mysql-test/t/func_in.test:
        Fixed shifted error messages
      mysql-test/t/func_str.test:
        Fixed shifted error messages
      mysql-test/t/func_test.test:
        Fixed shifted error messages
      mysql-test/t/grant.test:
        Fixed shifted error messages
      mysql-test/t/innodb.test:
        Change to 4.1 syntax
      mysql-test/t/key_cache.test:
        Fixed shifted error messages
      mysql-test/t/myisam.test:
        New test of blob and end space
      mysql-test/t/row.test:
        Fixed shifted error messages
      mysql-test/t/rpl_until.test:
        Fixed shifted error messages
      mysql-test/t/subselect.test:
        Fixed shifted error messages
      mysql-test/t/subselect_innodb.test:
        Fix test to take into account foreign key constraints
      mysql-test/t/union.test:
        Fixed shifted error messages
      mysql-test/t/user_var.test:
        Fixed shifted error messages
      mysql-test/t/variables.test:
        Fixed shifted error messages
      mysys/my_handler.c:
        Merge with 4.0 code
      sql/ha_heap.cc:
        After merge fixes
      sql/handler.cc:
        After merge fixes
      sql/item.cc:
        After merge fixes
      sql/item_cmpfunc.cc:
        Ensure that we are comparing end space with BINARY strings
      sql/item_cmpfunc.h:
        Ensure that we are comparing end space with BINARY strings
      sql/log_event.cc:
        More DBUG statements
        Ensure that we use all options to LOAD DATA in replication
      sql/opt_range.cc:
        After merge fixes
      sql/sql_db.cc:
        After merge fixes
      sql/sql_handler.cc:
        After merge fixes
        Use 'any_db' instead of '' to mean 'no database comparison'
      sql/sql_parse.cc:
        After merge fixes
      sql/sql_select.cc:
        After merge fixes
        Added function comment for setup_group()
      sql/sql_string.cc:
        Added stringcmp() for binary comparison.
        Added function comments for sortcmp() and stringcmp()
      sql/sql_string.h:
        Added stringcmp()
      sql/sql_table.cc:
        After merge fixes
      sql/sql_update.cc:
        After merge fixes
      sql/sql_yacc.yy:
        Use 'any_db' instead of '' to mean any database. Using "" causes a 'wrong db name' error.
      strings/ctype-big5.c:
        Strip only end space, not other space characters.
      strings/ctype-bin.c:
        Removed some not needed functions.
        Added function comments
        Don't remove end space in comparisons
        Change my_wildcmp_bin() to be 'identical' with other similar code
      strings/ctype-czech.c:
        Strip only end space, not other space characters.
      strings/ctype-gbk.c:
        Strip only end space, not other space characters.
      strings/ctype-latin1.c:
        Strip only end space, not other space characters.
      strings/ctype-mb.c:
        Strip only end space, not other space characters.
      strings/ctype-simple.c:
        Strip only end space, not other space characters.
      strings/ctype-sjis.c:
        Strip only end space, not other space characters.
      strings/ctype-tis620.c:
        Added usage of my_instr_simple. This needs to be cleaned up!
      strings/ctype-utf8.c:
        Strip only end space, not other space characters.
      strings/ctype-win1250ch.c:
        Strip only end space, not other space characters.
        Fixed indentation
      strings/strto.c:
        Code cleanup
      a07e48ec
  35. 14 Feb, 2004 1 commit
  36. 09 Feb, 2004 1 commit
    • unknown's avatar
      Added --compact to mysqlbinlog · 35b1f544
      unknown authored
      Fixed output from mysqlbinlog when using --skip-comments
      Fixed warnings from valgrind
      Fixed ref_length when used with HEAP tables
      More efficent need_conversion()
      Fixed error handling in UPDATE with not updateable tables
      Fixed bug in null handling in CAST to signed/unsigned
      
      
      
      client/client_priv.h:
        cleanup & added OPT_COMPACT
      client/mysqldump.c:
        Added option --compact to get a compact readable dump.
        Ensure that SET CHARACTER_SET_CLIENT is not done if we have not remembered the old character set
        Print optimization comments even if --skip-comments are given as these are not true comments. (Before these where only printed at end, which was a bug)
      mysql-test/r/cast.result:
        More cast tests
      mysql-test/r/derived.result:
        Removed warnings
      mysql-test/r/mysqldump.result:
        Update results after fixing mysqlbinlog
      mysql-test/r/query_cache.result:
        Make test usable with --extern
        more tests
      mysql-test/r/rpl_until.result:
        Make test repeatable under valgrind
      mysql-test/r/sql_mode.result:
        Fix test result
      mysql-test/r/subselect.result:
        Make test smaller. Update wrong results
      mysql-test/t/cast.test:
        More cast tests
      mysql-test/t/derived.test:
        Removed warnings
      mysql-test/t/query_cache.test:
        Make test usable with --extern
        more tests
      mysql-test/t/rpl_until.test:
        fix for valgrind.  Becasue of unknown reason one got 'Slave_SQL_Running=yes' in this setup
      mysql-test/t/subselect.test:
        Make test case smaller
      sql/field.cc:
        Updated need_conversion() to use new arguments
      sql/ha_heap.cc:
        Moved initialization of ref_length to right place. This fixed problem that we had a ref_length of 8 for heap tables, which was not efficent.
      sql/item_func.cc:
        Cleanup
      sql/item_func.h:
        Fixed bug in null_handling for cast to signed/unsigned
      sql/item_strfunc.cc:
        Optimized/cleaned up Item_func_conv_charset3
      sql/item_sum.cc:
        Cleanup.
        Ensure that some flag variables are cleared in cleanup()
      sql/item_sum.h:
        Fixed references to uninitialized memory
      sql/opt_range.cc:
        Fixed spelling error
      sql/sql_class.cc:
        Fixed wrong return code, which could case protocol problems
      sql/sql_class.h:
        After merge fix
      sql/sql_prepare.cc:
        Added comments
      sql/sql_show.cc:
        Cleanup
      sql/sql_string.cc:
        Optimzed usage of need_conversion().
        - Removed not used argument
        - Save diff lenght in 'offset' to not have to recalculate length several times.
        Cleaned up comment
        Optimized copy_aligned() based on the knowledge that it's only called when you have wrong data
      sql/sql_string.h:
        Updated need_conversion() and copy_aligned() to use new arguments
      sql/sql_update.cc:
        Fixed error handling with non-updateable tables
      sql/sql_yacc.yy:
        Ensure that lex->lock_options are set correctly (to get rid of warnings from valgrind)
        Ensure that cast_type sets lex->charset and lex->length. Without these CONVERT() didn't work properly
      35b1f544
  37. 05 Feb, 2004 1 commit
    • unknown's avatar
      correct processing of rand() in subqueries with static tables (BUG#2645) · 76f8bceb
      unknown authored
      mysql-test/r/subselect.result:
        test of execution plan of subqueries with static tables and rand()
      mysql-test/t/subselect.test:
        test of execution plan of subqueries with static tables and rand()
      sql/item_func.cc:
        use normal Item_func mechanism to report used tables
      sql/item_func.h:
        use normal Item_func mechanism to report used tables
      sql/sql_select.cc:
        correct processing of rand() in subqueries with static tables
      76f8bceb
  38. 04 Feb, 2004 1 commit
    • unknown's avatar
      correct assignment of default limit (BUG#2600) · fc248069
      unknown authored
      mysql-test/r/subselect.result:
        test of global limit and subqueries
      mysql-test/t/subselect.test:
        test of global limit and subqueries
      sql/sql_lex.cc:
        correct detection of non-default limits
      sql/sql_parse.cc:
        correct assignment of default limit
      sql/sql_yacc.yy:
        correct assignment of default limit
      fc248069