[ https://issues.apache.org/jira/browse/CALCITE-5547?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17718018#comment-17718018 ]
Jiajun Xie commented on CALCITE-5547: ------------------------------------- The PR is ready: https://github.com/apache/calcite/pull/3183 > 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 SELECT '' as \"xxx\", * > FROM (values (1, 4, 'one')) as t1(i ,j ,t ) > LEFT JOIN (values (1, -1)) as t2(i ,k ) > USING (i) > 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)