search

zhouqingqing / qpmodel

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

add IN correlated subquery support #220

Closed zhouqingqing closed 3 years ago

zhouqingqing commented 4 years ago

See subquery.cs handling EXISTS and scalar-subquery.

9DemonFox commented 3 years ago

select a1 from a where a2 not in (1,2) Inlist Expr doesn't support NOT IN 

PhysicScanTable a (actual rows=2)
    Output: a.a1[0]
    Filter: a.a2[1] in (1,2)