[jira] Commented: (DERBY-4145) NullPointerException on CREATE TABLE when generated column depends on another generated column

[Knut Anders Hatlen (JIRA)]

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

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

Full stack trace:

java.lang.NullPointerException
        at 
org.apache.derby.impl.sql.compile.BinaryOperatorNode.genSQLJavaSQLTree(BinaryOperatorNode.java:416)
        at 
org.apache.derby.impl.sql.compile.BinaryOperatorNode.bindExpression(BinaryOperatorNode.java:329)
        at 
org.apache.derby.impl.sql.compile.BinaryArithmeticOperatorNode.bindExpression(BinaryArithmeticOperatorNode.java:129)
        at 
org.apache.derby.impl.sql.compile.GenerationClauseNode.bindExpression(GenerationClauseNode.java:117)
        at 
org.apache.derby.impl.sql.compile.TableElementList.bindAndValidateGenerationClauses(TableElementList.java:803)
        at 
org.apache.derby.impl.sql.compile.CreateTableNode.bindStatement(CreateTableNode.java:441)
        at 
org.apache.derby.impl.sql.GenericStatement.prepMinion(GenericStatement.java:316)
        at 
org.apache.derby.impl.sql.GenericStatement.prepare(GenericStatement.java:88)
        at 
org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(GenericLanguageConnectionContext.java:802)
        at 
org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:606)
        at 
org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:555)
        at org.apache.derby.impl.tools.ij.ij.executeImmediate(ij.java:329)
        at org.apache.derby.impl.tools.ij.utilMain.doCatch(utilMain.java:505)
        at 
org.apache.derby.impl.tools.ij.utilMain.runScriptGuts(utilMain.java:347)
        at org.apache.derby.impl.tools.ij.utilMain.go(utilMain.java:245)
        at org.apache.derby.impl.tools.ij.Main.go(Main.java:210)
        at org.apache.derby.impl.tools.ij.Main.mainCore(Main.java:177)
        at org.apache.derby.impl.tools.ij.Main.main(Main.java:73)
        at org.apache.derby.tools.ij.main(ij.java:59)

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