• Igor Babaev's avatar
    MDEV-19179 Regression: SELECT ... UNION ... with inconsistent column names fails · 1248c654
    Igor Babaev authored
    A bogus error message was issued when a condition was pushed into a
    materialized derived table or view specified as union of selects with
    aggregation when the corresponding columns of the selects had different
    names. This happened because the expression pushed into having clauses of
    the selects was adjusted for the names of the first select of the union.
    The easiest solution was to rename the columns of the other selects to be
    name compatible with the columns of the first select.
    
    Approved by Oleksandr Byelkin <sanja@mariadb.com>
    1248c654
derived_cond_pushdown.result 314 KB