[SPARK-36508] Disallow binary operations between Interval and String literal

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Done
• Affects Version/s: 3.2.0
• Component/s: SQL
• Assignee: Gengliang Wang
• Reporter: Gengliang Wang
• Created: 13/Aug/21 09:31
• Updated: 14/Aug/21 02:52
• Resolved: 14/Aug/21 02:51

Description

If a binary operation contains interval type and string literal, we can't decide which interval type the string literal should be promoted as. There are many possible interval types, such as year interval, month interval, day interval, hour interval, etc.
The related binary operation for Interval should be

• Add
• Subtract
• Comparisions

Issue Links

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