• Sergei Petrunia's avatar
    MDEV-22462: Item_in_subselect::create_single_in_to_exists_cond(JOIN *, Item... · 2087d47a
    Sergei Petrunia authored
    MDEV-22462: Item_in_subselect::create_single_in_to_exists_cond(JOIN *, Item **, Item **): Assertion `false' failed.
    
    Item_in_subselect::create_single_in_to_exists_cond() should handle the
    case where the subquery is a table-less select but it is not a result
    of a UNION.
    
    (Table-less subqueries like "(SELECT 1)" are "substituted" with their select
    list, but table-less subqueries with WHERE or HAVING clause, like
    "(SELECT 1 WHERE ...)" are not substituted. They are handled with regular
    execution path)
    2087d47a
subselect4.result 107 KB