[IGNITE-15141] Support NULL_FIRST/LAST for index column ordering.

• Type: Improvement
• Status: Open
• Priority: Trivial
• Resolution: Unresolved
• Labels: iep-54 ignite-3 newbie
• Ignite Flags: Docs Required, Release Notes Required
• Assignee: Unassigned
• Reporter: Andrey Mashenkov
• Created: 16/Jul/21 20:31
• Updated: 15/Nov/24 19:45

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.

Issue Links

• duplicates: IGNITE-17563 Sql. Add nulls ordering support to CREATE INDEX command.
• is a child of: IGNITE-13616 IEP-54 Live schema for tables