[DERBY-4488] Nullpointer when performing INSERT INTO

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 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
• Fix Version/s: 10.3.3.1, 10.4.2.1, 10.5.3.1, 10.6.1.0
• Component/s: SQL
• Urgency: Normal
• Issue & fix info: Repro attached
• Bug behavior facts: Regression
• Assignee: Knut Anders Hatlen
• Reporter: Huib
• Created: 21/Dec/09 02:34
• Updated: 17/Jun/13 09:19
• Resolved: 31/Mar/11 19:55

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)