Uploaded image for project: 'Apache Trafodion'
  1. Apache Trafodion
  2. TRAFODION-3129

round(m,n) function does not cut the value to n digits precision

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 2.2.0
    • Fix Version/s: any
    • Component/s: sql-general
    • Labels:
      None

      Description

      Below sql should return 123.46, but it returns 123.4600,

      >>select round(123.4567,2) from dual;

      (EXPR)
      ---------------------

      123.4600

      — 1 row(s) selected.

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              Yuan_Liu Yuan Liu
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated: