• unknown's avatar
    Some simple optimisation · 1db2b4e6
    unknown authored
    = ANY and <> ALL converted to (NOT) IN to get advantage of IN optimisation
    
    
    mysql-test/r/subselect.result:
      test of new optimisation
    mysql-test/t/subselect.test:
      test of new optimisation
    sql/mysql_priv.h:
      new function for subquery creation
    sql/sql_parse.cc:
      layout fix
      new function for subquery creation (convert some ALL/ANY to IN)
    sql/sql_yacc.yy:
      same code blocks replaced with function
    1db2b4e6
subselect.result 53.7 KB