[Feature Request]Fix potential float -> double casting issue and align in expression with comparator "=" implementation

Feature request

Which Delta project/connector is this regarding?

• Spark
• Standalone
• Flink
• Kernel
• Other (fill in here)

Overview

In https://github.com/delta-io/delta/pull/5186, we are kind of customizing the type check and value comparison among numerics.

Technically we could streamline the implementation via a refactor to 1.figure out the narrowest type 2.transform the expression via implicit cast expression 3.simplify the value comparision.

Doing so today will have 1 test failure fails due to float -> double convertion 84.08 -> 84.08000183105469 We need to investigate this logic in implicit cast and then do refactoring to unify the expression logic

Motivation

Further details

Willingness to contribute

The Delta Lake Community encourages new feature contributions. Would you or another member of your organization be willing to contribute an implementation of this feature?

• Yes. I can contribute this feature independently.
• Yes. I would be willing to contribute this feature with guidance from the Delta Lake community.
• No. I cannot contribute this feature at this time.