• Igor Babaev's avatar
    Fixed bug #49600. · 577b7345
    Igor Babaev authored
    The problem could be demonstrated with an outer join of two single-row
    tables where the values of the join attributes were null. Any query
    with such a join could return a wrong result set if the where
    condition of the query was not empty. For queries with empty
    where conditions the result sets were correct.
    This was the consequence of two bugs in the code:
     - Item_equal objects for on conditions of outer joins were
       not built if the processed query had no where condition
     - the check for null values in the code that evaluated constant 
       Item_equal objects was incorrect.
    Fixed both above problems.
    Added a test case for the bug and adjusted results for some other
    test cases.
    577b7345
sql_select.cc 561 KB