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

["Stanislav Lukyanov (JIRA)" <ji...@apache.org>]

Stanislav Lukyanov created IGNITE-11146:
-------------------------------------------

             Summary: SQL: QueryIndex and DDL generate indexes with different default names
                 Key: IGNITE-11146
                 URL: https://issues.apache.org/jira/browse/IGNITE-11146
             Project: Ignite
          Issue Type: Task
          Components: sql
            Reporter: Stanislav Lukyanov


`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
{code}
new QueryIndex("a")
{code}
in a table "Foo" creates an index with name
{code}
FOO_A_ASC_IDX
{code}
while the query
{code}
CREATE INDEX ON PUBLIC.FOO (a)
{code}
creates an index
{code}
foo_a_asc_idx
{code}

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



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)