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

A corner case bug and missing optimization in ScrollInsensitiveResultSet

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • 10.0.2.1
    • 10.2.1.6
    • JDBC
    • None
    • Solaris 10/x86, Sun VM 1.4.2

    Description

      a) For a scrollable, insensitive result set (read-only) which is
      empty, ResultSet#afterLast should have no effect, but erroneously
      sets the internal variable afterLast to true, so that a sunsequent
      call to ResultSet#isAfterLast will return 'true' in the embedded
      client. It does not happen on the client driver, because it seems
      to do some double book-keeping for this case.

      b) In ScrollInsensitiveResultSet#getNextRowCore and #getAbsoluteRow,
      there are missing checks will cause unnecessary read (attempts)
      from underlying result set even if end has been seen already.

      Both would be nice to fix in preparation for DERBY-690...

      Attachments

        1. derby-992-1.diff
          2 kB
          Dag H. Wanvik
        2. derby-992-1.stat
          0.2 kB
          Dag H. Wanvik
        3. Main.java
          1 kB
          Dag H. Wanvik

        Activity

          People

            dagw Dag H. Wanvik
            dagw Dag H. Wanvik
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: