[ https://issues.apache.org/jira/browse/IGNITE-13376?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17213642#comment-17213642 ]
Aleksey Plekhanov commented on IGNITE-13376: -------------------------------------------- Cherry-picked to 2.9 [~tledkov-gridgain], please be careful next time resolving ticket (set correct "fix version" or note about the ticket on dev-list if the ticket should be included into release after the code freeze stage) > 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 > Fix For: 2.9 > > 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)