Tracking: Which TPC-H queries can be run?
Opened this issue · 0 comments
jurplel commented
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
- 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