[ https://issues.apache.org/jira/browse/CALCITE-5547?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jiajun Xie updated CALCITE-5547: -------------------------------- Description: The query {code:java} SELECT '' as \"xxx\", * FROM (values (1, 4, 'one')) as t1(i ,j ,t ) LEFT JOIN (values (1, -1)) as t2(i ,k ) USING (i) {code} returns columns (xxx, i, j, i0), but should return columns (xxx, i, j, t, k) was: The query {code:java} SELECT '' as \"xxx\", * FROM (values (1, 4, 'one')) as t1(i ,j ,t ) LEFT JOIN (values (1, -1)) as t2(i ,k ) USING (i) {code} returns columns (xxx, i, j, i0), but should return columns (xxx, i, j, t, k) > JOIN USING returns incorrect column names > ----------------------------------------- > > Key: CALCITE-5547 > URL: https://issues.apache.org/jira/browse/CALCITE-5547 > Project: Calcite > Issue Type: Bug > Components: core > Affects Versions: 1.33.0 > Reporter: Sean Broeder > Assignee: Jiajun Xie > Priority: Major > Labels: pull-request-available > > The query > {code:java} > SELECT '' as \"xxx\", * > FROM (values (1, 4, 'one')) as t1(i ,j ,t ) > LEFT JOIN (values (1, -1)) as t2(i ,k ) > USING (i) {code} > returns columns (xxx, i, j, i0), > but should return columns (xxx, i, j, t, k) > -- This message was sent by Atlassian Jira (v8.20.10#820010)