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

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

    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

          Issue Links

            Activity

              People

              • Assignee:
                vvysotskyi Volodymyr Vysotskyi
                Reporter:
                seanhychu Sean Hsuan-Yi Chu
                Reviewer:
                Arina Ielchiieva
              • Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: