You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "zhen wang (JIRA)" <ji...@apache.org> on 2018/02/22 13:04:00 UTC
[jira] [Commented] (CALCITE-2081) NPE in join of 2 subqueries using
window functions
[ https://issues.apache.org/jira/browse/CALCITE-2081?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16372781#comment-16372781 ]
zhen wang commented on CALCITE-2081:
------------------------------------
https://github.com/apache/calcite/pull/634
just like Luis mentioned the issue is caused by window function variable name collisions.
this is one possible fix, [~julianhyde] let me know your thoughts
> NPE in join of 2 subqueries using window functions
> --------------------------------------------------
>
> Key: CALCITE-2081
> URL: https://issues.apache.org/jira/browse/CALCITE-2081
> Project: Calcite
> Issue Type: Bug
> Reporter: Luis Fernando Kauer
> Assignee: Julian Hyde
> Priority: Major
>
> NPE when joining 2 subqueries that use window functions.
> Testing with a new test case in JdbcTest:
> {code}
> /** Tests for a join of subqueries using Window Functions */
> @Test public void testJoinWithWinAgg() {
> final String sql = "select a.*, b.r from\n"
> + "(select \"deptno\", first_value(\"empid\") over \n"
> + "(partition by \"deptno\" order by \"commission\") as r\n"
> + "from \"hr\".\"emps\") a\n"
> + "left join\n"
> + "(select \"deptno\", last_value(\"empid\") over \n"
> + "(partition by \"deptno\" order by \"commission\") as r\n"
> + "from \"hr\".\"emps\") b\n"
> + "on a.\"deptno\" = b.\"deptno\"";
> CalciteAssert.hr()
> .query(sql)
> .runs();
> }
> {code}
> Debugging this I found out that the NPE occurs at Expressions.declare (line 2937) in initializer.getType() because initializer is null. The statement is
> {code}
> int prevStart;
> {code}
> This statement does not have an initializer, but the method "declare" is trying to get the initializer's type, generating NPE.
> This happens when joining 2 subqueries that use window functions because they end up using the same variables. In BlockBuilder.append (line 124) it checks if the variable already exists and the problem starts there.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)