Hello, I have a problem with a specific query that do not return as much results as expected. The problem is when I use where clause combined with a select on an EntitySet and FirstAndDefault (sample code below) DataObjects.Net version: 4.6.4.1123 Model:
Code:
Returns 0 result, where 1 was expected. |
Hello olorin, finally we've made a fix for that. Let us know if you need a nightly build. |
Hello olorin, we've confirmed your problem. Please wait for the fix
Hello Denis, any news on this issue?
Hello olorin, unfortunately fix is not ready yet. Our current internal representation of queries only allows null result of scalar subqueries. First try was to add implicit call to coalesce() on the result however this is proven not to work because it makes scalar subquery to produce more than one column (i.e. original result of subquery and actual correct result).
Were you able to find a solution to this problem?
Not yet, unfortunately
Any news? Do you plan to fix this issue? Any idea on how to write the query diffrently to work around this issue?
Hello Olorin. I really apologize for such delay. Our current estimate is to fix this bug within a week.