Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-3033

select query results in nullpointer exception in skipScan()

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.2.2.0
    • Fix Version/s: 10.3.2.1, 10.4.1.3
    • Component/s: SQL
    • Labels:
      None
    • Environment:
      Windows XP, Java 5.0, JDBC, Derby 10.2.2.0
    • Bug behavior facts:
      Regression

      Description

      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)

        Attachments

        1. bug4736.sql
          1 kB
          Bryan Pendleton
        2. d3033-sane-ij-session-10.3.1.5.txt
          8 kB
          Dag H. Wanvik
        3. generatedActivation.txt
          11 kB
          Bryan Pendleton
        4. noClosureOfNotExists.diff
          2 kB
          Bryan Pendleton
        5. patchWithImprovedComments.diff
          43 kB
          Bryan Pendleton
        6. patchWithRenamedTest.diff
          41 kB
          Bryan Pendleton
        7. query_plan.new
          10 kB
          Katherine Marsden
        8. query_plan.old
          7 kB
          Katherine Marsden
        9. queryPlanRS.txt
          1 kB
          Bryan Pendleton
        10. repro2.java
          9 kB
          Bryan Pendleton
        11. repro2.java
          7 kB
          Bryan Pendleton
        12. repro3.java
          9 kB
          A B
        13. test.rar
          946 kB
          Haolan Qin
        14. test.zip
          1.16 MB
          Dag H. Wanvik
        15. viewer_10_1.zip
          803 kB
          Katherine Marsden

          Issue Links

            Activity

              People

              • Assignee:
                bryanpendleton Bryan Pendleton
                Reporter:
                hqin Haolan Qin
              • Votes:
                1 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: