mirror of
https://github.com/mariadb-corporation/mariadb-columnstore-engine.git
synced 2025-04-26 11:48:52 +03:00
23 lines
484 B
Plaintext
23 lines
484 B
Plaintext
#
|
|
# Test FlUSH
|
|
# Author: Bharath, bharath.bokka@mariadb.com
|
|
#
|
|
-- source ../include/have_columnstore.inc
|
|
|
|
--disable_warnings
|
|
DROP DATABASE IF EXISTS mcs115_db;
|
|
--enable_warnings
|
|
|
|
CREATE DATABASE mcs115_db;
|
|
USE mcs115_db;
|
|
|
|
CREATE TABLE t1 (a INT, b CHAR(1))ENGINE=Columnstore;
|
|
INSERT INTO t1 VALUES(NULL, ''),(1, 'z'),(2, 'y'),(1, 'y'),(2, 'z'),(3, 'z');
|
|
|
|
SELECT COUNT(a) FROM t1;
|
|
SELECT COUNT(DISTINCT a) FROM t1;
|
|
SELECT COUNT(DISTINCT b) FROM t1;
|
|
|
|
# Clean UP
|
|
DROP DATABASE mcs115_db;
|