You've already forked mariadb-columnstore-engine
mirror of
https://github.com/mariadb-corporation/mariadb-columnstore-engine.git
synced 2025-07-29 08:21:15 +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>
199 lines
6.4 KiB
Plaintext
199 lines
6.4 KiB
Plaintext
USE outerjoin;
|
|
select count(*) from orders o
|
|
join customer c on o.o_custkey = c.c_custkey
|
|
join nation n on c.c_nationkey = n.n_nationkey
|
|
join region r on n.n_regionkey = r.r_regionkey
|
|
where c_custkey < 10
|
|
;
|
|
count(*)
|
|
78
|
|
select count(*) from orders o
|
|
join (select * from customer where c_custkey < 10) c on o.o_custkey = c.c_custkey
|
|
join nation n on c.c_nationkey = n.n_nationkey
|
|
join region r on n.n_regionkey = r.r_regionkey
|
|
;
|
|
count(*)
|
|
78
|
|
select count(*) from orders o
|
|
join (select * from customer where c_custkey < 10) c on o.o_custkey = c.c_custkey
|
|
join nation n on c.c_nationkey = n.n_nationkey
|
|
left join region r on n.n_regionkey = r.r_regionkey
|
|
;
|
|
count(*)
|
|
78
|
|
select count(*) from orders o
|
|
join (select * from customer where c_custkey < 10) c on o.o_custkey = c.c_custkey
|
|
join nation n on c.c_nationkey = n.n_nationkey
|
|
right join region r on n.n_regionkey = r.r_regionkey
|
|
;
|
|
count(*)
|
|
83
|
|
select count(*) from orders o
|
|
join (select * from customer where c_custkey < 10) c on o.o_custkey = c.c_custkey
|
|
left join nation n on c.c_nationkey = n.n_nationkey
|
|
join region r on n.n_regionkey = r.r_regionkey
|
|
;
|
|
count(*)
|
|
78
|
|
select count(*) from orders o
|
|
join (select * from customer where c_custkey < 10) c on o.o_custkey = c.c_custkey
|
|
left join nation n on c.c_nationkey = n.n_nationkey
|
|
left join region r on n.n_regionkey = r.r_regionkey
|
|
;
|
|
count(*)
|
|
80
|
|
select count(*) from orders o
|
|
join (select * from customer where c_custkey < 10) c on o.o_custkey = c.c_custkey
|
|
left join nation n on c.c_nationkey = n.n_nationkey
|
|
right join region r on n.n_regionkey = r.r_regionkey
|
|
;
|
|
count(*)
|
|
83
|
|
select count(*) from orders o
|
|
join (select * from customer where c_custkey < 10) c on o.o_custkey = c.c_custkey
|
|
right join nation n on c.c_nationkey = n.n_nationkey
|
|
join region r on n.n_regionkey = r.r_regionkey
|
|
;
|
|
count(*)
|
|
97
|
|
select count(*) from orders o
|
|
join (select * from customer where c_custkey < 10) c on o.o_custkey = c.c_custkey
|
|
right join nation n on c.c_nationkey = n.n_nationkey
|
|
left join region r on n.n_regionkey = r.r_regionkey
|
|
;
|
|
count(*)
|
|
103
|
|
select count(*) from orders o
|
|
join (select * from customer where c_custkey < 10) c on o.o_custkey = c.c_custkey
|
|
right join nation n on c.c_nationkey = n.n_nationkey
|
|
right join region r on n.n_regionkey = r.r_regionkey
|
|
;
|
|
count(*)
|
|
101
|
|
select count(*) from orders o
|
|
left join (select * from customer where c_custkey < 10) c on o.o_custkey = c.c_custkey
|
|
join nation n on c.c_nationkey = n.n_nationkey
|
|
join region r on n.n_regionkey = r.r_regionkey
|
|
;
|
|
count(*)
|
|
78
|
|
select count(*) from orders o
|
|
left join (select * from customer where c_custkey < 10) c on o.o_custkey = c.c_custkey
|
|
join nation n on c.c_nationkey = n.n_nationkey
|
|
left join region r on n.n_regionkey = r.r_regionkey
|
|
;
|
|
count(*)
|
|
78
|
|
select count(*) from orders o
|
|
left join (select * from customer where c_custkey < 10) c on o.o_custkey = c.c_custkey
|
|
join nation n on c.c_nationkey = n.n_nationkey
|
|
right join region r on n.n_regionkey = r.r_regionkey
|
|
;
|
|
count(*)
|
|
83
|
|
select count(*) from orders o
|
|
left join (select * from customer where c_custkey < 10) c on o.o_custkey = c.c_custkey
|
|
left join nation n on c.c_nationkey = n.n_nationkey
|
|
join region r on n.n_regionkey = r.r_regionkey
|
|
;
|
|
count(*)
|
|
78
|
|
select count(*) from orders o
|
|
left join (select * from customer where c_custkey < 10) c on o.o_custkey = c.c_custkey
|
|
left join nation n on c.c_nationkey = n.n_nationkey
|
|
left join region r on n.n_regionkey = r.r_regionkey
|
|
;
|
|
count(*)
|
|
1610
|
|
select count(*) from orders o
|
|
left join (select * from customer where c_custkey < 10) c on o.o_custkey = c.c_custkey
|
|
left join nation n on c.c_nationkey = n.n_nationkey
|
|
right join region r on n.n_regionkey = r.r_regionkey
|
|
;
|
|
count(*)
|
|
83
|
|
select count(*) from orders o
|
|
left join (select * from customer where c_custkey < 10) c on o.o_custkey = c.c_custkey
|
|
right join nation n on c.c_nationkey = n.n_nationkey
|
|
join region r on n.n_regionkey = r.r_regionkey
|
|
;
|
|
count(*)
|
|
97
|
|
select count(*) from orders o
|
|
left join (select * from customer where c_custkey < 10) c on o.o_custkey = c.c_custkey
|
|
right join nation n on c.c_nationkey = n.n_nationkey
|
|
left join region r on n.n_regionkey = r.r_regionkey
|
|
;
|
|
count(*)
|
|
103
|
|
select count(*) from orders o
|
|
left join (select * from customer where c_custkey < 10) c on o.o_custkey = c.c_custkey
|
|
right join nation n on c.c_nationkey = n.n_nationkey
|
|
right join region r on n.n_regionkey = r.r_regionkey
|
|
;
|
|
count(*)
|
|
101
|
|
select count(*) from orders o
|
|
left join (select * from customer where c_custkey < 10) c on o.o_custkey = c.c_custkey
|
|
join nation n on c.c_nationkey = n.n_nationkey
|
|
join region r on n.n_regionkey = r.r_regionkey
|
|
;
|
|
count(*)
|
|
78
|
|
select count(*) from orders o
|
|
left join (select * from customer where c_custkey < 10) c on o.o_custkey = c.c_custkey
|
|
join nation n on c.c_nationkey = n.n_nationkey
|
|
left join region r on n.n_regionkey = r.r_regionkey
|
|
;
|
|
count(*)
|
|
78
|
|
select count(*) from orders o
|
|
left join (select * from customer where c_custkey < 10) c on o.o_custkey = c.c_custkey
|
|
join nation n on c.c_nationkey = n.n_nationkey
|
|
right join region r on n.n_regionkey = r.r_regionkey
|
|
;
|
|
count(*)
|
|
83
|
|
select count(*) from orders o
|
|
right join (select * from customer where c_custkey < 10) c on o.o_custkey = c.c_custkey
|
|
left join nation n on c.c_nationkey = n.n_nationkey
|
|
join region r on n.n_regionkey = r.r_regionkey
|
|
;
|
|
count(*)
|
|
81
|
|
select count(*) from orders o
|
|
right join (select * from customer where c_custkey < 10) c on o.o_custkey = c.c_custkey
|
|
left join nation n on c.c_nationkey = n.n_nationkey
|
|
left join region r on n.n_regionkey = r.r_regionkey
|
|
;
|
|
count(*)
|
|
102
|
|
select count(*) from orders o
|
|
right join (select * from customer where c_custkey < 10) c on o.o_custkey = c.c_custkey
|
|
left join nation n on c.c_nationkey = n.n_nationkey
|
|
right join region r on n.n_regionkey = r.r_regionkey
|
|
;
|
|
count(*)
|
|
86
|
|
select count(*) from orders o
|
|
right join (select * from customer where c_custkey < 10) c on o.o_custkey = c.c_custkey
|
|
right join nation n on c.c_nationkey = n.n_nationkey
|
|
join region r on n.n_regionkey = r.r_regionkey
|
|
;
|
|
count(*)
|
|
97
|
|
select count(*) from orders o
|
|
right join (select * from customer where c_custkey < 10) c on o.o_custkey = c.c_custkey
|
|
right join nation n on c.c_nationkey = n.n_nationkey
|
|
left join region r on n.n_regionkey = r.r_regionkey
|
|
;
|
|
count(*)
|
|
103
|
|
select count(*) from orders o
|
|
right join (select * from customer where c_custkey < 10) c on o.o_custkey = c.c_custkey
|
|
right join nation n on c.c_nationkey = n.n_nationkey
|
|
right join region r on n.n_regionkey = r.r_regionkey
|
|
;
|
|
count(*)
|
|
101
|