Details

    • Type: Improvement Improvement
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 10.6.1.0
    • Component/s: SQL
    • Labels:
      None
    • Urgency:
      Normal

      Description

      SQL 2008 allows ORDER BY to be specified in subqueries. In conjunction with OFFSET/FETCH and/or ROW_NUMBER
      meaningful subqueries with row ordering may be formulated. Cf. MySQL's LIMIT may be used in subqueries as well.
      Note that OFFSET/FETCH is currently not allowed in subqueries, either.

      1. derby-4397-1.diff
        55 kB
        Dag H. Wanvik
      2. derby-4397-1.stat
        1 kB
        Dag H. Wanvik
      3. derby-4397-2.diff
        50 kB
        Dag H. Wanvik
      4. derby-4397-2.stat
        1 kB
        Dag H. Wanvik
      5. derby-4397-all-subqueries.diff
        70 kB
        Dag H. Wanvik
      6. derby-4397-all-subqueries.stat
        2 kB
        Dag H. Wanvik
      7. derby-4397-insert-from-exists.diff
        59 kB
        Dag H. Wanvik
      8. derby-4397-insert-from-exists.stat
        2 kB
        Dag H. Wanvik
      9. derby-4397-sortavoidance-a.diff
        3 kB
        Dag H. Wanvik
      10. derby-4397-sortavoidance-a.stat
        0.2 kB
        Dag H. Wanvik
      11. orderBySpec.html
        11 kB
        Dag H. Wanvik
      12. orderBySpec.html
        10 kB
        Dag H. Wanvik
      13. orderBySpec.html
        10 kB
        Dag H. Wanvik
      14. orderBySpec.html
        9 kB
        Dag H. Wanvik
      15. orderBySpec.html
        9 kB
        Dag H. Wanvik
      16. orderBySpec.html
        9 kB
        Dag H. Wanvik

        Issue Links

          Activity

          No work has yet been logged on this issue.

            People

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

              Dates

              • Created:
                Updated:
                Resolved:

                Development