[
https://issues.apache.org/jira/browse/DERBY-4488?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13013683#comment-13013683
]
Kathey Marsden commented on DERBY-4488:
---------------------------------------
ported fix to 10.4 with the following revision which does not show up in
subversion comments because the comment was for some reason truncated on the
initial checkin.
----------------------------------------------------------------------
r1085551 | kmarsden | 2011-03-25 13:33:53 -0700 (Fri, 25 Mar 2011) | 5 lines
DERBY-4488 Nullpointer when performing INSERT INTO
merge revision 903108 from trunk
Contributed by Knut Anders Hatlen
> Nullpointer when performing INSERT INTO
> ---------------------------------------
>
> Key: DERBY-4488
> URL: https://issues.apache.org/jira/browse/DERBY-4488
> Project: Derby
> Issue Type: Bug
> Components: SQL
> Affects Versions: 10.3.1.4, 10.3.2.1, 10.3.3.0, 10.4.1.3, 10.4.2.0,
> 10.5.1.1, 10.5.2.0, 10.5.3.0, 10.6.1.0
> Reporter: Huib
> Assignee: Knut Anders Hatlen
> Fix For: 10.5.3.1, 10.6.1.0
>
> Attachments: d4488.sql, debug info.txt, setTopResult.diff
>
>
> 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.
For more information on JIRA, see: http://www.atlassian.com/software/jira
