[
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. {color:green}[Update: See
DERBY-6688 and DERBY-6689.]{color} 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. The change only affects task
a) mentioned. {color:green}[Update: See DERBY-6688 and DERBY-6689]{color}
> 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)
