[jira] [Updated] (IGNITE-15484) SQL allows "create index" query with duplicated columns

["Maksim Timonin (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/IGNITE-15484?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Maksim Timonin updated IGNITE-15484:
------------------------------------
    Description: 
This query should forbid such queries and raise an exception:

"create index IDX on table (id ASC, id DESC);"

Now it creates index last appearance of the field, in this case (id DESC).

 

  was:
This query should raise an exception:

"create index IDX on table (id ASC, id DESC);"

But actually it creates index with (id DESC).

 


> SQL allows "create index" query with duplicated columns
> -------------------------------------------------------
>
>                 Key: IGNITE-15484
>                 URL: https://issues.apache.org/jira/browse/IGNITE-15484
>             Project: Ignite
>          Issue Type: New Feature
>            Reporter: Maksim Timonin
>            Assignee: Maksim Timonin
>            Priority: Major
>          Time Spent: 10m
>  Remaining Estimate: 0h
>
> This query should forbid such queries and raise an exception:
> "create index IDX on table (id ASC, id DESC);"
> Now it creates index last appearance of the field, in this case (id DESC).
>  



--
This message was sent by Atlassian Jira
(v8.3.4#803005)