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

FROM_DAYS() function returned incorrect values

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Not a Bug
    • None
    • 1.0.1
    • ExeMgr
    • None
    • 1.0.2-1

    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, CDECIMAL4, FROM_DAYS(CDECIMAL4) from datatypetestm order by cidx

      cidx CDECIMAL4 FROM_DAYS(CDECIMAL4)
      1 -999 0000-00-00
      2 -998 0000-00-00
      3 -997 0000-00-00
      4 -996 0000-00-00
      5 -995 0000-00-00
      6 995 0000-00-00
      7 996 0000-00-00
      8 997 0000-00-00
      9 998 0000-00-00
      10 999 0000-00-00
      11 0 0000-00-00
      11 rows in set

      MySQL and MariaDB returns:

      select cidx, CDECIMAL4, FROM_DAYS(CDECIMAL4) from datatypetestm order by cidx

      cidx CDECIMAL4 FROM_DAYS(CDECIMAL4)
      1 -999 0000-00-00
      2 -998 0000-00-00
      3 -997 0000-00-00
      4 -996 0000-00-00
      5 -995 0000-00-00
      6 995 0002-09-22
      7 996 0002-09-23
      8 997 0002-09-24
      9 998 0002-09-25
      10 999 0002-09-26
      11 0 0000-00-00
      11 rows in set

      Attachments

        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.