yugo-n
commented
5 years ago Outer joins are now supported.
Remaining restrictions are:
- outer join view's targetlist must contain attributes used in the join conditions
- outer join view's targetlist cannot contain non strict functions
- outer join supports only simple equijoin
- outer join view's WHERE clause cannot contain non null-rejecting predicates
- aggregate is not supported with outer join
- subquery is not supported with outer join
Some might be able to relaxed in future and some might not.
Currenty, outer join is not supported by IVM.