[
https://issues.apache.org/jira/browse/DERBY-4488?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Huib updated DERBY-4488:
------------------------
Attachment: debug info.txt
Attached is the derby log file with:
derby.language.logQueryPlan=true
derby.stream.error.logSeverityLevel=20000
> 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 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.
