mirror of
https://github.com/mariadb-corporation/mariadb-columnstore-engine.git
synced 2025-04-26 11:48:52 +03:00
* 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>
68 lines
1.5 KiB
Plaintext
68 lines
1.5 KiB
Plaintext
# -------------------------------------------------------------- #
|
|
# Test case migrated from regression test suite: bug3522.sql
|
|
#
|
|
# Author: Daniel Lee, daniel.lee@mariadb.com
|
|
# -------------------------------------------------------------- #
|
|
#
|
|
--source ../include/have_columnstore.inc
|
|
#
|
|
USE tpch1;
|
|
#
|
|
select
|
|
count(distinct c1) c1,
|
|
count(distinct c2) c2,
|
|
count(distinct c3) c3,
|
|
count(distinct c4) c4,
|
|
count(distinct c5) c5,
|
|
count(distinct c6) c6,
|
|
count(distinct c7) c7,
|
|
count(distinct c8) c8,
|
|
count(distinct c9) c9,
|
|
count(distinct c10) c10,
|
|
count(distinct c11) c11,
|
|
count(distinct c12) c12,
|
|
count(distinct c13) c13,
|
|
count(distinct c14) c14,
|
|
count(distinct c15) c15,
|
|
count(distinct c16) c16,
|
|
count(distinct c17) c17,
|
|
count(distinct c18) c18,
|
|
count(distinct c19) c19,
|
|
count(distinct c20) c20,
|
|
count(distinct c21) c21,
|
|
count(distinct c22) c22,
|
|
count(distinct c23) c23,
|
|
count(distinct c24) c24,
|
|
count(distinct c25) c25,
|
|
count(distinct c26) c26,
|
|
count(distinct c27) c27,
|
|
count(distinct c28) c28,
|
|
count(distinct c29) c29,
|
|
count(distinct c30) c30,
|
|
count(distinct c31) c31,
|
|
count(distinct c32) c32,
|
|
count(distinct c33) c33,
|
|
count(distinct c34) c34,
|
|
count(distinct c35) c35,
|
|
count(distinct c36) c36,
|
|
count(distinct c37) c37,
|
|
count(distinct c38) c38,
|
|
count(distinct c39) c39,
|
|
count(distinct c40) c40,
|
|
count(distinct c41) c41,
|
|
count(distinct c42) c42,
|
|
count(distinct c43) c43,
|
|
count(distinct c44) c44,
|
|
count(distinct c45) c45,
|
|
count(distinct c46) c46,
|
|
count(distinct c47) c47,
|
|
count(distinct c48) c48,
|
|
count(distinct c49) c49,
|
|
count(distinct c50) c50
|
|
from wide
|
|
where idx = 99;
|
|
|
|
|
|
#
|
|
|