[ https://issues.apache.org/jira/browse/IGNITE-19912?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17740465#comment-17740465 ]
Evgeny Stanilovsky commented on IGNITE-19912: --------------------------------------------- [~xtern] can u make a review plz? bot report will be soon. > Duplicated index creation using SQL leads to node start-up failure > ------------------------------------------------------------------ > > Key: IGNITE-19912 > URL: https://issues.apache.org/jira/browse/IGNITE-19912 > Project: Ignite > Issue Type: Bug > Affects Versions: 2.15 > Reporter: Evgeny Stanilovsky > Assignee: Evgeny Stanilovsky > Priority: Major > Attachments: DuplicateIndexCreationTest.java > > Time Spent: 0.5h > Remaining Estimate: 0h > > In case an index for the field is specified using QuerySqlFields(index=true) > annotation, it's possible to create multiple additional indices for the same > field using CREATE INDEX IF NOT EXISTS statement without explicit index name > specification. As a result, all indices that were created via SQL have the > same name, which leads to node failure on the next restart due to Index with > name 'person_name_asc_idx' already exists. exception. -- This message was sent by Atlassian Jira (v8.20.10#820010)