• Varun Gupta's avatar
    MDEV-23449: alias do not exist and a query do not report an error · 26f50335
    Varun Gupta authored
    For an IN/ANY/ALL subquery without an aggregate function and HAVING clause,
    the GROUP BY clause is removed.
    Due to the GROUP BY list being removed, the invalid reference in the GROUP BY
    clause was never resolved.
    Remove the GROUP BY list only when the all the items in the GROUP BY list
    are resolved.
    Also removing the GROUP BY list later would not affect the extension that allows
    using non-aggregated field in an aggregate function (when ONLY_FULL_GROUP_BY
    is not set) because the GROUP BY list is removed only when their is
    NO aggregate function in IN/ALL/ANY subquery.
    26f50335
subselect4.result 104 KB