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] Created: (DERBY-4672) NullPointerException in insert from nested select with parameter
Date Fri, 21 May 2010 14:22:16 GMT
NullPointerException in insert from nested select with parameter
----------------------------------------------------------------

                 Key: DERBY-4672
                 URL: https://issues.apache.org/jira/browse/DERBY-4672
             Project: Derby
          Issue Type: Bug
          Components: SQL
    Affects Versions: 10.6.1.0, 10.5.3.0, 10.4.1.3, 10.2.2.0, 10.7.0.0
            Reporter: Knut Anders Hatlen


Compilation of this statement fails with a NullPointerException:

    insert into t select x from (select ? from t) s(x)

It should fail, but not with a NullPointerException. The expected error is:

ERROR 42X34: There is a ? parameter in the select list.  This is not allowed.

I found this issue when testing the fix for DERBY-4671. It is not the same issue, since DERBY-4671
was a regression in 10.6.1, and this issue has been there for a long time (I've only tested
back to 10.2.2.0, but it may have existed even before that).

java.lang.NullPointerException
        at org.apache.derby.impl.sql.compile.BaseTypeCompiler.numberStorable(BaseTypeCompiler.java:316)
        at org.apache.derby.impl.sql.compile.NumericTypeCompiler.storable(NumericTypeCompiler.java:329)
        at org.apache.derby.impl.sql.compile.ResultColumn.checkStorableExpression(ResultColumn.java:887)
        at org.apache.derby.impl.sql.compile.ResultColumn.checkStorableExpression(ResultColumn.java:879)
        at org.apache.derby.impl.sql.compile.ResultColumnList.checkStorableExpressions(ResultColumnList.java:953)
        at org.apache.derby.impl.sql.compile.InsertNode.bindStatement(InsertNode.java:456)
        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.EmbedPreparedStatement.<init>(EmbedPreparedStatement.java:130)
        at org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(EmbedPreparedStatement20.java:82)
        at org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(EmbedPreparedStatement30.java:63)
        at org.apache.derby.impl.jdbc.EmbedPreparedStatement40.<init>(EmbedPreparedStatement40.java:40)
        at org.apache.derby.jdbc.Driver40.newEmbedPreparedStatement(Driver40.java:105)
        at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(EmbedConnection.java:1607)
        at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(EmbedConnection.java:1435)

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