• unknown's avatar
    independent ALL/ANY subselect on top of WHERE clause (subselect without GROUP... · 9a3979e2
    unknown authored
    independent ALL/ANY subselect on top of WHERE clause (subselect without GROUP BY or aggregate functions) optimisation
    
    (SCRUM) (WL#1086)
    
    
    mysql-test/r/subselect.result:
      new optimisation tests
    mysql-test/t/subselect.test:
      new optimisation tests
    sql/item_cmpfunc.cc:
      new NOT
    sql/item_cmpfunc.h:
      new NOT
    sql/item_subselect.cc:
      independent ALL/ANY in top of WHERE clause optimisation
    sql/item_subselect.h:
      independent ALL/ANY in top of WHERE clause optimisation
    sql/item_sum.cc:
      prevent fixlields call for parameters of min/max if it is already done
    sql/sql_union.cc:
      removed debuging print
    sql/sql_yacc.yy:
      support of ALL optimisation
    9a3979e2
item_cmpfunc.h 22.3 KB