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>
44 lines
1.8 KiB
Plaintext
44 lines
1.8 KiB
Plaintext
USE ssb1;
|
|
select count(*) as c1 from dateinfo where (d_year, d_yearmonthnum) = (1994,199402);
|
|
c1
|
|
28
|
|
select count(*) as c2 from dateinfo where (d_year, d_month, d_daynuminweek) = (1993, 'February', 3);
|
|
c2
|
|
4
|
|
select count(*) as c3 from dateinfo where (d_year, d_month, d_daynuminweek) in ((1993, 'February', 3), (1994, 'February',2));
|
|
c3
|
|
8
|
|
select d_year, count(*) as c4 from dateinfo where (d_dayofweek, d_year) not in (('Monday', 1994), ('Tuesday', 1995)) group by 1 order by 1;
|
|
d_year c4
|
|
1992 366
|
|
1993 365
|
|
1994 313
|
|
1995 313
|
|
1996 366
|
|
1997 365
|
|
1998 364
|
|
select d_year, count(*) as c5 from dateinfo where (d_dayofweek, d_year) in (('Monday', 1994), ('Tuesday', 1995)) group by 1 order by 1;
|
|
d_year c5
|
|
1994 52
|
|
1995 52
|
|
(select d_year, count(*) as c6 from dateinfo where (d_dayofweek, d_year) = ('Monday', 1994) group by 1) union
|
|
(select d_year, count(*) as c6 from dateinfo where (d_dayofweek, d_year) = ('Tuesday', 1995) group by 1) order by 1;
|
|
d_year c6
|
|
1994 52
|
|
1995 52
|
|
select d_dayofweek, count(*) as c7 from lineorder join part on lo_partkey = p_partkey join dateinfo on lo_orderdate = d_datekey
|
|
where ((lo_orderdate, p_container)) in ((19980104, 'LG BAG'), (19970204, 'LG JAR')) group by 1 order by 1;
|
|
d_dayofweek c7
|
|
Monday 59
|
|
Wednesday 66
|
|
select count(*) as c8 from lineorder where lo_orderdate in
|
|
(select d_datekey from dateinfo where (d_yearmonthnum, d_daynuminmonth) in ((199204, 12), (199505,11)));
|
|
c8
|
|
4755
|
|
select 'c10' as c10, supplier.* from supplier where (s_suppkey, s_name, s_address, s_city, s_nation, s_region, s_phone) =
|
|
(10, 'Supplier#000000010', 'Saygah3gYWM', 'UNITED ST9', 'UNITED STATES', 'AMERICA', '34-741-346-9870');
|
|
c10 s_suppkey s_name s_address s_city s_nation s_region s_phone
|
|
select count(*) as c11 from supplier where (s_suppkey, s_region) <> (10, 'AMERICA');
|
|
c11
|
|
9999
|