• unknown's avatar
    keep old engine & JOIN if we changed subquery Item (Bug #3646) · e54ca13b
    unknown authored
    
    mysql-test/r/subselect.result:
      ALL/ANY test
    mysql-test/t/subselect.test:
      ALL/ANY test
    sql/item_subselect.cc:
      keep old engine & JOIN if we changed subquery Item, which allow avoid second all SELECT items fix_fields call with pervios clean up (because of second setup_tables which remove table->key_use and maybe something else)
      keep list when we change Item in SELECT list
      processing inserted max/min function (now JOIN::prepare will be called only once)
      methods of changing item for subselect engines
    sql/item_subselect.h:
      change item & results procedure
    sql/item_sum.cc:
      Item_sum_hybrid::clear moved to .cc file (to keep .h clean and to make inserving/removing debug info easy)
    sql/item_sum.h:
      Item_sum_hybrid::clear moved to .cc file (to keep .h clean and to make inserving/removing debug info easy)
    sql/sql_lex.cc:
      note about new method
    sql/sql_lex.h:
      method for changing result of UNION JOINs
    sql/sql_select.cc:
      method for changing result in JOIN
    sql/sql_select.h:
      method for changing result in JOIN
    sql/sql_union.cc:
      method for changing result in JOIN
    e54ca13b
subselect.test 47 KB