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