Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Date: Wed, 6 Aug 2014 17:48:12 +0000 (UTC)
From: "Dag H. Wanvik (JIRA)" <jira@apache.org>
To: derby-dev@db.apache.org
Message-ID: <JIRA.12712555.1399375676714.26853.1407347292073@arcas>
In-Reply-To: <JIRA.12712555.1399375676714@arcas>
References: <JIRA.12712555.1399375676714@arcas>
Subject: [jira] [Comment Edited] (DERBY-6565) ROW_NUMBER function throws
 NullPointerException in UPDATE statement
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


    [ https://issues.apache.org/jira/browse/DERBY-6565?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14085706#comment-14085706 ] 

Dag H. Wanvik edited comment on DERBY-6565 at 8/6/14 5:47 PM:
--------------------------------------------------------------

Here is a single line patch that makes the repro work. I am not sure if this change is sound, or we need more. If it is, it seems we are lucky and we can marry the windowing rather easily into the update. Reminder to self: any new tests should also include the new MERGE statement. The change only affects task a) mentioned. {color:green}[Update: See DERBY-6688 and DERBY-6689]{color}


was (Author: dagw):
Here is a single line patch that makes the repro work. I am not sure if this change is sound, or we need more. If it is, it seems we are lucky and we can marry the windowing rather easily into the update. Reminder to self: any new tests should also include the new MERGE statement. The change only affects task a) mentioned.

> ROW_NUMBER function throws NullPointerException in UPDATE statement
> -------------------------------------------------------------------
>
>                 Key: DERBY-6565
>                 URL: https://issues.apache.org/jira/browse/DERBY-6565
>             Project: Derby
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 10.10.2.0
>            Reporter: Knut Anders Hatlen
>            Assignee: Dag H. Wanvik
>            Priority: Minor
>             Fix For: 10.11.1.1
>
>         Attachments: derby-6565-forbid.diff, derby-6565-forbid.status, derby-6565.diff
>
>
> A NullPointerException is raised with this (possibly illegal?) UPDATE statement:
> {noformat}
> ij version 10.10
> ij> connect 'jdbc:derby:memory:db;create=true';
> ij> create table t(x int);
> 0 rows inserted/updated/deleted
> ij> insert into t values 1;
> 1 row inserted/updated/deleted
> ij> update t set x = row_number() over ();
> ERROR XJ001: Java exception: ': java.lang.NullPointerException'.
> {noformat}


--
This message was sent by Atlassian JIRA
(v6.2#6252)