Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Message-ID: <211856838.1257544953186.JavaMail.jira@brutus>
Date: Fri, 6 Nov 2009 22:02:33 +0000 (UTC)
From: "Knut Anders Hatlen (JIRA)" <jira@apache.org>
To: derby-dev@db.apache.org
Subject: [jira] Commented: (DERBY-4439) NullPointerException at bind time
 when selecting from VALUES NULL
In-Reply-To: <1223072317.1257544952751.JavaMail.jira@brutus>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


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

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

java.lang.NullPointerException
	at org.apache.derby.impl.sql.compile.BinaryOperatorNode.genSQLJavaSQLTree(BinaryOperatorNode.java:412)
	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.ResultColumn.bindExpression(ResultColumn.java:605)
	at org.apache.derby.impl.sql.compile.ResultColumnList.bindExpressions(ResultColumnList.java:693)
	at org.apache.derby.impl.sql.compile.SelectNode.bindExpressions(SelectNode.java:552)
	at org.apache.derby.impl.sql.compile.DMLStatementNode.bindExpressions(DMLStatementNode.java:227)
	at org.apache.derby.impl.sql.compile.DMLStatementNode.bind(DMLStatementNode.java:140)
	at org.apache.derby.impl.sql.compile.CursorNode.bindStatement(CursorNode.java:249)
	at org.apache.derby.impl.sql.GenericStatement.prepMinion(GenericStatement.java:324)
	at org.apache.derby.impl.sql.GenericStatement.prepare(GenericStatement.java:90)
	at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(GenericLanguageConnectionContext.java:828)
	at org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:606)
	at org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:555)

> NullPointerException at bind time when selecting from VALUES NULL
> -----------------------------------------------------------------
>
>                 Key: DERBY-4439
>                 URL: https://issues.apache.org/jira/browse/DERBY-4439
>             Project: Derby
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 10.5.3.0, 10.6.0.0
>            Reporter: Knut Anders Hatlen
>            Priority: Minor
>
> I see a NullPointerException when I try the following query:
> ij> select x*2 from (values null) v(x);
> ERROR XJ001: Java exception: ': java.lang.NullPointerException'.
> It should fail gracefully instead, like this similar query:
> ij> select x from (values null) v(x);
> ERROR 42X07: Null is only allowed in a VALUES clause within an INSERT statement.

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