Apache Drill
  1. Apache Drill
  2. DRILL-910

to_number returns a float when when integer is expected.

    Details

    • Type: Bug Bug
    • Status: Open
    • Priority: Critical Critical
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: Future
    • Component/s: Functions - Drill
    • Labels:
      None

      Description

      git.commit.id.abbrev=8490d74
      git.build.time=02.06.2014 @ 10\:11\:56 PDT

      0: jdbc:drill:schema=dfs> select to_number('$987,966', '$###,###') from voter where voter_id=10;
      ------------

      EXPR$0

      ------------

      987966.0

      ------------

      0: jdbc:drill:schema=dfs> select to_number('2,900.55', '#,###') from voter where voter_id=10;
      ------------

      EXPR$0

      ------------

      2901.0

      ------------

      In the first example, an int is passed to_number so we expect an in to return. In the second example, the format in the second argument is to return an int.
      In both cases, postgres and oracle return an int.

        Activity

        No work has yet been logged on this issue.

          People

          • Assignee:
            Daniel Barclay (Drill)
            Reporter:
            Krystal
          • Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

            • Created:
              Updated:

              Development