mirror of
https://github.com/mariadb-corporation/mariadb-columnstore-engine.git
synced 2025-04-26 11:48:52 +03:00
4c9d6e39ac
* Restructured test suites and added autopilot and extended suites * Updated autopilot with correct branch - develop * Moved setup test case to a 'setup' directory, for consistency * Fixed a path issue * Updated some tests cases to keep up with development Co-authored-by: root <root@rocky8.localdomain>
65 lines
2.6 KiB
Plaintext
65 lines
2.6 KiB
Plaintext
#
|
|
# Test case migrated from regression test suite:
|
|
# ./mysql/queries/nightly/alltest/test000/tpchSchemaValidation/wide.sql
|
|
#
|
|
# Author: Susil, susil.behera@mariadb.com
|
|
#
|
|
|
|
-- source ../include/have_columnstore.inc
|
|
|
|
USE tpch1;
|
|
|
|
select count(*) from wide;
|
|
select count(c1), min(c1), max(c1) from wide;
|
|
select count(c2), min(c2), max(c2) from wide;
|
|
select count(c3), min(c3), max(c3) from wide;
|
|
select count(c4), min(c4), max(c4) from wide;
|
|
select count(c5), min(c5), max(c5) from wide;
|
|
select count(c6), min(c6), max(c6) from wide;
|
|
select count(c7), min(c7), max(c7) from wide;
|
|
select count(c8), min(c8), max(c8) from wide;
|
|
select count(c9), min(c9), max(c9) from wide;
|
|
select count(c10), min(c10), max(c10) from wide;
|
|
select count(c11), min(c11), max(c11) from wide;
|
|
select count(c12), min(c12), max(c12) from wide;
|
|
select count(c13), min(c13), max(c13) from wide;
|
|
select count(c14), min(c14), max(c14) from wide;
|
|
select count(c15), min(c15), max(c15) from wide;
|
|
select count(c16), min(c16), max(c16) from wide;
|
|
select count(c17), min(c17), max(c17) from wide;
|
|
select count(c18), min(c18), max(c18) from wide;
|
|
select count(c19), min(c19), max(c19) from wide;
|
|
select count(c20), min(c20), max(c20) from wide;
|
|
select count(c21), min(c21), max(c21) from wide;
|
|
select count(c22), min(c22), max(c22) from wide;
|
|
select count(c23), min(c23), max(c23) from wide;
|
|
select count(c24), min(c24), max(c24) from wide;
|
|
select count(c25), min(c25), max(c25) from wide;
|
|
select count(c26), min(c26), max(c26) from wide;
|
|
select count(c27), min(c27), max(c27) from wide;
|
|
select count(c28), min(c28), max(c28) from wide;
|
|
select count(c29), min(c29), max(c29) from wide;
|
|
select count(c30), min(c30), max(c30) from wide;
|
|
select count(c31), min(c31), max(c31) from wide;
|
|
select count(c32), min(c32), max(c32) from wide;
|
|
select count(c33), min(c33), max(c33) from wide;
|
|
select count(c34), min(c34), max(c34) from wide;
|
|
select count(c35), min(c35), max(c35) from wide;
|
|
select count(c36), min(c36), max(c36) from wide;
|
|
select count(c37), min(c37), max(c37) from wide;
|
|
select count(c38), min(c38), max(c38) from wide;
|
|
select count(c39), min(c39), max(c39) from wide;
|
|
select count(c40), min(c40), max(c40) from wide;
|
|
select count(c41), min(c41), max(c41) from wide;
|
|
select count(c42), min(c42), max(c42) from wide;
|
|
select count(c43), min(c43), max(c43) from wide;
|
|
select count(c44), min(c44), max(c44) from wide;
|
|
select count(c45), min(c45), max(c45) from wide;
|
|
select count(c46), min(c46), max(c46) from wide;
|
|
select count(c47), min(c47), max(c47) from wide;
|
|
select count(c48), min(c48), max(c48) from wide;
|
|
select count(c49), min(c49), max(c49) from wide;
|
|
select count(c50), min(c50), max(c50) from wide;
|
|
|
|
|