Re: Alias on union

2024-01-05 Thread Eric Berryman
Thank you! That was exactly it! I didn’t realize that was the behavior. But it of course makes sense after being told. Eric On Fri, Jan 5, 2024 at 17:00 Julian Hyde wrote: > Maybe the problem is the ‘build()’ after ‘as(“core”)’? > > The alias is associated with entry on the RelBuilder stack,

Re: Alias on union

2024-01-05 Thread Julian Hyde
Maybe the problem is the ‘build()’ after ‘as(“core”)’? The alias is associated with entry on the RelBuilder stack, not the RelNode. Once you have popped it, the alias is forgotten. Julian > On Jan 5, 2024, at 10:47, Eric Berryman wrote: > > I’m trying to use a union in a join, but I don’t

Alias on union

2024-01-05 Thread Eric Berryman
I’m trying to use a union in a join, but I don’t see the alias as available (I get an error that the alias/field does not exist on the line of the below left join). The error shows available alias/fields and I see the union id fields but the alias is an empty set aliases:[]. Is this possible?