You've already forked mariadb-columnstore-engine
mirror of
https://github.com/mariadb-corporation/mariadb-columnstore-engine.git
synced 2025-11-03 17:13:17 +03:00
77 lines
2.5 KiB
Plaintext
77 lines
2.5 KiB
Plaintext
# -------------------------------------------------------------- #
|
|
# This test is to setup a the required databases for csinternal
|
|
# test suite. It must be executed alone before executing the
|
|
# devregression test suite.
|
|
#
|
|
# Author: Daniel Lee, daniel.lee@mariadb.com
|
|
# -------------------------------------------------------------- #
|
|
#
|
|
--source ../include/have_columnstore.inc
|
|
--source ../include/detect_maxscale.inc
|
|
#
|
|
--disable_warnings
|
|
DROP DATABASE IF EXISTS tpch1m;
|
|
DROP DATABASE IF EXISTS tpch1;
|
|
DROP DATABASE IF EXISTS ssb1;
|
|
DROP DATABASE IF EXISTS dml;
|
|
DROP DATABASE IF EXISTS autopilot;
|
|
DROP DATABASE IF EXISTS outerjoin;
|
|
CREATE DATABASE IF NOT EXISTS test;
|
|
--enable_warnings
|
|
#
|
|
CREATE DATABASE tpch1m;
|
|
CREATE DATABASE tpch1;
|
|
CREATE DATABASE ssb1;
|
|
CREATE DATABASE dml;
|
|
CREATE DATABASE autopilot;
|
|
CREATE DATABASE outerjoin;
|
|
#
|
|
USE tpch1m;
|
|
--source ../include/dbt3/createTables.inc
|
|
--source ../include/dbt3/ldiTables1m.inc
|
|
--source ../include/dbt3/countTables.inc
|
|
#
|
|
USE tpch1;
|
|
--source ../include/dbt3/createTables.inc
|
|
--source ../include/dbt3/ldiTables1g.inc
|
|
--source ../include/dbt3/countTables.inc
|
|
#
|
|
use ssb1;
|
|
--source ../include/ssb/createTables.inc
|
|
--source ../include/ssb/ldiTables1g.inc
|
|
--source ../include/ssb/countTables.inc
|
|
#
|
|
USE dml;
|
|
--source ../include/dbt3/createTables.inc
|
|
--source ../include/dbt3/ldiTables1g.inc
|
|
--source ../include/dbt3/countTables.inc
|
|
#
|
|
# Create misc test tables
|
|
USE tpch1;
|
|
--source ../include/regression_create_dtypes.inc
|
|
--source ../include/regression_create_simple_subselect.inc
|
|
--source ../include/regression_create_empsalary.inc
|
|
--source ../include/regression_create_datatypetestm.inc
|
|
--source ../include/regression_create_datatypetestm1.inc
|
|
--source ../include/regression_create_wide_tables.inc
|
|
--source ../include/regression_create_misc_tables.inc
|
|
#
|
|
USE autopilot;
|
|
--source ../include/autopilot_create_datatypetestm_tables.inc
|
|
--source ../include/autopilot_create_datatypeupdate_table.inc
|
|
--source ../include/autopilot_create_jsontest_table.inc
|
|
#
|
|
USE outerjoin;
|
|
--source ../include/dbt3/createTables.inc
|
|
--source ../include/dbt3/ldiTables1m.inc
|
|
--source ../include/dbt3/countTables.inc
|
|
--source ../include/autopilot_create_outerjoin_tables.inc
|
|
#
|
|
# Set table name to case insensitive
|
|
--exec if test -f /etc/my.cnf.d/server.cnf; then sed -i 's/\[mysqld\]/\[mysqld\]\nlower_case_table_names=1/g' /etc/my.cnf.d/server.cnf; fi
|
|
--exec if test -f /etc/mysql/mariadb.conf.d/50.server.cnf; then sed -i 's/\[mysqld\]/\[mysqld\]\nlower_case_table_names=1/g' /etc/mysql/mariadb.conf.d/50-server.cnf; fi
|
|
#
|
|
--exec systemctl restart mariadb
|
|
--exec sleep 10
|
|
|