select query results in nullpointer exception in skipScan()
-----------------------------------------------------------
Key: DERBY-3033
URL: https://issues.apache.org/jira/browse/DERBY-3033
Project: Derby
Issue Type: Bug
Components: SQL
Affects Versions: 10.2.2.0
Environment: Windows XP, Java 5.0, JDBC, Derby 10.2.2.0
Reporter: Haolan Qin
The following error was repeatedly thrown when we tried to run a select query
via JDBC. Strangely, the exact same select query did not trigger any error when
run from the command line console. After we added an index, the error went away
completely.
java.lang.NullPointerException
at org.apache.derby.impl.sql.execute.NoPutResultSetImpl.skipScan(Unknown
Source)
at org.apache.derby.impl.sql.execute.TableScanResultSet.openCore(Unknown
Source)
at
org.apache.derby.impl.sql.execute.IndexRowToBaseRowResultSet.openCore(Unknown
Source)
at org.apache.derby.impl.sql.execute.ProjectRestrictResultSet.openCore(Unknown
Source)
at org.apache.derby.impl.sql.execute.JoinResultSet.openRight(Unknown Source)
at org.apache.derby.impl.sql.execute.JoinResultSet.openCore(Unknown Source)
at org.apache.derby.impl.sql.execute.ProjectRestrictResultSet.openCore(Unknown
Source)
at org.apache.derby.impl.sql.execute.SortResultSet.openCore(Unknown Source)
at org.apache.derby.impl.sql.execute.ProjectRestrictResultSet.openCore(Unknown
Source)
at org.apache.derby.impl.sql.execute.BasicNoPutResultSetImpl.open(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)
at org.apache.derby.impl.drda.DRDAStatement.execute(Unknown Source)
at org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknown Source)
at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source)
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
