db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Huib (JIRA)" <j...@apache.org>
Subject [jira] Created: (DERBY-4488) Nullpointer when performing INSERT INTO
Date Mon, 21 Dec 2009 02:35:18 GMT
Nullpointer when performing INSERT INTO
---------------------------------------

                 Key: DERBY-4488
                 URL: https://issues.apache.org/jira/browse/DERBY-4488
             Project: Derby
          Issue Type: Bug
          Components: Store
    Affects Versions: 10.5.3.0
            Reporter: Huib


To replicate, execute the following SQL:

create table feed (fst integer, snd varchar(50), unique(fst))
insert into feed values (1, 'fst')

CREATE TABLE tbl (col1 INTEGER, col2 INTEGER NOT NULL REFERENCES feed (fst) ON DELETE RESTRICT
ON UPDATE RESTRICT)

insert into tbl(col1) 
select 2 from feed

The result of the last INSERT INTO query is:
java.lang.NullPointerException
	at org.apache.derby.impl.store.access.btree.BTreeScan.initScanParams(Unknown Source)
	at org.apache.derby.impl.store.access.btree.BTreeScan.reopenScan(Unknown Source)
	at org.apache.derby.impl.sql.execute.TableScanResultSet.reopenScanController(Unknown Source)
	at org.apache.derby.impl.sql.execute.TableScanResultSet.reopenScanController(Unknown Source)
	at org.apache.derby.impl.sql.execute.TableScanResultSet.reopenCore(Unknown Source)
	at org.apache.derby.impl.sql.execute.BulkTableScanResultSet.reopenCore(Unknown Source)
	at org.apache.derby.impl.sql.execute.ProjectRestrictResultSet.reopenCore(Unknown Source)
	at org.apache.derby.impl.sql.execute.NormalizeResultSet.reopenCore(Unknown Source)
	at org.apache.derby.impl.sql.execute.InsertResultSet.open(Unknown Source)
	at org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown Source)
	at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source)
	at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source)
	at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source)
	at org.apache.derby.impl.jdbc.EmbedPreparedStatement.execute(Unknown Source)


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