[jira] [Comment Edited] (DERBY-6565) ROW_NUMBER function throws NullPointerException in UPDATE statement

["Dag H. Wanvik (JIRA)" <ji...@apache.org>]

    [ 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/5/14 2:56 AM:
--------------------------------------------------------------

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.


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.

> 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
>         Attachments: 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)