terrajobst / nquery-vnext

A Roslyn inspired rewrite of NQuery
MIT License
72 stars 16 forks source link

Query can cause InvalidOperationException with message "The value 'RightOuter' of type BoundJoinType was unexpected" #8

Closed dallmair closed 6 years ago

dallmair commented 6 years ago

Sample query (it does not make sense, but should not crash NQuery either):

SELECT  *
FROM    Orders o
        RIGHT JOIN Categories c ON o.EmployeeID <= c.CategoryID

Root cause is the generation of a right outer join which is kept in the execution pipeline. Or, in other words, the missing Semi Join Simplification.