You've already forked mariadb-columnstore-engine
mirror of
https://github.com/mariadb-corporation/mariadb-columnstore-engine.git
synced 2025-11-03 17:13:17 +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>
300 lines
3.4 KiB
Plaintext
300 lines
3.4 KiB
Plaintext
USE tpch1;
|
|
select n_name from ((select n_name, n_regionkey from nation) union all
|
|
(select n_name, n_regionkey from nation)) as a order by 1;
|
|
n_name
|
|
ALGERIA
|
|
ALGERIA
|
|
ARGENTINA
|
|
ARGENTINA
|
|
BRAZIL
|
|
BRAZIL
|
|
CANADA
|
|
CANADA
|
|
CHINA
|
|
CHINA
|
|
EGYPT
|
|
EGYPT
|
|
ETHIOPIA
|
|
ETHIOPIA
|
|
FRANCE
|
|
FRANCE
|
|
GERMANY
|
|
GERMANY
|
|
INDIA
|
|
INDIA
|
|
INDONESIA
|
|
INDONESIA
|
|
IRAN
|
|
IRAN
|
|
IRAQ
|
|
IRAQ
|
|
JAPAN
|
|
JAPAN
|
|
JORDAN
|
|
JORDAN
|
|
KENYA
|
|
KENYA
|
|
MOROCCO
|
|
MOROCCO
|
|
MOZAMBIQUE
|
|
MOZAMBIQUE
|
|
PERU
|
|
PERU
|
|
ROMANIA
|
|
ROMANIA
|
|
RUSSIA
|
|
RUSSIA
|
|
SAUDI ARABIA
|
|
SAUDI ARABIA
|
|
UNITED KINGDOM
|
|
UNITED KINGDOM
|
|
UNITED STATES
|
|
UNITED STATES
|
|
VIETNAM
|
|
VIETNAM
|
|
select n_name from ((select n_name, n_regionkey from nation) union
|
|
(select n_name, n_regionkey from nation)) as a order by 1;
|
|
n_name
|
|
ALGERIA
|
|
ARGENTINA
|
|
BRAZIL
|
|
CANADA
|
|
CHINA
|
|
EGYPT
|
|
ETHIOPIA
|
|
FRANCE
|
|
GERMANY
|
|
INDIA
|
|
INDONESIA
|
|
IRAN
|
|
IRAQ
|
|
JAPAN
|
|
JORDAN
|
|
KENYA
|
|
MOROCCO
|
|
MOZAMBIQUE
|
|
PERU
|
|
ROMANIA
|
|
RUSSIA
|
|
SAUDI ARABIA
|
|
UNITED KINGDOM
|
|
UNITED STATES
|
|
VIETNAM
|
|
select a_name from ((select n_name as a_name from nation) union (select
|
|
n_name as a_name from nation)) as a order by 1;
|
|
a_name
|
|
ALGERIA
|
|
ARGENTINA
|
|
BRAZIL
|
|
CANADA
|
|
CHINA
|
|
EGYPT
|
|
ETHIOPIA
|
|
FRANCE
|
|
GERMANY
|
|
INDIA
|
|
INDONESIA
|
|
IRAN
|
|
IRAQ
|
|
JAPAN
|
|
JORDAN
|
|
KENYA
|
|
MOROCCO
|
|
MOZAMBIQUE
|
|
PERU
|
|
ROMANIA
|
|
RUSSIA
|
|
SAUDI ARABIA
|
|
UNITED KINGDOM
|
|
UNITED STATES
|
|
VIETNAM
|
|
select name1 from ((select n_name as name1, n_regionkey from nation)
|
|
union all (select n_name as name1, n_regionkey from nation)) as a order by 1;
|
|
name1
|
|
ALGERIA
|
|
ALGERIA
|
|
ARGENTINA
|
|
ARGENTINA
|
|
BRAZIL
|
|
BRAZIL
|
|
CANADA
|
|
CANADA
|
|
CHINA
|
|
CHINA
|
|
EGYPT
|
|
EGYPT
|
|
ETHIOPIA
|
|
ETHIOPIA
|
|
FRANCE
|
|
FRANCE
|
|
GERMANY
|
|
GERMANY
|
|
INDIA
|
|
INDIA
|
|
INDONESIA
|
|
INDONESIA
|
|
IRAN
|
|
IRAN
|
|
IRAQ
|
|
IRAQ
|
|
JAPAN
|
|
JAPAN
|
|
JORDAN
|
|
JORDAN
|
|
KENYA
|
|
KENYA
|
|
MOROCCO
|
|
MOROCCO
|
|
MOZAMBIQUE
|
|
MOZAMBIQUE
|
|
PERU
|
|
PERU
|
|
ROMANIA
|
|
ROMANIA
|
|
RUSSIA
|
|
RUSSIA
|
|
SAUDI ARABIA
|
|
SAUDI ARABIA
|
|
UNITED KINGDOM
|
|
UNITED KINGDOM
|
|
UNITED STATES
|
|
UNITED STATES
|
|
VIETNAM
|
|
VIETNAM
|
|
select a.a_name, a.regionkey from ((select n_name as a_name, n_regionkey
|
|
as regionkey from nation) union (select n_name as a_name, n_regionkey as
|
|
regionkey from nation)) as a order by 1, 2;
|
|
a_name regionkey
|
|
ALGERIA 0
|
|
ARGENTINA 1
|
|
BRAZIL 1
|
|
CANADA 1
|
|
CHINA 2
|
|
EGYPT 4
|
|
ETHIOPIA 0
|
|
FRANCE 3
|
|
GERMANY 3
|
|
INDIA 2
|
|
INDONESIA 2
|
|
IRAN 4
|
|
IRAQ 4
|
|
JAPAN 2
|
|
JORDAN 4
|
|
KENYA 0
|
|
MOROCCO 0
|
|
MOZAMBIQUE 0
|
|
PERU 1
|
|
ROMANIA 3
|
|
RUSSIA 3
|
|
SAUDI ARABIA 4
|
|
UNITED KINGDOM 3
|
|
UNITED STATES 1
|
|
VIETNAM 2
|
|
select a_name from ((select n_name as a_name from nation) union all (select
|
|
n_name as a_name from nation)) as a order by 1;
|
|
a_name
|
|
ALGERIA
|
|
ALGERIA
|
|
ARGENTINA
|
|
ARGENTINA
|
|
BRAZIL
|
|
BRAZIL
|
|
CANADA
|
|
CANADA
|
|
CHINA
|
|
CHINA
|
|
EGYPT
|
|
EGYPT
|
|
ETHIOPIA
|
|
ETHIOPIA
|
|
FRANCE
|
|
FRANCE
|
|
GERMANY
|
|
GERMANY
|
|
INDIA
|
|
INDIA
|
|
INDONESIA
|
|
INDONESIA
|
|
IRAN
|
|
IRAN
|
|
IRAQ
|
|
IRAQ
|
|
JAPAN
|
|
JAPAN
|
|
JORDAN
|
|
JORDAN
|
|
KENYA
|
|
KENYA
|
|
MOROCCO
|
|
MOROCCO
|
|
MOZAMBIQUE
|
|
MOZAMBIQUE
|
|
PERU
|
|
PERU
|
|
ROMANIA
|
|
ROMANIA
|
|
RUSSIA
|
|
RUSSIA
|
|
SAUDI ARABIA
|
|
SAUDI ARABIA
|
|
UNITED KINGDOM
|
|
UNITED KINGDOM
|
|
UNITED STATES
|
|
UNITED STATES
|
|
VIETNAM
|
|
VIETNAM
|
|
select a.a_name, a.regionkey from ((select n_name as a_name, n_regionkey
|
|
as regionkey from nation) union all (select n_name as a_name, n_regionkey as
|
|
regionkey from nation)) as a order by 1, 2;
|
|
a_name regionkey
|
|
ALGERIA 0
|
|
ALGERIA 0
|
|
ARGENTINA 1
|
|
ARGENTINA 1
|
|
BRAZIL 1
|
|
BRAZIL 1
|
|
CANADA 1
|
|
CANADA 1
|
|
CHINA 2
|
|
CHINA 2
|
|
EGYPT 4
|
|
EGYPT 4
|
|
ETHIOPIA 0
|
|
ETHIOPIA 0
|
|
FRANCE 3
|
|
FRANCE 3
|
|
GERMANY 3
|
|
GERMANY 3
|
|
INDIA 2
|
|
INDIA 2
|
|
INDONESIA 2
|
|
INDONESIA 2
|
|
IRAN 4
|
|
IRAN 4
|
|
IRAQ 4
|
|
IRAQ 4
|
|
JAPAN 2
|
|
JAPAN 2
|
|
JORDAN 4
|
|
JORDAN 4
|
|
KENYA 0
|
|
KENYA 0
|
|
MOROCCO 0
|
|
MOROCCO 0
|
|
MOZAMBIQUE 0
|
|
MOZAMBIQUE 0
|
|
PERU 1
|
|
PERU 1
|
|
ROMANIA 3
|
|
ROMANIA 3
|
|
RUSSIA 3
|
|
RUSSIA 3
|
|
SAUDI ARABIA 4
|
|
SAUDI ARABIA 4
|
|
UNITED KINGDOM 3
|
|
UNITED KINGDOM 3
|
|
UNITED STATES 1
|
|
UNITED STATES 1
|
|
VIETNAM 2
|
|
VIETNAM 2
|