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 "Kristian Waagan (Updated) (JIRA)" <ji...@apache.org> on 2012/03/14 17:42:41 UTC
[jira] [Updated] (DERBY-5614) NullPointerException with INSERT INTO
[global temporary table] SELECT ... FROM [VTI]
[ https://issues.apache.org/jira/browse/DERBY-5614?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kristian Waagan updated DERBY-5614:
-----------------------------------
Affects Version/s: 10.7.1.1
10.8.2.2
Adjusting Affects versions. This bug may go further back than 10.7, but I'm not planning to verify that. Since nobody has reported the problem earlier, the usage scenario is probably pretty rare.
> NullPointerException with INSERT INTO [global temporary table] SELECT ... FROM [VTI]
> ------------------------------------------------------------------------------------
>
> Key: DERBY-5614
> URL: https://issues.apache.org/jira/browse/DERBY-5614
> Project: Derby
> Issue Type: Bug
> Components: SQL
> Affects Versions: 10.7.1.1, 10.8.2.2, 10.9.0.0
> Reporter: Kristian Waagan
> Assignee: Kristian Waagan
> Labels: derby_triage10_9
> Fix For: 10.7.1.4, 10.8.2.3, 10.9.0.0
>
> Attachments: derby-5614-1a-disable_bulkinsert_gtt.diff, derby-5614-1b-disable_bulkinsert_gtt.diff, repro.sql
>
>
> Inserting into a global temporary table (GTT) while selecting data from a VTI fails with a NullPointerException:
> Caused by: java.lang.NullPointerException
> at org.apache.derby.impl.sql.execute.WriteCursorConstantAction.getEmptyHeapRow(WriteCursorConstantAction.java:324)
> at org.apache.derby.impl.sql.execute.InsertResultSet.bulkInsertCore(InsertResultSet.java:1209)
> at org.apache.derby.impl.sql.execute.InsertResultSet.open(InsertResultSet.java:466)
> at org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(GenericPreparedStatement.java:443)
> at org.apache.derby.impl.sql.GenericPreparedStatement.execute(GenericPreparedStatement.java:324)
> at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(EmbedStatement.java:1242)
> ... 6 more
> Investigation exposed the fact that bulk insert doesn't support a GTT as the target, and further that Derby enables bulk insert when the source is a VTI.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira