[jira] [Created] (IGNITE-19305) Index alive after drop indexed column

["Alexander Belyak (Jira)" <ji...@apache.org>]

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)