1. 17 Feb, 2012 1 commit
    • Igor Babaev's avatar
      Fixed LP bug #933117. · c563ea07
      Igor Babaev authored
      The bug was fixed with the code back-ported from the patch for LP bug 800184
      pushed into mariadb-5.3.
      c563ea07
  2. 12 Feb, 2012 1 commit
  3. 11 Feb, 2012 3 commits
  4. 03 Feb, 2012 3 commits
  5. 23 Jan, 2012 1 commit
  6. 21 Jan, 2012 1 commit
    • Igor Babaev's avatar
      Fixed LP bug #919427. · bb4053af
      Igor Babaev authored
      The function subselect_uniquesubquery_engine::copy_ref_key has to take into
      account that when EXPLAIN is processed the array of store_key object created
      for any TABLE_REF may contain elements for constant items. These items should
      be ignored by thefunction.
      bb4053af
  7. 12 Jan, 2012 4 commits
  8. 30 Dec, 2011 1 commit
  9. 29 Dec, 2011 1 commit
  10. 14 Jan, 2012 2 commits
  11. 13 Jan, 2012 1 commit
    • Igor Babaev's avatar
      Back-ported the test cases for bug #12763207 from mysql-5.6 code line into 5.2 · 6dfe0956
      Igor Babaev authored
      Completed the fix for this bug.
      Note: in 5.3 the affected 'if' statement in Item_in_subselect::single_value_transformer()
      starting with the  condition (thd->variables.sql_mode & MODE_ONLY_FULL_GROUP_BY)
      should be removed altogether. The change from table.cc is not needed either.
      This is because in 5.3
       - min/max transformation for subqueries are done at the optimization phase
       - evaluation of the expensive subqueries is done at the execution phase.
      
      Added an EXPLAIN EXTENDED to the test case for bug #12329653. 
      6dfe0956
  12. 10 Jan, 2012 2 commits
  13. 08 Jan, 2012 1 commit
    • Michael Widenius's avatar
      Fixed compiler and test failures found by buildbot · 629cdab8
      Michael Widenius authored
      configure.in:
        Added testing of STRNDUP (not found on solaris)
      mysql-test/include/wait_until_connected_again.inc:
        Also test for error 2005 (can happen on windows)
      mysql-test/include/wait_until_disconnected.inc:
        Also test for error 2005 (can happen on windows)
      mysql-test/suite/innodb_plugin/r/innodb_bug30423.result:
        Number of rows is not stable (found difference on Solaris)
      mysql-test/suite/innodb_plugin/t/innodb_bug30423.test:
        Number of rows is not stable (found difference on Solaris)
      plugin/auth_pam/auth_pam.c:
        Use internal strndup if it doesn't exist on system (solaris)
        Changed code so that it should also compile on solaris.
      629cdab8
  14. 07 Jan, 2012 2 commits
  15. 05 Jan, 2012 1 commit
  16. 04 Jan, 2012 1 commit
  17. 02 Jan, 2012 1 commit
  18. 30 Dec, 2011 1 commit
  19. 29 Dec, 2011 2 commits
    • Igor Babaev's avatar
      Fixed LP bug #806057. · 40c42468
      Igor Babaev authored
      A table expression with a natural join or a USING clause is transformed
      into an equivalent expression with equi-join ON conditions. If a reference
      to a virtual column happened to occur only in these generated equi-join
      conditions then it was not erroneously marked in the TABLE::vcol_set bitmap.
      This could lead to wrong results for queries containing natural join
      expressions or USING clauses. 
      40c42468
    • Igor Babaev's avatar
      Fixed LP bug #777654. · 5ab628e0
      Igor Babaev authored
      The method Item_sum_num::fix_fields() calculated the value of
      the flag Item_sum_num::maybe_null in some cases incorrectly.
      5ab628e0
  20. 28 Dec, 2011 1 commit
    • Igor Babaev's avatar
      Fixed LP bug #879860. · 31805e62
      Igor Babaev authored
      The MIN/MAX optimization cannot be applied to a subquery if its WHERE clause
      contains a conjunctive condition depending on an outer reference.
      31805e62
  21. 27 Dec, 2011 1 commit
    • Igor Babaev's avatar
      Fixed LP bug #904345. · c9259f16
      Igor Babaev authored
      The MIN/MAX optimizer code from the function opt_sum_query erroneously
      did not take into account conjunctive conditions that did not depend on
      any table, yet were not identified as constant items. These could be
      items containing rand() or PS/SP parameters. These items are supposed
      to be evaluated at the execution phase. That's why if such conditions
      can be extracted from the WHERE condition the MIN/MAX optimization is
      not applied as currently it is always done at the optimization phase.
      
      (In 5.3 expensive subqueries are also evaluated only at the execution
      phase. So, if a constant condition with such subquery can be extracted
      from the WHERE clause the MIN/MAX optimization should not be applied 
      in 5.3.)
      
      IF an IN/ALL/SOME predicate with a constant left part is transformed
      into an EXISTS subquery the resulting subquery should not be considered
      uncacheable if the right part of the predicate is not uncacheable.
      
      Backported the function dbug_print_item() from 5.3. The function is used
      only for debugging.  
       
      c9259f16
  22. 23 Dec, 2011 1 commit
  23. 22 Dec, 2011 2 commits
  24. 21 Dec, 2011 2 commits
  25. 20 Dec, 2011 1 commit
    • Igor Babaev's avatar
      Fixed LP bug #794005. · 27380e4f
      Igor Babaev authored
      The function st_table::mark_virtual_columns_for_write() did not take into
      account the fact that for any table the value of st_table::vfield is 0
      when there are no virtual columns in the table definition.
      27380e4f
  26. 19 Dec, 2011 1 commit
    • Igor Babaev's avatar
      Fixed LP bug #906322. · bad3e417
      Igor Babaev authored
      If the sorted table belongs to a dependent subquery then the function
      create_sort_index() should not clear TABLE:: select and TABLE::select
      for this table after the sort of the table has been performed, because
      these members are needed for the second execution of the subquery.
      
       
      bad3e417
  27. 13 Dec, 2011 1 commit