Skip to content

[Feature] Exchanges the names of two tables or view atomically. #20442

@catpineapple

Description

@catpineapple

Search before asking

  • I had searched in the issues and found no similar issues.

Description

This method can realize the RENAME of the temporary table under the atomic operation.

Use case

for : a _1 to a_2

a_1 rename a_temp
a_2 rename a_1
a_temp rename a_1

it`s not atomical

but :

exchange tables name_1 and name_2;

it will be atomical

Related issues

No response

Are you willing to submit PR?

  • Yes I am willing to submit a PR!

Code of Conduct

Metadata

Metadata

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions