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>
85 lines
5.3 KiB
Plaintext
85 lines
5.3 KiB
Plaintext
USE tpch1;
|
|
set autocommit=0;
|
|
select count(*) from nation where n_nationkey * (n_regionkey > 0) = 0;
|
|
count(*)
|
|
5
|
|
select count(*) from nation where n_nationkey * (n_regionkey > 0) = 0;
|
|
count(*)
|
|
5
|
|
select count(*) from nation where n_nationkey * (n_regionkey > 0) = 0;
|
|
count(*)
|
|
5
|
|
select count(*) from nation where n_nationkey * (n_regionkey > 2) = 0;
|
|
count(*)
|
|
15
|
|
select count(*) from nation where n_nationkey * (n_regionkey > 2) = 0;
|
|
count(*)
|
|
15
|
|
select count(*) from nation where n_nationkey * (n_regionkey > 2) = 0;
|
|
count(*)
|
|
15
|
|
update nation set n_regionkey = n_nationkey where n_nationkey * (n_regionkey > 0) = 0;
|
|
select count(*) from nation where n_nationkey * (n_regionkey > 0) = 0;
|
|
count(*)
|
|
1
|
|
select * from nation;
|
|
n_nationkey n_name n_regionkey n_comment
|
|
0 ALGERIA 0 haggle. carefully final deposits detect slyly agai
|
|
1 ARGENTINA 1 al foxes promise slyly according to the regular accounts. bold requests alon
|
|
2 BRAZIL 1 y alongside of the pending deposits. carefully special packages are about the ironic forges. slyly special
|
|
3 CANADA 1 eas hang ironic, silent packages. slyly regular packages are furiously over the tithes. fluffily bold
|
|
4 EGYPT 4 y above the carefully unusual theodolites. final dugouts are quickly across the furiously regular d
|
|
5 ETHIOPIA 5 ven packages wake quickly. regu
|
|
6 FRANCE 3 refully final requests. regular, ironi
|
|
7 GERMANY 3 l platelets. regular accounts x-ray: unusual, regular acco
|
|
8 INDIA 2 ss excuses cajole slyly across the packages. deposits print aroun
|
|
9 INDONESIA 2 slyly express asymptotes. regular deposits haggle slyly. carefully ironic hockey players sleep blithely. carefull
|
|
10 IRAN 4 efully alongside of the slyly final dependencies.
|
|
11 IRAQ 4 nic deposits boost atop the quickly final requests? quickly regula
|
|
12 JAPAN 2 ously. final, express gifts cajole a
|
|
13 JORDAN 4 ic deposits are blithely about the carefully regular pa
|
|
14 KENYA 14 pending excuses haggle furiously deposits. pending, express pinto beans wake fluffily past t
|
|
15 MOROCCO 15 rns. blithely bold courts among the closely regular packages use furiously bold platelets?
|
|
16 MOZAMBIQUE 16 s. ironic, unusual asymptotes wake blithely r
|
|
17 PERU 1 platelets. blithely pending dependencies use fluffily across the even pinto beans. carefully silent accoun
|
|
18 CHINA 2 c dependencies. furiously express notornis sleep slyly regular accounts. ideas sleep. depos
|
|
19 ROMANIA 3 ular asymptotes are about the furious multipliers. express dependencies nag above the ironically ironic account
|
|
20 SAUDI ARABIA 4 ts. silent requests haggle. closely express packages sleep across the blithely
|
|
21 VIETNAM 2 hely enticingly express accounts. even, final
|
|
22 RUSSIA 3 requests against the platelets use never according to the quickly regular pint
|
|
23 UNITED KINGDOM 3 eans boost carefully special requests. accounts are. carefull
|
|
24 UNITED STATES 1 y final packages. slow foxes cajole quickly. quickly silent platelets breach ironic accounts. unusual pinto be
|
|
rollback;
|
|
update nation set n_regionkey = n_nationkey where n_nationkey * (n_regionkey > 2) = 0;
|
|
select count(*) from nation where n_nationkey * (n_regionkey > 2) = 0;
|
|
count(*)
|
|
3
|
|
select * from nation;
|
|
n_nationkey n_name n_regionkey n_comment
|
|
0 ALGERIA 0 haggle. carefully final deposits detect slyly agai
|
|
1 ARGENTINA 1 al foxes promise slyly according to the regular accounts. bold requests alon
|
|
2 BRAZIL 2 y alongside of the pending deposits. carefully special packages are about the ironic forges. slyly special
|
|
3 CANADA 3 eas hang ironic, silent packages. slyly regular packages are furiously over the tithes. fluffily bold
|
|
4 EGYPT 4 y above the carefully unusual theodolites. final dugouts are quickly across the furiously regular d
|
|
5 ETHIOPIA 5 ven packages wake quickly. regu
|
|
6 FRANCE 3 refully final requests. regular, ironi
|
|
7 GERMANY 3 l platelets. regular accounts x-ray: unusual, regular acco
|
|
8 INDIA 8 ss excuses cajole slyly across the packages. deposits print aroun
|
|
9 INDONESIA 9 slyly express asymptotes. regular deposits haggle slyly. carefully ironic hockey players sleep blithely. carefull
|
|
10 IRAN 4 efully alongside of the slyly final dependencies.
|
|
11 IRAQ 4 nic deposits boost atop the quickly final requests? quickly regula
|
|
12 JAPAN 12 ously. final, express gifts cajole a
|
|
13 JORDAN 4 ic deposits are blithely about the carefully regular pa
|
|
14 KENYA 14 pending excuses haggle furiously deposits. pending, express pinto beans wake fluffily past t
|
|
15 MOROCCO 15 rns. blithely bold courts among the closely regular packages use furiously bold platelets?
|
|
16 MOZAMBIQUE 16 s. ironic, unusual asymptotes wake blithely r
|
|
17 PERU 17 platelets. blithely pending dependencies use fluffily across the even pinto beans. carefully silent accoun
|
|
18 CHINA 18 c dependencies. furiously express notornis sleep slyly regular accounts. ideas sleep. depos
|
|
19 ROMANIA 3 ular asymptotes are about the furious multipliers. express dependencies nag above the ironically ironic account
|
|
20 SAUDI ARABIA 4 ts. silent requests haggle. closely express packages sleep across the blithely
|
|
21 VIETNAM 21 hely enticingly express accounts. even, final
|
|
22 RUSSIA 3 requests against the platelets use never according to the quickly regular pint
|
|
23 UNITED KINGDOM 3 eans boost carefully special requests. accounts are. carefull
|
|
24 UNITED STATES 24 y final packages. slow foxes cajole quickly. quickly silent platelets breach ironic accounts. unusual pinto be
|
|
rollback;
|