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