[IGNITE-17563] Sql. Add nulls ordering support to CREATE INDEX command.

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: sql
• Labels: ignite-3
• Epic Link: SQL indexes 3.0
• Ignite Flags: Docs Required, Release Notes Required
• Assignee: Unassigned
• Reporter: Andrey Mashenkov
• Created: 22/Aug/22 11:23
• Updated: 06/Jun/23 12:56

Description

As of now, CREATE INDEX support only DESC_NULLS_FIRST and ASC_NULLS_LAST ordering.

Let's support other orderings as well (see Collation and Columncollation classes).
Some of internal structures already supports all of null orderings.
However, we still have to fix parser to support proper 'CREATE INDEX' syntax and pass null-ordering flag to storage descriptor.

Issue Links

• is duplicated by: IGNITE-15141 Support NULL_FIRST/LAST for index column ordering.