[jira] [Updated] (IGNITE-13376) Primary index can be created with fields sequence differ from declared.

["Stanilovsky Evgeny (Jira)" <ji...@apache.org>]

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

Stanilovsky Evgeny updated IGNITE-13376:
----------------------------------------
    Reviewer: Taras Ledkov

> Primary index can be created with fields sequence differ from declared.
> -----------------------------------------------------------------------
>
>                 Key: IGNITE-13376
>                 URL: https://issues.apache.org/jira/browse/IGNITE-13376
>             Project: Ignite
>          Issue Type: Improvement
>          Components: sql
>    Affects Versions: 2.7.6, 2.8.1
>            Reporter: Stanilovsky Evgeny
>            Assignee: Stanilovsky Evgeny
>            Priority: Major
>          Time Spent: 10m
>  Remaining Estimate: 0h
>
> Steps to reproduce: 
> Execute the following DDL (create table + create index):
> {noformat}
> CREATE TABLE IF NOT EXISTS Workspace (
>     id UUID NOT NULL,
>     accountId UUID NOT NULL,
>     jsonModel VARCHAR,
>     PRIMARY KEY (accountId, id)
>   ) WITH "template=partitioned,atomicity=transactional,key_type=org.gridgain.gmc.dto.workspace.WorkspaceKey,value_type=workspace.Workspace,cache_name=WorkspaceCache";
> CREATE INDEX IF NOT EXISTS workspace_id_account_id_idx ON Workspace (id, accountId);
> {noformat}
> On node start got the following warning:
> {noformat}
> Index with the given set or subset of columns already exists (consider dropping either new or existing index) [cacheName=WorkspaceCache, schemaName=PUBLIC, tableName=WORKSPACE, newIndexName=WORKSPACE_ID_ACCOUNT_ID_IDX, existingIndexName=_key_PK, existingIndexColumns=[ID, ACCOUNTID]]
> {noformat}
> But PK and index have different order!



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