mirror of
https://github.com/mariadb-corporation/mariadb-columnstore-engine.git
synced 2025-04-26 11:48:52 +03:00
28 lines
704 B
Plaintext
28 lines
704 B
Plaintext
#
|
|
# Test ALTER TABLE schemas in various possible ways.
|
|
#
|
|
-- source ../include/have_columnstore.inc
|
|
-- source include/have_innodb.inc
|
|
|
|
--disable_warnings
|
|
DROP DATABASE IF EXISTS mcol4202_db1;
|
|
DROP DATABASE IF EXISTS mcol4202_db2;
|
|
--enable_warnings
|
|
|
|
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;
|
|
USE mcol4202_db2;
|
|
INSERT INTO t1 values (222);
|
|
SELECT * FROM t1;
|
|
RENAME TABLE mcol4202_db2.t1 to mcol4202_db1.t33333;
|
|
USE mcol4202_db1;
|
|
SELECT * from t33333;
|
|
|
|
|
|
DROP DATABASE mcol4202_db1;
|
|
DROP DATABASE mcol4202_db2;
|