Thank you for confirming Julian. I have logged CALCITE-5547 for this.
> On Feb 27, 2023, at 12:23 PM, Julian Hyde <[email protected]> wrote:
>
> 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
>
