Felerius/hyrise

Fix issue with recursive optimizations

Closed this issue · 1 comments

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))

Fixed by #12