[CALCITE-922] AssertionError extracting value from an INTERVAL literal

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.5.0
• Component/s: core
• Assignee: Sean Hsuan-Yi Chu
• Reporter: Sean Hsuan-Yi Chu
• Created: 16/Oct/15 06:39
• Updated: 27/Feb/24 22:24
• Resolved: 24/Oct/15 02:38

Description

CAST(...) * (INTERVAL constant) results into Internal Error.

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

• incorporates: CALCITE-928 Parsing Issue with Interval