I agree. Your query should return (xxx, i, j, t, k). Please log a bug.
> On Feb 27, 2023, at 11:54 AM, Sean Broeder <[email protected]> wrote:
>
> Hi,
> I am investigating a query where a column is selected as well as a join of
> two tables with ‘using’ syntax. I believe calcite is not returning the
> correct columns. I am hoping someone can confirm my finding or correct my
> misunderstanding.
>
> For example, given the query:
> “SELECT '' as \"xxx\", *
> FROM (values (1, 4, 'one')) as t1(i ,j ,t )
> LEFT JOIN (values (1, -1)) as t2(i ,k )
> USING (i)”
>
> I believe it should return columns (xxx, i, j, t, k), but I am seeing (xxx,
> i, j, i0)
>
> Is my expectation correct?
>
> Thanks,
> Sean
