• unknown's avatar
    Fix bugs lp:833777, lp:894397 · 62e7ab3a
    unknown authored
    Analysis:
    lp:894397 was a consequence of a prior incorrect fix of lp:833777
    which didn't take into account that even when all tables are
    constant there may be correlated conditions, and the where clause
    is not equivalent to the constant conditions.
    
    Solution:
    When there are constant tables only, evaluate only the conditions
    that reference outer fields, because the constant conditions are
    already checked, and the where clause doesn't have other conditions
    than constant ones, and outer referencing ones. The fix for
    lp:894397 also fixes lp:833777.
    62e7ab3a
subselect_no_semijoin.result 196 KB