You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@ignite.apache.org by "Alexander Belyak (Jira)" <ji...@apache.org> on 2023/04/18 14:33:00 UTC

[jira] [Created] (IGNITE-19304) Create index with same column twice

Alexander Belyak created IGNITE-19304:
-----------------------------------------

             Summary: Create index with same column twice
                 Key: IGNITE-19304
                 URL: https://issues.apache.org/jira/browse/IGNITE-19304
             Project: Ignite
          Issue Type: Bug
          Components: sql
    Affects Versions: 3.0
            Reporter: Alexander Belyak


Unable to create index with same column twice:
{noformat}
create table tindex(
id int primary key,
v1 int, 
v2 int);
create index titest on tindex(v1,v1){noformat}
error:
{noformat}
[Code: 0, SQL State: 50000]  Exception while executing query [query=create index titest on tindex(v1,v1)]. Error message:IGN-CMN-65535 TraceId:203a2c0c-fbf1-4143-aa47-50c97223ad84 Named List element with key "V1" already exists{noformat}
But documentation [https://ignite.apache.org/docs/3.0.0-beta/sql-reference/ddl#create-index] do not block it. Postgres allow to execute such DDL too.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)