[SPARK-34248] Allow implicit casting string literal to other data types under ANSI mode

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.1.2
• Component/s: SQL
• Assignee: Gengliang Wang
• Reporter: Gengliang Wang
• Created: 26/Jan/21 16:08
• Updated: 29/Nov/21 09:16
• Resolved: 10/Feb/21 03:01

Description

As the default type coercion rules allow converting String type to other primitive types, we can specially allow converting string literal to other primitive types in ANSI mode. So that users won't get many SQL execution failure on switching to ANSI mode.
This is learned from PostgreSQL.