search

zhouqingqing / qpmodel

A Relational Optimizer and Executor
MIT License
66 stars 18 forks source link

add IN subquery decorrelation support & fix not handle NOT IN bug #242

Closed 9DemonFox closed 3 years ago

9DemonFox commented 3 years ago

this check-in adds IN subquery decorrelation support for #220. And fix not handle NOT IN bug in #224.

9DemonFox commented 3 years ago

fine turning is for your recomendation. Fix NOT IN subquery BUG; Support simple corelated InSubquery fix part of issue in #224 pass the unitTest related to NOT IN in #issue224 cancel some recomendation and valid UnitTest related to NOT IN

9DemonFox commented 3 years ago

the uncoverd codes are also uncovered in existsToMarkJoin.

zhouqingqing commented 3 years ago

please update the check-in comments to say this check-in adds IN subquery decorrelation support.