[DRILL-3950] CAST(...) * (Interval Constant) gives Internal Exception

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.15.0
• Component/s: Query Planning & Optimization
• Assignee: Vova Vysotskyi
• Reporter: Sean Hsuan-Yi Chu
• Reviewer: Arina Ielchiieva
• Created: 19/Oct/15 17:28
• Updated: 27/Sep/19 14:21
• Resolved: 24/Sep/18 14:35

Description

For example,

select cast(empno as Integer) * (INTERVAL '1' DAY)
from emp

results into

java.lang.AssertionError: Internal error: invalid literal: INTERVAL '1' DAY

The reason is that INTERVAL constant is not extracted properly in the cases where this constant times a CAST() function

Issue Links

• links to: GitHub Pull Request #218