… value type tries to return null instead of default Sql naturally returns null for subqueries that contain no results. Fix is to recognize the pattern and add COALESCE around it, and in case original ...