db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Knut Anders Hatlen (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-4425) NullPointerException with INSERT INTO ... from UNION and columns generated from expressions
Date Tue, 08 Dec 2009 10:31:18 GMT

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

Knut Anders Hatlen commented on DERBY-4425:
-------------------------------------------

DERBY-4442 fixed a family of INSERT bugs, including this one, making the original fix for
this issue unnecessary. The fix was therefore backed out in revision 888311, but the tests
are still part of the regression test suite.

> NullPointerException with INSERT INTO ... from UNION and columns generated from expressions
> -------------------------------------------------------------------------------------------
>
>                 Key: DERBY-4425
>                 URL: https://issues.apache.org/jira/browse/DERBY-4425
>             Project: Derby
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 10.5.1.1, 10.5.3.0, 10.6.0.0
>            Reporter: Knut Anders Hatlen
>            Assignee: Bryan Pendleton
>             Fix For: 10.6.0.0
>
>         Attachments: checkIsGenerated.diff
>
>
> This bug is similar to DERBY-4419, only that it uses columns that are auto-generated
from expressions and not identity columns. The proposed fix for DERBY-4419 only addresses
the case with an identity column.
> ij> create table t1(x int);
> 0 rows inserted/updated/deleted
> ij> create table t2(x int);
> 0 rows inserted/updated/deleted
> ij> create table t3(x int, y generated always as (2*x));
> 0 rows inserted/updated/deleted
> ij> insert into t3(x) select * from t1 union select * from t2;
> ERROR XJ001: Java exception: ': java.lang.NullPointerException'.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message