cmu-db/optd

Tracking: Which TPC-H queries can be run?

Opened this issue · 0 comments

Related: #11, #68, #127

Ran with no datafusion optimizations (all of our own optimizations), on the subquery unnesting branch (bowad/subquery-unnest)

Tests were done for whether or not the query works with perfbench. Query result may be incorrect, but it compiles and runs

  • Q1
  • Q2
    • Depends on more complete subquery unnesting ruleset
  • Q3
  • Q4
    • Depends on subquery unnesting EXISTS support
    • May depend also on left semi join
  • Q5
  • Q6
  • Q7
  • Q8
  • Q9
  • Q10
  • Q11
    • Depends on more complete subquery unnesting
  • Q12
  • Q13
  • Q14
  • Q15
    • Error: db error: ERROR: cannot insert multiple commands into a prepared statement
    • ??? maybe test framework bug
  • Q16
    • Depends on subquery unnesting IN support
    • May depend also on left anti join
  • Q17
    • Depends on more complete subquery unnesting ruleset
  • Q18
    • Depends on subquery unnesting IN support
    • May depend also on left semi join
  • Q19
  • Q20
    • Depends on subquery unnesting IN support
    • May depend also on left semi join
  • Q21
    • Depends on subquery unnesting EXISTS support
    • May depend also on left semi and left anti join
  • Q22
    • Depends on subquery unnesting IN support
    • May depend also on left anti join