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 specifies that OFFSET/FETCH (<result offset clause>, <fetch
      first clause>) may be used in subqueries. Currently, Derby only
      allows this at the outer (cursor) level. Cf. also DERBY-4397 on
      allowing ORDER BY in subqueries for this extension to be portable and
      useful.

      SQL features:

      F856 Nested <fetch first clause> in <query expression>
      F857 Top-level <fetch first clause> in <query expression> (already present in 10.5)
      F858 <fetch first clause> in subqueries
      F859 Top-level <fetch first clause> in views
      F860 dynamic <fetch first row count> in <fetch first clause> (already present in 10.5)

      F861 Top-level <result offset clause> in <query expression> (already present in 10.5)
      F862 <result offset clause> in subqueries
      F863 Nested <result offset clause> in <query expression>
      F864 Top-level <result offset clause> in views
      F865 dynamic <offset row count> in <result offset clause> (already present in 10.5)

      1. derby-4398-insert.diff
        67 kB
        Dag H. Wanvik
      2. derby-4398-insert.stat
        1 kB
        Dag H. Wanvik
      3. derby-4398-2.diff
        86 kB
        Dag H. Wanvik
      4. derby-4398-2.stat
        2 kB
        Dag H. Wanvik
      5. derby-4398-3.diff
        89 kB
        Dag H. Wanvik
      6. derby-4398-3.stat
        2 kB
        Dag H. Wanvik

        Issue Links

          Activity

          Gavin made changes -
          Workflow jira [ 12478688 ] Default workflow, editable Closed status [ 12799627 ]
          Dag H. Wanvik made changes -
          Link This issue relates to DERBY-4649 [ DERBY-4649 ]
          Dag H. Wanvik made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Dag H. Wanvik made changes -
          Status In Progress [ 3 ] Resolved [ 5 ]
          Resolution Fixed [ 1 ]
          Dag H. Wanvik made changes -
          Link This issue relates to DERBY-4518 [ DERBY-4518 ]
          Dag H. Wanvik made changes -
          Description SQL 2008 specifies that OFFSET/FETCH (<result offset clause>, <fetch first clause>) may be used in subqueries.
          Currently, Derby only allows this at the outer (cursor) level. Cf. also DERBY-4397 on allowing ORDER BY in subqueries
          for this extension to be portable and useful.
          SQL 2008 specifies that OFFSET/FETCH (<result offset clause>, <fetch
          first clause>) may be used in subqueries. Currently, Derby only
          allows this at the outer (cursor) level. Cf. also DERBY-4397 on
          allowing ORDER BY in subqueries for this extension to be portable and
          useful.

          SQL features:

          F856 Nested <fetch first clause> in <query expression>
          F857 Top-level <fetch first clause> in <query expression> (already present in 10.5)
          F858 <fetch first clause> in subqueries
          F859 Top-level <fetch first clause> in views
          F860 dynamic <fetch first row count> in <fetch first clause> (already present in 10.5)

          F861 Top-level <result offset clause> in <query expression> (already present in 10.5)
          F862 <result offset clause> in subqueries
          F863 Nested <result offset clause> in <query expression>
          F864 Top-level <result offset clause> in views
          F865 dynamic <offset row count> in <result offset clause> (already present in 10.5)
          Dag H. Wanvik made changes -
          Fix Version/s 10.6.0.0 [ 12313727 ]
          Issue & fix info [Patch Available]
          Dag H. Wanvik made changes -
          Attachment derby-4398-3.diff [ 12429882 ]
          Attachment derby-4398-3.stat [ 12429883 ]
          Dag H. Wanvik made changes -
          Attachment derby-4398-2.diff [ 12429635 ]
          Attachment derby-4398-2.stat [ 12429636 ]
          Dag H. Wanvik made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          Dag H. Wanvik made changes -
          Assignee Dag H. Wanvik [ dagw ]
          Dag H. Wanvik made changes -
          Issue & fix info [Patch Available]
          Dag H. Wanvik made changes -
          Attachment derby-4398-insert.diff [ 12428521 ]
          Attachment derby-4398-insert.stat [ 12428522 ]
          Dag H. Wanvik made changes -
          Field Original Value New Value
          Link This issue is related to DERBY-4397 [ DERBY-4397 ]
          Dag H. Wanvik created issue -

            People

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

              Dates

              • Created:
                Updated:
                Resolved:

                Development