Apache Drill
  1. Apache Drill
  2. DRILL-709

FLOOR function should return an int instead of decimal

    Details

    • Type: Bug Bug
    • Status: Resolved
    • Priority: Major Major
    • Resolution: Duplicate
    • Affects Version/s: 0.1.0-m1
    • Fix Version/s: 0.4.0
    • Component/s: Functions - Drill
    • Labels:
      None

      Description

      Drill's FLOOR function returns a decimal instead of an int. For example:
      select floor(100.75) from student where student_id=11;
      Returns 100.0

        Issue Links

          Activity

          Tony Stevenson made changes -
          Workflow no-reopen-closed, patch-avail, testing [ 12862004 ] Drill workflow [ 12933519 ]
          Jacques Nadeau made changes -
          Fix Version/s 0.4.0 [ 12324963 ]
          Fix Version/s Future [ 12326743 ]
          Yash Sharma made changes -
          Assignee Yash Sharma [ yash360@gmail.com ]
          Harold Dost III made changes -
          Status Testing [ 10012 ] Resolved [ 5 ]
          Resolution Duplicate [ 3 ]
          Harold Dost III made changes -
          Status Patch Available [ 10002 ] Testing [ 10012 ]
          Harold Dost III made changes -
          Status Open [ 1 ] Patch Available [ 10002 ]
          Harold Dost III made changes -
          Link This issue duplicates DRILL-520 [ DRILL-520 ]
          Mehant Baid made changes -
          Field Original Value New Value
          Fix Version/s Future [ 12326743 ]
          Krystal created issue -

            People

            • Assignee:
              Yash Sharma
              Reporter:
              Krystal
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development