optd icon indicating copy to clipboard operation
optd copied to clipboard

Tracking: Which TPC-H queries can be run?

Open jurplel opened this issue 5 months ago • 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
    • Broken in same way as [previously found issue](https://github.com/cmu-db/optd/issues/
    • perftest issue?
  • [ ] Q2
    • Depends on more complete subquery unnesting ruleset
  • [x] Q3
  • [ ] Q4
    • Depends on subquery unnesting EXISTS support
    • May depend also on left semi join
  • [x] Q5
  • [x] Q6
  • [x] Q7
  • [x] Q8
  • [x] Q9
  • [x] Q10
  • [ ] Q11
    • Depends on more complete subquery unnesting
  • [x] Q12
  • [x] Q13
  • [x] 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
  • [x] 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

jurplel avatar Sep 03 '24 17:09 jurplel