• Igor Babaev's avatar
    MDEV-16726 Assertion `tab->type == JT_REF || tab->type == JT_EQ_REF' failed · 9cea4ccf
    Igor Babaev authored
    Due to a legacy bug in the code of make_join_statistics() detecting
    so-called constant tables could miss some of them in rare queries
    that used RIGHT JOIN. As a result these queries had execution plans
    different from the execution plans of the equivalent queries with
    LEFT JOIN.
    Besides starting from 10.2 this could trigger an assertion failure.
    9cea4ccf
join_outer.result 78.7 KB