Good question, but wrong explanation (and also wrong error message from SQL Server):
The coalesce expects at least one typed NULL in order to execute and hence the error.
Simple example that does NOT contain a typed NULL:
COALESCE(1,1)
Best Regards,
Chris Büttner