Sign in
apache
/
drill-test-framework
/
9a5d7ecf7f32f0e95c0ea874e75d785fdee9e51d
/
.
/
framework
/
resources
/
Functional
/
semijoin
/
antiJoinExists14.sql
blob: 5c694b448092d973c428af73f3875befc9c9a141 [
file
] [
log
] [
blame
]
set
`
planner
.
enable_semijoin
`
=
true
;
SELECT
orders
.
o_totalprice
FROM
orders
WHERE
not
EXISTS
(
SELECT
1
FROM
customer
WHERE
customer
.
c_custkey
=
orders
.
o_custkey
)
order
by
orders
.
o_totalprice limit
10
;
reset
`
planner
.
enable_semijoin
`;