• sergefp@mysql.com's avatar
    BUG#24127: (a,b) IN (SELECT c,d ...) can produce wrong results if a and/or b are NULLs: · c3f46e1f
    sergefp@mysql.com authored
    - Make the code produce correct result: use an array of triggers to turn on/off equalities for each
      compared column. Also turn on/off optimizations based on those equalities.
    - Make EXPLAIN output show "Full scan on NULL key" for tables for which we switch between
      ref/unique_subquery/index_subquery and ALL access.
    - index_subquery engine now has HAVING clause when it is needed, and it is
      displayed in EXPLAIN EXTENDED
    - Fix incorrect presense of "Using index" for index/unique-based subqueries (BUG#22930)
    // bk trigger note: this commit refers to BUG#24127
    c3f46e1f
item_subselect.cc 61.8 KB