[SPARK-40143] ANSI mode: allow explicitly casting fraction strings as Integral types

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Won't Do
• Affects Version/s: 3.4.0
• Component/s: SQL
• Assignee: Gengliang Wang
• Reporter: Gengliang Wang
• Created: 19/Aug/22 03:50
• Updated: 13/Jan/23 04:22
• Resolved: 13/Jan/23 04:22

Description

It's part of the ANSI SQL standard, and more consistent with the non-ansi casting. We can have different behavior for implicit casting to avoid `'1.2' = 1` returns true.

Issue Links

• links to: [Github] Pull Request #37576 (gengliangwang)
• links to: [Github] Pull Request #37576 (gengliangwang)