You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ignite.apache.org by "Stanislav Lukyanov (JIRA)" <ji...@apache.org> on 2019/01/30 14:40:00 UTC
[jira] [Created] (IGNITE-11146) SQL: QueryIndex and DDL generate
indexes with different default names
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)