An error occurred fetching the project authors.
  1. 07 May, 2007 1 commit
    • unknown's avatar
      Bug#28133: Wrong DATE/DATETIME comparison in IN() function. · 0fd2b3dd
      unknown authored
      The IN function was comparing DATE/DATETIME values either as ints or as
      strings. Both methods have their disadvantages and may lead to a wrong
      result.
      
      Now IN function checks whether all of its arguments has the STRING result
      types and at least one of them is a DATE/DATETIME item. If so it uses either
      an object of the in_datetime class or an object of the cmp_item_datetime
      class to perform its work. If the IN() function arguments are rows then
      row columns are checked whether the DATE/DATETIME comparator should be used
      to compare them.
      The in_datetime class is used to find occurence of the item to be checked
      in the vector of the constant DATE/DATETIME values. The cmp_item_datetime
      class is used to compare items one by one in the DATE/DATETIME context.
      Both classes obtain values from items with help of the get_datetime_value()
      function and cache the left item if it is a constant one.
      
      
      
      mysql-test/t/type_datetime.test:
        Added a test case for the bug#28133: Wrong DATE/DATETIME comparison in IN() function.
      mysql-test/r/type_datetime.result:
        Added a test case for the bug#28133: Wrong DATE/DATETIME comparison in IN() function.
      mysql-test/r/func_in.result:
        A test case result is corrected after the fix for the bug#28133.
      sql/item_cmpfunc.h:
        Bug#28133: Wrong DATE/DATETIME comparison in IN() function.
        Two DATE/DATETIME comparison classes are added.
        The in_datetime class is used to find occurence of the item to be checked
        in the vector of the constant DATE/DATETIME values. The cmp_item_datetime
        class is used to compare items one by one in the DATE/DATETIME context.
        Both classes obtain values from items with help of the get_datetime_value()
        function and cache the left item if it is a constant one.
      sql/item_cmpfunc.cc:
        Bug#28133: Wrong DATE/DATETIME comparison in IN() function.
        Now IN function checks whether all of its arguments has the STRING result
        types and at least one of them is a DATE/DATETIME item. If so it uses either
        an object of the in_datetime class or an object of the cmp_item_datetime
        class to perform its work. If the IN() function arguments are rows then
        row columns are checked whether the DATE/DATETIME comparator should be used
        to compare them.
      0fd2b3dd
  2. 22 Mar, 2007 1 commit
    • unknown's avatar
      Fixed bug #27362: crash at evaluation of IN predicate when one · a4a23fb9
      unknown authored
      of its argument happened to be a decimal expression returning
      the NULL value.
      The crash was due to the fact the function in_decimal::set did
      not take into account that val_decimal() could return 0 if 
      the decimal expression had been evaluated to NULL.  
      
      
      mysql-test/r/func_in.result:
        Added a test case for bug #27362.
      mysql-test/t/func_in.test:
        Added a test case for bug #27362.
      a4a23fb9
  3. 08 Mar, 2007 1 commit
  4. 06 Mar, 2007 1 commit
  5. 02 Mar, 2007 1 commit
    • unknown's avatar
      Bug #19342: · b114118a
      unknown authored
      Several problems here :
       1. The conversion to double of an hex string const item
       was not taking into account the unsigned flag.
       
       2. IN was not behaving in the same was way as comparisons
       when performed over an INT/DATE/DATETIME/TIMESTAMP column
       and a constant. The ordinary comparisons in that case 
       convert the constant to an INTEGER value and do int 
       comparisons. Fixed the IN to do the same.
       
       3. IN is not taking into account the unsigned flag when 
       calculating <expr> IN (<int_const1>, <int_const2>, ...).
       Extended the implementation of IN to store and process
       the unsigned flag for its arguments.
      
      
      mysql-test/r/func_in.result:
        Bug #19342: test case
      mysql-test/t/func_in.test:
        Bug #19342: test case
      sql/item.h:
        Bug #19342: correct handling of sign in conersion to real.
      sql/item_cmpfunc.cc:
        Bug #19342: exteneded the IN values list
         to support unsigned longlong values.
         Correct comparison of integers in IN with
         regard of signedness.
         Compare DATE/DATETIME/TIMESTAMP values as
         integers in IN.
      sql/item_cmpfunc.h:
        Bug #19342: exteneded the IN values list
         to support unsigned longlong values.
         Correct comparison of integers in IN with
         regard of signedness.
      b114118a
  6. 16 Feb, 2007 1 commit
    • unknown's avatar
      BUG#20420: optimizer reports wrong keys on left join with IN · 652a090a
      unknown authored
       When checking if an IN predicate can be evaluated using a key
       the optimizer makes sure that all the arguments of IN are of
       the same result type. To assure that it check whether 
       Item_func_in::array is filled in. 
       However Item_func_in::array is set if the types are
       the same AND all the arguments are compile time constants.
       Fixed by introducing Item_func_in::arg_types_compatible
       flag to allow correct checking of the desired condition.
      
      
      mysql-test/r/func_in.result:
        BUG#20420: optimizer reports wrong keys on left join with IN
         - reenabled the test case
      mysql-test/t/func_in.test:
        BUG#20420: optimizer reports wrong keys on left join with IN
         - reenabled the test case
      sql/item_cmpfunc.cc:
        BUG#20420: optimizer reports wrong keys on left join with IN
         Check the IN argument types in a correct way
      sql/item_cmpfunc.h:
        BUG#20420: optimizer reports wrong keys on left join with IN
         Check the IN argument types in a correct way
      sql/opt_range.cc:
        BUG#20420: optimizer reports wrong keys on left join with IN
         Check the IN argument types in a correct way
      652a090a
  7. 24 Jan, 2007 1 commit
  8. 15 Jan, 2007 1 commit
    • unknown's avatar
      BUG#20420: optimizer reports wrong keys on left join with IN · a2ae17b1
      unknown authored
       The optimizer needs to evaluate whether predicates are better
       evaluated using an index. IN is one such predicate.
       To qualify an IN predicate must involve a field of the index
       on the left and constant arguments on the right.
       However whether an expression is a constant can be determined only
       by knowing the preceding tables in the join order. 
       Assuming that only IN predicates with expressions on the right that
       are constant for the whole query qualify limits the scope of 
       possible optimizations of the IN predicate (more specifically it
       doesn't allow the "Range checked for each record" optimization for
       such an IN predicate.
       Fixed by not pre-determining the optimizability of the IN predicate
       in the case when all right IN operands are not SQL constant expressions
      
      
      mysql-test/r/func_in.result:
        BUG#20420: optimizer reports wrong keys on left join with IN
         - test case
      mysql-test/t/func_in.test:
        BUG#20420: optimizer reports wrong keys on left join with IN
         - test case
      sql/item_cmpfunc.h:
        BUG#20420: optimizer reports wrong keys on left join with IN
         - cannot decide on the optimizability of a function without
           knowing the tables before it in the join order
      a2ae17b1
  9. 29 Nov, 2006 1 commit
  10. 27 Nov, 2006 1 commit
    • unknown's avatar
      Fix for bug #24261 "crash when WHERE contains NOT IN ('<negative value>') for unsigned column type" · 2e758a7c
      unknown authored
      When calculating a SEL_TREE for the "c_{i-1} < X < c_i" interval, check if the tree returned for the "-inf < X < c_0" interval is NULL
      
      
      mysql-test/r/func_in.result:
        Added testcase for bug #24261 "crash when WHERE contains NOT IN ('<negative value>') for unsigned column type"
      mysql-test/t/func_in.test:
        Added testcase for bug #24261 "crash when WHERE contains NOT IN ('<negative value>') for unsigned column type"
      sql/opt_range.cc:
        When calculating a SEL_TREE for the "c_{i-1} < X < c_i" interval, check if the tree returned for the "-inf < X < c_0" interval is NULL
      2e758a7c
  11. 16 Nov, 2006 1 commit
    • unknown's avatar
      BUG#17047: CHAR() and IN() can return NULL without signaling NULL result · e40e8052
      unknown authored
      The problem was that some functions (namely IN() starting with 4.1, and
      CHAR() starting with 5.0) were returning NULL in certain conditions,
      while they didn't set their maybe_null flag.  Because of that there could
      be some problems with 'IS NULL' check, and statements that depend on the
      function value domain, like CREATE TABLE t1 SELECT 1 IN (2, NULL);.
      
      The fix is to set maybe_null correctly.
      
      
      mysql-test/r/func_in.result:
        Add result for bug#17047: CHAR() and IN() can return NULL without
        signaling NULL result.
      mysql-test/t/func_in.test:
        Add test case for bug#17047: CHAR() and IN() can return NULL without
        signaling NULL result.
      sql/item_cmpfunc.cc:
        Remove assignment to maybe_null, as it was already set in fix_fields()
        based on all arguments, not only on the first.
      e40e8052
  12. 26 Sep, 2006 1 commit
    • unknown's avatar
      Fixed bug #18360: Type aggregation for IN and CASE may lead to a wrong · c1bbfb2b
      unknown authored
      result
      
      The IN function aggregates result types of all expressions. It uses that 
      type in comparison of left expression and expressions in right part. 
      This approach works in most cases. But let's consider the case when the
      right part contains both strings and integers. In that case this approach may
      cause wrong results because all strings which do not start with a digit are
      evaluated as 0.
      CASE uses the same approach when a CASE expression is given thus it's also
      affected.
      
      The idea behind this fix is to make IN function to compare expressions with
      different result types differently. For example a string in the left
      part will be compared as string with strings specified in right part and
      will be converted to real for comparison to int or real items in the right
      part.
      
      A new function called collect_cmp_types() is added. It collects different
      result types for comparison of first item in the provided list with each 
      other item in the list. 
      
      The Item_func_in class now can refer up to 5 cmp_item objects: 1 for each
      result type for comparison purposes. cmp_item objects are allocated according
      to found result types. The comparison of the left expression with any
      right part expression is now based only on result types of these expressions.
      
      The Item_func_case class is modified in the similar way when a CASE
      expression is specified. Now it can allocate up to 5 cmp_item objects
      to compare CASE expression with WHEN expressions of different types.
      The comparison of the CASE expression with any WHEN expression now based only 
      on result types of these expressions.
      
      
      
      sql/item.cc:
        Cleaned up an outdated comment.
      sql/item_cmpfunc.cc:
            Fixed bug #18360: Type aggregation for IN and CASE may lead to a wrong result
            A new function called collect_cmp_types() is added. It collects different
            result types for comparison of first item in the provided list with each 
            other item in the list. 
            The Item_func_in class now can refer up to 5 cmp_item objects: 1 for each
            result type for comparison purposes. cmp_item objects are allocated according
            to found result types. The comparison of the left expression with any
            right part expression is now based only on result types of these expressions.
            The Item_func_case class is modified in the similar way when a CASE
            expression is specified. Now it can allocate up to 5 cmp_item objects
            to compare CASE expression with WHEN expressions of different types.
            The comparison of the CASE expression with any WHEN expression now based only 
            on result types of these expressions.
      sql/item_cmpfunc.h:
            Fixed bug#18360: Type aggregation for IN and CASE may lead to a wrong result
            The Item_func_in class now can refer up to 5 cmp_item objects.
            The Item_func_case class is modified in the similar way.
      sql/opt_range.cc:
            Fixed bug #18360: Type aggregation for IN and CASE may lead to a wrong
            resultSmall code changes due to changes in Item_func_in class.
      mysql-test/t/view.test:
        Added a test comment
      mysql-test/t/func_in.test:
        Added a test case for bug#18360: Type aggregation for IN and CASE may lead to a wrong
        result
      mysql-test/r/func_in.result:
        Added a test case for bug#18360: Type aggregation for IN and CASE may lead to a wrong
        result
      c1bbfb2b
  13. 28 Jul, 2006 1 commit
    • unknown's avatar
      BUG#14940 "MySQL choose wrong index", v.2 · ef452e19
      unknown authored
      - Make the range-et-al optimizer produce E(#table records after table 
                                                 condition is applied),
      - Make the join optimizer use this value,
      - Add "filtered" column to EXPLAIN EXTENDED to show 
        fraction of records left after table condition is applied
      - Adjust test results, add comments
      
      
      mysql-test/r/archive_gis.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/auto_increment.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/bdb_gis.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/bench_count_distinct.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/binlog_stm_blackhole.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/case.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/cast.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/compress.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/ctype_collate.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/ctype_cp1250_ch.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/date_formats.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/distinct.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/fulltext.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/func_compress.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/func_crypt.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/func_default.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/func_encrypt.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/func_gconcat.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/func_group.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/func_if.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/func_in.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/func_like.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/func_math.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/func_op.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/func_regexp.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/func_set.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/func_str.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/func_system.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/func_test.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/func_time.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/gis.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/group_by.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/group_min_max.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/having.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/heap.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/heap_hash.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/index_merge.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/index_merge_innodb.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/index_merge_ror.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/innodb_gis.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/insert_update.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/join.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/join_nested.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/key_diff.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/myisam.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/ndb_gis.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/negation_elimination.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/null.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/olap.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/partition_pruning.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/query_cache.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/row.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/rpl_get_lock.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/rpl_master_pos_wait.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/select.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/ssl.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/ssl_compress.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/subselect.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/type_blob.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/union.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/varbinary.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/variables.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/view.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/t/ctype_cp1250_ch.test:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/t/func_like.test:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/t/group_min_max.test:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/t/index_merge_ror.test:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/t/index_merge_ror_cpk.test:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/t/join.test:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/t/partition_pruning.test:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      sql/opt_range.cc:
        BUG#14940: Make range/index_merge/group-min-max optimizer produce TABLE::quick_condition_rows -
          estimate of #records that will match the table condition.
      sql/sql_class.cc:
        BUG#14940: Add "filtered" column to output of EXPLAIN EXTENDED
      sql/sql_select.cc:
        BUG#14940: 
        - Make the join optimizer to use TABLE::quick_condition_rows=
          = E(#table records after filtering with table condition) 
        - Add "filtered" column to output of EXPLAIN EXTENDED
      sql/sql_select.h:
        BUG#14940: Added comments
      sql/table.h:
        BUG#14940: Added comments
      ef452e19
  14. 19 Jun, 2006 1 commit
    • unknown's avatar
      item_cmpfunc.cc, func_in.result, func_in.test: · 028fa1e4
      unknown authored
        Reverted fix for bug#18360
      
      
      mysql-test/t/func_in.test:
        Reverted fix for bug#18360
      mysql-test/r/func_in.result:
        Reverted fix for bug#18360
      sql/item_cmpfunc.cc:
        Reverted fix for bug#18360
      028fa1e4
  15. 30 May, 2006 1 commit
  16. 29 May, 2006 1 commit
    • unknown's avatar
      Fixed bug#18360: Incorrect type coercion in IN() results in false comparison · c007daba
      unknown authored
      The IN() function uses agg_cmp_type() to aggregate all types of its arguments
      to find out some common type for comparisons. In this particular case the 
      char() and the int was aggregated to double because char() can contain values
      like '1.5'. But all strings which do not start from a digit are converted to
      0. thus 'a' and 'z' become equal. 
      This behaviour is reasonable when all function arguments are constants. But 
      when there is a field or an expression this can lead to false comparisons. In
      this case it makes more sense to coerce constants to the type of the field
      argument.
      
      The agg_cmp_type() function now aggregates types of constant and non-constant
      items separately. If some non-constant items will be found then their
      aggregated type will be returned. Thus after the aggregation constants will be
      coerced to the aggregated type. 
      
      
      mysql-test/t/func_in.test:
        Added test case for bug#18360: Incorrect type coercion in IN() results in false comparison.
      mysql-test/r/func_in.result:
        Added test case for bug#18360: Incorrect type coercion in IN() results in false comparison.
      sql/item_cmpfunc.cc:
        Fixed bug#18360: Incorrect type coercion in IN() results in false comparison.
        The agg_cmp_type() function now aggregates types of constant and non-constant
        items separately. If some non-constant items will be found then their
        aggregated type will be returned. Thus after the aggregation constants will
        be coerced to the aggregated type.
      c007daba
  17. 15 May, 2006 1 commit
    • unknown's avatar
      BUG#19618: Crash for unsigned_col NOT IN (-1, ... ) · e5838e16
      unknown authored
      - When manually constructing a SEL_TREE for "t.key NOT IN(...)", take into account that 
        get_mm_parts may return a tree with type SEL_TREE::IMPOSSIBLE
      - Added missing OOM checks
      - Added comments
      
      
      mysql-test/r/func_in.result:
        Testcase for BUG#19618
      mysql-test/t/func_in.test:
        Testcase for BUG#19618
      e5838e16
  18. 25 Apr, 2006 1 commit
    • unknown's avatar
      BUG#15872: Don't run the range analyzer on "t1.keypart NOT IN (const1, ..., )", as that consumes · 15e00f1f
      unknown authored
      too much memory. Instead, either create the equvalent SEL_TREE manually, or create only two ranges that
      strictly include the area to scan
      (Note: just to re-iterate: increasing NOT_IN_IGNORE_THRESHOLD will make optimization run slower for big 
      IN-lists, but the server will not run out of memory. O(N^2) memory use has been eliminated)
      
      
      mysql-test/r/func_in.result:
        Testcase for BUG#15872
      mysql-test/t/func_in.test:
        Testcase for BUG#15872
      sql/item.cc:
        BUG#15872: Added Item_decimal::set_decimal_value()
      sql/item.h:
        UG#15872: Added Item_decimal::set_decimal_value()
      sql/item_cmpfunc.h:
        BUG#15872: Added in_vector::create_item(), in_vector::value_to_item() and their implementations in concrete
        classes.
      sql/opt_range.cc:
        BUG#15872: Don't run the range analyzer on "t1.keypart NOT IN (const1, ..., )", as that 
        consumes too much memory. Instead, either 
         A) create the equivalent SEL_TREE manually, making use of the fact that item_not_in->array
            has an ordered IN-list, or
         B) create only two ranges: (-inf|NULL) < X < min_value_from_in_list,  max_value_from_in_list < X
        (Choose #B if the IN-list has > 10K elements)
      15e00f1f
  19. 13 Oct, 2005 1 commit
    • unknown's avatar
      type_binary.result, type_binary.test: · 60e411eb
      unknown authored
        new file
      mysql_fix_privilege_tables.sql, mysql_create_system_tables.sh:
        Adding true BINARY/VARBINARY: fixing "password" type, not to be 0x00-padding.
      Many files:
        Adding true BINARY/VARBINARY: fixing tests not to output 0x00 bytes.
        Adding true BINARY/VARBINARY: new pad_char structure member.
      ctype-bin.c:
        Adding true BINARY/VARBINARY: new pad_char structure member.
        New strnxfrm, with two trailing length bytes.
      field.cc:
        Adding true BINARY/VARBINARY.
      
      
      sql/field.cc:
        Adding true BINARY/VARBINARY.
      strings/ctype-big5.c:
        Adding true BINARY/VARBINARY: new pad_char structure member.
      strings/ctype-bin.c:
        Adding true BINARY/VARBINARY: new pad_char structure member.
        New strnxfrm, with two trailing length bytes.
      strings/ctype-cp932.c:
        Adding true BINARY/VARBINARY: new pad_char structure member.
      strings/ctype-czech.c:
        Adding true BINARY/VARBINARY: new pad_char structure member.
      strings/ctype-euc_kr.c:
        Adding true BINARY/VARBINARY: new pad_char structure member.
      strings/ctype-eucjpms.c:
        Adding true BINARY/VARBINARY: new pad_char structure member.
      strings/ctype-extra.c:
        Adding true BINARY/VARBINARY: new pad_char structure member.
      strings/ctype-gb2312.c:
        Adding true BINARY/VARBINARY: new pad_char structure member.
      strings/ctype-gbk.c:
        Adding true BINARY/VARBINARY: new pad_char structure member.
      strings/ctype-latin1.c:
        Adding true BINARY/VARBINARY: new pad_char structure member.
      strings/ctype-simple.c:
        Adding true BINARY/VARBINARY: new pad_char structure member.
      strings/ctype-sjis.c:
        Adding true BINARY/VARBINARY: new pad_char structure member.
      strings/ctype-tis620.c:
        Adding true BINARY/VARBINARY: new pad_char structure member.
      strings/ctype-uca.c:
        Adding true BINARY/VARBINARY: new pad_char structure member.
      strings/ctype-ucs2.c:
        Adding true BINARY/VARBINARY: new pad_char structure member.
      strings/ctype-ujis.c:
        Adding true BINARY/VARBINARY: new pad_char structure member.
      strings/ctype-utf8.c:
        Adding true BINARY/VARBINARY: new pad_char structure member.
      strings/ctype-win1250ch.c:
        Adding true BINARY/VARBINARY: new pad_char structure member.
      include/m_ctype.h:
        Adding true BINARY/VARBINARY: new pad_char structure member.
      mysql-test/t/alter_table.test:
        Adding true BINARY/VARBINARY: fixing tests not to output 0x00 bytes.
      mysql-test/t/binary.test:
        Adding true BINARY/VARBINARY: fixing tests not to output 0x00 bytes.
      mysql-test/t/cast.test:
        Adding true BINARY/VARBINARY: fixing tests not to output 0x00 bytes.
      mysql-test/t/ctype_cp1251.test:
        Adding true BINARY/VARBINARY: fixing tests not to output 0x00 bytes.
      mysql-test/t/ctype_many.test:
        Adding true BINARY/VARBINARY: fixing tests not to output 0x00 bytes.
      mysql-test/t/federated.test:
        Adding true BINARY/VARBINARY: fixing tests not to output 0x00 bytes.
      mysql-test/t/func_in.test:
        Adding true BINARY/VARBINARY: fixing tests not to output 0x00 bytes.
      mysql-test/t/ndb_condition_pushdown.test:
        Adding true BINARY/VARBINARY: fixing tests not to output 0x00 bytes.
      mysql-test/t/ndb_types.test:
        Adding true BINARY/VARBINARY: fixing tests not to output 0x00 bytes.
      mysql-test/t/sp.test:
        Adding true BINARY/VARBINARY: fixing tests not to output 0x00 bytes.
      mysql-test/t/type_blob.test:
        Adding true BINARY/VARBINARY: fixing tests not to output 0x00 bytes.
      mysql-test/r/alter_table.result:
        Adding true BINARY/VARBINARY: fixing tests not to output 0x00 bytes.
      mysql-test/r/binary.result:
        Adding true BINARY/VARBINARY: fixing tests not to output 0x00 bytes.
      mysql-test/r/cast.result:
        Adding true BINARY/VARBINARY: fixing tests not to output 0x00 bytes.
      mysql-test/r/ctype_cp1251.result:
        Adding true BINARY/VARBINARY: fixing tests not to output 0x00 bytes.
      mysql-test/r/ctype_many.result:
        Adding true BINARY/VARBINARY: fixing tests not to output 0x00 bytes.
      mysql-test/r/federated.result:
        Adding true BINARY/VARBINARY: fixing tests not to output 0x00 bytes.
      mysql-test/r/func_in.result:
        Adding true BINARY/VARBINARY: fixing tests not to output 0x00 bytes.
      mysql-test/r/ndb_condition_pushdown.result:
        Adding true BINARY/VARBINARY: fixing tests not to output 0x00 bytes.
      mysql-test/r/ndb_types.result:
        Adding true BINARY/VARBINARY: fixing tests not to output 0x00 bytes.
      mysql-test/r/sp.result:
        Adding true BINARY/VARBINARY: fixing tests not to output 0x00 bytes.
      mysql-test/r/system_mysql_db.result:
        Adding true BINARY/VARBINARY: fixing tests not to output 0x00 bytes.
      mysql-test/r/type_blob.result:
        Adding true BINARY/VARBINARY: fixing tests not to output 0x00 bytes.
      scripts/mysql_create_system_tables.sh:
        Adding true BINARY/VARBINARY: fixing "password" type, not to be 0x00-padding.
      scripts/mysql_fix_privilege_tables.sql:
        Adding true BINARY/VARBINARY: fixing "password" type, not to be 0x00-padding.
      60e411eb
  20. 23 Sep, 2005 1 commit
    • unknown's avatar
      Fix for BUG#13419: In "ref" optimizer, take into account that item=Item_func_in(x,y) is · 32de9735
      unknown authored
      not equivalent to "x=y" when item->negated == TRUE.
      
      
      mysql-test/r/func_in.result:
        Testcase for BUG#13419
      mysql-test/t/func_in.test:
        Testcase for BUG#13419
      sql/sql_select.cc:
        Fix for BUG#13419:
        * Take into account that item=Item_func_in(x,y) is not equivalent to "x=y" when 
          item->negated == TRUE.
        * Removed comment that is no longer true.
      32de9735
  21. 14 Sep, 2005 2 commits
    • unknown's avatar
      postmerge fix · 98b6fd87
      unknown authored
      98b6fd87
    • unknown's avatar
      part 1 (ver 2, postreview fix) of WL#2787 · f7aeb6f9
      unknown authored
      view definer information syntax/storage/replication
      fixed SOURCE field of .frm
      
      
      mysql-test/r/func_in.result:
        definer information added to CREATE VIEW
      mysql-test/r/lowercase_view.result:
        definer information added to CREATE VIEW
      mysql-test/r/mysqldump.result:
        definer information added to CREATE VIEW
      mysql-test/r/rpl_view.result:
        check log of queries
      mysql-test/r/skip_grants.result:
        --skip-grants do not allow use user information
      mysql-test/r/sql_mode.result:
        definer information added to CREATE VIEW
      mysql-test/r/temp_table.result:
        definer information added to CREATE VIEW
      mysql-test/r/view.result:
        definer information added to CREATE VIEW
        test of storing/restoring definer information
      mysql-test/r/view_grant.result:
        test of grant check of definer information
        definer information added to CREATE VIEW
      mysql-test/t/rpl_view.test:
        check log of queries
      mysql-test/t/skip_grants.test:
        --skip-grants do not allow use user information
      mysql-test/t/view.test:
        test of storing/restoring definer information
      mysql-test/t/view_grant.test:
        test of grant check of definer information
      sql/mysql_priv.h:
        CREATE/ALTER VIEW print support
        set current user as definer procedure
      sql/share/errmsg.txt:
        new errors/warnings
      sql/sql_acl.cc:
        make find_acl_user public to allow to check user
      sql/sql_acl.h:
        make find_acl_user public to allow to check user
      sql/sql_lex.h:
        storing definer information
      sql/sql_parse.cc:
        send CREATE/ALTER VIEW for replication with full list of options
        set current user as definer procedure
      sql/sql_show.cc:
        new CREATE VIEW options printed
      sql/sql_view.cc:
        check of definer clause
        changes in .frm file
        definer information storage support
        now we store only original SELECT in SOURCE field of .frm
      sql/sql_yacc.yy:
        definer information sintax support
        getting SOURCE field information for .frm
      sql/table.h:
        definer information storage
      f7aeb6f9
  22. 13 Sep, 2005 1 commit
    • unknown's avatar
      BUG#10713 mysqldump includes database in create view and referenced tables · 2761c648
      unknown authored
       - Update test results
       - Updates after review
      
      
      mysql-test/r/func_in.result:
        Update test results
      mysql-test/r/lowercase_view.result:
        Update test results
      mysql-test/r/mysqldump.result:
        Update test results
      mysql-test/r/sql_mode.result:
        Update test results
      mysql-test/r/temp_table.result:
        Update test results
      mysql-test/r/view.result:
        Update test results
      mysql-test/t/mysqldump.test:
        Update test results
      sql/sql_show.cc:
        Updated after review
      2761c648
  23. 17 Jul, 2005 1 commit
    • unknown's avatar
      func_in.result, func_in.test: · e155a0c0
      unknown authored
        Fixed bug #11885.
      sql_select.cc:
        Fixed bug #11885.
        Predicates of the forms 'a IN (v)' 'a NOT IN (v)' now
        is replaced by 'a=v' and 'a<>v' at the parsing stage.
      sql_yacc.yy:
        Fixed bug #11885.
        Predicates of the forms 'a IN (v)' 'a NOT IN (v)' now 
        is replaced by 'a=v' and 'a<>v' at the parsing stage.
      
      
      sql/sql_yacc.yy:
        Fixed bug #11885.
        Predicates of the forms 'a IN (v)' 'a NOT IN (v) now 
        is replaced by 'a=v' and 'a<>v' at the parsing stage.
      sql/sql_select.cc:
        Fixed bug #11885.
        Predicates of the forms 'a IN (v)' 'a NOT IN (v) now
        is replaced by 'a=v' and 'a<>v' at the parsing stage.
      mysql-test/t/func_in.test:
        Fixed bug #11885.
      mysql-test/r/func_in.result:
        Fixed bug #11885.
      e155a0c0
  24. 20 Jan, 2005 1 commit
    • unknown's avatar
      item_cmpfunc.cc: · 9241e345
      unknown authored
        Bug#7834 Illegal mix of collations in IN operator
        IN was the first function supporting 
        character set convertion.
        agg_arg_charsets() was written afterwards,
        which is more flexible.
        Now IN just reuses this function.
      
      
      sql/item_cmpfunc.cc:
        Bug#7834 Illegal mix of collations in IN operator
        IN was the first function supporting 
        character set convertion.
        agg_arg_charsets() was written afterwards,
        which is more flexible.
        Now IN just reuses this function.
      9241e345
  25. 05 Nov, 2004 1 commit
    • unknown's avatar
      func_in.result, func_in.test: · 62ded37e
      unknown authored
        Added a case for bug #6365.
      item_cmpfunc.cc:
        Fixed bug #6365 : Server crashed when list of values
        in IN predicate contains NULL while the tested field is
        of the character type and not of the default set;
        e.g. when f in 'f IN (NULL,'aa') belongs to binary
        character set, while the default character set is latin1.
      
      
      sql/item_cmpfunc.cc:
        Fixed bug #6365 : Server crash when list of values
        in IN predicate contains NULL while the tested field is
        of the character type of not of the default set
        e.g. when f in 'f IN (NULL,'aa') belongs to binary
        character set, while the default character set is latin1.
      mysql-test/t/func_in.test:
        Added a case for bug #6365.
      mysql-test/r/func_in.result:
        Added a case for bug #6365.
      62ded37e
  26. 01 Sep, 2004 1 commit
  27. 31 Aug, 2004 1 commit
    • unknown's avatar
      fixed open_and_lock_tables result processing (all open_and_lock_tables revision) · 6e314e04
      unknown authored
      fixed printing of COLLATE operation
      (BUG#5155)
      
      
      mysql-test/r/case.result:
        fixed printing of COLLATE operation
      mysql-test/r/func_if.result:
        fixed printing of COLLATE operation
      mysql-test/r/func_in.result:
        fixed printing of COLLATE operation
      mysql-test/r/func_str.result:
        fixed printing of COLLATE operation
      mysql-test/r/func_test.result:
        fixed printing of COLLATE operation
      mysql-test/r/view.result:
        VIEW with collation
      mysql-test/t/view.test:
        VIEW with collation
      sql/item_strfunc.cc:
        fixed printing of COLLATE operation
      sql/item_strfunc.h:
        fixed printing of COLLATE operation
      sql/sp_head.cc:
        fixed open_and_lock_tables result processing
      sql/sql_base.cc:
        fixed open_and_lock_tables result processing
      sql/sql_delete.cc:
        fixed open_and_lock_tables result processing
      sql/sql_help.cc:
        fixed open_and_lock_tables result processing
      sql/sql_load.cc:
        fixed open_and_lock_tables result processing
      sql/sql_parse.cc:
        fixed open_and_lock_tables result processing
      sql/sql_prepare.cc:
        fixed open_and_lock_tables result processing
      sql/sql_show.cc:
        fixed open_and_lock_tables result processing
      sql/sql_update.cc:
        fixed open_and_lock_tables result processing
      6e314e04
  28. 20 Jul, 2004 1 commit
    • unknown's avatar
      mark subquery in the FROM clause like derived and quoate all identifiers (BUG#4609) · ec33aa2b
      unknown authored
      mysql-test/r/bench_count_distinct.result:
        Quoting of fields and tables names
      mysql-test/r/case.result:
        Quoting of fields and tables names
      mysql-test/r/fulltext.result:
        Quoting of fields and tables names
      mysql-test/r/func_default.result:
        Quoting of fields and tables names
      mysql-test/r/func_gconcat.result:
        Quoting of fields and tables names
      mysql-test/r/func_group.result:
        Quoting of fields and tables names
      mysql-test/r/func_if.result:
        Quoting of fields and tables names
      mysql-test/r/func_in.result:
        Quoting of fields and tables names
      mysql-test/r/func_regexp.result:
        Quoting of fields and tables names
      mysql-test/r/func_test.result:
        Quoting of fields and tables names
      mysql-test/r/gis.result:
        Quoting of fields and tables names
      mysql-test/r/group_by.result:
        Quoting of fields and tables names
      mysql-test/r/having.result:
        Quoting of fields and tables names
      mysql-test/r/insert_update.result:
        Quoting of fields and tables names
      mysql-test/r/join_nested.result:
        Quoting of fields and tables names
      mysql-test/r/olap.result:
        Quoting of fields and tables names
      mysql-test/r/query_cache.result:
        Quoting of fields and tables names
      mysql-test/r/select.result:
        Quoting of fields and tables names
      mysql-test/r/subselect.result:
        Quoting of fields and tables names
      mysql-test/r/union.result:
        Quoting of fields and tables names
      mysql-test/r/varbinary.result:
        Quoting of fields and tables names
      mysql-test/r/view.result:
        Quoting of fields and tables names
        test of view with quated fields
      mysql-test/t/view.test:
        test of view with quated fields
      sql/item.cc:
        Quoting of fields and tables names
      sql/item.h:
        Quoting of fields and tables names
      sql/sql_select.cc:
        Quoting of fields and tables names
      sql/sql_view.cc:
        mark subquery in the FROM clause like derived
      ec33aa2b
  29. 13 May, 2004 1 commit
  30. 31 Oct, 2003 1 commit
    • unknown's avatar
      amall fix · d6aacb9e
      unknown authored
      mysql-test/r/derived.result:
        fixed results after merge
      mysql-test/r/func_in.result:
        small fix to amke all names uniform
      mysql-test/r/func_math.result:
        forgot to change
      sql/item.cc:
        fix
      sql/item_create.cc:
        small fix to amke all names uniform
      d6aacb9e
  31. 30 Oct, 2003 1 commit
    • unknown's avatar
      added code covarage for functions convert(), nullif(), crc32(),... · 87e6c2ba
      unknown authored
      added code covarage for functions convert(), nullif(), crc32(), is_used_lock(), char_lengtrh(), bit_xor()
      added string length for more speed
      made code covarage for print() method of Item
      fixed printability of some items (SCRUM) (WL#1274)
      
      
      mysql-test/r/auto_increment.result:
        print() code coverage
      mysql-test/r/bench_count_distinct.result:
        print() code coverage
      mysql-test/r/case.result:
        print() code coverage
      mysql-test/r/cast.result:
        print() code coverage
      mysql-test/r/ctype_collate.result:
        print() code coverage
      mysql-test/r/ctype_many.result:
        convert with 3 arguments code covarage
        print() code coverage
      mysql-test/r/ctype_utf8.result:
        char_length code coverage
      mysql-test/r/date_formats.result:
        print() code coverage
      mysql-test/r/fulltext.result:
        print() code coverage
      mysql-test/r/func_compress.result:
        print() code coverage
      mysql-test/r/func_gconcat.result:
        print() code coverage
      mysql-test/r/func_group.result:
        bit_xor() code coverage
        print() code coverage
      mysql-test/r/func_if.result:
        nullif() code coverage
        print() code coverage
      mysql-test/r/func_in.result:
        print() code coverage
      mysql-test/r/func_math.result:
        print() code coverage
      mysql-test/r/func_op.result:
        print() code coverage
      mysql-test/r/func_regexp.result:
        print() code coverage
      mysql-test/r/func_set.result:
        print() code coverage
      mysql-test/r/func_str.result:
        crc32() code coverage
        print() code coverage
      mysql-test/r/func_system.result:
        print() code coverage
      mysql-test/r/func_test.result:
        print() code coverage
      mysql-test/r/func_time.result:
        print() code coverage
      mysql-test/r/group_by.result:
        print() code coverage
      mysql-test/r/having.result:
        print() code coverage
      mysql-test/r/insert_update.result:
        print() code coverage
      mysql-test/r/null.result:
        print() code coverage
      mysql-test/r/olap.result:
        print() code coverage
      mysql-test/r/query_cache.result:
        print() code coverage
      mysql-test/r/row.result:
        print() code coverage
      mysql-test/r/rpl000001.result:
        print() code coverage
      mysql-test/r/rpl_get_lock.result:
        print() code coverage
      mysql-test/r/rpl_master_pos_wait.result:
        print() code coverage
      mysql-test/r/select.result:
        print() code coverage
      mysql-test/r/subselect.result:
        print() code coverage
      mysql-test/r/type_blob.result:
        print() code coverage
      mysql-test/r/varbinary.result:
        print() code coverage
      mysql-test/r/variables.result:
        print() code coverage
      mysql-test/t/auto_increment.test:
        print() code coverage
      mysql-test/t/bench_count_distinct.test:
        print() code coverage
      mysql-test/t/case.test:
        print() code coverage
      mysql-test/t/cast.test:
        print() code coverage
      mysql-test/t/ctype_collate.test:
        print() code coverage
      mysql-test/t/ctype_many.test:
        convert with 3 arguments code covarage
        print() code coverage
      mysql-test/t/ctype_utf8.test:
        char_length code coverage
      mysql-test/t/date_formats.test:
        print() code coverage
      mysql-test/t/fulltext.test:
        print() code coverage
      mysql-test/t/func_compress.test:
        print() code coverage
      mysql-test/t/func_gconcat.test:
        print() code coverage
      mysql-test/t/func_group.test:
        bit_xor() code coverage
        print() code coverage
      mysql-test/t/func_if.test:
        nullif() code coverage
        print() code coverage
      mysql-test/t/func_in.test:
        print() code coverage
      mysql-test/t/func_math.test:
        print() code coverage
      mysql-test/t/func_op.test:
        print() code coverage
      mysql-test/t/func_regexp.test:
        print() code coverage
      mysql-test/t/func_set.test:
        print() code coverage
      mysql-test/t/func_str.test:
        crc32() code covarage
        print() code coverage
      mysql-test/t/func_system.test:
        print() code coverage
      mysql-test/t/func_test.test:
        print() code coverage
      mysql-test/t/func_time.test:
        print() code coverage
      mysql-test/t/group_by.test:
        print() code coverage
      mysql-test/t/having.test:
        print() code coverage
      mysql-test/t/insert_update.test:
        print() code coverage
      mysql-test/t/null.test:
        print() code coverage
      mysql-test/t/olap.test:
        print() code coverage
      mysql-test/t/query_cache.test:
        print() code coverage
      mysql-test/t/row.test:
        print() code coverage
      mysql-test/t/rpl000001.test:
        print() code coverage
      mysql-test/t/rpl_get_lock.test:
        print() code coverage
      mysql-test/t/rpl_master_pos_wait.test:
        print() code coverage
      mysql-test/t/select.test:
        print() code coverage
      mysql-test/t/type_blob.test:
        print() code coverage
      mysql-test/t/varbinary.test:
        print() code coverage
      mysql-test/t/variables.test:
        print() code coverage
      sql/item.cc:
        added string length for more speed
        layout fix
        fixed string printability
      sql/item.h:
        added string length for more speed
      sql/item_cmpfunc.cc:
        added string length for more speed
      sql/item_cmpfunc.h:
        fixed printability
      sql/item_create.cc:
        fixed printability
      sql/item_func.cc:
        fixed printability
        added string length for more speed
      sql/item_func.h:
        fixed printability
      sql/item_strfunc.cc:
        fixed printability
        added string length for more speed
      sql/item_strfunc.h:
        fixed printability
      sql/item_subselect.cc:
        added string length for more speed
      sql/item_sum.cc:
        added string length for more speed
      sql/item_timefunc.cc:
        added string length for more speed
      sql/item_timefunc.h:
        fixed printability
      sql/item_uniq.h:
        added string length for more speed
      sql/key.cc:
        added string length for more speed
      sql/sql_lex.cc:
        added string length for more speed
      sql/sql_parse.cc:
        after merge fix
      sql/sql_repl.cc:
        string changed with character for more speed
      sql/sql_select.cc:
        added string length for more speed
      sql/sql_show.cc:
        added string length for more speed
      87e6c2ba
  32. 18 Jul, 2003 1 commit
  33. 16 Jul, 2003 1 commit
  34. 05 Jan, 2003 1 commit
    • unknown's avatar
      Changed mysql-test to print warnings for not existing table to DROP TABLE · 14810ff1
      unknown authored
      Cleaned up test; Removed wrong DROP TABLE commands and use standard table and database names.
      changed store_warning() -> push_warning_print()
      
      
      
      BitKeeper/deleted/.del-rpl000016-slave.opt~ef76f85ddcc13b87:
        Delete: mysql-test/t/rpl000016-slave.opt
      BitKeeper/deleted/.del-sel000001.test~9567c1646058cc:
        Delete: mysql-test/t/sel000001.test
      BitKeeper/deleted/.del-sel000002.test~9f500639572e18e1:
        Delete: mysql-test/t/sel000002.test
      BitKeeper/deleted/.del-sel000003.test~63a5512d18cd20a2:
        Delete: mysql-test/t/sel000003.test
      BitKeeper/deleted/.del-sel000001.result~383913ae4505ec86:
        Delete: mysql-test/r/sel000001.result
      BitKeeper/deleted/.del-sel000002.result~d1787e6fd5dbc1cc:
        Delete: mysql-test/r/sel000002.result
      BitKeeper/deleted/.del-sel000003.result~d7b657b1e3a286a7:
        Delete: mysql-test/r/sel000003.result
      BitKeeper/deleted/.del-sel000031.result~d49aeac63ad7db4d:
        Delete: mysql-test/r/sel000031.result
      BitKeeper/deleted/.del-sel000031.test~50a19a8e204e99bc:
        Delete: mysql-test/t/sel000031.test
      BitKeeper/deleted/.del-sel000032.result~6cb30e23cbca9fb0:
        Delete: mysql-test/r/sel000032.result
      BitKeeper/deleted/.del-sel000032.test~e32da7c3fc4b7ace:
        Delete: mysql-test/t/sel000032.test
      BitKeeper/deleted/.del-rpl000003.result~68d6ee00beaa011:
        Delete: mysql-test/r/rpl000003.result
      BitKeeper/deleted/.del-rpl000003.test~b7cfc4c5576fbafd:
        Delete: mysql-test/t/rpl000003.test
      client/mysql.cc:
        Don't yet print information about SQL help
      client/mysqltest.c:
        Added test options:
        --enable_warnings
        --disable_warnings
        --enable_info
        --disable_info
      configure.in:
        changed version number of shared libraries
      mysql-test/include/master-slave.inc:
        Don't write warnings on init
      mysql-test/r/backup.result:
        Updated results
      mysql-test/r/bdb.result:
        Updated results
      mysql-test/r/bigint.result:
        Updated results
      mysql-test/r/bool.result:
        Updated results
      mysql-test/r/create.result:
        Updated results
      mysql-test/r/delete.result:
        Updated results
      mysql-test/r/derived.result:
        Updated results
      mysql-test/r/distinct.result:
        Updated results
      mysql-test/r/drop.result:
        Updated results
      mysql-test/r/flush.result:
        Updated results
      mysql-test/r/fulltext.result:
        Updated results
      mysql-test/r/fulltext_multi.result:
        Updated results
      mysql-test/r/fulltext_order_by.result:
        Updated results
      mysql-test/r/func_equal.result:
        Updated results
      mysql-test/r/func_in.result:
        Updated results
      mysql-test/r/func_set.result:
        Updated results
      mysql-test/r/gcc296.result:
        Updated results
      mysql-test/r/group_by.result:
        Updated results
      mysql-test/r/innodb-deadlock.result:
        Updated results
      mysql-test/r/innodb.result:
        Updated results
      mysql-test/r/innodb_cache.result:
        Updated results
      mysql-test/r/innodb_handler.result:
        Updated results
      mysql-test/r/insert.result:
        Updated results
      mysql-test/r/insert_select.result:
        Updated results
      mysql-test/r/isam.result:
        Updated results
      mysql-test/r/join_outer.result:
        Updated results
      mysql-test/r/key.result:
        Updated results
      mysql-test/r/merge.result:
        Updated results
      mysql-test/r/multi_update.result:
        Updated results
      mysql-test/r/myisam.result:
        Updated results
      mysql-test/r/null.result:
        Updated results
      mysql-test/r/null_key.result:
        Updated results
      mysql-test/r/odbc.result:
        Updated results
      mysql-test/r/olap.result:
        Updated results
      mysql-test/r/order_by.result:
        Updated results
      mysql-test/r/query_cache.result:
        Updated results
      mysql-test/r/rename.result:
        Updated results
      mysql-test/r/row.result:
        Updated results
      mysql-test/r/rpl000001.result:
        Updated results
      mysql-test/r/rpl000002.result:
        Updated results
      mysql-test/r/rpl000004.result:
        Updated results
      mysql-test/r/rpl000005.result:
        Updated results
      mysql-test/r/rpl000006.result:
        Updated results
      mysql-test/r/rpl000008.result:
        Updated results
      mysql-test/r/rpl000009.result:
        Updated results
      mysql-test/r/rpl000010.result:
        Updated results
      mysql-test/r/rpl000011.result:
        Updated results
      mysql-test/r/rpl000012.result:
        Updated results
      mysql-test/r/rpl000013.result:
        Updated results
      mysql-test/r/rpl_alter.result:
        Updated results
      mysql-test/r/rpl_empty_master_crash.result:
        Updated results
      mysql-test/r/rpl_redirect.result:
        Updated results
      mysql-test/r/rpl_replicate_do.result:
        Updated results
      mysql-test/r/rpl_rotate_logs.result:
        Updated results
      mysql-test/r/rpl_skip_error.result:
        Updated results
      mysql-test/r/rpl_temporary.result:
        Updated results
      mysql-test/r/select.result:
        Updated results
      mysql-test/r/subselect.result:
        Updated results
      mysql-test/r/temp_table.result:
        Updated results
      mysql-test/r/type_date.result:
        Updated results
      mysql-test/r/type_float.result:
        Updated results
      mysql-test/r/union.result:
        Updated results
      mysql-test/r/update.result:
        Updated results
      mysql-test/r/user_var.result:
        Updated results
      mysql-test/r/varbinary.result:
        Updated results
      mysql-test/r/variables.result:
        Updated results
      mysql-test/r/warnings.result:
        Updated results
      mysql-test/t/alias.test:
        Don't write warnings when initializing test
      mysql-test/t/alter_table.test:
        Don't write warnings when initializing test
      mysql-test/t/analyse.test:
        Don't write warnings when initializing test
      mysql-test/t/auto_increment.test:
        Don't write warnings when initializing test
      mysql-test/t/backup.test:
        Don't write warnings when initializing test
      mysql-test/t/bdb-alter-table-1.test:
        Don't write warnings when initializing test
      mysql-test/t/bdb-crash.test:
        Don't write warnings when initializing test
      mysql-test/t/bdb-deadlock.test:
        Don't write warnings when initializing test
      mysql-test/t/bdb.test:
        Don't write warnings when initializing test
        cleaned up test
      mysql-test/t/bdb_cache.test:
        Don't write warnings when initializing test
      mysql-test/t/bench_count_distinct.test:
        Don't write warnings when initializing test
      mysql-test/t/bigint.test:
        Don't write warnings when initializing test
      mysql-test/t/binary.test:
        Don't write warnings when initializing test
      mysql-test/t/bool.test:
        Don't write warnings when initializing test
        Changed to use standard table names
      mysql-test/t/bulk_replace.test:
        Don't write warnings when initializing test
      mysql-test/t/case.test:
        Don't write warnings when initializing test
      mysql-test/t/check.test:
        Don't write warnings when initializing test
      mysql-test/t/compare.test:
        Don't write warnings when initializing test
      mysql-test/t/connect.test:
        Removed empty line
      mysql-test/t/constraints.test:
        Don't write warnings when initializing test
      mysql-test/t/count_distinct.test:
        Don't write warnings when initializing test
      mysql-test/t/count_distinct2.test:
        Don't write warnings when initializing test
      mysql-test/t/create.test:
        Don't write warnings when initializing test
        Cleaned up test
      mysql-test/t/ctype_latin1_de.test:
        Don't write warnings when initializing test
      mysql-test/t/ctype_many.test:
        Don't write warnings when initializing test
      mysql-test/t/delayed.test:
        Don't write warnings when initializing test
      mysql-test/t/delete.test:
        Don't write warnings when initializing test
        Cleaned up test
      mysql-test/t/derived.test:
        Don't write warnings when initializing test
        Cleaned up test
      mysql-test/t/dirty_close.test:
        Don't write warnings when initializing test
      mysql-test/t/distinct.test:
        Don't write warnings when initializing test
        Cleaned up test
      mysql-test/t/drop.test:
        Don't write warnings when initializing test
      mysql-test/t/empty_table.test:
        Don't write warnings when initializing test
      mysql-test/t/err000001.test:
        Don't write warnings when initializing test
        Cleaned up test
      mysql-test/t/explain.test:
        Don't write warnings when initializing test
      mysql-test/t/flush.test:
        Don't write warnings when initializing test
      mysql-test/t/foreign_key.test:
        Don't write warnings when initializing test
      mysql-test/t/fulltext.test:
        Don't write warnings when initializing test
      mysql-test/t/fulltext_cache.test:
        Don't write warnings when initializing test
      mysql-test/t/fulltext_distinct.test:
        Don't write warnings when initializing test
      mysql-test/t/fulltext_left_join.test:
        Don't write warnings when initializing test
      mysql-test/t/fulltext_multi.test:
        Don't write warnings when initializing test
      mysql-test/t/fulltext_order_by.test:
        Don't write warnings when initializing test
      mysql-test/t/fulltext_update.test:
        Don't write warnings when initializing test
      mysql-test/t/func_concat.test:
        Don't write warnings when initializing test
      mysql-test/t/func_date_add.test:
        Don't write warnings when initializing test
      mysql-test/t/func_encrypt.test:
        Don't write warnings when initializing test
      mysql-test/t/func_equal.test:
        Don't write warnings when initializing test
      mysql-test/t/func_group.test:
        Don't write warnings when initializing test
      mysql-test/t/func_if.test:
        Don't write warnings when initializing test
      mysql-test/t/func_in.test:
        Don't write warnings when initializing test
      mysql-test/t/func_isnull.test:
        Don't write warnings when initializing test
      mysql-test/t/func_like.test:
        Don't write warnings when initializing test
      mysql-test/t/func_regexp.test:
        Don't write warnings when initializing test
      mysql-test/t/func_set.test:
        Don't write warnings when initializing test
        Merged test with other tests
      mysql-test/t/func_str.test:
        Don't write warnings when initializing test
      mysql-test/t/func_time.test:
        Don't write warnings when initializing test
      mysql-test/t/func_timestamp.test:
        Don't write warnings when initializing test
      mysql-test/t/gcc296.test:
        Don't write warnings when initializing test
        Cleaned up test
      mysql-test/t/grant_cache.test:
        Don't write warnings when initializing test
      mysql-test/t/group_by.test:
        Don't write warnings when initializing test
        Cleaned up test
      mysql-test/t/handler.test:
        Don't write warnings when initializing test
      mysql-test/t/having.test:
        Don't write warnings when initializing test
      mysql-test/t/heap.test:
        Don't write warnings when initializing test
      mysql-test/t/heap_auto_increment.test:
        Don't write warnings when initializing test
      mysql-test/t/heap_btree.test:
        Don't write warnings when initializing test
      mysql-test/t/heap_hash.test:
        Don't write warnings when initializing test
      mysql-test/t/innodb-deadlock.test:
        Don't write warnings when initializing test
      mysql-test/t/innodb.test:
        Don't write warnings when initializing test
      mysql-test/t/innodb_cache.test:
        Don't write warnings when initializing test
      mysql-test/t/innodb_handler.test:
        Don't write warnings when initializing test
      mysql-test/t/ins000001.test:
        Don't write warnings when initializing test
      mysql-test/t/insert.test:
        Don't write warnings when initializing test
        cleaned up test.
        Changed to use standard database and table names
      mysql-test/t/insert_select.test:
        Don't write warnings when initializing test
        Changed to use standard table names
      mysql-test/t/insert_update.test:
        Don't write warnings when initializing test
      mysql-test/t/isam.test:
        Don't write warnings when initializing test
        cleaned up test
      mysql-test/t/join.test:
        Don't write warnings when initializing test
      mysql-test/t/join_crash.test:
        Don't write warnings when initializing test
      mysql-test/t/join_outer.test:
        Don't write warnings when initializing test
      mysql-test/t/key.test:
        Don't write warnings when initializing test
      mysql-test/t/key_diff.test:
        Don't write warnings when initializing test
      mysql-test/t/key_primary.test:
        Don't write warnings when initializing test
      mysql-test/t/keywords.test:
        Don't write warnings when initializing test
      mysql-test/t/kill.test:
        Don't write warnings when initializing test
      mysql-test/t/limit.test:
        Don't write warnings when initializing test
      mysql-test/t/lock.test:
        Don't write warnings when initializing test
      mysql-test/t/lock_multi.test:
        Don't write warnings when initializing test
      mysql-test/t/lowercase_table.test:
        Don't write warnings when initializing test
      mysql-test/t/merge.test:
        Don't write warnings when initializing test
        cleaned up test
      mysql-test/t/multi_update.test:
        Don't write warnings when initializing test
      mysql-test/t/myisam.test:
        Don't write warnings when initializing test
      mysql-test/t/null.test:
        Don't write warnings when initializing test
      mysql-test/t/null_key.test:
        Don't write warnings when initializing test
      mysql-test/t/odbc.test:
        Don't write warnings when initializing test
      mysql-test/t/olap.test:
        Don't write warnings when initializing test
      mysql-test/t/order_by.test:
        Don't write warnings when initializing test
      mysql-test/t/order_fill_sortbuf.test:
        Don't write warnings when initializing test
      mysql-test/t/query_cache.test:
        Don't write warnings when initializing test
      mysql-test/t/raid.test:
        Don't write warnings when initializing test
      mysql-test/t/range.test:
        Don't write warnings when initializing test
      mysql-test/t/rename.test:
        Don't write warnings when initializing test
      mysql-test/t/repair.test:
        Don't write warnings when initializing test
      mysql-test/t/replace.test:
        Don't write warnings when initializing test
      mysql-test/t/rollback.test:
        Don't write warnings when initializing test
      mysql-test/t/row.test:
        Don't write warnings when initializing test
      mysql-test/t/rpl000001.test:
        Don't write warnings when initializing test
      mysql-test/t/rpl000002.test:
        Don't write warnings when initializing test
      mysql-test/t/rpl000004.test:
        Don't write warnings when initializing test
      mysql-test/t/rpl000005.test:
        Don't write warnings when initializing test
      mysql-test/t/rpl000006.test:
        Don't write warnings when initializing test
      mysql-test/t/rpl000008-slave.opt:
        Don't write warnings when initializing test
      mysql-test/t/rpl000008.test:
        Don't write warnings when initializing test
      mysql-test/t/rpl000009-slave.opt:
        Don't write warnings when initializing test
      mysql-test/t/rpl000009.test:
        Don't write warnings when initializing test
      mysql-test/t/rpl000010.test:
        Don't write warnings when initializing test
      mysql-test/t/rpl000011.test:
        Don't write warnings when initializing test
      mysql-test/t/rpl000012.test:
        Don't write warnings when initializing test
      mysql-test/t/rpl000013.test:
        Don't write warnings when initializing test
      mysql-test/t/rpl000015.test:
        Don't write warnings when initializing test
      mysql-test/t/rpl000017.test:
        Don't write warnings when initializing test
      mysql-test/t/rpl000018.test:
        Don't write warnings when initializing test
      mysql-test/t/rpl_alter.test:
        Don't write warnings when initializing test
      mysql-test/t/rpl_empty_master_crash.test:
        Don't write warnings when initializing test
      mysql-test/t/rpl_redirect.test:
        Don't write warnings when initializing test
      mysql-test/t/rpl_replicate_do.test:
        Don't write warnings when initializing test
      mysql-test/t/rpl_rotate_logs.test:
        Don't write warnings when initializing test
      mysql-test/t/rpl_skip_error.test:
        Don't write warnings when initializing test
      mysql-test/t/rpl_temporary.test:
        Don't write warnings when initializing test
      mysql-test/t/sel000033.test:
        Don't write warnings when initializing test
      mysql-test/t/sel000100.test:
        Don't write warnings when initializing test
      mysql-test/t/select.test:
        Don't write warnings when initializing test
      mysql-test/t/select_found.test:
        Don't write warnings when initializing test
      mysql-test/t/select_safe.test:
        Don't write warnings when initializing test
      mysql-test/t/show_check.test:
        Don't write warnings when initializing test
      mysql-test/t/status.test:
        Don't write warnings when initializing test
      mysql-test/t/subselect.test:
        Don't write warnings when initializing test
      mysql-test/t/symlink.test:
        Don't write warnings when initializing test
      mysql-test/t/tablelock.test:
        Don't write warnings when initializing test
      mysql-test/t/temp_table.test:
        Don't write warnings when initializing test
      mysql-test/t/truncate.test:
        Don't write warnings when initializing test
      mysql-test/t/type_blob.test:
        Don't write warnings when initializing test
      mysql-test/t/type_date.test:
        Don't write warnings when initializing test
      mysql-test/t/type_datetime.test:
        Don't write warnings when initializing test
      mysql-test/t/type_decimal.test:
        Don't write warnings when initializing test
      mysql-test/t/type_enum.test:
        Don't write warnings when initializing test
      mysql-test/t/type_float.test:
        Don't write warnings when initializing test
      mysql-test/t/type_ranges.test:
        Don't write warnings when initializing test
      mysql-test/t/type_set.test:
        Don't write warnings when initializing test
      mysql-test/t/type_time.test:
        Don't write warnings when initializing test
      mysql-test/t/type_timestamp.test:
        Don't write warnings when initializing test
      mysql-test/t/type_uint.test:
        Don't write warnings when initializing test
      mysql-test/t/type_year.test:
        Don't write warnings when initializing test
      mysql-test/t/union.test:
        Don't write warnings when initializing test
      mysql-test/t/update.test:
        Don't write warnings when initializing test
      mysql-test/t/user_var.test:
        Don't write warnings when initializing test
      mysql-test/t/varbinary.test:
        Don't write warnings when initializing test
      mysql-test/t/variables.test:
        Don't write warnings when initializing test
      mysql-test/t/warnings.test:
        Don't write warnings when initializing test
      mysys/my_vsnprintf.c:
        Safety fix
      readline/terminal.c:
        Removed compiler warnings
      sql/ha_berkeley.cc:
        Indentation changes
      sql/mysql_priv.h:
        Change store_warning -> push_warning_printf
      sql/sql_db.cc:
        Change store_warning -> push_warning_printf
      sql/sql_error.cc:
        Change store_warning -> push_warning_printf
      sql/sql_table.cc:
        Change store_warning -> push_warning_printf
      14810ff1
  35. 06 Dec, 2002 1 commit
    • unknown's avatar
      _NEW_ IN/ALL/ANY/SOME behaviour with NULL (SCRUM related) · 59b37119
      unknown authored
      optimization of left expression evaluation
      more descriptive method name
      
      
      mysql-test/r/func_in.result:
        test of _NEW_ IN behaviour with NULL
      mysql-test/r/subselect.result:
        test of _NEW_ IN/ALL/ANY/SOME behaviour with NULL
      mysql-test/t/func_in.test:
        test of _NEW_ IN behaviour with NULL
      mysql-test/t/subselect.test:
        test of _NEW_ IN/ALL/ANY/SOME behaviour with NULL
      sql/item.cc:
        _NEW_ IN/ALL/ANY/SOME behaviour with NULL
        optimization of left expression evaluation
      sql/item.h:
        _NEW_ IN/ALL/ANY/SOME behaviour with NULL
        optimization of left expression evaluation
      sql/item_cmpfunc.cc:
        _NEW_ IN/ALL/ANY/SOME behaviour with NULL
        optimization of left expression evaluation
      sql/item_cmpfunc.h:
        _NEW_ IN/ALL/ANY/SOME behaviour with NULL
        optimization of left expression evaluation
      sql/item_subselect.cc:
        _NEW_ IN/ALL/ANY/SOME behaviour with NULL
        optimization of left expression evaluation
      sql/item_subselect.h:
        _NEW_ IN/ALL/ANY/SOME behaviour with NULL
        optimization of left expression evaluation
      sql/sql_class.cc:
        more descriptive method name
      sql/sql_union.cc:
        more descriptive method name
      59b37119
  36. 30 Aug, 2002 1 commit
    • unknown's avatar
      fixed tests to be independed from environment · db951c2f
      unknown authored
      mysql-test/r/binary.result:
        fixed test to be independed from environment
      mysql-test/r/delayed.result:
        fixed test to be independed from environment
      mysql-test/r/fulltext_left_join.result:
        fixed test to be independed from environment
      mysql-test/r/func_group.result:
        fixed test to be independed from environment
      mysql-test/r/func_in.result:
        fixed test to be independed from environment
      mysql-test/r/key_primary.result:
        fixed test to be independed from environment
      mysql-test/r/lock_multi.result:
        fixed test to be independed from environment
      mysql-test/r/odbc.result:
        fixed test to be independed from environment
      mysql-test/r/type_set.result:
        fixed test to be independed from environment
      mysql-test/r/type_time.result:
        fixed test to be independed from environment
      mysql-test/r/type_timestamp.result:
        fixed test to be independed from environment
      mysql-test/r/type_year.result:
        fixed test to be independed from environment
      mysql-test/r/varbinary.result:
        fixed test to be independed from environment
      mysql-test/r/warnings.result:
        fixed test to be independed from environment
      mysql-test/t/binary.test:
        fixed test to be independed from environment
      mysql-test/t/delayed.test:
        fixed test to be independed from environment
      mysql-test/t/flush_table.test:
        fixed test to be independed from environment
      mysql-test/t/fulltext_left_join.test:
        fixed test to be independed from environment
      mysql-test/t/func_group.test:
        fixed test to be independed from environment
      mysql-test/t/func_in.test:
        fixed test to be independed from environment
      mysql-test/t/key_primary.test:
        fixed test to be independed from environment
      mysql-test/t/lock_multi.test:
        fixed test to be independed from environment
      mysql-test/t/odbc.test:
        fixed test to be independed from environment
      mysql-test/t/type_set.test:
        fixed test to be independed from environment
      mysql-test/t/type_time.test:
        fixed test to be independed from environment
      mysql-test/t/type_timestamp.test:
        fixed test to be independed from environment
      mysql-test/t/type_year.test:
        fixed test to be independed from environment
      mysql-test/t/varbinary.test:
        fixed test to be independed from environment
      mysql-test/t/warnings.test:
        fixed test to be independed from environment
      db951c2f
  37. 28 Sep, 2001 1 commit
    • unknown's avatar
      client/mysqlmanagerc.c · 29f148bd
      unknown authored
          added support for quiet
          increased line buffer size
      client/mysqltest.c
          fixed memory leak
          added query logging to result file
          added error message logging to result file
          added enable_query_log/disable_query_log
      mysql-test/mysql-test-run.sh
          converted tests to use mysqlmanager
      
      Updated test results
      
      
      BitKeeper/etc/ignore:
        added *.reject
      client/mysqlmanagerc.c:
        added support for quiet
        increased line buffer size
      client/mysqltest.c:
        fixed memory leak
        added query logging to result file
        added error message logging to result file
        added enable_query_log/disable_query_log
      mysql-test/mysql-test-run.sh:
        converted tests to use mysqlmanager
      mysql-test/r/alias.result:
        log queries
      mysql-test/r/alter_table.result:
        log queries
      mysql-test/r/analyse.result:
        log queries
      mysql-test/r/auto_increment.result:
        log queries
      mysql-test/r/backup.result:
        log queries
      mysql-test/r/bdb-crash.result:
        log queries
      mysql-test/r/bench_count_distinct.result:
        log queries
      mysql-test/r/bigint.result:
        log queries
      mysql-test/r/binary.result:
        log queries
      mysql-test/r/bulk_replace.result:
        log queries
      mysql-test/r/case.result:
        log queries
      mysql-test/r/check.result:
        log queries
      mysql-test/r/comments.result:
        log queries
      mysql-test/r/compare.result:
        log queries
      mysql-test/r/count_distinct.result:
        log queries
      mysql-test/r/count_distinct2.result:
        log queries
      mysql-test/r/create.result:
        log queries
      mysql-test/r/ctype_latin1_de.result:
        log queries
      mysql-test/r/delayed.result:
        log queries
      mysql-test/r/dirty-close.result:
        log queries
      mysql-test/r/distinct.result:
        log queries
      mysql-test/r/drop.result:
        log queries
      mysql-test/r/empty_table.result:
        log queries
      mysql-test/r/explain.result:
        log queries
      mysql-test/r/flush.result:
        log queries
      mysql-test/r/fulltext.result:
        log queries
      mysql-test/r/fulltext_cache.result:
        log queries
      mysql-test/r/fulltext_distinct.result:
        log queries
      mysql-test/r/fulltext_left_join.result:
        log queries
      mysql-test/r/fulltext_multi.result:
        log queries
      mysql-test/r/fulltext_order_by.result:
        log queries
      mysql-test/r/fulltext_update.result:
        log queries
      mysql-test/r/fulltext_var.result:
        log queries
      mysql-test/r/func_crypt.result:
        log queries
      mysql-test/r/func_date_add.result:
        log queries
      mysql-test/r/func_equal.result:
        log queries
      mysql-test/r/func_group.result:
        log queries
      mysql-test/r/func_in.result:
        log queries
      mysql-test/r/func_like.result:
        log queries
      mysql-test/r/func_math.result:
        log queries
      mysql-test/r/func_misc.result:
        log queries
      mysql-test/r/func_op.result:
        log queries
      mysql-test/r/func_regexp.result:
        log queries
      mysql-test/r/func_set.result:
        log queries
      mysql-test/r/func_str.result:
        log queries
      mysql-test/r/func_system.result:
        log queries
      mysql-test/r/func_test.result:
        log queries
      mysql-test/r/func_time.result:
        log queries
      mysql-test/r/func_timestamp.result:
        log queries
      mysql-test/r/group_by.result:
        log queries
      mysql-test/r/handler.result:
        log queries
      mysql-test/r/having.result:
        log queries
      mysql-test/r/heap.result:
        log queries
      mysql-test/r/identity.result:
        log queries
      mysql-test/r/ins000001.result:
        log queries
      mysql-test/r/insert.result:
        log queries
      mysql-test/r/insert_select.result:
        log queries
      mysql-test/r/isam.result:
        log queries
      mysql-test/r/join.result:
        log queries
      mysql-test/r/join_crash.result:
        log queries
      mysql-test/r/join_outer.result:
        log queries
      mysql-test/r/key.result:
        log queries
      mysql-test/r/key_diff.result:
        log queries
      mysql-test/r/key_primary.result:
        log queries
      mysql-test/r/keywords.result:
        log queries
      mysql-test/r/kill.result:
        log queries
      mysql-test/r/limit.result:
        log queries
      mysql-test/r/lock.result:
        log queries
      mysql-test/r/merge.result:
        log queries
      mysql-test/r/multi_update.result:
        log queries
      mysql-test/r/myisam.result:
        log queries
      mysql-test/r/null.result:
        log queries
      mysql-test/r/null_key.result:
        log queries
      mysql-test/r/odbc.result:
        log queries
      mysql-test/r/openssl_1.result:
        log queries
      mysql-test/r/openssl_2.result:
        log queries
      mysql-test/r/order_by.result:
        log queries
      mysql-test/r/order_fill_sortbuf.result:
        log queries
      mysql-test/r/raid.result:
        log queries
      mysql-test/r/range.result:
        log queries
      mysql-test/r/rename.result:
        log queries
      mysql-test/r/replace.result:
        log queries
      mysql-test/r/rollback.result:
        log queries
      mysql-test/r/rpl000001.result:
        log queries
      mysql-test/r/rpl000002.result:
        log queries
      mysql-test/r/rpl000003.result:
        log queries
      mysql-test/r/rpl000004.result:
        log queries
      mysql-test/r/rpl000005.result:
        log queries
      mysql-test/r/rpl000006.result:
        log queries
      mysql-test/r/rpl000007.result:
        log queries
      mysql-test/r/rpl000008.result:
        log queries
      mysql-test/r/rpl000009.result:
        log queries
      mysql-test/r/rpl000010.result:
        log queries
      mysql-test/r/rpl000011.result:
        log queries
      mysql-test/r/rpl000012.result:
        log queries
      mysql-test/r/rpl000013.result:
        log queries
      mysql-test/r/rpl000014.result:
        log queries
      mysql-test/r/rpl000015.result:
        log queries
      mysql-test/r/rpl000016.result:
        log queries
      mysql-test/r/rpl000017.result:
        log queries
      mysql-test/r/rpl000018.result:
        log queries
      mysql-test/r/rpl_get_lock.result:
        log queries
      mysql-test/r/rpl_log.result:
        log queries
      mysql-test/r/rpl_magic.result:
        log queries
      mysql-test/r/rpl_mystery22.result:
        log queries
      mysql-test/r/rpl_sporadic_master.result:
        log queries
      mysql-test/r/sel000001.result:
        log queries
      mysql-test/r/sel000002.result:
        log queries
      mysql-test/r/sel000003.result:
        log queries
      mysql-test/r/sel000031.result:
        log queries
      mysql-test/r/sel000032.result:
        log queries
      mysql-test/r/sel000033.result:
        log queries
      mysql-test/r/sel000100.result:
        log queries
      mysql-test/r/select.result:
        log queries
      mysql-test/r/select_found.result:
        log queries
      mysql-test/r/select_safe.result:
        log queries
      mysql-test/r/show_check.result:
        log queries
      mysql-test/r/slave-running.result:
        log queries
      mysql-test/r/slave-stopped.result:
        log queries
      mysql-test/r/status.result:
        log queries
      mysql-test/r/symlink.result:
        log queries
      mysql-test/r/tablelock.result:
        log queries
      mysql-test/r/temp_table.result:
        log queries
      mysql-test/r/truncate.result:
        log queries
      mysql-test/r/type_blob.result:
        log queries
      mysql-test/r/type_date.result:
        log queries
      mysql-test/r/type_datetime.result:
        log queries
      mysql-test/r/type_decimal.result:
        log queries
      mysql-test/r/type_enum.result:
        log queries
      mysql-test/r/type_float.result:
        log queries
      mysql-test/r/type_ranges.result:
        log queries
      mysql-test/r/type_time.result:
        log queries
      mysql-test/r/type_timestamp.result:
        log queries
      mysql-test/r/type_uint.result:
        log queries
      mysql-test/r/type_year.result:
        log queries
      mysql-test/r/union.result:
        log queries
      mysql-test/r/update.result:
        log queries
      mysql-test/r/user_var.result:
        log queries
      mysql-test/r/varbinary.result:
        log queries
      mysql-test/r/variables.result:
        log queries
      mysql-test/t/bench_count_distinct.test:
        log queries
      mysql-test/t/check.test:
        log queries
      mysql-test/t/count_distinct2.test:
        log queries
      mysql-test/t/flush.test:
        log queries
      mysql-test/t/isam.test:
        log queries
      mysql-test/t/multi_update.test:
        log queries
      mysql-test/t/myisam.test:
        log queries
      mysql-test/t/order_fill_sortbuf.test:
        log queries
      mysql-test/t/rpl000016.test:
        log queries
      tools/managertest1.nc:
        test for def_exec overwrite
      tools/mysqlmanager.c:
        support def_exec overwrite and queries on running server
      29f148bd
  38. 28 Dec, 2000 1 commit
    • unknown's avatar
      Added support for hex strings to mysqlimport · f537319d
      unknown authored
      A lot of new tests to mysqltest
      Fixed bug with BDB tables and autocommit
      
      
      BitKeeper/deleted/.del-delete.test~389410e29f2cebe5:
        Delete: mysql-test/t/delete.test
      BitKeeper/deleted/.del-delete.result~e866a6678e29f186:
        Delete: mysql-test/r/delete.result
      BitKeeper/deleted/.del-sel000014.test~74cb8c70f1d73fcc:
        Delete: mysql-test/t/sel000014.test
      BitKeeper/deleted/.del-sel000015.test~7442bf9cbc96fe07:
        Delete: mysql-test/t/sel000015.test
      BitKeeper/deleted/.del-sel000016.test~f495235f14c47ec:
        Delete: mysql-test/t/sel000016.test
      BitKeeper/deleted/.del-sel000017.test~7c39f2b45a6aa780:
        Delete: mysql-test/t/sel000017.test
      BitKeeper/deleted/.del-sel000018.test~16207f3ad74de75e:
        Delete: mysql-test/t/sel000018.test
      BitKeeper/deleted/.del-sel000014.result~fc8de0ec89d9e35:
        Delete: mysql-test/r/sel000014.result
      BitKeeper/deleted/.del-sel000015.result~cadbc52051d47bac:
        Delete: mysql-test/r/sel000015.result
      BitKeeper/deleted/.del-sel000016.result~6177851869bd5b07:
        Delete: mysql-test/r/sel000016.result
      BitKeeper/deleted/.del-sel000017.result~84ebf147850ff31c:
        Delete: mysql-test/r/sel000017.result
      BitKeeper/deleted/.del-sel000018.result~562ac9094cf53aba:
        Delete: mysql-test/r/sel000018.result
      BitKeeper/deleted/.del-sel000005.test~982fde89a4d6d886:
        Delete: mysql-test/t/sel000005.test
      BitKeeper/deleted/.del-sel000006.test~291cc6c8d85e51df:
        Delete: mysql-test/t/sel000006.test
      BitKeeper/deleted/.del-sel000005.result~d5410bb765199cc5:
        Delete: mysql-test/r/sel000005.result
      BitKeeper/deleted/.del-sel000006.result~d38004d1acfc11a5:
        Delete: mysql-test/r/sel000006.result
      BitKeeper/deleted/.del-sel000004.test~daf9ad4a1a31cd3c:
        Delete: mysql-test/t/sel000004.test
      BitKeeper/deleted/.del-sel000007.test~f431e4f4739a24c3:
        Delete: mysql-test/t/sel000007.test
      BitKeeper/deleted/.del-sel000008.test~b338ef585cadf7ae:
        Delete: mysql-test/t/sel000008.test
      BitKeeper/deleted/.del-sel000009.test~a455c38f5c942cd1:
        Delete: mysql-test/t/sel000009.test
      BitKeeper/deleted/.del-sel000010.test~ca07085ae92255f1:
        Delete: mysql-test/t/sel000010.test
      BitKeeper/deleted/.del-sel000011.test~c2a971726c9d18d6:
        Delete: mysql-test/t/sel000011.test
      BitKeeper/deleted/.del-sel000012.test~ae64bff363c42e92:
        Delete: mysql-test/t/sel000012.test
      BitKeeper/deleted/.del-sel000013.test~ce8aa504ba4f74ba:
        Delete: mysql-test/t/sel000013.test
      BitKeeper/deleted/.del-sel000019.test~8fd63c8dc6be8dbc:
        Delete: mysql-test/t/sel000019.test
      BitKeeper/deleted/.del-sel000020.test~c5758ad18a6dff1e:
        Delete: mysql-test/t/sel000020.test
      BitKeeper/deleted/.del-sel000021.test~94dd47de2872264a:
        Delete: mysql-test/t/sel000021.test
      BitKeeper/deleted/.del-sel000022.test~6e3e5435e66875e9:
        Delete: mysql-test/t/sel000022.test
      BitKeeper/deleted/.del-sel000023.test~7bdfcfaa278f837d:
        Delete: mysql-test/t/sel000023.test
      BitKeeper/deleted/.del-sel000024.test~849f47e6cbdc4fe3:
        Delete: mysql-test/t/sel000024.test
      BitKeeper/deleted/.del-sel000025.test~65b32b4b67e4c77:
        Delete: mysql-test/t/sel000025.test
      BitKeeper/deleted/.del-sel000026.test~d8aa2d614f23b1:
        Delete: mysql-test/t/sel000026.test
      BitKeeper/deleted/.del-sel000027.test~ab44bb57a580de9:
        Delete: mysql-test/t/sel000027.test
      BitKeeper/deleted/.del-sel000028.test~db9bfc0a808fb629:
        Delete: mysql-test/t/sel000028.test
      BitKeeper/deleted/.del-sel000029.test~6aae34dbb3ee86d9:
        Delete: mysql-test/t/sel000029.test
      BitKeeper/deleted/.del-sel000030.test~a29683eac3e7b706:
        Delete: mysql-test/t/sel000030.test
      BitKeeper/deleted/.del-sel000004.result~1f8d1265be521c17:
        Delete: mysql-test/r/sel000004.result
      BitKeeper/deleted/.del-sel000007.result~df455e49f9727c4f:
        Delete: mysql-test/r/sel000007.result
      BitKeeper/deleted/.del-sel000008.result~67a459ff62c84d6a:
        Delete: mysql-test/r/sel000008.result
      BitKeeper/deleted/.del-sel000009.result~e042b35ab131fb3:
        Delete: mysql-test/r/sel000009.result
      BitKeeper/deleted/.del-sel000010.result~eee5b9631a1e0066:
        Delete: mysql-test/r/sel000010.result
      BitKeeper/deleted/.del-sel000011.result~6907fe356973ed25:
        Delete: mysql-test/r/sel000011.result
      BitKeeper/deleted/.del-sel000012.result~be18991fc28954c2:
        Delete: mysql-test/r/sel000012.result
      BitKeeper/deleted/.del-sel000013.result~513389e06c96af73:
        Delete: mysql-test/r/sel000013.result
      BitKeeper/deleted/.del-sel000019.result~2870fe1c4998d929:
        Delete: mysql-test/r/sel000019.result
      BitKeeper/deleted/.del-sel000020.result~faa670294ef5fa91:
        Delete: mysql-test/r/sel000020.result
      BitKeeper/deleted/.del-sel000021.result~8f0ce4ec26e0c21d:
        Delete: mysql-test/r/sel000021.result
      BitKeeper/deleted/.del-sel000022.result~34828a43753ee767:
        Delete: mysql-test/r/sel000022.result
      BitKeeper/deleted/.del-sel000023.result~13e112d77573bf17:
        Delete: mysql-test/r/sel000023.result
      BitKeeper/deleted/.del-sel000024.result~b10d449624f48d07:
        Delete: mysql-test/r/sel000024.result
      BitKeeper/deleted/.del-sel000025.result~f31e08fcca805f35:
        Delete: mysql-test/r/sel000025.result
      BitKeeper/deleted/.del-sel000026.result~854fa951666b7982:
        Delete: mysql-test/r/sel000026.result
      BitKeeper/deleted/.del-sel000027.result~cfd73fe738f27da:
        Delete: mysql-test/r/sel000027.result
      BitKeeper/deleted/.del-sel000028.result~13ff5add6ac24908:
        Delete: mysql-test/r/sel000028.result
      BitKeeper/deleted/.del-sel000029.result~c6d071781808aa26:
        Delete: mysql-test/r/sel000029.result
      BitKeeper/deleted/.del-sel000030.result~98d496948e15064d:
        Delete: mysql-test/r/sel000030.result
      BitKeeper/deleted/.del-alt000001.test~633aed61c4bad94c:
        Delete: mysql-test/t/alt000001.test
      BitKeeper/deleted/.del-alt000001.result~393103dbf15f35c9:
        Delete: mysql-test/r/alt000001.result
      BitKeeper/deleted/.del-mrg000001.dummy.result~bf7e6d609f22b897:
        Delete: mysql-test/r/mrg000001.dummy.result
      BitKeeper/deleted/.del-mrg000001.result~db2ef2e717ab8332:
        Delete: mysql-test/r/mrg000001.result
      BitKeeper/deleted/.del-mrg000002.result~745be0854aaaaf5e:
        Delete: mysql-test/r/mrg000002.result
      BitKeeper/deleted/.del-mrg000001.test~e0327f9d1e6cb4e:
        Delete: mysql-test/t/mrg000001.test
      BitKeeper/deleted/.del-mrg000002.test~16b3a176adc0f311:
        Delete: mysql-test/t/mrg000002.test
      Docs/manual.texi:
        Changelog
      client/mysqlimport.c:
        Added support for hex strings
      client/mysqltest.c:
        Added linenumbers in output
        Only allow '{' first on a row (Conflicts with ODBC {} syntax).
        Handle bigger queries.
        Handle double ''
        Truncate result files.
      mysql-test/mysql-test-run.sh:
        Added --verbose
        cleanup
      mysql-test/r/bdb.result:
        Updating of test
      mysql-test/r/func_crypt.result:
        Updating of test
      mysql-test/r/func_equal.result:
        Updating of test
      mysql-test/r/func_str.result:
        Updating of test
      mysql-test/r/ins000001.result:
        Updating of test
      mysql-test/t/bdb.test:
        Updating of test
      mysql-test/t/err000001.test:
        Updating of test
      mysql-test/t/func_crypt.test:
        Updating of test
      mysql-test/t/func_equal.test:
        Updating of test
      mysql-test/t/func_str.test:
        Updating of test
      mysql-test/t/ins000001.test:
        Updating of test
      sql/gen_lex_hash.cc:
        Smaller table
      sql/handler.cc:
        Fixed bug in auto_commit
      f537319d