[IGNITE-11146] SQL: QueryIndex and DDL generate indexes with different default names

• Type: Improvement
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Component/s: sql
• Ignite Flags: Docs Required
• Assignee: Unassigned
• Reporter: Stanislav Lukyanov
• Created: 30/Jan/19 14:39
• Updated: 14/Feb/19 14:42

Description

`QueryIndex` with a name set and `CREATE INDEX` without a specified name create indexes with different names, even if all parameters are the same - `CREATE INDEX` produces a lower-case name, and `QueryIndex` produces an upper-case one.

For example

new QueryIndex("a")

in a table "Foo" creates an index with name

FOO_A_ASC_IDX

while the query

CREATE INDEX ON PUBLIC.FOO (a)

creates an index

foo_a_asc_idx

It would be better if DDL generated an upper-case name since that's the default in SQL.