[ https://issues.apache.org/jira/browse/DRILL-3950?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16299685#comment-16299685 ]
Kunal Khatua commented on DRILL-3950: ------------------------------------- [~priteshm] looks like this relates to calcite. We can verify this as part of Calcite upgrade. > CAST(...) * (Interval Constant) gives Internal Exception > -------------------------------------------------------- > > Key: DRILL-3950 > URL: https://issues.apache.org/jira/browse/DRILL-3950 > Project: Apache Drill > Issue Type: Bug > Components: Query Planning & Optimization > Reporter: Sean Hsuan-Yi Chu > Assignee: Jinfeng Ni > Labels: interval > > For example, > {code} > select cast(empno as Integer) * (INTERVAL '1' DAY) > from emp > {code} > results into > {code} > java.lang.AssertionError: Internal error: invalid literal: INTERVAL '1' DAY > {code} > The reason is that INTERVAL constant is not extracted properly in the cases > where this constant times a CAST() function -- This message was sent by Atlassian JIRA (v6.4.14#64029)