What's Changed
New feature
-
Add support for outer joins (#48) by @yugo-n in #149
Views that include outer joins are now supported, under the following restrictions:
- The target list of an outer join view must include all attributes used in join conditions.
- The target list of an outer join view cannot contain non-strict functions.
- Only simple equijoins are supported.
- The WHERE clause of an outer join view cannot contain non-null-rejecting predicates.
- Aggregates are not supported in outer join views.
- Subqueries are not supported in outer join views.
Full Changelog: v1.12...v1.13
Acknowledgements
The development of the outer join support was sponsored by Mediapart.