• sergefp@mysql.com's avatar
    BUG#8804: wrong results for NULL IN (SELECT ...) · 54a713aa
    sergefp@mysql.com authored
    Evaluate "NULL IN (SELECT ...)" in a special way: Disable pushed-down 
    conditions and their "consequences": 
     = Do full table scans instead of unique_[index_subquery] lookups.
     = Change appropriate "ref_or_null" accesses to full table scans in
       subquery's joins.
    Also cache value of NULL IN (SELECT ...) if the SELECT is not correlated 
    wrt any upper select.
    54a713aa
subselect3.test 3.41 KB