Yasir <yasir.hussain.s...@gmail.com> writes:
> On Sat, Oct 26, 2024 at 12:21 AM Tom Lane <t...@sss.pgh.pa.us> wrote:
>> I forgot to mention a third problem, which is that reassigning the
>> alias during subquery pullup means it doesn't happen if subquery
>> pullup doesn't happen.
> Yes, that is by design.
By design? How can you claim that's not a bug? The alias(es)
associated with a VALUES clause surely should not vary depending
on whether the clause includes a volatile function --- not to
mention other unobvious reasons for flattening to happen or not.
regards, tom lane
