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

Drill can't handle NaN, Infinity literals

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Major
    • Resolution: Unresolved
    • None
    • None
    • None
    • None

    Description

      Queries like:
      select sin(cast('NaN' as double)) from (values(1))
      select cast('Infinity' as double)+1 from (values(1))

      end up with NumberFormatException, because Drill and Calcite use BigDecimal to handle double literals. As a solution we can add special symbols NAN, POS_INF, NEG_INF which will represent not numeric literals.
      Created calcite jira for this functionality.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              volodymyr.tkach Volodymyr Tkach
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated: