db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Dag H. Wanvik (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (DERBY-6565) ROW_NUMBER function throws NullPointerException in UPDATE statement
Date Tue, 05 Aug 2014 02:56:15 GMT

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

Dag H. Wanvik updated DERBY-6565:
---------------------------------

    Attachment: derby-6565.diff

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)

Mime
View raw message