database/mariadb-columnstore-engine
1
0
Fork 0
mirror of https://github.com/mariadb-corporation/mariadb-columnstore-engine.git synced 2025-07-29 08:21:15 +03:00
Code Activity
Files
test-debug-fix
mariadb-columnstore-engine/mysql-test/columnstore/autopilot/r/mcs6892_outerjoin_oneTable.result
Daniel Lee 2606c91afd Dlee 22.08.2 updates (#2578) 
* Sort test result so the test case would pass

* Server message has been changes

* Added schema name in query for rows in test case only.  Also use lower case schema name

* Changed database to lower case

* Run test case in its own database to avoid table already exists error

Co-authored-by: root <root@rocky8.localdomain>
2022-10-05 16:56:57 -05:00

233 lines
40 KiB
Plaintext
Raw Permalink Blame History

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