[SPARK-3688][SQL]LogicalPlan can't resolve column correctlly

we should add some judgements base on the datatype to handle some particular sql described in https://issues.apache.org/jira/browse/SPARK-3688
I don't think we need the `withName` call anymore, since now we preserve case of attribute names by leveraging `resolver` to compare names.