• Tom Lane's avatar
    Fix UNION/INTERSECT/EXCEPT over no columns. · c4c2885c
    Tom Lane authored
    Since 9.4, we've allowed the syntax "select union select" and variants
    of that.  However, the planner wasn't expecting a no-column set operation
    and ended up treating the set operation as if it were UNION ALL.
    
    Turns out it's trivial to fix in v10 and later; we just need to be careful
    about not generating a Sort node with no sort keys.  However, since a weird
    corner case like this is never going to be exercised by developers, we'd
    better have thorough regression tests if we want to consider it supported.
    
    Per report from Victor Yegorov.
    
    Discussion: https://postgr.es/m/CAGnEbojGJrRSOgJwNGM7JSJZpVAf8xXcVPbVrGdhbVEHZ-BUMw@mail.gmail.com
    c4c2885c
createplan.c 194 KB