[SPARK-3363][SQL] Type Coercion should support every type to have null value

Type Coercion should support every type to have null value
Is there a reason we can't just call `findTightestCommonType` here?