You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Andrey Mashenkov (Jira)" <ji...@apache.org> on 2023/05/16 16:50:00 UTC

[jira] [Updated] (IGNITE-15485) Sql. Extend SQL grammar with ALTER TABLE RENAME statement

     [ https://issues.apache.org/jira/browse/IGNITE-15485?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Andrey Mashenkov updated IGNITE-15485:
--------------------------------------
    Description: 
As we can CREATE and DROP TABLE need to provide the ability to alter a name of an index by DDL commands.

Let's extend SQL grammar with the following syntax:
ALTER TABLE [ IF EXISTS ] <name> RENAME TO <new_name>

  was:
Today we are handling a rename operation, but do nothing:
{code}
tablesCfg.tables().listenElements(new ConfigurationNamedListListener<>() {
	@Override
	public CompletableFuture<?> onRename(String oldName, String newName, ConfigurationNotificationEvent<TableView> ctx) {
		return CompletableFuture.completedFuture(null);
	}
}
{code}

We have to have an implementation for the rename operation, that may be possible to change a table name through the TableManager API.
Also, firing a local event (_TableEvent#RENAME_) is required.


> Sql. Extend SQL grammar with ALTER TABLE RENAME statement
> ---------------------------------------------------------
>
>                 Key: IGNITE-15485
>                 URL: https://issues.apache.org/jira/browse/IGNITE-15485
>             Project: Ignite
>          Issue Type: Improvement
>            Reporter: Alexander Lapin
>            Priority: Major
>              Labels: ignite-3
>
> As we can CREATE and DROP TABLE need to provide the ability to alter a name of an index by DDL commands.
> Let's extend SQL grammar with the following syntax:
> ALTER TABLE [ IF EXISTS ] <name> RENAME TO <new_name>



--
This message was sent by Atlassian Jira
(v8.20.10#820010)