• Oleksandr Byelkin's avatar
    MDEV-214 lp:967242 Wrong result with JOIN, AND in ON condition, multi-part... · 8fe40c50
    Oleksandr Byelkin authored
    MDEV-214 lp:967242 Wrong result with JOIN, AND in ON condition, multi-part key, GROUP BY, subquery and OR in WHERE
    
    The problem was in the code (update_const_equal_items()) which marked
    index parts constant independently of the place where the equality was used.
    In the test suite it marked t2_1.c part constant despite the fact that
    it connected by OR with other expression.
    
    Solution is to mark constant only top equalities connected with AND.
    8fe40c50
group_by.test 48 KB