You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Mark Swatosh (JIRA)" <ji...@apache.org> on 2019/01/07 16:12:00 UTC

[jira] [Updated] (DERBY-6735) NPE when the select list contains ROW_NUMBER and subquery

     [ https://issues.apache.org/jira/browse/DERBY-6735?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Mark Swatosh updated DERBY-6735:
--------------------------------
    Affects Version/s: 10.14.2.0

> NPE when the select list contains ROW_NUMBER and subquery
> ---------------------------------------------------------
>
>                 Key: DERBY-6735
>                 URL: https://issues.apache.org/jira/browse/DERBY-6735
>             Project: Derby
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 10.6.1.0, 10.7.1.1, 10.8.1.2, 10.9.1.0, 10.10.1.1, 10.11.1.1, 10.14.2.0
>         Environment: Windows 7 64Bit, Java8_20 64Bit
>            Reporter: Thomas Meyer
>            Priority: Major
>
> When using row_number() over() in an SQL I get this exception:
> ERROR XJ001: DERBY SQL error: ERRORCODE: 0, SQLSTATE: XJ001, SQLERRMC: java.lang.NullPointerException¶¶XJ001.U
> java.sql.SQLException: DERBY SQL error: ERRORCODE: 0, SQLSTATE: XJ001, SQLERRMC: java.lang.NullPointerException¶¶XJ001.U
>         at org.apache.derby.client.am.SQLExceptionFactory.getSQLException(Unknown Source)
>         at org.apache.derby.client.am.SqlException.getSQLException(Unknown Source)
>         at org.apache.derby.client.am.ClientStatement.execute(Unknown Source)
>         at org.apache.derby.impl.tools.ij.ij.executeImmediate(Unknown Source)
>         at org.apache.derby.impl.tools.ij.utilMain.doCatch(Unknown Source)
>         at org.apache.derby.impl.tools.ij.utilMain.runScriptGuts(Unknown Source)
>         at org.apache.derby.impl.tools.ij.utilMain.go(Unknown Source)
>         at org.apache.derby.impl.tools.ij.Main.go(Unknown Source)
>         at org.apache.derby.impl.tools.ij.Main.mainCore(Unknown Source)
>         at org.apache.derby.impl.tools.ij.Main.main(Unknown Source)
>         at org.apache.derby.tools.ij.main(Unknown Source)
> Caused by: ERROR XJ001: DERBY SQL error: ERRORCODE: 0, SQLSTATE: XJ001, SQLERRMC: java.lang.NullPointerException¶¶XJ001.U
>         at org.apache.derby.client.am.ClientStatement.completeSqlca(Unknown Source)
>         at org.apache.derby.client.net.NetStatementReply.parsePrepareError(Unknown Source)
>         at org.apache.derby.client.net.NetStatementReply.parsePRPSQLSTTreply(Unknown Source)
>         at org.apache.derby.client.net.NetStatementReply.readPrepareDescribeOutput(Unknown Source)
>         at org.apache.derby.client.net.StatementReply.readPrepareDescribeOutput(Unknown Source)
>         at org.apache.derby.client.net.NetStatement.readPrepareDescribeOutput_(Unknown Source)
>         at org.apache.derby.client.am.ClientStatement.readPrepareDescribeOutput(Unknown Source)
>         at org.apache.derby.client.am.ClientStatement.flowExecute(Unknown Source)
>         at org.apache.derby.client.am.ClientStatement.executeX(Unknown Source)
>         ... 9 more
> ij>



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)