DROP DATABASE IF EXISTS MCOL5886;
CREATE DATABASE MCOL5886;
USE MCOL5886;
CREATE USER IF NOT EXISTS'cejuser'@'localhost' IDENTIFIED BY 'Vagrant1|0000001';
GRANT ALL PRIVILEGES ON *.* TO 'cejuser'@'localhost';
FLUSH PRIVILEGES;
CREATE TABLE   t1( a DECIMAL(12, 2), b int ) ENGINE=innodb PARTITION BY KEY(b,a) PARTITIONS 4;
INSERT INTO t1 SELECT seq, seq/10 FROM seq_1_to_100;
CREATE TABLE IF NOT EXISTS t2  ( a DECIMAL(12, 2), b int ) ENGINE=COLUMNSTORE;
SELECT COUNT(*) FROM (SELECT * FROM t1 PARTITION (p0)) tt;
COUNT(*)
20
SELECT COUNT(*) FROM (SELECT * FROM t2 UNION ALL SELECT * FROM t1 PARTITION (p0)) tt;
COUNT(*)
20
REVOKE ALL PRIVILEGES ON *.* FROM 'cejuser'@'localhost';
DROP USER 'cejuser'@'localhost';
DROP DATABASE MCOL5886;