Alexander Belyak created IGNITE-19304:
-----------------------------------------
Summary: Create index with same column twice
Key: IGNITE-19304
URL: https://issues.apache.org/jira/browse/IGNITE-19304
Project: Ignite
Issue Type: Bug
Components: sql
Affects Versions: 3.0
Reporter: Alexander Belyak
Unable to create index with same column twice:
{noformat}
create table tindex(
id int primary key,
v1 int,
v2 int);
create index titest on tindex(v1,v1){noformat}
error:
{noformat}
[Code: 0, SQL State: 50000] Exception while executing query [query=create
index titest on tindex(v1,v1)]. Error message:IGN-CMN-65535
TraceId:203a2c0c-fbf1-4143-aa47-50c97223ad84 Named List element with key "V1"
already exists{noformat}
But documentation
[https://ignite.apache.org/docs/3.0.0-beta/sql-reference/ddl#create-index] do
not block it. Postgres allow to execute such DDL too.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
