db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mike Matrigali (JIRA)" <derby-...@db.apache.org>
Subject [jira] Updated: (DERBY-1574) NullPointerException in UPDATE with COALESCE and subquery
Date Tue, 25 Jul 2006 20:58:17 GMT
     [ http://issues.apache.org/jira/browse/DERBY-1574?page=all ]

Mike Matrigali updated DERBY-1574:
----------------------------------


AS posted to list:
A B commented on DERBY-1574:
----------------------------
For the record, I ran the simple repro against an early version of 10.1(10.1.2.3) and also
against 10.0, and the NPE reproduces for both of those codelines, as well.  So in case anyone
is wondering (I know I was), this is *not* a regression.  For what that's worth...

> NullPointerException in UPDATE with COALESCE and subquery
> ---------------------------------------------------------
>
>                 Key: DERBY-1574
>                 URL: http://issues.apache.org/jira/browse/DERBY-1574
>             Project: Derby
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 10.1.3.1
>         Environment: Java 1.5.0_06
>            Reporter: Christian d'Heureuse
>            Priority: Minor
>
> The following statements generate a NullPointerException:
> CREATE TABLE t1 (i INTEGER);
> CREATE TABLE t2 (i INTEGER);
> UPDATE t1
>    SET i = COALESCE(
>       (SELECT i FROM t2 WHERE t2.i=t1.i),
>       0);
> Any further SQL statements generate an internal error in RawStore, e.g.:
> SELECT * FROM t1;

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Mime
View raw message