[
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.
