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] Updated: (DERBY-4488) Nullpointer when performing INSERT INTO
Date Mon, 21 Dec 2009 02:48:18 GMT

     [ https://issues.apache.org/jira/browse/DERBY-4488?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Huib updated DERBY-4488:
------------------------

    Description: 
To replicate, execute the following 4 queries:

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


  was:
To replicate, execute the following 4 queries:

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



> 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
>         Attachments: debug info.txt
>
>
> To replicate, execute the following 4 queries:
> 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 1 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