1. 01 Feb, 2009 6 commits
  2. 31 Jan, 2009 8 commits
  3. 30 Jan, 2009 5 commits
  4. 29 Jan, 2009 14 commits
  5. 28 Jan, 2009 7 commits
    • Sergey Petrunia's avatar
      Merge · 7820ae5e
      Sergey Petrunia authored
      7820ae5e
    • Sergey Petrunia's avatar
      BUG#37822: Correlated subquery with IN and IS UNKNOWN provides wrong result · cd4f6cc1
      Sergey Petrunia authored
      Item_in_optimizer::is_null() evaluated "NULL IN (SELECT ...)" to NULL regardless of
      whether subquery produced any records, this was a documented limitation.
      
      The limitation has been removed (see bugs 8804, 24085, 24127) now
      Item_in_optimizer::val_int() correctly handles all cases with NULLs. Make
      Item_in_optimizer::is_null() invoke val_int() to return correct values for
      "NULL IN (SELECT ...)".
      cd4f6cc1
    • Gleb Shchepa's avatar
      64c0951f
    • Gleb Shchepa's avatar
      Bug #39069: <row constructor> IN <table-subquery> seriously · b41c1a45
      Gleb Shchepa authored
                  messed up
      
      "ROW(...) IN (SELECT ... FROM DUAL)" always returned TRUE.
      
      Item_in_subselect::row_value_transformer rewrites "ROW(...)
      IN SELECT" conditions into the "EXISTS (SELECT ... HAVING ...)"
      form.
      For a subquery from the DUAL pseudotable resulting HAVING
      condition is an expression on constant values, so further
      transformation with optimize_cond() eliminates this HAVING
      condition and resets JOIN::having to NULL.
      Then JOIN::exec treated that NULL as an always-true-HAVING
      and that caused a bug.
      
      To distinguish an optimized out "HAVING TRUE" clause from
      "HAVING FALSE" we already have the JOIN::having_value flag.
      However, JOIN::exec() ignored JOIN::having_value as described
      above as if it always set to COND_TRUE.
      
      The JOIN::exec method has been modified to take into account
      the value of the JOIN::having_value field.
      b41c1a45
    • Davi Arnaut's avatar
      Merge from 5.0-bugteam · dd2d8eba
      Davi Arnaut authored
      dd2d8eba
    • Magnus Svensson's avatar
      Merge · faca74e1
      Magnus Svensson authored
      faca74e1
    • Magnus Svensson's avatar
      WL#4189 mtr.pl v2 · f3f31c9e
      Magnus Svensson authored
       - Fix faulty regex used for filtering out suspicious warnings, causing
         warnings/errors from previous tests to be reported
      f3f31c9e