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

NULLS FIRST / LAST for ORDER BY

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • None
    • 10.4.1.3
    • SQL
    • None

    Description

      I suggest to implement the "null ordering" option for the "ORDER BY" clause:

      According to the SQL standard, 10.10 <sort specification list>:

      <null ordering> ::=
      NULLS FIRST

      NULLS LAST

      Attachments

        1. prototypeCodeNoTests.diff
          34 kB
          Bryan Pendleton
        2. prototypeCodeNoTests_v3.diff
          27 kB
          Bryan Pendleton
        3. prototypeCodeNoTests_v2.diff
          41 kB
          Bryan Pendleton
        4. nullOrderingPatch.diff
          43 kB
          Bryan Pendleton

        Issue Links

          is duplicated by

          Sub-task - The sub-task of the issue DERBY-2965 Add support for NULLS FIRST / NULLS LAST on ORDER BY clause

          • 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-4382 missing documentation from reference guide for ORDER BY null ordering clause (i.e. NULLS FIRST / NULLS LAST )

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

          Improvement - An improvement or enhancement to an existing feature or task. DERBY-581 Modify SQL to skip N rows of the result and return the next M rows

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

          Activity

            People

              bryanpendleton Bryan Pendleton
              chdh@inventec.ch Christian d'Heureuse
              Votes:
              1 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: