[SPARK-33275] ANSI mode: runtime errors instead of returning null on invalid inputs

• Type: New Feature
• Status: Resolved
• Priority: Major
• Resolution: Done
• Affects Version/s: 3.1.0
• Component/s: SQL
• Epic Link: ANSI SQL compliance
• Assignee: Apache Spark
• Reporter: Wenchen Fan
• Created: 28/Oct/20 17:15
• Updated: 25/Nov/23 21:37
• Resolved: 25/Nov/23 21:37

Description

We should respect the ANSI mode in more places. What we have done so far are mostly the overflow check in various operators. This ticket is to track a category of ANSI mode behaviors: operators should throw runtime errors instead of returning null when the input is invalid.

Sub-Tasks

• Fix the constant folding rule to skip it if the expression fails to execute: In Progress