Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-3950

CAST(...) * (Interval Constant) gives Internal Exception

Attach filesAttach ScreenshotVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    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

      Attachments

        Activity
          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            volodymyr Vova Vysotskyi
            seanhychu Sean Hsuan-Yi Chu
            Arina Ielchiieva Arina Ielchiieva
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment