Alexander Belyak created IGNITE-19305: -----------------------------------------
Summary: Index alive after drop indexed column Key: IGNITE-19305 URL: https://issues.apache.org/jira/browse/IGNITE-19305 Project: Ignite Issue Type: Bug Components: sql Affects Versions: 3.0 Reporter: Alexander Belyak Unable to create index with the same name after dropping indexed column: {noformat} create table tindex( id int primary key, v1 int, v2 int); create index titest on tindex(v1, v2) alter table tindex drop column v1; create index titest on tindex(v2);{noformat} error: {noformat} [Code: 0, SQL State: 50000] Exception while executing query [query=create index titest on tindex(v2)]. Error message:IGN-SQL-17 TraceId:5f61df67-cc61-4eb1-98be-3bbaa25a7c44 IGN-SQL-17 TraceId:5f61df67-cc61-4eb1-98be-3bbaa25a7c44 Index already exists [name="PUBLIC"."TITEST"]{noformat} Expected behaviour: 1) index titest drop while dropping v1 columnd 2) index titest successfully created on the last DDL operation. -- This message was sent by Atlassian Jira (v8.20.10#820010)