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
