[jira] [Updated] (IGNITE-17429) Sql. Extend sql grammar to support CREATE/DROP INDEX statements
[
https://issues.apache.org/jira/browse/IGNITE-17429?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Konstantin Orlov updated IGNITE-17429:
--
Description:
We need to give an ability to manage index via DDL statements.
As a first step lets support CREATE and DROP statements only. Within this
ticket we need to extend the sql grammar file as well as provide all necessary
structures to keep parsed AST.
The proposed grammar:
{code:java}
CREATE INDEX [IF NOT EXISTS] name ON table_name [USING { HASH | TREE }]
(column_name [ASC | DESC] [NULLS {FIRST | LAST}] [, ...]);
{code}
{code:java}
DROP INDEX [IF EXISTS] name;{code}
was:
We need to give an ability to manage index via DDL statements.
As a first step lets support CREATE and DROP statements only. Within this
ticket we need to extend the sql grammar file as well as provide all necessary
structures to keep parsed AST.
The proposed grammar:
{code:java}
CREATE INDEX [IF NOT EXISTS] name ON table_name [USING HASH | SORTED ]
(column_name [ASC | DESC] [NULLS {FIRST | LAST}] [, ...]);
{code}
{code:java}
DROP INDEX [IF EXISTS] name;{code}
> Sql. Extend sql grammar to support CREATE/DROP INDEX statements
> ---
>
> Key: IGNITE-17429
> URL: https://issues.apache.org/jira/browse/IGNITE-17429
> Project: Ignite
> Issue Type: Improvement
> Components: sql
>Reporter: Konstantin Orlov
>Assignee: Konstantin Orlov
>Priority: Major
> Labels: ignite-3
>
> We need to give an ability to manage index via DDL statements.
> As a first step lets support CREATE and DROP statements only. Within this
> ticket we need to extend the sql grammar file as well as provide all
> necessary structures to keep parsed AST.
> The proposed grammar:
> {code:java}
> CREATE INDEX [IF NOT EXISTS] name ON table_name [USING { HASH | TREE }]
> (column_name [ASC | DESC] [NULLS {FIRST | LAST}] [, ...]);
>
> {code}
> {code:java}
> DROP INDEX [IF EXISTS] name;{code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
[jira] [Updated] (IGNITE-17429) Sql. Extend sql grammar to support CREATE/DROP INDEX statements
[
https://issues.apache.org/jira/browse/IGNITE-17429?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Yury Gerzhedovich updated IGNITE-17429:
---
Description:
We need to give an ability to manage index via DDL statements.
As a first step lets support CREATE and DROP statements only. Within this
ticket we need to extend the sql grammar file as well as provide all necessary
structures to keep parsed AST.
The proposed grammar:
{code:java}
CREATE INDEX [IF NOT EXISTS] name ON table_name [USING HASH | SORTED ]
(column_name [ASC | DESC] [NULLS {FIRST | LAST}] [, ...]);
{code}
{code:java}
DROP INDEX [IF EXISTS] name;{code}
was:
We need to give an ability to manage index via DDL statements.
As a first step lets support CREATE and DROP statements only. Within this
ticket we need to extend the sql grammar file as well as provide all necessary
structures to keep parsed AST.
The proposed grammar:
{code:java}
CREATE INDEX [[IF NOT EXISTS] name] ON table_name [USING HASH | SORTED ]
(column_name [ASC | DESC] [NULLS {FIRST | LAST}] [, ...]);
{code}
{code:java}
DROP INDEX [IF EXISTS] name;{code}
> Sql. Extend sql grammar to support CREATE/DROP INDEX statements
> ---
>
> Key: IGNITE-17429
> URL: https://issues.apache.org/jira/browse/IGNITE-17429
> Project: Ignite
> Issue Type: Improvement
> Components: sql
>Reporter: Konstantin Orlov
>Priority: Major
> Labels: ignite-3
>
> We need to give an ability to manage index via DDL statements.
> As a first step lets support CREATE and DROP statements only. Within this
> ticket we need to extend the sql grammar file as well as provide all
> necessary structures to keep parsed AST.
> The proposed grammar:
> {code:java}
> CREATE INDEX [IF NOT EXISTS] name ON table_name [USING HASH | SORTED ]
> (column_name [ASC | DESC] [NULLS {FIRST | LAST}] [, ...]);
>
> {code}
> {code:java}
> DROP INDEX [IF EXISTS] name;{code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
[jira] [Updated] (IGNITE-17429) Sql. Extend sql grammar to support CREATE/DROP INDEX statements
[
https://issues.apache.org/jira/browse/IGNITE-17429?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Yury Gerzhedovich updated IGNITE-17429:
---
Description:
We need to give an ability to manage index via DDL statements.
As a first step lets support CREATE and DROP statements only. Within this
ticket we need to extend the sql grammar file as well as provide all necessary
structures to keep parsed AST.
The proposed grammar:
{code:java}
CREATE INDEX [[IF NOT EXISTS] name] ON table_name [USING HASH | SORTED ]
(column_name [ASC | DESC] [NULLS {FIRST | LAST}] [, ...]);
{code}
{code:java}
DROP INDEX [IF EXISTS] name;{code}
was:
We need to give an ability to manage index via DDL statements.
As a first step lets support CREATE and DROP statements only. Within this
ticket we need to extend the sql grammar file as well as provide all necessary
structures to keep parsed AST.
The proposed grammar:
{code:java}
CREATE INDEX [[IF NOT EXISTS] name] ON table_name [USING HASH | BTREE ]
(column_name [ASC | DESC] [NULLS {FIRST | LAST}] [, ...]);
{code}
{code:java}
DROP INDEX [IF EXISTS] name;{code}
> Sql. Extend sql grammar to support CREATE/DROP INDEX statements
> ---
>
> Key: IGNITE-17429
> URL: https://issues.apache.org/jira/browse/IGNITE-17429
> Project: Ignite
> Issue Type: Improvement
> Components: sql
>Reporter: Konstantin Orlov
>Priority: Major
> Labels: ignite-3
>
> We need to give an ability to manage index via DDL statements.
> As a first step lets support CREATE and DROP statements only. Within this
> ticket we need to extend the sql grammar file as well as provide all
> necessary structures to keep parsed AST.
> The proposed grammar:
> {code:java}
> CREATE INDEX [[IF NOT EXISTS] name] ON table_name [USING HASH | SORTED ]
> (column_name [ASC | DESC] [NULLS {FIRST | LAST}] [, ...]);
>
> {code}
> {code:java}
> DROP INDEX [IF EXISTS] name;{code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
[jira] [Updated] (IGNITE-17429) Sql. Extend sql grammar to support CREATE/DROP INDEX statements
[
https://issues.apache.org/jira/browse/IGNITE-17429?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Yury Gerzhedovich updated IGNITE-17429:
---
Description:
We need to give an ability to manage index via DDL statements.
As a first step lets support CREATE and DROP statements only. Within this
ticket we need to extend the sql grammar file as well as provide all necessary
structures to keep parsed AST.
The proposed grammar:
{code:java}
CREATE INDEX [[IF NOT EXISTS] name] ON table_name [USING HASH | BTREE ]
(column_name [ASC | DESC] [NULLS {FIRST | LAST}] [, ...]);
{code}
{code:java}
DROP INDEX [IF EXISTS] name;{code}
was:
We need to give an ability to manage index via DDL statements.
As a first step lets support CREATE and DROP statements only. Within this
ticket we need to extend the sql grammar file as well as provide all necessary
structures to keep parsed AST.
The proposed grammar:
CREATE INDEX [[IF NOT EXISTS] name] ON table_name [USING HASH | BTREE ]
(column_name [ASC | DESC] [NULLS {FIRST | LAST}] [, ...]);
DROP INDEX [IF EXISTS] name;
> Sql. Extend sql grammar to support CREATE/DROP INDEX statements
> ---
>
> Key: IGNITE-17429
> URL: https://issues.apache.org/jira/browse/IGNITE-17429
> Project: Ignite
> Issue Type: Improvement
> Components: sql
>Reporter: Konstantin Orlov
>Priority: Major
> Labels: ignite-3
>
> We need to give an ability to manage index via DDL statements.
> As a first step lets support CREATE and DROP statements only. Within this
> ticket we need to extend the sql grammar file as well as provide all
> necessary structures to keep parsed AST.
> The proposed grammar:
> {code:java}
> CREATE INDEX [[IF NOT EXISTS] name] ON table_name [USING HASH | BTREE ]
> (column_name [ASC | DESC] [NULLS {FIRST | LAST}] [, ...]);
>
> {code}
> {code:java}
> DROP INDEX [IF EXISTS] name;{code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
[jira] [Updated] (IGNITE-17429) Sql. Extend sql grammar to support CREATE/DROP INDEX statements
[
https://issues.apache.org/jira/browse/IGNITE-17429?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Yury Gerzhedovich updated IGNITE-17429:
---
Description:
We need to give an ability to manage index via DDL statements.
As a first step lets support CREATE and DROP statements only. Within this
ticket we need to extend the sql grammar file as well as provide all necessary
structures to keep parsed AST.
The proposed grammar:
CREATE INDEX [[IF NOT EXISTS] name] ON table_name [USING HASH | BTREE ]
(column_name [ASC | DESC] [NULLS {FIRST | LAST}] [, ...]);
DROP INDEX [IF EXISTS] name;
was:
We need to give an ability to manage index via DDL statements.
As a first step lets support CREATE and DROP statements only. Within this
ticket we need to extend the sql grammar file as well as provide all necessary
structures to keep parsed AST.
The proposed grammar:
CREATE INDEX [[IF NOT EXISTS] name] ON table_name [USING HASH | BTREE ]
(column_name [ASC | DESC] [NULLS \\{FIRST | LAST}] [, ...])
DROP INDEX [IF EXISTS] name
> Sql. Extend sql grammar to support CREATE/DROP INDEX statements
> ---
>
> Key: IGNITE-17429
> URL: https://issues.apache.org/jira/browse/IGNITE-17429
> Project: Ignite
> Issue Type: Improvement
> Components: sql
>Reporter: Konstantin Orlov
>Priority: Major
> Labels: ignite-3
>
> We need to give an ability to manage index via DDL statements.
> As a first step lets support CREATE and DROP statements only. Within this
> ticket we need to extend the sql grammar file as well as provide all
> necessary structures to keep parsed AST.
> The proposed grammar:
> CREATE INDEX [[IF NOT EXISTS] name] ON table_name [USING HASH | BTREE ]
> (column_name [ASC | DESC] [NULLS {FIRST | LAST}] [, ...]);
> DROP INDEX [IF EXISTS] name;
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
[jira] [Updated] (IGNITE-17429) Sql. Extend sql grammar to support CREATE/DROP INDEX statements
[
https://issues.apache.org/jira/browse/IGNITE-17429?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Yury Gerzhedovich updated IGNITE-17429:
---
Description:
We need to give an ability to manage index via DDL statements.
As a first step lets support CREATE and DROP statements only. Within this
ticket we need to extend the sql grammar file as well as provide all necessary
structures to keep parsed AST.
The proposed grammar:
CREATE INDEX [[IF NOT EXISTS] name] ON table_name [USING HASH | BTREE ]
(column_name [ASC | DESC] [NULLS \\{FIRST | LAST}] [, ...])
DROP INDEX [IF EXISTS] name
was:
We need to give an ability to manage index via DDL statements.
As a first step lets support CREATE and DROP statements only. Within this
ticket we need to extend the sql grammar file as well as provide all necessary
structures to keep parsed AST.
The proposed grammar:
CREATE INDEX [[IF NOT EXISTS] name] ON table_name [USING HASH | BTREE ]
(column_name [ASC | DESC] [NULLS \{FIRST | LAST}] [, ...])
> Sql. Extend sql grammar to support CREATE/DROP INDEX statements
> ---
>
> Key: IGNITE-17429
> URL: https://issues.apache.org/jira/browse/IGNITE-17429
> Project: Ignite
> Issue Type: Improvement
> Components: sql
>Reporter: Konstantin Orlov
>Priority: Major
> Labels: ignite-3
>
> We need to give an ability to manage index via DDL statements.
> As a first step lets support CREATE and DROP statements only. Within this
> ticket we need to extend the sql grammar file as well as provide all
> necessary structures to keep parsed AST.
> The proposed grammar:
> CREATE INDEX [[IF NOT EXISTS] name] ON table_name [USING HASH | BTREE ]
> (column_name [ASC | DESC] [NULLS \\{FIRST | LAST}] [, ...])
> DROP INDEX [IF EXISTS] name
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
[jira] [Updated] (IGNITE-17429) Sql. Extend sql grammar to support CREATE/DROP INDEX statements
[
https://issues.apache.org/jira/browse/IGNITE-17429?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Yury Gerzhedovich updated IGNITE-17429:
---
Description:
We need to give an ability to manage index via DDL statements.
As a first step lets support CREATE and DROP statements only. Within this
ticket we need to extend the sql grammar file as well as provide all necessary
structures to keep parsed AST.
The proposed grammar:
CREATE INDEX [[IF NOT EXISTS] name] ON table_name [USING HASH | BTREE ]
(column_name [ASC | DESC] [NULLS \{FIRST | LAST}] [, ...])
was:
We need to give an ability to manage index via DDL statements.
As a first step lets support CREATE and DROP statements only. Within this
ticket we need to extend the sql grammar file as well as provide all necessary
structures to keep parsed AST.
The proposed grammar:
CREATE INDEX [[IF NOT EXISTS] name] ON table_name [USING HASH | BTREE ]
(column_name [ASC | DESC] [NULLS \{FIRST | LAST}] [, ...])
> Sql. Extend sql grammar to support CREATE/DROP INDEX statements
> ---
>
> Key: IGNITE-17429
> URL: https://issues.apache.org/jira/browse/IGNITE-17429
> Project: Ignite
> Issue Type: Improvement
> Components: sql
>Reporter: Konstantin Orlov
>Priority: Major
> Labels: ignite-3
>
> We need to give an ability to manage index via DDL statements.
> As a first step lets support CREATE and DROP statements only. Within this
> ticket we need to extend the sql grammar file as well as provide all
> necessary structures to keep parsed AST.
> The proposed grammar:
> CREATE INDEX [[IF NOT EXISTS] name] ON table_name [USING HASH | BTREE ]
> (column_name [ASC | DESC] [NULLS \{FIRST | LAST}] [, ...])
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
[jira] [Updated] (IGNITE-17429) Sql. Extend sql grammar to support CREATE/DROP INDEX statements
[
https://issues.apache.org/jira/browse/IGNITE-17429?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Yury Gerzhedovich updated IGNITE-17429:
---
Description:
We need to give an ability to manage index via DDL statements.
As a first step lets support CREATE and DROP statements only. Within this
ticket we need to extend the sql grammar file as well as provide all necessary
structures to keep parsed AST.
The proposed grammar:
CREATE INDEX [[IF NOT EXISTS] name] ON table_name [USING HASH | BTREE ]
(column_name [ASC | DESC] [NULLS \{FIRST | LAST}] [, ...])
was:
We need to give an ability to manage index via DDL statements.
As a first step lets support CREATE and DROP statements only. Within this
ticket we need to extend the sql grammar file as well as provide all necessary
structures to keep parsed AST.
> Sql. Extend sql grammar to support CREATE/DROP INDEX statements
> ---
>
> Key: IGNITE-17429
> URL: https://issues.apache.org/jira/browse/IGNITE-17429
> Project: Ignite
> Issue Type: Improvement
> Components: sql
>Reporter: Konstantin Orlov
>Priority: Major
> Labels: ignite-3
>
> We need to give an ability to manage index via DDL statements.
> As a first step lets support CREATE and DROP statements only. Within this
> ticket we need to extend the sql grammar file as well as provide all
> necessary structures to keep parsed AST.
> The proposed grammar:
> CREATE INDEX [[IF NOT EXISTS] name] ON table_name [USING HASH | BTREE ]
> (column_name [ASC | DESC] [NULLS \{FIRST | LAST}] [, ...])
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
