Subquery Unnesting Bugs/missing features - Githubissues

cmu-db / optd

CMU-DB's Cascades optimizer framework

https://cmu-db.github.io/optd/

MIT License

373 stars 22 forks source link

Subquery Unnesting Bugs/missing features #188

Open jurplel opened 3 weeks ago

jurplel commented 3 weeks ago

[ ] More testing (+ unit tests)
[ ] Query plan correctness issues
- [ ] Datafusion plan typing issues
[ ] EXISTS clauses
[ ] IN clauses
[ ] ANY/ALL clauses
[ ] Correctness issue with COUNT(*) (requires adding left outer join to plan)
[ ] Support more pushdowns (e.g. limit, joins)
[ ] Optimizations from the paper are all missing (Out of scope?)

Here are some test subqueries from my development: https://pastebin.com/SJV9q03B