You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Alexander Belyak (Jira)" <ji...@apache.org> on 2023/04/18 15:20:00 UTC
[jira] [Updated] (IGNITE-19305) Index alive after drop indexed column
[ https://issues.apache.org/jira/browse/IGNITE-19305?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Alexander Belyak updated IGNITE-19305:
--------------------------------------
Description:
In [documentation|https://ignite.apache.org/docs/3.0.0-beta/sql-reference/ddl#alter-table-if-exists-table-drop-column-if-exists-column1-column2-int] I see: "If the column was indexed, the index has to be dropped manually in advance by using the 'DROP INDEX' command." But it seems like an alpha version limitation.
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.
was:
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.
> 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
> Priority: Major
>
> In [documentation|https://ignite.apache.org/docs/3.0.0-beta/sql-reference/ddl#alter-table-if-exists-table-drop-column-if-exists-column1-column2-int] I see: "If the column was indexed, the index has to be dropped manually in advance by using the 'DROP INDEX' command." But it seems like an alpha version limitation.
> 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)