Sign in
apache
/
drill-test-framework
/
0c85b4fdd97d4bceb9f295eb434983b210bff100
/
.
/
framework
/
resources
/
Functional
/
semijoin
/
semiJoinWithConstantsBelowThreshold12.sql
blob: 00132e64d837e90b18ffba0c96ec3a7d4ee71480 [
file
] [
log
] [
blame
]
set
`
planner
.
enable_semijoin
`
=
true
;
select
orders
.
o_totalprice
from
orders
where
orders
.
o_custkey
in
(
60001
,
60002
,
60003
,
60004
,
60005
,
60006
,
60007
,
60008
,
60009
,
60010
)
order
by
orders
.
o_totalprice limit
10
;
reset
`
planner
.
enable_semijoin
`;