You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "Julian Hyde (JIRA)" <ji...@apache.org> on 2015/07/13 20:43:04 UTC
[jira] [Created] (CALCITE-801) NullPointerException using USING on
table alias with column aliases
Julian Hyde created CALCITE-801:
-----------------------------------
Summary: NullPointerException using USING on table alias with column aliases
Key: CALCITE-801
URL: https://issues.apache.org/jira/browse/CALCITE-801
Project: Calcite
Issue Type: Bug
Reporter: Julian Hyde
Assignee: Julian Hyde
Calcite gives a NullPointerException using USING on table alias with column aliases. For example,
{code}
select *
from (values (100, 'Bill', 1),
(200, 'Eric', 1),
(150, 'Sebastian', 3)) as e(empid, name, deptno)
join (values (1, 'LeaderShip'),
(2, 'TestGroup'),
(3, 'Development')) as d(deptno, name)
using (deptno);
{code}
gives
{noformat}
Caused by: java.lang.NullPointerException
> at org.apache.calcite.sql2rel.SqlToRelConverter.convertUsing(SqlToRelConverter.java:2306)
> at org.apache.calcite.sql2rel.SqlToRelConverter.convertJoinCondition(SqlToRelConverter.java:2279)
> at org.apache.calcite.sql2rel.SqlToRelConverter.convertFrom(SqlToRelConverter.java:1921)
> at org.apache.calcite.sql2rel.SqlToRelConverter.convertSelectImpl(SqlToRelConverter.java:601)
> at org.apache.calcite.sql2rel.SqlToRelConverter.convertSelect(SqlToRelConverter.java:581)
> at org.apache.calcite.sql2rel.SqlToRelConverter.convertQueryRecursive(SqlToRelConverter.java:2763)
> at org.apache.calcite.sql2rel.SqlToRelConverter.convertQuery(SqlToRelConverter.java:535)
> at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:222)
> at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:188)
> at org.apache.calcite.prepare.CalcitePrepareImpl.prepare2_(CalcitePrepareImpl.java:669)
{noformat}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)