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

to_number returns a float when when integer is expected.

    Details

    • Type: Bug
    • Status: Open
    • Priority: 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.

        Attachments

          Activity

            People

            • Assignee:
              dsbos Daniel Barclay
              Reporter:
              knguyen Krystal
            • Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

              • Created:
                Updated: