DROP DATABASE IF EXISTS mcol4202_db1;
DROP DATABASE IF EXISTS mcol4202_db2;
CREATE DATABASE mcol4202_db1;
CREATE DATABASE mcol4202_db2;
CREATE TABLE mcol4202_db1.t1 (id INT) ENGINE=Columnstore;
INSERT INTO mcol4202_db1.t1 values (111);
RENAME TABLE mcol4202_db1.t1 TO mcol4202_db2.t1;
SELECT * FROM mcol4202_db2.t1;
id
111
USE mcol4202_db2;
INSERT INTO t1 values (222);
SELECT * FROM t1;
id
111
222
RENAME TABLE mcol4202_db2.t1 to mcol4202_db1.t33333;
USE mcol4202_db1;
SELECT * from t33333;
id
111
222
DROP DATABASE mcol4202_db1;
DROP DATABASE mcol4202_db2;