mirror of
https://github.com/mariadb-corporation/mariadb-columnstore-engine.git
synced 2025-04-20 09:07:44 +03:00
29 lines
636 B
Plaintext
29 lines
636 B
Plaintext
#-- source ../include/have_columnstore.inc
|
|
|
|
--disable_warnings
|
|
DROP DATABASE IF EXISTS analyze_table_db;
|
|
--enable_warnings
|
|
|
|
CREATE DATABASE analyze_table_db;
|
|
USE analyze_table_db;
|
|
|
|
create table t1 (a int, b int, c int) engine=columnstore;
|
|
insert into t1 values (1, 2, 3), (2, 2, 2), (2, 3, 4);
|
|
analyze table t1;
|
|
|
|
create table t2 (a int, b double) engine=columnstore;
|
|
insert into t2 values (2, 3), (3, 4);
|
|
analyze table t2;
|
|
|
|
create table t3 (a varchar(25)) engine=columnstore;
|
|
insert into t3 values ("a"), ("b");
|
|
analyze table t3;
|
|
|
|
|
|
analyze table t1, t2, t3;
|
|
|
|
DROP TABLE t1;
|
|
DROP TABLE t2;
|
|
DROP TABLE t3;
|
|
DROP DATABASE analyze_table_db;
|