optd
optd copied to clipboard
Tracking: Which TPC-H queries can be run?
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