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

ceiling/ceil and floor functions return decimal value instead of an integer

    Details

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

      Description

      Ran the following queries in drill:
      0: jdbc:drill:schema=dfs> select ceiling(55.8) from dfs.`student` where rownum=11;
      ------------

      EXPR$0

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

      56.0

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

      0: jdbc:drill:schema=dfs> select floor(55.8) from dfs.`student` where rownum=11;
      ------------

      EXPR$0

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

      55.0

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

      The same queries executed from oracle, postgres and mysql returned integer values of 56 and 55.

      Found the following description of the two functions from http://users.atw.hu/sqlnut/sqlnut2-chp-4-sect-4.html :

      Ceil/Ceiling:
      Rounds a noninteger value upwards to the next greatest integer. Returns an integer value unchanged.
      Floor:
      Rounds a noninteger value downwards to the next least integer. Returns an integer value unchanged.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                karthikm Karthikeyan Manivannan
                Reporter:
                knguyen Krystal
                Reviewer:
                Krystal
              • Votes:
                0 Vote for this issue
                Watchers:
                6 Start watching this issue

                Dates

                • Created:
                  Updated: