When the ternary condition contains a == null check, the else branch doesn't eliminate null values in the else expression, resulting in queries that will scan more data than required when executed ...

Regression (V9): Generated SQL from ternary expression on nullable property causes slow execution on SQL Server #36291 ...