[ https://issues.apache.org/jira/browse/IGNITE-13376?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17181815#comment-17181815 ]
Ignite TC Bot commented on IGNITE-13376: ---------------------------------------- {panel:title=Branch: [pull/8172/head] Base: [master] : No blockers found!|borderStyle=dashed|borderColor=#ccc|titleBGColor=#D6F7C1}{panel} {panel:title=Branch: [pull/8172/head] Base: [master] : New Tests (4)|borderStyle=dashed|borderColor=#ccc|titleBGColor=#D6F7C1} {color:#00008b}Queries 1{color} [[tests 4|https://ci.ignite.apache.org/viewLog.html?buildId=5556518]] * {color:#013220}IgniteBinaryCacheQueryTestSuite: BasicIndexMultinodeTest.testCorrectPkFldsSequence - PASSED{color} * {color:#013220}IgniteBinaryCacheQueryTestSuite: BasicIndexTest.testCorrectPkFldsSequence - PASSED{color} * {color:#013220}IgniteBinaryCacheQueryTestSuite: BasicIndexMultinodeTest.testCorrectFieldsSequenceInPk - PASSED{color} * {color:#013220}IgniteBinaryCacheQueryTestSuite: BasicIndexTest.testCorrectFieldsSequenceInPk - PASSED{color} {panel} [TeamCity *--> Run :: All* Results|https://ci.ignite.apache.org/viewLog.html?buildId=5556547&buildTypeId=IgniteTests24Java8_RunAll] > 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)