mirror of
https://github.com/mariadb-corporation/mariadb-columnstore-engine.git
synced 2025-04-26 11:48:52 +03:00
8671f55784
* Add MTR_SUITE_LIST * Typo * Add data download * Install tar and lz4 * Change the way MTR_SUITE_LIST is set up * Use bash for MTR_SUITE_LIST * Another one * Fix reference results for full MTR develop, disable broken JSON test and tests with 10GB database * Fix timestamps and truncate cos * Fix some more references * Fix dokcerhub step for custom build * One more fix for dockerhub step on custom build * Fix tests for regr functions with truncate * Full mtr set on nghtly + MTR_FULL_SET flag * One more fix for dockerhub * Fix MTR_FULL_SET * Testing MTR_FULL_SET * sorted_result in tests + fix typo * Truncate even more * Typo * truncate 2 more tests * Disable regr_* functions tests * fix setup mtr step * correct settings for table creation * Put setup for tests into drone * Fix for debian based distros * More truncates * Disable the rest --------- Co-authored-by: Leonid Fedorov <leonid.fedorov@mariadb.com>
78 lines
2.5 KiB
Plaintext
78 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
|
|
#
|
|
--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
|
|
#
|
|
SET GLOBAL columnstore_use_import_for_batchinsert=ON;
|
|
#
|
|
--exec systemctl restart mariadb
|
|
--exec sleep 10
|
|
|