Fix behavioural differences due to return type and handle constant string literal inputs differently for COALESCE function

Fix behavioural differences due to return type and handle constant string literal inputs differently for COALESCE function #13036