Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-78

ROUND() function returns incorrect value

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Fixed
    • None
    • 1.0.4
    • ExeMgr
    • None
    • 1.0.2-1, 1.0.2-2, 2016-19

    Description

      Build tested:

      InfiniDB> getcalpontsoft
      getcalpontsoftwareinfo Mon May 23 16:47:57 2016

      Name : infinidb-platform Relocations: (not relocatable)
      Version : 5.0 Vendor: MariaDB, Inc.
      Release : 0 Build Date: Sun 15 May 2016 07:24:29 PM CDT
      Install Date: Mon 16 May 2016 05:21:51 PM CDT Build Host: srvbuilder
      Group : Applications Source RPM: infinidb-5.0-0.src.rpm

      ColumnStore returns:

      select cidx, CDECIMAL1, ROUND(CDECIMAL1,-1) from datatypetestm order by cidx

      cidx CDECIMAL1 ROUND(CDECIMAL1,-1)
      1 -9 -9
      2 -8 -9
      3 -7 -9
      4 -6 -9
      5 -5 -9
      6 5 9
      7 6 9
      8 7 9
      9 8 9
      10 9 9
      11 0 0
      11 rows in set

      MySQL and MariaDB returns:

      select cidx, CDECIMAL1, ROUND(CDECIMAL1,-1) from datatypetestm order by cidx

      cidx CDECIMAL1 ROUND(CDECIMAL1,-1)
      1 -9 -10
      2 -8 -10
      3 -7 -10
      4 -6 -10
      5 -5 -10
      6 5 10
      7 6 10
      8 7 10
      9 8 10
      10 9 10
      11 0 0
      11 rows in set

      Attachments

        Issue Links

          Activity

            People

              dleeyh Daniel Lee (Inactive)
              dleeyh Daniel Lee (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.