An error occurred fetching the project authors.
  1. 18 Jan, 2005 1 commit
  2. 26 Dec, 2004 2 commits
    • igor@rurik.mysql.com's avatar
      subselect.result, subselect.test: · 04974868
      igor@rurik.mysql.com authored
        Added a couple of new test cases for bug #7351.
      04974868
    • igor@rurik.mysql.com's avatar
      subselect.result, subselect.test: · d3fa2453
      igor@rurik.mysql.com authored
        Added test cases for bug #7351.
      item_cmpfunc.cc:
        Fixed bug #7351: incorrect result for a query with a
        subquery returning empty set.
        If in the predicate v IN (SELECT a FROM t WHERE cond)
        v is null, then the result of the predicate is either
        INKNOWN or FALSE. It is FALSE if the subquery returns
        an empty set.
      item_subselect.cc:
        Fixed bug #7351: incorrect result for a query with a
        subquery returning empty set.
        The problem was due to not a quite legal transformation
        for 'IN' subqueries. A subquery containing a predicate
        of the form
        v IN (SELECT a FROM t WHERE cond)
        was transformed into
        EXISTS(SELECT a FROM t WHERE cond AND (a=v OR a IS NULL)).
        Yet, this transformation is valid only if v is not null.
        If v is null, then, in the case when
        (SELECT a FROM t WHERE cond) returns an empty set the value
        of the predicate is FALSE, otherwise the result of the
        predicate is INKNOWN.
        The fix resolves this problem by changing the result
        of the transformation to
        EXISTS(SELECT a FROM t WHERE cond AND (v IS NULL OR (a=v OR a IS NULL)))
        in the case when v is nullable.
        The new transformation prevents applying the lookup
        optimization for IN subqueries. To make it still
        applicable we have to introduce guarded access methods.
      d3fa2453
  3. 14 Dec, 2004 1 commit
  4. 11 Dec, 2004 1 commit
  5. 25 Nov, 2004 1 commit
  6. 22 Nov, 2004 1 commit
  7. 18 Nov, 2004 1 commit
  8. 16 Nov, 2004 1 commit
  9. 15 Nov, 2004 2 commits
  10. 27 Oct, 2004 1 commit
  11. 17 Sep, 2004 1 commit
  12. 06 Sep, 2004 1 commit
  13. 24 Aug, 2004 1 commit
  14. 23 Aug, 2004 1 commit
  15. 21 Aug, 2004 1 commit
    • hf@deer.(none)'s avatar
      Proposed fix for bug #5003 (subselect with MIN() and LIKE crashes server) · 6c136f99
      hf@deer.(none) authored
      We have next problem here:
      active_index is wrong in the subselect's handler on the second val_int() call.
      Optimizer sees that we can use index-read for that kind of condition,
      and matching_cond() (sql/opt_sum.cc) doesn't. I suspect, proper solution is
      to add appropriate code to the matching_cond() but now just added
      missed initialization.
      6c136f99
  16. 19 Aug, 2004 1 commit
  17. 13 Aug, 2004 1 commit
  18. 12 Aug, 2004 1 commit
  19. 04 Jul, 2004 1 commit
  20. 22 Jun, 2004 1 commit
  21. 18 Jun, 2004 1 commit
  22. 17 Jun, 2004 1 commit
  23. 13 Jun, 2004 1 commit
  24. 10 Jun, 2004 1 commit
  25. 28 May, 2004 1 commit
  26. 07 May, 2004 1 commit
  27. 06 May, 2004 1 commit
  28. 05 May, 2004 1 commit
  29. 02 May, 2004 1 commit
  30. 23 Mar, 2004 1 commit
  31. 18 Mar, 2004 1 commit
  32. 16 Mar, 2004 1 commit
  33. 17 Feb, 2004 1 commit
  34. 16 Feb, 2004 1 commit
    • monty@mysql.com's avatar
      After merge fixes · f43093ec
      monty@mysql.com authored
      Added more DBUG statements
      Ensure that we are comparing end space with BINARY strings
      Use 'any_db' instead of '' to mean any database. (For HANDLER command)
      Only strip ' ' when comparing CHAR, not other space-like characters (like \t)
      f43093ec
  35. 14 Feb, 2004 1 commit
  36. 09 Feb, 2004 1 commit
    • monty@mysql.com's avatar
      Added --compact to mysqlbinlog · 06432eac
      monty@mysql.com authored
      Fixed output from mysqlbinlog when using --skip-comments
      Fixed warnings from valgrind
      Fixed ref_length when used with HEAP tables
      More efficent need_conversion()
      Fixed error handling in UPDATE with not updateable tables
      Fixed bug in null handling in CAST to signed/unsigned
      06432eac
  37. 05 Feb, 2004 1 commit
  38. 04 Feb, 2004 1 commit