[
https://issues.apache.org/jira/browse/IGNITE-11146?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Stanislav Lukyanov updated IGNITE-11146:
----------------------------------------
Issue Type: Bug (was: Task)
> 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: Bug
> Components: sql
> Reporter: Stanislav Lukyanov
> Priority: Major
>
> `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)
