Derby
  1. Derby
  2. DERBY-5385

Improve documentation for OFFSET/FETCH NEXT

    Details

    • Type: Improvement Improvement
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 10.6.1.0, 10.6.2.1, 10.7.1.1, 10.8.1.2
    • Fix Version/s: 10.8.2.2, 10.9.1.0
    • Component/s: Documentation
    • Labels:
      None

      Description

      cf the suggestion in DERBY-4518.

      1. rrefsqljoffsetfetch.html
        5 kB
        Kim Haase
      2. DERBY-5385.diff
        2 kB
        Kim Haase

        Issue Links

          Activity

          Dag H. Wanvik created issue -
          Dag H. Wanvik made changes -
          Field Original Value New Value
          Link This issue is related to DERBY-4518 [ DERBY-4518 ]
          Dag H. Wanvik made changes -
          Affects Version/s 10.7.1.1 [ 12315564 ]
          Affects Version/s 10.6.2.1 [ 12315343 ]
          Affects Version/s 10.6.1.0 [ 12313727 ]
          Kim Haase made changes -
          Assignee Kim Haase [ chaase3 ]
          Hide
          Kim Haase added a comment -

          Attaching DERBY-5385.diff and rrefsqljoffsetfetch.html. The patch clarifies the meaning of "dynamic parameter" and adds an example of using one of the clauses in a subquery (the same example that is in the Query topic).

          Please let me know if changes are needed or if more information would be useful.

          Show
          Kim Haase added a comment - Attaching DERBY-5385 .diff and rrefsqljoffsetfetch.html. The patch clarifies the meaning of "dynamic parameter" and adds an example of using one of the clauses in a subquery (the same example that is in the Query topic). Please let me know if changes are needed or if more information would be useful.
          Kim Haase made changes -
          Attachment DERBY-5385.diff [ 12490810 ]
          Attachment rrefsqljoffsetfetch.html [ 12490811 ]
          Kim Haase made changes -
          Issue & fix info [Patch Available]
          Hide
          Dag H. Wanvik added a comment - - edited

          Thanks, Kim. Changes look good to me. But this observation by Tiago was the reason we kept DERBY-4518 open, I believe:

          "I couldn't find an example under "The result offset and fetch first clauses" that demonstrates the use of OFFSET within sub-queries. There is an example under "Duplicates in UNION, INTERSECT, and EXCEPT ALL results" but at least to me, that wouldn't be the first logical place I'd visit to find examples of OFFSET usage on sub-queries."

          Perhaps it might be good to to point to the example of use in sub-queries from "The result offset and fetch first clauses" section's examples, or make another one there?

          Show
          Dag H. Wanvik added a comment - - edited Thanks, Kim. Changes look good to me. But this observation by Tiago was the reason we kept DERBY-4518 open, I believe: "I couldn't find an example under "The result offset and fetch first clauses" that demonstrates the use of OFFSET within sub-queries. There is an example under "Duplicates in UNION, INTERSECT, and EXCEPT ALL results" but at least to me, that wouldn't be the first logical place I'd visit to find examples of OFFSET usage on sub-queries." Perhaps it might be good to to point to the example of use in sub-queries from "The result offset and fetch first clauses" section's examples, or make another one there?
          Hide
          Kim Haase added a comment -

          I thought I took that example from "Duplicates in UNION, INTERSECT, and EXCEPT ALL results" and put it right into this topic. Isn't it there? The comment says "Use of ORDER BY and FETCH FIRST in a subquery".

          Show
          Kim Haase added a comment - I thought I took that example from "Duplicates in UNION, INTERSECT, and EXCEPT ALL results" and put it right into this topic. Isn't it there? The comment says "Use of ORDER BY and FETCH FIRST in a subquery".
          Hide
          Dag H. Wanvik added a comment -

          Sure it's there. I must have looked at this before my morning coffee.. Sorry +1

          Show
          Dag H. Wanvik added a comment - Sure it's there. I must have looked at this before my morning coffee.. Sorry +1
          Hide
          Kim Haase added a comment -

          Thanks very much, Dag!

          Committed patch DERBY-5385.diff to documentation trunk at revision 1160250.
          Merged to 10.8 doc branch at revision 1160256.

          Show
          Kim Haase added a comment - Thanks very much, Dag! Committed patch DERBY-5385 .diff to documentation trunk at revision 1160250. Merged to 10.8 doc branch at revision 1160256.
          Kim Haase made changes -
          Status Open [ 1 ] Resolved [ 5 ]
          Issue & fix info [Patch Available]
          Fix Version/s 10.8.1.6 [ 12316676 ]
          Fix Version/s 10.9.0.0 [ 12316344 ]
          Resolution Fixed [ 1 ]
          Hide
          Dag H. Wanvik added a comment -

          Thanks, Kim, closing.

          Show
          Dag H. Wanvik added a comment - Thanks, Kim, closing.
          Dag H. Wanvik made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Myrna van Lunteren made changes -
          Fix Version/s 10.8.2.0 [ 12317955 ]
          Fix Version/s 10.8.1.6 [ 12316676 ]
          Myrna van Lunteren made changes -
          Fix Version/s 10.8.2.2 [ 12317968 ]
          Fix Version/s 10.8.2.0 [ 12317955 ]
          Gavin made changes -
          Workflow jira [ 12627338 ] Default workflow, editable Closed status [ 12797175 ]

            People

            • Assignee:
              Kim Haase
              Reporter:
              Dag H. Wanvik
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development