Query: runtime error (invalid cast) for query projecting bool property with conditional and coalesce

[maumar]

query:

ctx.Gears.Select(g => g.LeaderNickname != null ? (bool?)(g.Nickname.Length == 5) ?? default(bool) : (bool?)null)

query:

SELECT CASE
   WHEN [g].[LeaderNickname] IS NOT NULL
   THEN COALESCE(CASE
	   WHEN CAST(LEN([g].[Nickname]) AS int) = 5
	   THEN CAST(1 AS BIT) ELSE CAST(0 AS BIT)
   END, 0) ELSE NULL
END
FROM [Gears] AS [g]
WHERE [g].[Discriminator] IN (N'Officer', N'Gear')

exception:

Specified cast is not valid.

we should inject cast to bool around the coalesce inside the case statement