db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rick Hillegas (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-4145) NullPointerException on CREATE TABLE when generated column depends on another generated column
Date Mon, 06 Apr 2009 19:03:12 GMT

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

Rick Hillegas commented on DERBY-4145:
--------------------------------------

The bug occurs when a generation clause includes a forward reference to a generated column
which is declared later on in the table's signature. The bug occurs because we look for the
referenced columns after we bind the generation clauses. When we bind the earlier generated
columns, we trip across references to columns which haven't been bound yet. This raises an
npe. The fix is to bind the generation clauses after we look for illegal references.

> NullPointerException on CREATE TABLE when generated column depends on another generated
column
> ----------------------------------------------------------------------------------------------
>
>                 Key: DERBY-4145
>                 URL: https://issues.apache.org/jira/browse/DERBY-4145
>             Project: Derby
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 10.5.1.0
>            Reporter: Knut Anders Hatlen
>            Assignee: Rick Hillegas
>
> ij> create table t (c1 int, c2 int, c3 generated always as (c1 + c4), c4 generated
always as (-c1));
> 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