db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Knut Anders Hatlen (JIRA)" <derby-...@db.apache.org>
Subject [jira] Created: (DERBY-1528) Preparing "SELECT INTO table SELECT FROM (...)" may cause NullPointerException and subsequent internal errors reported by RawStore module
Date Tue, 18 Jul 2006 10:48:13 GMT
Preparing "SELECT INTO table SELECT FROM (...)" may cause NullPointerException and subsequent
internal errors reported by RawStore module
-----------------------------------------------------------------------------------------------------------------------------------------

                 Key: DERBY-1528
                 URL: http://issues.apache.org/jira/browse/DERBY-1528
             Project: Derby
          Issue Type: Bug
          Components: SQL
    Affects Versions: 10.1.3.1
            Reporter: Knut Anders Hatlen


When preparing a "INSERT INTO table SELECT FROM (...)" statement,
Derby in some cases throw a NullPointerException or an
AssertFailure. This happens when a '?' occurs in a VALUES statement in
the from list. If one tries to access the table after the
NullPointerException, this exception is thrown:

ERROR 40XT0: An internal error was identified by RawStore module.

Example:

ij> create table t (text varchar(20), len int);
0 rows inserted/updated/deleted
ij> prepare p as 'insert into t select x, length(x) from (values(?)) as v(x)';
ERROR XJ001: Java exception: ': java.lang.NullPointerException'.
ij> select * from t;
ERROR 40XT0: An internal error was identified by RawStore module.

Replacing '?' with 'CAST (? AS VARCHAR(20))' fixes the problem, but
there is enough information in the query to determine the type of the
parameter even without the cast.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Mime
View raw message