Uploaded image for project: 'Ignite'
  1. Ignite
  2. IGNITE-15141

Support NULL_FIRST/LAST for index column ordering.

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Open
    • Trivial
    • Resolution: Unresolved
    • None
    • None
    • None
    • Docs Required, Release Notes Required

    Description

      'Null' values are out of natural order in general.
      SQL standard offers the next options: nulls_first and nulls_last.

      Let's extend SortOrder enum to support both cases for Asc and Desc orders.

      Attachments

        Issue Links

          duplicates

          Improvement - An improvement or enhancement to an existing feature or task. IGNITE-17563 Sql. Add nulls ordering support to CREATE INDEX command.

          • Major - Major loss of function.
          • Open
          is a child of

          Improvement - An improvement or enhancement to an existing feature or task. IGNITE-13616 IEP-54 Live schema for tables

          • Major - Major loss of function.
          • Open

          Activity

            People

              Unassigned Unassigned
              amashenkov Andrey Mashenkov
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated: