• Igor Babaev's avatar
    MDEV-18896 Crash in convert_join_subqueries_to_semijoins · 0dd12b4f
    Igor Babaev authored
    If an IN-subquery is used in a table-less select the current code
    should never consider it as candidate for semi-join optimizations.
    Yet the function check_and_do_in_subquery_rewrites() improperly
    checked the property "to be a table-less select". As a result
    such select in IN subquery was used in INSERT .. SELECT then
    the IN subquery by mistake was registered as a semi-join subquery
    and convert_subq_to_sj() was called for it. However the code of
    this function does not assume that the parent select of the subquery
    could be a table-less select.
    0dd12b4f
subselect_sj_jcl6.result 120 KB