Implement Spark-compatible CAST from String to Floating Point

[andygrove]

What is the problem the feature request solves?

What is the problem the feature request solves?

We currently delegate to DataFusion when casting from string to floating point and there are some differences in behavior compared to Spark.

• Spark supports inputs ending with d or f such as -12.34d and DataFusion does not
• Spark ignores leading and trailing whitespace but DataFusion does not and returns null
• DataFusion does not throw exceptions for invalid inputs in ANSI mode

Describe the potential solution

No response

Additional context

No response