[SPARK-37513] date +/- interval with only day-time fields returns different data type between Spark3.2 and Spark3.1

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.3.0
• Fix Version/s: 3.2.1, 3.3.0
• Component/s: SQL
• Assignee: Jiaan Geng
• Reporter: Jiaan Geng
• Created: 01/Dec/21 06:32
• Updated: 01/Dec/21 08:21
• Resolved: 01/Dec/21 08:21

Description

select date '2011-11-11' + interval 12 hours;

Previously returned the date type, now it returns the timestamp type.

Issue Links

• links to: [Github] Pull Request #34766 (beliefer)
• links to: [Github] Pull Request #34766 (beliefer)