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

          Issue Links

          is related to

          Bug - A problem which impairs or prevents the functions of the product. DERBY-1357 Short-circuit logic in optimizer appears to be incorrect...

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. DERBY-4798 NPE in nested outer join

          • Major - Major loss of function.
          • Closed

          Improvement - An improvement or enhancement to an existing feature or task. DERBY-3097 Unnecessary if statement can be removed from BaseActivation.getColumnFromNow

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

            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: