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: 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

          No work has yet been logged on this issue.

            People

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

              Dates

              • Created:
                Updated:
                Resolved:

                Development