Fix issue with recursive optimizations
Closed this issue · 1 comments
Felerius commented
Sample query:
SELECT s_suppkey
FROM supplier
WHERE s_suppkey IN (
SELECT c_custkey
FROM customer
WHERE c_custkey IN (
SELECT o_custkey
FROM orders
WHERE o_totalprice > c_acctbal AND o_totalprice > c_custkey AND o_totalprice > s_suppkey
)
)
Single line version for pasting into hyriseConsole:
SELECT s_suppkey FROM supplier WHERE s_suppkey IN (SELECT c_custkey FROM customer WHERE c_custkey IN (SELECT o_custkey FROM orders WHERE o_totalprice > c_acctbal AND o_totalprice > c_custkey AND o_totalprice > s_suppkey))