mirror of
https://github.com/mariadb-corporation/mariadb-columnstore-engine.git
synced 2025-04-18 21:44:02 +03:00
1283f1fc4d
* Added order by clause to keep results consistent over test runs * Updated test result for the merging of MCOL-5519 * Updated test results for the merging of MCOL-4632 * Updated test result for the merging of MCOL-5519 * Added missing / to path * Improved few tests cases * Fixed test case name --------- Co-authored-by: root <root@rocky8.localdomain>
76 lines
2.5 KiB
Plaintext
76 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
|
|
#
|
|
--exec systemctl restart mariadb
|
|
--exec sleep 10
|
|
|