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`;