You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Knut Anders Hatlen (JIRA)" <ji...@apache.org> on 2009/12/21 08:46:18 UTC
[jira] Commented: (DERBY-4488) Nullpointer when performing INSERT
INTO
[ https://issues.apache.org/jira/browse/DERBY-4488?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12793103#action_12793103 ]
Knut Anders Hatlen commented on DERBY-4488:
-------------------------------------------
I tried to reproduce this on 10.5.3.0, starting with a clean database. Here's what I see:
ij> CREATE TABLE feed (fst INTEGER, snd VARCHAR(50), UNIQUE(fst));
0 rows inserted/updated/deleted
ij> INSERT INTO feed VALUES (1, 'fst');
1 row inserted/updated/deleted
ij> CREATE TABLE tbl (col1 INTEGER, col2 INTEGER NOT NULL REFERENCES feed (fst) ON DELETE RESTRICT ON UPDATE RESTRICT);
0 rows inserted/updated/deleted
ij> INSERT INTO tbl(col1) SELECT 1 FROM feed;
ERROR 23502: Column 'COL2' cannot accept a NULL value.
Did I miss something?
> 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.