[SPARK-33794] next_day function should throw runtime exception when receiving invalid input under ANSI mode

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.0.0
• Fix Version/s: 3.2.0
• Component/s: SQL
• Assignee: Chongguang LIU
• Reporter: Chongguang LIU
• Created: 15/Dec/20 13:35
• Updated: 05/Jan/21 05:20
• Resolved: 05/Jan/21 05:20

Description

Hello all,

According to ANSI compliance, the next_day function should throw an runtime exception when receiving invalid value for dayOfWeek, exemple receiving "xx" instead of "SUNDAY".

 

A similar improvement has been done on the element_at function: https://issues.apache.org/jira/browse/SPARK-33386

 

If you agree with this proposition, i can submit a pull request with necessary change.

 

Kind regardes,

 

Issue Links

• links to: [Github] Pull Request #30807 (chongguang)